Given the progress both Mariadb and postgresql has made I think you will not go wrong with either. In both you have support for json now which one you chose dep

Given the progress both Mariadb and postgresql has made I think you will not go wrong with either. In both you have support for json now which one you chose depends on your use case. Mariadb - If you want easy horizontal scalability with master-master replication go with mariadb. Postgresql - If you want reliable and powerful sql-92 compliance and willing to work with master-slave go for postgresql. You can do master to master with postgre-Xl [1]. But still given the ease of use with which you can work with galera cluster I would not recommend postgresql for master-master. Anyways for your other questions: 2. SQLite already supports json type [2] so its not SQLite+JSON its just SQLite. 3. Yes you can write a simple python script to do it. 4. Why to use a custom file format when SQLite has its own format with support for json. [1] https://www.postgres-xl.org/ https://www.postgres-xl.org/ [2] https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html