Postgres support // Abstracting the UI to be compatible with any database

[verekia]

I haven't been able to find a solid solution to manage the content of my databases (PostgreSQL) with a clean web UI that also works on mobile.

Firetable looks like a product that can be abstracted into just an UI package. The community could build adapters to plug that UI to any kind of database (MySQL, SQLite, Postgres, AWS...).

Alternatives:
Airtable is great on desktop and mobile but has a proprietary closed database.
Forest Admin is not usable on mobile.
Adminium is limited, and ugly.

[andig]

Sounds like an excellent idea. Firetable can easily provide e.g. admin access to any sort of (embedded) data store if abstraction permits. UI and storage should be decoupled, as well as UI and serving the UI.

[jonathan-chin]

any idea where this lands on the team's roadmap? I'm working on a non profit project and this abstraction could add so much value.

[shamsmosowi]

This is probably a long term project. Currently firetable relies heavily on firebase auth and storage, and has some firestore specific features, making it hard to make into a generic database UI. For now, I suggest checking out nocodb it might be the right solution for you

[glarrain-cdd]

Hello @shamsmosowi. Any news in this regard?
In the official website it is stated that support for MongoDB and PostgreSQL is "coming soon". Is there a timeline that you can share?
Thanks

[platform-kit]

@shamsmosowi any ETA on postgresql?

[harinij]

We are looking at this project now in our roadmap and will keep everyone posted once we have an ETA 🤞

[il3ven]

I'll be working on this. 😄

[yescine]

@il3ven any update on PostgreSQL integration or any open-source database ?! relying on third party for data storage remove all the fun and values especially with nowadays the need for data for LLM training.

[il3ven]

any update on PostgreSQL integration or any open-source database

@yescine I prototyped Postgres integration using postgrest and realtime. After a week of effort I was able to read data and show it in Rowy. However, more effort and research from both dev and user side is needed to understand better the best solution here and to provide ETA.

Could you share your use case for using Postgres with Rowy since there are other hosted Postgres database options and with table UI to manage it already out there, is there any specific reason you are looking for it on Rowy? Or is there any specific shortcoming in the other products that you are looking for us to address? This will greatly help us ensure we are building meaningful and useful product for you.

[yescine]

@il3ven since I use Hasura in every project (and future ones), PostgreSQL is my primary choice of DB. Not only is it versatile in handling jsonb data, vector data, etc., but many microservices related to my projects (invoices, accounting, etc.) also use PostgreSQL. While Hasura offers a basic level of data visualization, I require a more advanced and user-friendly UI to comprehend my data.

What I appreciate about Rowy is that it provides full Node.js code for calculating and aggregating cell data. For comparison, I started using NocoDB, which offers basic arithmetic for columns and cells.