A developer details the migration of searchcode.com's database from MySQL to SQLite, resulting in what might be the world's largest SQLite database at 6.4TB. The migration involved implementing BTRFS compression, upgrading to a powerful server with an Intel Xeon CPU, and successfully maintaining performance across all operations.

https://boyter.org/posts/searchcode-bigger-sqlite-than-you/

#databasemigration #sqlite #infrastructure #performance #codesearch