Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) m (→SQLfast) |
||
Ligne 18 : | Ligne 18 : | ||
:*<b>expert users</b>: SQLfast is a fine environment for fast database application prototyping. | :*<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. | :*<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. | ||
+ | :SQLfast runs on Windows, OS X and Linux machines. Its default database manager is SQLite 3 but versions for MySQL and MS Access are being developed. | ||
: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 | + | *'''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 the basic version relies on the SQLite 3 DBMS. 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 |