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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
bb4847adbbba92f60d30cf5d3370d40e |
| User & Date: | drh 2012-10-29 13:15:33 |
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
135
136
137
138
139
140
141
142
...
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
</p>
</li>
<li><p><b>Command-line dataset analysis tool</b></p>
<p>
Experienced SQL users can employ
the command-line <b>sqlite</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>
................................................................................
</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>sqlite</b> or <b>sqlite.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
|
|
|
|
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
...
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
</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> ................................................................................ </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 |