WX and Supabase

Hi,
has anybody worked with supabase and Windev?
I am mainly interested in the following:

1. do you use PCSofts direct PostgreSQL driver, the ODBC driver or the JSON Api ?
2. what do you use to synchronize databases in supabase (postgreSQL) - like WXs wdmodfic ?

Regards
Steven Sitas

Hi Steven

I'm curious what the advantage of using a PostgreSQL database is over HFSQL?

Hi,

1. It is based on PostgreSQL, a high quality industrial strength open source database and using it on the cloud (safety etc) - fits with some of my clients needs.
2. It automatically creates Restful APIs and Graph QL Apis and they support PostgreSQL Row Level Security. Great for mobile apps
3. Very easy to setup and the hosting price is nice - I have been testing it with loveable.dev and I am surprised with its ease and quality
4. I am afraid that at some point PCSoft may go for a SAAS model with HFSQL and charge for it. If my apps use PostgreSQL, I can move easier to a new development environment ..

But since everything is moving very fast to the cloud. I see it as a first step WITHOUT having to support the cloud infrastructure myself

Regards
Steven Sitas

The PostgreSQL driver works great. (You can simply swap out anything in code with HChangeConnection.)

In general - I use HFSQL for all of the basic database CRUD stuff, but have a number of APIs that rely on complex SQL joins, and there is no way the world that this can be accomplished with HFSQL.

Hi Derek,
have you any experience with PostgREST?

Regards
Steven Sitas

Hi Steven,

No sorry. First time I ever heard of it, but it sure seems that there are lots of interesting options these days.

Regards,
Derek

hi do you mean a graph db. Like a simantic db like neo4j? I wam wordking on that and It seems I have to make a webservice api endpoint system in python . Thispython script in my case uses the native driver for the semantic db . I post and call with webdev .

But if postgess can generate Graph QL Apis ( is this a graph db like neo4j , I like to ake suer we are talkig about the same thing ) then that is cool