Welcome! Log In Create A New Profile

Advanced

WX and Supabase

Posted by SteveSitas 
WX and Supabase
March 17, 2025 09:25AM
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
Info
Re: WX and Supabase
March 28, 2025 12:46PM
Hi Steven

I'm curious what the advantage of using a PostgreSQL database is over HFSQL?
Re: WX and Supabase
March 28, 2025 03:02PM
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
Re: WX and Supabase
March 28, 2025 04:56PM
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.
Re: WX and Supabase
March 28, 2025 07:43PM
Hi Derek,
have you any experience with PostgREST?

Regards
Steven Sitas
Re: WX and Supabase
March 30, 2025 03:36AM
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
Re: WX and Supabase
April 03, 2025 08:45PM
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
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: