Hacker News new | ask | show | jobs
by mtmail 462 days ago
From your description all would easily fit into RAM and full-scan searches across all records will be fast enough. Browsers hardly sweat reading 200MB data files. No need for indexes, optimized storage, compression or special query languages. Unless you'd worry about scale (managing the same for 1000 people). It's a luxury of modern hardware. I think databases or similar data stores will remain, but for many projects looking at performance or small memory footprint will no longer matter. I've used Postgresql for tiny projects (all in docker containers) because it was convenient.
1 comments

I often go with either SQLite or a JSON loaded to RAM and synced for really small stuff. But even SQLite is starting to seem like overkill. Honestly, I think most of my data will be able to fit into a single context window of an AI soon enough.