sqlite is amazing and everything. I still use Postgresql for most things - the tool support is genuinely a lot better. I also find the explain output much easi

sqlite is amazing and everything. 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.