Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 53 : | Ligne 53 : | ||
**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 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 - 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 - 2. Basic scripts</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-Tuto02-Basic-programs.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 4. Creating a database</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-Tuto04-Creating-DB.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 5. Updating data</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-Tuto05-Updating-data.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 6. More on variables</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-Tuto06-More-on-variables.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 7. Taking decisions</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-Tuto07-Taking-decisions.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 8. Reading data</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-Tuto08-Reading-data.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 9. Looping - The final chapter</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-Tuto09-More-on-Loops.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 10. SQLfast expressions</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-Tuto10-Expressions.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 11. Output channels</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-Tuto11-Output-Channels.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 12. Dialogues</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-Tuto12-Dialogues.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 13. Displaying data</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-Tuto13-Displaying-data.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 14. Advanced dialogues</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 15. Big data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 16. Writing data tables - Part 1</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-Tuto16-Writing-tables-1.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 17. Writing data tables - Part 2</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-Tuto17-Writing-tables-2.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 18. Importing data (CVS)</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-Tuto18-Importing-data-(CSV).pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 19. Importing data (DBF)</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-Tuto19-Importing-data-(DBF).pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 20. Importing data (MS Access)</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 22. Extending SQLfast</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 24. Recursive programming</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 25. Metadata - Walking on the wild side</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-Tuto25-MetaData.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 26. Metadata - Inception</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 28. SQLdraw</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 29. Aid to SQLfast development</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 31. Topological sorting</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-Tuto31-Topo-sort.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 32. Conway's Game of Life</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-Tuto32-Life-Game.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 33. Interactive SQLfast interpreters</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-Tuto33-Interactive-SQLfast.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 34. Geographic information systems</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 35. Kings of France - Part 1</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-Tuto35-Kings-of-France.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 36. Kings of France - Part 2</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-Tuto36-Kings-of-France(2).pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 37. Text processing</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. | |
− | + | :*<u>SQLfast Tutorial - 38. Temporal databases</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | |
− | + | :*<u>SQLfast Tutorial - 39. Schema-less databases (1)</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-Tuto39-Schemaless-DB(1).pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 40. Schema-less databases (2)</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-Tuto40-Schemaless-DB(2).pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 41. Schema-less databases (3)</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-Tuto41-Schemaless-DB(3).pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - 42. SQL code injection</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-Tuto42-SQL-injection.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - Appendix 1. A basket of examples</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-TutoA1-Basket-of-examples.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - Appendix 2. SQLfast installation</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-TutoA2-SQLfast-installation.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - Appendix 3. SQLfast summary</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-TutoA3-Summary.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - Appendix 4. SQL in a nutshell</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-TutoA4-SQL.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - Appendix 8. SQLite transactions</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-TutoA8-SQLite-Transactions.pdf [full text]] | |
− | + | :*<u>SQLfast Tutorial - Appendix 9. SQLfast internals</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-TutoA9-SQLfast-implementation.pdf [full text]] | |
===DB-MAIN=== | ===DB-MAIN=== |
<Retour à la page d'accueil / Back>
Sommaire |