SQLite JSON at Full Index Speed Using Generated Columns
Published: (December 12, 2025 at 08:25 AM EST)
1 min read
Source: Hacker News
Source: Hacker News
Related posts
Read more »JSON Parsing for Large Payloads: Balancing Speed, Memory, and Scalability
Benchmarking JSON libraries for large payloads !Illustration by VectorElements on Unsplashhttps://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-do...
How JOIN FETCH Reduced Database Load by 94%: A Real-World Case Study
Introduction The N+1 problem is one of the most common causes of high database load in Spring Boot applications. In this article, I’ll show you how to systemat...
High-Performance SQLite Reads in a Go Server
Workload Assumptions These recommendations assume: - Reads dominate writes are rare or offline - A single server process owns the database - Multiple goroutine...
Avoid UUIDv4 Primary Keys
Introduction Over the last decade, when working on databases with UUID Version 4^1 as the primary key data type, these databases have usually had bad performan...