I still use Postgresql for most things - the tool support is genuinely a lot better. I also find the explain output much easier to understand.
There are also features which I occasionally use which Postgresql support such as partitioning, functional indexes, partial indexes. These can be emulated in some way with sqlite I'm sure, but they are fairly nice.
I have implemented some really critical stuff in sqlite and it's been amazing though. Anyone using sqlite in production needs to really understand the concurrency limits though.
Which middleman? The suggested method of obtaining pure iron powder involves electrolysis of oxidized iron powder. I don't even see where you could insert coke into this process.
The process for actually making iron, rather than the one they've imagined, involves smelting with coke. I'm pretty sure that electrolysing iron oxide is not a thing that's done on an industrial scale.
I still use Postgresql for most things - the tool support is genuinely a lot better. I also find the explain output much easier to understand.
There are also features which I occasionally use which Postgresql support such as partitioning, functional indexes, partial indexes. These can be emulated in some way with sqlite I'm sure, but they are fairly nice.
I have implemented some really critical stuff in sqlite and it's been amazing though. Anyone using sqlite in production needs to really understand the concurrency limits though.