Hi Baserow Community,
I’m looking for some suggestion/feedback about a potential use case I am considering. Is the following a sane idea? If so, any thoughts on how to proceed (I am planning on self-hosting).
I’m in the process of migrating away from a Gatsby static website which pulls its data from Airtable. This setup has all kinds of issues that are not worth getting into. I’m currently in the process of migrating this static site to a python flask web application that is backed by a postgres database. The flask app uses SQLAlchemy to handle all the database functions (defining a schema, querying the database, etc.) I have written a one-off script which pulls my data off of Airtable and adds it to postgres, maintaining the relational structure of the data. My data is highly relational. I have set up a postgres schema which does a good job at modeling the data, using my own naming conventions.
This is a great setup, but I miss the Airtable UI which is amazing. I came across Baserow and it looks amazing in that it is Airtable-like but can run off a local postgres database. My idea is to somehow set up Baserow as a UI to my existing postgres schema. I assume that Baserow has it’s own naming conventions with respect to database schemas and perhaps I’ll have to change naming convention to match the Baserow one(?)
To sum up my questions are:
- Is this a sane use case?
- If so, how should I set it up? Should I use the Airtable migration tool to do the initial migration? Can I set up Baserow to read an existing postgres database? If so how do I do this?