Thi is just a question to gather opinion/experiences
I’m planning to write a post about an awesome service that I’ve been using for other stuff outside AppSheet that’s basically a “Postgres-as-a-service” in escense.
I think that pricing is really fair, more so considering that it supports Realtime database and API access via PostgREST.
@Marc_Dillon @1minManager @WillowMobileSys @Koichi_Tsuji @takuya_miyai
It’s funny that you posted this today, because I was just talking about it with a client. With the following config on Google Cloud
… it costs about $250 per month. We’re considering dropping the “vCPUs” down to 1, and the “Memory” down to 3.75 GB, based on our usage charts, and that should cut that cost about in half.
We’ve currently got 160 tables in the database. Nothing super big, maybe 20k records is the biggest one, but a lot of 3-6k record tables. We also have a few dozen apps, most of which are accessing some of the main reference tables in the db, but many also still with tables on GSheets waiting to be converted. That’s a pretty decent amount, so I doubt many other Appsheet users would need to use higher settings than this.
We also think that the “Highly available” setting was important to turn on, as there seemed to be some issues before we turned it on, but can’t really confirm that 100%. This setting adds a large chunk to the cost I believe.
Thanks, that was what I wanted to see, the voice of the experience.
Maybe you will find my next post useful, it seems like your cost could go a little bit down
@SkrOYC I’ve mainly got lots of small clients so I haven’t yet found how to justify the switch to enterprise licencing. So I’ve never actually used SQL yet with Appsheet
Great to know @1minManager
Thanks for your time
I have a handful of mssql DB in azure which are by far the most affordable (<$50/mo/instance) that have never given me issues.
I have some postgres DB in AWS for non-AppSheet workflows that run a bit more ($100/mo/instance); I had used a postgres db in AWS that was about $50/mo in the past and it worked fine. I have been testing some stuff on supabase recently, which has postgres databases hosted in aws.. not sure on the specs for these.
You nailed it
Here it is, the post I talked about:
Supabase mets AppSheet - Google Cloud Community
It’s meant for users wanting to test SQL on a free an easy way as well as a way to present Supabase to anyone already using SQL that might consider it a better alternative
