Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix the name of the command-line tool in the whentouse.html page. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
bb4847adbbba92f60d30cf5d3370d40e |
User & Date: | drh 2012-10-29 13:15:33.705 |
Context
2012-10-29
| ||
19:14 | Fix typos in the documentation of xDisconnect and xDestroy methods of virtual tables. (check-in: 1974081af3 user: drh tags: trunk) | |
13:15 | Fix the name of the command-line tool in the whentouse.html page. (check-in: bb4847adbb user: drh tags: trunk) | |
2012-10-26
| ||
14:21 | Update althttpd.c to use getrusage() for finding run-time information for the log. Always wait for children prior to reporting child runtimes. (check-in: 357e7b7813 user: drh tags: trunk) | |
Changes
Changes to pages/whentouse.in.
︙ | ︙ | |||
128 129 130 131 132 133 134 | </p> </li> <li><p><b>Command-line dataset analysis tool</b></p> <p> Experienced SQL users can employ | | | 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 | </p> </li> <li><p><b>Command-line dataset analysis tool</b></p> <p> Experienced SQL users can employ the command-line <b>sqlite3</b> program to analyze miscellaneous datasets. Raw data can be imported from CSV files, then that data can be sliced and diced to generate a myriad of summary reports. Possible uses include website log analysis, sports statistics analysis, compilation of programming metrics, and analysis of experimental results. </p> |
︙ | ︙ | |||
163 164 165 166 167 168 169 | </p> </li> <li><p><b>Database Pedagogy</b></p> <p> Because it is simple to setup and use (installation is trivial: just | | | 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 | </p> </li> <li><p><b>Database Pedagogy</b></p> <p> Because it is simple to setup and use (installation is trivial: just copy the <b>sqlite3</b> or <b>sqlite3.exe</b> executable to the target machine and run it) SQLite makes a good database engine for use in teaching SQL. Students can easily create as many databases as they like and can email databases to the instructor for comments or grading. For more advanced students who are interested in studying how an RDBMS is implemented, the modular and well-commented and documented SQLite code can serve as a good basis. This is not to say that SQLite is an accurate model of how other database engines are implemented, but rather a student who |
︙ | ︙ |