Building Production Applications Using Go & SQLite
Explore the potential of SQLite for building scalable, production-ready applications on a single node in this GopherCon 2021 talk by Ben Johnson. Learn about recent advances in SQLite that make it a viable alternative to distributed computing, and discover how to leverage its capabilities for read-heavy workloads and moderate request loads. Dive into essential SQLite configurations, including journal mode, busy timeout, and foreign key enforcement. Examine the SQLite type system, benchmarking techniques, and methods for parallelizing in-memory SQLite. Investigate the data durability spectrum, exploring trade-offs between cost, complexity, and performance. Gain insights into improving data durability, regular backup strategies, and the use of Litestream for clustered SQLite setups. Compare SQLite performance with other SQL databases and learn how to benchmark network latency for point query performance. Finally, consider the possibilities of horizontally scaling SQLite for enhanced production experiences. Read more