News for hackers. Stuff that matters.
Re:SQLite JSON at Full Index Speed Using Generated Columns by focusgroup0 on Friday December 12, 2025 @02:20PM (#46247680)
Thanks for the feedback. The document model in mongo was slopped together by a junior engineer, so perhaps an unorthodox approach. It is basically flat, and already used in a pseudo-relational manner via in-app join to the existing sqlite store. This blog post inspired me to think, what if we just chucked all the json from mongo into sqlite and used the generated indices? Then we can gradually "strangler fig" endpoint by endpoint
Re:SQLite JSON at Full Index Speed Using Generated Columns by rglynn on Saturday December 13, 2025 @03:55AM (#46253156)
This sounds roughly on-track, but I agree with GP; Postgres would probably be better (also has great JSON(B) support).