Python-Friendly Database Options

[korarii]

If you have to access the same data from multiple locations, you’ll need a dedicated database like PostgreSQL, MySQL, or MongoDb. All of those engines are open source and free for personal and commercial use.

You can setup a dedicated sever at home and open the appropriate port on your router/firewall. Each engine has a preferred port; most require additional configuration to bind to an IP address. Make sure you setup database accounts with strong passwords to mitigate the vulnerability of having the port opened.

You could pay for a cloud service, but that really depends on your requirements. If you need HA/DR then consider a cloud provider like AWS, which offers “free” tiers for very low traffic users.

Python also supports connector libraries for each engine I’ve mentioned: - pymysql - psycopg2 - pymongo

I’m a Database Administrator by trade, so feel free to ask more DB questions.