Jacob Kaplan-Moss

3 items tagged “sqlite”

📌 How SQLite Is Tested

SQLite’s testing infrastructure is nothing short of inspired: “SQLite [...] consists of approximately 62.2 KSLOC of C code. [...] By comparison, the project has 716 times as much test code and test scripts—44568.6 KSLOC. [...] The TCL test suite obtains 99.37% statement coverage [... and] 95.16% branch coverage.” #

📌 Steve.org.uk - asql - Apache SQL querying

Read Apache logs into a sqlite database. #

📌 SqliteToPgScript - Trac Hacks - Plugins Macros etc. - Trac

Script to migrate a SQLite trac database to PostgreSQL. Needed a couple of hacks by hand, but otherwise works quite well. #