I realize the hosting version uses sqlite as the datasource, but can Grist itself be used on top of a postgres database? If so, is there any chance you would think of offering this as a hosted solution? What about bring your own database type of hosting solution, so you can host Grist software, but the database is connected via an external source?
1 Like
https://electric-sql.com/ is software that synchronizes one or more Sqlite databases with one or more Postgres servers. You can INSERT (or UPDATE/DELETE) to sqlite (even when offline) , which is synchronized ( when you are online) to Postgres, or in reverse direction. No matter how - manualy with interactive client, or programmaticaly. So you can work with both databases at the same time and data is synchronized all the time.
Hi @Francek_Prijatelj, I see you’ve posted this comment a number of times. Nice of you to share the idea, but it would really be helpful if you could elaborate on how one might go about setting up electric-sql to work with Grist.