is there something like duckdb but suited for transactional database while still being postgres compatible

It might sound confusing but I wish to genuinely have something of a simpler postgres (in sqlite?) and then later if need be, i could migrate to postgres I suppose.