search

rowyio / rowy

Low-code backend platform. Manage database on spreadsheet-like UI and build cloud functions workflows in JS/TS, all in your browser.
http://rowy.io
Other
5.84k stars 477 forks source link

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

Open verekia opened 3 years ago

verekia commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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 commented 1 year ago

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 commented 1 year ago

@shamsmosowi any ETA on postgresql?

harinij commented 1 year ago

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

il3ven commented 1 year ago

I'll be working on this. 😄

yescine commented 8 months ago

@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 commented 8 months ago

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 commented 8 months ago

@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.