Dbm (discuter | contributions) m (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 52 : | Ligne 52 : | ||
**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]] | **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. | **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 processing made easy - Tutorial and Case studies</u>, 700 pages, PReCISE Research Center publication, draft version, 2014. | + | **Jean-Luc Hainaut. <u>Dictionary of SQLfast command and parameters</u>, 34 pages, PReCISE Research Center publication, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Commands.pdf [full text]] |
− | **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. | + | **Jean-Luc Hainaut. <u>SQLfast: Database processing made easy - Tutorial and Case studies</u>, 700 pages, PReCISE Research Center publication, draft version, May 2014. |
+ | **Many chapters of the tutorial 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. | ||
:*SQLfast Tutorial - <b>1st pages</b> and <b>Table of contents</b>, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto00-1st-pages.pdf [full text]] | :*SQLfast Tutorial - <b>1st pages</b> and <b>Table of contents</b>, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto00-1st-pages.pdf [full text]] | ||
− | :*SQLfast Tutorial - <b>1. Introduction</b>, draft version, | + | :*SQLfast Tutorial - <b>1. Introduction</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto01-Introduction.pdf [full text]] |
− | :*SQLfast Tutorial - <b>2. Basic scripts</b>, draft version, | + | :*SQLfast Tutorial - <b>2. Basic scripts</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto02-Basic-programs.pdf [full text]] |
− | :*SQLfast Tutorial - <b>4. Creating a database</b>, draft version, | + | :*SQLfast Tutorial - <b>4. Creating a database</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto04-Creating-DB.pdf [full text]] |
− | :*SQLfast Tutorial - <b>5. Updating data</b>, draft version, | + | :*SQLfast Tutorial - <b>5. Updating data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto05-Updating-data.pdf [full text]] |
:*SQLfast Tutorial - <b>6. More on variables</b>, draft version, March 7, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto06-More-on-variables.pdf [full text]] | :*SQLfast Tutorial - <b>6. More on variables</b>, draft version, March 7, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto06-More-on-variables.pdf [full text]] | ||
− | :*SQLfast Tutorial - <b>7. Taking decisions</b>, draft version, | + | :*SQLfast Tutorial - <b>7. Taking decisions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto07-Taking-decisions.pdf [full text]] |
− | :*SQLfast Tutorial - <b>8. Reading data</b>, draft version, | + | :*SQLfast Tutorial - <b>8. Reading data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto08-Reading-data.pdf [full text]] |
− | :*SQLfast Tutorial - <b>9. Looping - The final chapter</b>, draft version, | + | :*SQLfast Tutorial - <b>9. Looping - The final chapter</b>, draft version, March 11, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto09-More-on-Loops.pdf [full text]] |
− | :*SQLfast Tutorial - <b>10. SQLfast expressions</b>, draft version, | + | :*SQLfast Tutorial - <b>10. SQLfast expressions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto10-Expressions.pdf [full text]] |
− | :*SQLfast Tutorial - <b>11. Output channels</b>, draft version, | + | :*SQLfast Tutorial - <b>11. Output channels</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto11-Output-Channels.pdf [full text]] |
− | :*SQLfast Tutorial - <b>12. Dialogues</b>, draft version, | + | :*SQLfast Tutorial - <b>12. Dialogues</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto12-Dialogues.pdf [full text]] |
− | :*SQLfast Tutorial - <b>13. Displaying data</b>, draft version, | + | :*SQLfast Tutorial - <b>13. Displaying data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto13-Displaying-data.pdf [full text]] |
− | :*SQLfast Tutorial - <b>14. Advanced dialogues</b>, draft version, | + | :*SQLfast Tutorial - <b>14. Advanced dialogues</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto14-Advanced-dialogues.pdf [full text]] |
:*SQLfast Tutorial - <b>15. Large data objects</b>, draft version, March 3, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto15-Big-data.pdf [full text]] | :*SQLfast Tutorial - <b>15. Large data objects</b>, draft version, March 3, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto15-Big-data.pdf [full text]] | ||
− | :*SQLfast Tutorial - <b>16. Writing data tables - Part 1</b>, draft version, | + | :*SQLfast Tutorial - <b>16. Writing data tables - Part 1</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto16-Writing-tables-1.pdf [full text]] |
:*SQLfast Tutorial - <b>17. Writing data tables - Part 2</b>, draft version, March 6, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto17-Writing-tables-2.pdf [full text]] | :*SQLfast Tutorial - <b>17. Writing data tables - Part 2</b>, draft version, March 6, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto17-Writing-tables-2.pdf [full text]] | ||
:*SQLfast Tutorial - <b>18. Importing data (CVS)</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto18-Importing-data-(CSV).pdf [full text]] | :*SQLfast Tutorial - <b>18. Importing data (CVS)</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto18-Importing-data-(CSV).pdf [full text]] | ||
Ligne 81 : | Ligne 82 : | ||
:*SQLfast Tutorial - <b>29. Aid to SQLfast development</b>, draft version, February 13, 2014. [full text] | :*SQLfast Tutorial - <b>29. Aid to SQLfast development</b>, draft version, February 13, 2014. [full text] | ||
:*SQLfast Tutorial - <b>31. Topological sorting</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto31-Topo-sort.pdf [full text]] | :*SQLfast Tutorial - <b>31. Topological sorting</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto31-Topo-sort.pdf [full text]] | ||
− | :*SQLfast Tutorial - <b>32. Conway's Game of Life</b>, draft version, | + | :*SQLfast Tutorial - <b>32. Conway's Game of Life</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto32-Life-Game.pdf [full text]] |
− | :*SQLfast Tutorial - <b>33. Interactive SQLfast interpreters</b>, draft version, | + | :*SQLfast Tutorial - <b>33. Interactive SQLfast interpreters</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto33-Interactive-SQLfast.pdf [full text]] |
:*SQLfast Tutorial - <b>34. Geographic information systems</b>, draft version, February 13, 2014. [full text] | :*SQLfast Tutorial - <b>34. Geographic information systems</b>, draft version, February 13, 2014. [full text] | ||
:*SQLfast Tutorial - <b>35. Kings of France - Part 1</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto35-Kings-of-France.pdf [full text]] | :*SQLfast Tutorial - <b>35. Kings of France - Part 1</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto35-Kings-of-France.pdf [full text]] | ||
− | :*SQLfast Tutorial - <b>36. Kings of France - Part 2</b>, draft version, | + | :*SQLfast Tutorial - <b>36. Kings of France - Part 2</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto36-Kings-of-France(2).pdf [full text]] |
:*SQLfast Tutorial - <b>37. Text processing</b>, draft version, February 13, 2014. | :*SQLfast Tutorial - <b>37. Text processing</b>, draft version, February 13, 2014. | ||
:*SQLfast Tutorial - <b>38. Temporal databases</b>, draft version, February 13, 2014. [full text] | :*SQLfast Tutorial - <b>38. Temporal databases</b>, draft version, February 13, 2014. [full text] | ||
− | :*SQLfast Tutorial - <b>39. Schema-less databases (1)</b>, draft version, | + | :*SQLfast Tutorial - <b>39. Schema-less databases (1)</b>, draft version, April 6, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto39-Schemaless-DB(1).pdf [full text]] |
:*SQLfast Tutorial - <b>40. Schema-less databases (2)</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto40-Schemaless-DB(2).pdf [full text]] | :*SQLfast Tutorial - <b>40. Schema-less databases (2)</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto40-Schemaless-DB(2).pdf [full text]] | ||
− | :*SQLfast Tutorial - <b>41. Schema-less databases (3)</b>, draft version, | + | :*SQLfast Tutorial - <b>41. Schema-less databases (3)</b>, draft version, April 6, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto41-Schemaless-DB(3).pdf [full text]] |
:*SQLfast Tutorial - <b>42. SQL code injection</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto42-SQL-injection.pdf [full text]] | :*SQLfast Tutorial - <b>42. SQL code injection</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto42-SQL-injection.pdf [full text]] | ||
+ | :*SQLfast Tutorial - <b>43. The book of which you are the hero</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto43-Game-Books.pdf [full text]] | ||
:*SQLfast Tutorial - <b>Appendix 1. A basket of examples</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA1-Basket-of-examples.pdf [full text]] | :*SQLfast Tutorial - <b>Appendix 1. A basket of examples</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA1-Basket-of-examples.pdf [full text]] | ||
:*SQLfast Tutorial - <b>Appendix 2. SQLfast installation</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA2-SQLfast-installation.pdf [full text]] | :*SQLfast Tutorial - <b>Appendix 2. SQLfast installation</b>, draft version, February 13, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA2-SQLfast-installation.pdf [full text]] |
<Retour à la page d'accueil / Back>
Sommaire |