Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 14 : | Ligne 14 : | ||
: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 will be used: | :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 will 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. | + | :*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. |
− | :*by <b>non expert</b> but <b>motivated users</b>: SQLfast is quite appropriate for the developments of small and simple 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. | + | :*by <b>non-expert</b> but <b>motivated users</b>: SQLfast is quite appropriate for the developments of small and simple 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. |
:*by <b>expert users</b>: SQLfast is a fine environment for fast database application prototyping. | :*by <b>expert users</b>: SQLfast is a fine environment for fast database application prototyping. | ||
:*by <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. | :*by <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. | ||
− | *''' | + | *'''Technical detail''': An SQLfast script (or program) is not limited in size: it can include just one statement but also several millions of statements. It is developed in Python 2.6 and relies on the SQLite-3 DBMS (interfaces with other DBMS are in preparation). Its main design objectives are to hide the complexity of database programming (connections, cursors, transactions, metadata management, etc.) and of graphical interactions, to provide very high level functions and to provide a secure user-friendly execution environment. The SQLfast language and environment comprise the following components: |
:*the full SQL language | :*the full SQL language | ||
:*variables in which data coming from a database, external files, computations ou GUI can be stored. Variables are typeless and have no size limit. A variable can contain data of any kind but also script fragments. The SQLfast ''macro processor'' can (recursively) replace variable references by their values. | :*variables in which data coming from a database, external files, computations ou GUI can be stored. Variables are typeless and have no size limit. A variable can contain data of any kind but also script fragments. The SQLfast ''macro processor'' can (recursively) replace variable references by their values. |
<Retour à la page d'accueil / Back>
Sommaire |