How to upgrade my personal project database from Notion
I've been using Notion as the database for some personal projects. The backend of the projects are written in Python. I don't have any formal CS training and have a vague idea that the better database solution has something to do with "data warehouses" and SQL, but I'm not sure where to go from here.
How are you accessing the data in notion now? Via HTTP? It might make sense to migrate to something that supports that interface in order to ease migration instead of a wholesale rewrite. You could start with sqlite or even postgres and with extensions mimic the interface you're used to while transitioning to a pretty scalable database.
What's the problem you're trying to solve?