> Once you realise that SQLite is just an aggregated view over this log it calls into question if you needed a third party query engine at all, suddenly the whole NoSQL vs SQL debate becomes a meaningless implementation detail.
You are correct on the premise, however my observation has been that teams who try to be lean and mean and minimize dependencies always start off believing they don't need a query engine... and they always end up needing one, often making things much worse by refusing to just migrate to any database due to sunk cost fallacy.
I fully agree with your argument that it's all just file operations in the end. To me SQLite wins for everything beyond persistence however: the SQL commands, extensions, backups, changesets / patchsets.
Can you, I, and many others write something that has 10% of SQLite feature set that serves us perfectly? Absolutely! But I don't want to, and in business settings nobody will allow you to hand-roll crucial infrastructure software (like databases) unless they're in full crisis mode and you're the mega-expensive consultant brought in to save the day.
I would love to read your analysis somewhere. It's a current interest of mine, both hobby and professional -- and limited to Elixir, Golang and Rust -- and I'm still slowly scoping the landscape.
Recommendations for good engines? Or just thoughts and analyses?
MacBooks are still unbeaten hardware-wise. Yes 8GB of RAM is embarrassing, no question about it.
I'll buy a Neo just for travel. I will remote to my machines with it.
Though I'm flabbergasted why has nobody else made as thin and lightweight laptop like Apple... for decades. And that includes no fan, or just a very quiet one.
I have no love for Apple at all. But the Neo is a game-changer and a well-deserved kick in the nuts of, well, every other hardware company really.
> x86 is on the way out in for most consumer devices.
Define "consumer devices"? I am holding on to my AMD Ryzen machines until they literally fall dead. I have no complaints from them. Maybe some modern or even next-gen ARM CPUs will be even better on Linux but I don't think we are quite there yet.
x86_64 is here to stay for a long time still.
But maybe you literally meant x86 as in the 32-bit CPU arch? If so, I'd mostly agree but not quite; they could be used in low-power micro-PCs for a long time still as well.
From my research on Macbook alternatives only the Zenbooks looked like almost-an-even-match to me. Curious what's your experience with day-to-day fan noise and heat.
I use Claude Opus 4.7 on max thinking inside Claude Code and I gotta tell you, as context of the project grows, it starts slipping. No amount of whipping and cursing has helped.
Currently looking to start making my own hooks setup so it can be safer but nothing concrete yet.
Iran is also playing a PR war lately, playing the victims of the big bad USA.
They IMO embarrassed themselves hugely by shooting missiles and drones at their neighbors; not sure they'll want to also try to sink (literally) a new way for the world to get oil from that peninsula but through other routes.
Though of course propaganda knows no rest. They'll likely bend over backwards and do a front flip to again make it the fault of everyone else but not them.
- This was not mostly (if not fully) an AI-generated text;
- Had a clear problem statement. Why would you burn money on $17 - $50 bounties? In the hopes that you'd collect $30 at $5.68 spend? You can literally offer your services to carry boxes for a higher hourly rate.
You are correct on the premise, however my observation has been that teams who try to be lean and mean and minimize dependencies always start off believing they don't need a query engine... and they always end up needing one, often making things much worse by refusing to just migrate to any database due to sunk cost fallacy.
I fully agree with your argument that it's all just file operations in the end. To me SQLite wins for everything beyond persistence however: the SQL commands, extensions, backups, changesets / patchsets.
Can you, I, and many others write something that has 10% of SQLite feature set that serves us perfectly? Absolutely! But I don't want to, and in business settings nobody will allow you to hand-roll crucial infrastructure software (like databases) unless they're in full crisis mode and you're the mega-expensive consultant brought in to save the day.
reply