Our safe choice, works everywhere database pick is PostgreSQL or SQLite.

There are a good many "NoSQL" databases which are documented oriented, but it's often a good idea to begin with Postgres until more is needed.

Indeed, Postgres can store records with native JSON and queried and indexed by the JSON fields, and as of early 2022 SQLite includes native JSON fields as well, obviating the benefits of using MongoDB or similar

CouchDB is squeaking in as the document data store of choice because of its native HTTP replication allowing seamless integration with PouchDB on the client of offline sync.