DUNOD2015 SQLfast - Historique des versions

Dbm le 1 octobre 2026 à 15:55

2026-10-01T15:55:33Z

Dbm : /* VERSION FRANCAISE */

2026-10-01T15:50:59Z

VERSION FRANCAISE

Dbm : /* SQLpy versions */

2026-10-01T13:19:45Z

SQLpy versions

Dbm le 1 octobre 2026 à 13:00

2026-10-01T13:00:20Z

Dbm le 19 mai 2026 à 09:53

2026-05-19T09:53:09Z

Dbm le 18 mai 2026 à 17:30

2026-05-18T17:30:50Z

Dbm le 18 mai 2026 à 14:20

2026-05-18T14:20:10Z

Dbm le 12 mai 2026 à 09:12

2026-05-12T09:12:17Z

Dbm : /* ENGLISH VERSION */

2024-09-15T11:11:02Z

ENGLISH VERSION

Dbm : /* ENGLISH VERSION */

2024-09-15T11:09:24Z

ENGLISH VERSION

@@ Ligne 91 : / Ligne 91 : @@
 '''Versions de SQLpy'''
 *'''<font color="red">v4.0 (2026-10-31)</font>''' [[#SQLpy versions|description]]
-*v3.1   (2022-12-12) [[#SQLpy versions|description]]
+*v3.1   (2025-05-14) [[#SQLpy versions|description]]
-*v2.1   (2022-07-02) [[#SQLpy versions|description]]
+*v2.1   (2023-10-15) [[#SQLpy versions|description]]
@@ Ligne 271 : / Ligne 271 : @@
 '''SQLfast versions'''
-*'''<font color="red">v5.1 (2023-06-04)</font>''' [[#SQLfast versions|description]]
+*'''<font color="red">v6.0 (2026-10-31)</font>''' [[#SQLfast versions|description]]
 *v5.0   (2022-12-12) [[#SQLfast versions|description]]
 *v4.1   (2022-07-02) [[#SQLfast versions|description]]
@@ Ligne 289 : / Ligne 289 : @@
 *v1.0.1 (2016-01-14) [[#SQLfast versions|description]]
 *v1.0.0 (2015-12-18) [[#SQLfast versions|description]]

@@ Ligne 93 : / Ligne 93 : @@
 *v3.1   (2022-12-12) [[#SQLpy versions|description]]
 *v2.1   (2022-07-02) [[#SQLpy versions|description]]
 <table><tr><td align=left valign=middle style="background-color:rgb(28,148,198);width:800px">

← Version précédente		Version du 1 octobre 2026 à 13:19
Ligne 815 :		Ligne 815 :
	*'''SQLpy v3.1 (2025-05-14)'''		*'''SQLpy v3.1 (2025-05-14)'''

		+	:*'''Database functions'''
		+	::*''with delete/update/insert'' allowed in '''ExecScript'''
		+	::*'''ExecScript''' with variable allows one query only (so, multiline queries allowed)
		+	::*''pragma'' SQLite commands also apply to ''InMemory'' DB
		+	::*'''CloseDB''': ignore UDF processing if UDF are not loaded
		+	::*Comment on UDF ''deterministic= True''
		+	::*UDF '''printMessage''', '''writeFile''', '''appendFile''' to trace trigger execution
		+	::*New functions '''ExtractVal''' (read a single value),'''ExtractRow''' (read a row),'''ExtractAll''' (read a list of rows)
		+	::*New function '''ExecProc''', intended to simulate SQL ''Stored procedures''

−	*'''SQLpy v2.1 (~~2024~~-11-15)'''	+	:*'''General functions'''
		+	::*New UDF '''wait''' (fixed or random time)
		+	::*New UDF '''sendMail'''
		+
		+	:*'''GUI functions'''
		+	::*New '''DrawBox''' dialog box to display still and animated vector-based graphics
		+	::*Code '0' point added in '''DrawBox''' (point with no symbol)
		+	::*'''SQLselect''': ''bar3'' also generated for empty result sets
		+	::*'''SQLselect''': two new formats, ''line'', same as ''text'' without trailing dot and ''standard-0'', same as ''standard-1'' with border and header off
		+	::*In a single-button box, the button is centered
		+
		+	:*'''SQLpy architecture'''
		+	::*Bugs fixed (computing of column length in ''SYS_COLUMN'', ...)
		+
		+
		+	*'''SQLpy v2.1 (2023-10-15)'''
		+
		+	:*'''Database functions'''
		+	::*a UDF library can be enabled on '''CreateDB''' and '''OpenDB''' (default '''SQL_UDF.py''', derived from SQLfast's). Includes '''upper2''' and '''lower2''' functions that extends native SQL ASCII-based functions to unicode
		+	::*allowing "escape #" in ''like'' predicate
		+
		+	:*'''General functions'''
		+	::*2 new functions: '''StartTimer''', '''GetTimer'''
		+
		+	:*'''GUI functions'''
		+	::*'''PictureBox''' now works (with limited picture formats) when ''PIL'' has not been installed
		+	::*horizontal scrollbar in '''TextBox'''
		+	::*new '''readonly''' param for display-only '''InfoBox''', '''EntryBox''' and '''TextBox''';
		+	::*'''ReadOnlyColor'': default background color for readonly boxes
		+	::*button labels can be written in several lines
		+	::*new '''butn''' param adds custom buttons to most boxes
		+	::*new '''winbut''' param enable/disables the ''Windows'' close button
		+
		+	:*'''SQLpy architecture'''
		+	::*All the buttons are generated by the unique ''Exit_Buttons'' procedure.
		+	::*Bugs fixed ('''Dquote''', multiple '''ListBox2''' instances in '''CompositeBox''', …)

@@ Ligne 32 : / Ligne 32 : @@
 ::[https://bit.ly/4wpXK8w '''SQLfast-FR.zip''']
 <!-- -->
-:* <font color="red">'''<i>NOUVEAU</i>'''</font> '''Module Python SQLpy v1.2''' ['''<i>dernière maj 2023-06-08</i>''']
+:* <font color="red">'''<i>NOUVEAU</i>'''</font> '''Module Python SQLpy v4.0''' ['''<i>dernière maj 2026-10-31</i>''']
 ::[https://bit.ly/3FVFI5P '''SQLpy.zip''']
 <!-- -->
@@ Ligne 70 : / Ligne 70 : @@
 '''Versions de SQLfast'''
-*'''<font color="red">v5.1 (2023-06-04)</font>''' [[#SQLfast versions|description]]
+*'''<font color="red">v6.0 (2026-10-31)</font>''' [[#SQLfast versions|description]]
 *v5.0   (2022-12-12) [[#SQLfast versions|description]]
 *v4.1   (2022-07-02) [[#SQLfast versions|description]]
@@ Ligne 89 : / Ligne 89 : @@
 *v1.0.0 (2015-12-18) [[#SQLfast versions|description]]
 <table><tr><td align=left valign=middle style="background-color:rgb(28,148,198);width:800px">
@@ Ligne 777 : / Ligne 781 : @@
 :*First public release.

@@ Ligne 40 : / Ligne 40 : @@
 :::[http://bit.ly/3FZ0yBq '''SQLfast_Installation_FR.pdf''']
 <!-- -->
-::* '''Manuel SQLfast : Database application programming''' (570 pages, en anglais) [''<i>dernière maj 2022-09-12</i>'']
+::* '''Manuel SQLfast : Database application programming''' (570 pages, en anglais) [''<i>dernière maj 2025-09-12</i>'']
 :::[http://bit.ly/3Wm8IZT '''SQLfast-Manual.pdf''']
 <!-- -->
@@ Ligne 237 : / Ligne 237 : @@
 :::[http://bit.ly/3Wrcl0Y '''SQLfast_Installation_EN.pdf''']
 <!-- -->
-::* <font color="red">'''<i>NEW</i>'''</font> '''SQLfast Manual: Database application programming''' (570 pages, English) [<font color="black">''<i>last update 2022-09-12</i>'']
+::* <font color="red">'''<i>NEW</i>'''</font> '''SQLfast Manual: Database application programming''' (570 pages, English) [<font color="black">''<i>last update 2025-09-12</i>'']
 :::[http://bit.ly/3Wm8IZT '''SQLfast-Manual.pdf''']
 <!-- -->

@@ Ligne 226 : / Ligne 226 : @@
 :'''Warning''', in some configurations, the Microsoft ''Edge'' browser refuses to download ''zip'' files. In such case, use ''Firefox'' or ''Chrome'' instead.
-::* <font color="red">'''<i>NEW</i>'''</font> '''SQLfast 5.1''' (English documentation) [<i>last update 2023-06-04</i>]
+::* <font color="red">'''<i>NEW</i>'''</font> '''SQLfast 6.1''' (English documentation) [<i>last update 2026-05-15</i>]
-:::[https://bit.ly/3BC97je '''SQLfast.zip''']
+:::[https://bit.ly/3Py6oRP '''SQLfast.zip''']
 <!-- -->
 ::* <font color="red">'''<i>NEW</i>'''</font> '''SQLpy Python module v1.2''' [<i>last update 2022-12-16</i>]

@@ Ligne 29 : / Ligne 29 : @@
 :'''Attention''', dans certaines configurations, le navigateur ''Edge'' de Microsoft refuse de télécharger des fichiers ''zip''. Dans un tel cas, utiliser plutôt ''Firefox'' ou ''Chrome''.
-:* <font color="red">'''<i>NOUVEAU</i>'''</font> '''Logiciel SQLfast v5.1''' (documentation en français) ['''<i>dernière maj 2023-06-04</i>''']
+:* <font color="red">'''<i>NOUVEAU</i>'''</font> '''Logiciel SQLfast v6.1''' (documentation en français) ['''<i>dernière maj 2026-05-15</i>''']
 ::[http://bit.ly/3V15zhk '''SQLfast-FR.zip''']
 <!-- -->

← Version précédente		Version du 15 septembre 2024 à 11:11
Ligne 320 :		Ligne 320 :
	SQLfast has been developed in Python since 2012. The current distribution includes ''SQLite3'', which offers a rich version of SQL2/SQL3 (including recursive CTE and ''window'' function) and GUI library ''Tkinter''. The current version has been compiled for MS Windows 64 bits (from Vista to Win11). SQLfast runs smoothly on Linux under Wine (some parameters may need to be adapted, such as default ''paths'' and character coding).		SQLfast has been developed in Python since 2012. The current distribution includes ''SQLite3'', which offers a rich version of SQL2/SQL3 (including recursive CTE and ''window'' function) and GUI library ''Tkinter''. The current version has been compiled for MS Windows 64 bits (from Vista to Win11). SQLfast runs smoothly on Linux under Wine (some parameters may need to be adapted, such as default ''paths'' and character coding).

−	For more technical detail, please consult the [https://~~projects~~.~~info.unamur.be~~/~~~dbm/mediawiki/index.php?title=LIBD:Outils&action=submit~~ [tools page]]	+	For more technical detail, please consult the [https://bit.ly/3x0fj2i [tools page]]

@@ Ligne 263 : / Ligne 263 : @@
 <!-- -->
 ::*''' Eleven temporal databases of various sizes''' (complement of case study ''Temporal databases - Part 2''. [''<i>last update 2019-08-01</i>'']
-:::[https://staff.info.unamur.be/dbm/Documents/Tutorials/SQLfast/TDB-Large.zip '''TDB-Large.zip (93 Mo)''']
+:::[https://projects.info.unamur.be/dbm/SQLfast/Case-Studies/TDB-Large.zip '''TDB-Large.zip (93 Mo)''']
 '''SQLfast versions'''