Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| SHA1 Hash: | bb4847adbbba92f60d30cf5d3370d40e5be1195e |
|---|---|
| Date: | 2012-10-29 13:15:33 |
| User: | drh |
| Comment: | Fix the name of the command-line tool in the whentouse.html page. |
Tags And Properties
- branch=trunk inherited from [b2e03e19ab]
- sym-trunk inherited from [b2e03e19ab]
Changes
Changes to pages/whentouse.in
128 </p> 128 </p> 129 </li> 129 </li> 130 130 131 <li><p><b>Command-line dataset analysis tool</b></p> 131 <li><p><b>Command-line dataset analysis tool</b></p> 132 132 133 <p> 133 <p> 134 Experienced SQL users can employ 134 Experienced SQL users can employ 135 the command-line <b>sqlite</b> program to analyze miscellaneous | 135 the command-line <b>sqlite3</b> program to analyze miscellaneous 136 datasets. Raw data can be imported from CSV files, then that 136 datasets. Raw data can be imported from CSV files, then that 137 data can be sliced and diced to generate a myriad of summary 137 data can be sliced and diced to generate a myriad of summary 138 reports. Possible uses include website log analysis, sports 138 reports. Possible uses include website log analysis, sports 139 statistics analysis, compilation of programming metrics, and 139 statistics analysis, compilation of programming metrics, and 140 analysis of experimental results. 140 analysis of experimental results. 141 </p> 141 </p> 142 142 ................................................................................................................................................................................ 163 </p> 163 </p> 164 </li> 164 </li> 165 165 166 <li><p><b>Database Pedagogy</b></p> 166 <li><p><b>Database Pedagogy</b></p> 167 167 168 <p> 168 <p> 169 Because it is simple to setup and use (installation is trivial: just 169 Because it is simple to setup and use (installation is trivial: just 170 copy the <b>sqlite</b> or <b>sqlite.exe</b> executable to the target machine | 170 copy the <b>sqlite3</b> or <b>sqlite3.exe</b> executable to the target machine 171 and run it) SQLite makes a good database engine for use in teaching SQL. 171 and run it) SQLite makes a good database engine for use in teaching SQL. 172 Students can easily create as many databases as they like and can 172 Students can easily create as many databases as they like and can 173 email databases to the instructor for comments or grading. For more 173 email databases to the instructor for comments or grading. For more 174 advanced students who are interested in studying how an RDBMS is 174 advanced students who are interested in studying how an RDBMS is 175 implemented, the modular and well-commented and documented SQLite code 175 implemented, the modular and well-commented and documented SQLite code 176 can serve as a good basis. This is not to say that SQLite is an accurate 176 can serve as a good basis. This is not to say that SQLite is an accurate 177 model of how other database engines are implemented, but rather a student who 177 model of how other database engines are implemented, but rather a student who