Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 13 : | Ligne 13 : | ||
:Despite its simplicity, the SQLfast language includes powerful features such as the full SQL language, script variables, GUI, comprehensive control structures (procedures, recursive calls, if-else, for-endfor, while-endwhile, exit, next, continue, stop, pause, goto etc.), a powerful text generator coupled with the select-from-where query, dynamic statement and script execution, external program interface, transactions, automatic metadata management, automatic database analysis, debugging, etc. | :Despite its simplicity, the SQLfast language includes powerful features such as the full SQL language, script variables, GUI, comprehensive control structures (procedures, recursive calls, if-else, for-endfor, while-endwhile, exit, next, continue, stop, pause, goto etc.), a powerful text generator coupled with the select-from-where query, dynamic statement and script execution, external program interface, transactions, automatic metadata management, automatic database analysis, debugging, etc. | ||
:The <b>SQLfast environment</b> is particularly <b>easy to install</b>. Once the standard Python environment is available, installing the SQLfast system just requires the copying a folder on the disk. No need to install a database manager nor GUI libraries, to compile modules to adapt them to the user equipment, to create accounts and to define access rights. | :The <b>SQLfast environment</b> is particularly <b>easy to install</b>. Once the standard Python environment is available, installing the SQLfast system just requires the copying a folder on the disk. No need to install a database manager nor GUI libraries, to compile modules to adapt them to the user equipment, to create accounts and to define access rights. | ||
− | :Due to its simplicity, its ease of use and its power, SQLfast is intended to audiences that have little time and/or knowledge to develop professional programs. In particular, it | + | :Due to its simplicity, its ease of use and its power, SQLfast is intended to audiences that have little time and/or knowledge to develop professional programs. In particular, it can be used by: |
− | :* | + | :*<b>non-expert users</b>: SQLfast provides an easy way to write small data processing tools customized to their exact needs, without resorting to complex programming or using powerful but complex softwares. |
− | :* | + | :*<b>non-expert</b> but <b>motivated users</b>: SQLfast is quite appropriate for the development of small and simple single-user applications for, e.g., library management, statistical analysis, simple data mining, geographic information systems, photo album, text analysis, graphical display of data, and so on. |
− | :* | + | :*<b>expert users</b>: SQLfast is a fine environment for fast database application prototyping. |
− | :* | + | :*<b>students</b>: the SQLfast language basically is SQL but it is also an ideal support to practical work in database introductory and advanced courses. It allows students to play with SQL in a secure environment and also to develop in a few lines powerful scripts without the burden of learning and using standard programming languages. |
:Finally, an important feature of the SQLfast environment is its <b>extensibility</b>: new functions, new resources and even new statements can be developed quite (or, at least, fairly) easily. | :Finally, an important feature of the SQLfast environment is its <b>extensibility</b>: new functions, new resources and even new statements can be developed quite (or, at least, fairly) easily. | ||
Ligne 49 : | Ligne 49 : | ||
*'''Availability''': Free of charge. Release date of beta: first quarter 2014. | *'''Availability''': Free of charge. Release date of beta: first quarter 2014. | ||
*'''References and resources''': | *'''References and resources''': | ||
+ | **SQLfast environment for Windows. Ask the beta version for testing. | ||
+ | **Python 2.7.6 Win32, Win64, Mac OS, Linux. Note that Mac OS systems natively include the Python environment [http://www.python.org/download/ [download page]] | ||
+ | **SQLite3 DBMS is already included in the Python installation. However, it can be useful to download the very last version (3.8.2 or later). Download it from [http://www.sqlite.org/download.html [SQLite3]]. Locate section <i>Precompiled Binaries for Windows</i>. In early 2014, the file was named <i>sqlite-dll-win32-x86-3080200.zip</i>. Open the archive and copy the <i>sqlite.dll</i> file in directory <i>Python 2.7/DLLs</i> of the Python directory. | ||
**Jean-Luc Hainaut. <u>SQLfast Database made easy - Tutorial and Case studies</u>, 700 pages, PReCISE Research Center publication, draft version, 2014. | **Jean-Luc Hainaut. <u>SQLfast Database made easy - Tutorial and Case studies</u>, 700 pages, PReCISE Research Center publication, draft version, 2014. | ||
+ | :Many chapters are already available, but in a draft version only. They are continuously updated, so that it is recommended to check them regularly to get their last versions. | ||
**<u>SQLfast Tutorial - 1st pages and Table of contents</u>, from ''SQLfast Database made easy - Tutorial and Case studies'',PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto00-1st-pages.pdf [full text]] | **<u>SQLfast Tutorial - 1st pages and Table of contents</u>, from ''SQLfast Database made easy - Tutorial and Case studies'',PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto00-1st-pages.pdf [full text]] | ||
**<u>SQLfast Tutorial - 1. Introduction</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto01-Introduction.pdf [full text]] | **<u>SQLfast Tutorial - 1. Introduction</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto01-Introduction.pdf [full text]] |
<Retour à la page d'accueil / Back>
Sommaire |