SQLite Sample Database Files

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

23 check-ins

2023-10-23
13:47
Fix FTS4 table in demo01.db so that it can be integrity-checked. Change FTS4 in sqliterepo.db into FTS5. Leaf check-in: e6fe90c3bb user: drh tags: trunk
2021-12-04
14:56
Fix a typo in ssb-queries.txt that prevented Q3.3 and following from running. check-in: b07a4a8c9c user: drh tags: trunk
2021-11-30
19:44
Change the ssb-small.db database to use integer primary key. Add scripts that were used to generate and query this database. check-in: 0174bf1c42 user: drh tags: trunk
16:26
Add an SSB (Star Schema Benchmark) database with scale 0.01, but with ANALYZE statistics taken from a scale 1.0 version of the database. check-in: 513443ec44 user: drh tags: trunk
15:43
Modify the TPC-H-small.db table to make use of WITHOUT ROWID where appropriate. Also run ANALYZE but revise the ANALYZE results so that they are for a scale-factor 1.0 database. check-in: 5e282ed3a0 user: drh tags: trunk
15:19
Add the TPC-H-small.db database obtained from [https://github.com/lovasoa/TPCH-sqlite]. check-in: b1f5936c5d user: drh tags: trunk
2018-04-12
14:00
Add read-only databases with both big-endian and little-endian WAL files. check-in: d1a7ba91eb user: drh tags: trunk
2017-07-26
16:59
Change the run_rbu_tests.tcl script to make temporary test databases writable. check-in: d74d356bf6 user: drh tags: trunk
2017-06-07
12:33
Add the "employee.db" database containing 240MB of test data derived from the MySQL employee test database at [https://github.com/datacharmer/test_db]. check-in: 33cae412d7 user: drh tags: trunk
2017-04-08
13:39
Update the selftest.txt script to include recently added test databases. check-in: 1b8f42f23f user: drh tags: trunk
13:36
Add the database of random JSON strings. check-in: fe7cd697e8 user: drh tags: trunk
2017-04-07
20:11
Add a test database that contains difficult-to-dump text strings. check-in: 12321619f7 user: drh tags: trunk
2017-03-25
12:31
Add demo01.db to the selftest.txt script. check-in: 97188236b6 user: drh tags: trunk
2017-03-23
17:23
Add the small "demo01.db" test database based on an old Fossil repository for SQLite4. check-in: 882db53866 user: drh tags: trunk
2017-03-22
12:59
Add the selftest.txt script that runs ".selftest" on all database files. check-in: ea1492a7a5 user: drh tags: trunk
2017-03-10
20:50
Remove obsolete sqlite_stat2 and sqlite_stat3 tables from sqliterepo.db. check-in: 525fa3c408 user: drh tags: trunk
18:36
Update rbu/rbu_round_trip.tcl to use "sqlite3 .selftest" instead of "dbselftest". check-in: ceef0c005b user: dan tags: trunk
01:01
Update the SELFTEST tables on databases so conform to the new CLI .selftest format. check-in: 0cb0b7b4c0 user: drh tags: trunk
2017-03-09
18:05
Add a corrupt database file that tests the ability of the CLI .dump command to reverse directions and return the tail data for both a rowid table and a WITHOUT ROWID table. check-in: bd97947e56 user: drh tags: trunk
2017-03-08
18:24
Add scripts to use the database files in this project to test RBU and sqldiff. check-in: 7e20e8aca3 user: dan tags: trunk
2017-03-07
20:01
Change the selftests on the sqlite_master table for the manyblob databases so that they include an ORDER BY clause. check-in: e13314eff6 user: drh tags: trunk
2017-02-08
20:47
Initial six test databases. check-in: 91b60cce4e user: drh tags: trunk
2017-02-07
21:13
initial empty check-in check-in: 8b25f87bfd user: drh tags: trunk