12 ms·
I have no use case where I store a TB of data in a sqlite let alone few GB. Currently this checks out and restore is few seconds.
by sighansen 18d ago
I have no use case where I store a TB of data in a sqlite let alone few GB. Currently this checks out and restore is few seconds.
- solatic 18d agoIt's classic HN to criticize OP that their solution doesn't scale, and then for OP to respond by saying that they don't need the scale and anyway PG tells you to do things that don't scale. SQLite is great for small-production scale. Don't let anyone tell you different. Just keep in mind that it's a pain to move if you ever do need to scale up. If it's a startup, you might. If it's a weekend hobby project you're building for your personal use only, you probably won't.