With either an in-memory db or using zstd compressed ramdisks the limits are ridiculous.
Who needs durability anyway, right?
Who needs durability anyway, right?
But more seriously if you want the best of both worlds (in-memory speeds and durability) there are NVDIMMs.
SQL Server can take advantage of them: https://docs.microsoft.com/en-us/sql/relational-databases/pe...
I imagine with some effort SQLite could as well.
[1] example: not quite WAL, but disabling full logging, so it was then on simple logging, on MSSQL as part of a log shrink process. On a cient site. Who did 3-hourly log backups.
Suitability depends on what the requirements are.