3 ms·
No one is running their OLTP and batch processing workloads on sqlite (bedrock or not) at scale. There may be unique cases for specific situations but show me a
by prescriptivist 4y ago
No one is running their OLTP and batch processing workloads on sqlite (bedrock or not) at scale. There may be unique cases for specific situations but show me an org with large and broad concurrency demands running sqlite at scale and I'm happy to be proven wrong.
- hansvm 4y agoThat sounds like a leadership problem rather than an indictment of sqlite
- prescriptivist 4y agoNo, it's pretty much an sqlite problem. As good as it is for limited concurrency situations (and synthetic benchmarks like this expensify blog), it does not compare to mysql or postgres for mediating hundreds or thousands of transactions per second.
- blowski 4y agoOne of the current Hacker News shibboleths: If SQLite is not the solution, change the problem.
- hansvm 4y agoMaybe, maybe not, but that wasn't the claim here. It was just a shitty argument against sqlite, one that could equally apply to mysql, lisp, questdb, apl, and a host of other tech if it were valid. Organizations choose tech stacks for a ton of reasons, most of which are only loosely related to performance and maintenance characteristics. The (proposed) fact that most organizations don't scale out sqlite doesn't say much at all about whether doing so I'd a good idea.
- rawoke083600 4y agoHaha too true ! If I may add: World: "We solved Cold Fusion !" HN: "Meh" World: "We solved Cold Fusion in RUST !" HN: "Shuttup you demi-god of tech and take my upvote !"