You can give Firebird a try.
It is a very capable relational database, that can be used in embedded mode ("single file"). It's the embedded DBMS used by the newer versions of LibreOffice.
It can also be used as a central database server installation in case youneed that later.
It offers much better data type handling than SQLite (which essentially doesn'...