SQLite has been the "get X thing done, quickly and effectively" for a very long while now, while far too many would keep chasing the shiny new fads with not as

SQLite has been the "get X thing done, quickly and effectively" for a very long while now, while far too many would keep chasing the shiny new fads with not as much solid footing and not as boring. There's still that lingering webscale effect on its reputation unfortunately. Not to say it's appropriate in every case, and many of its functions are incredibly unwieldy as opposed to postgres' to mention one, but that's something you can live with if it any of its great upsides apply to you. What seems to be taking over now are services that bolt stuff on top of it, some of which end up being valuable FOSS additions, others may as well just be proprietary hosted instances.