Jacob Kaplan-Moss

Activity tagged “sqlite”

Bookmarks

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.”

(programming, software, sqlite, testing)

Steve.org.uk - asql - Apache SQL querying

Read Apache logs into a sqlite database.

(analysis, apache, database, logging, sql, sqlite, stats, sysadmin)

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.

(postgresql, scripts, sqlite, trac)