File Driver Documentation -> Native Postgresql Driver

Tags: #<Tag:0x00007fc0dee2ee78>

Hello! My development team is looking for alternatives to using the ODBC driver for our Postgresql databases for a variety of reasons (easier distribution, some issues with the ODBC driver itself, and features that Postgresql supports but ODBC does not).

We’d like to implement a native Postgresql driver for Clarion and were wondering if there was any documentation for the Clarion file driver interface, or alternatively a base set of source code scaffolding a driver that we could license. We may also be able to pay for consultation for somebody with experience with developing a Clarion file driver.

Any hints or suggestions? Thanks!

We’re currently using Clarion 10 but willing to upgrade to 11 if that would help.

As far as I know there is no DDK (driver development kit), no docs, nothing.
I understand that you goal is FILE,DRIVER(‘Postgresql’) usage in standard browses/forms - just switch the file driver in the dct and voila but I’m afraid it is unattainable goal.
An alternative is a direct access to native postgres libraries (one of the implementations can be found here).

Thanks! Yes, you understood correctly the goal I was hoping for. I will check out your implementation.

There used to be a driver kit (not for at least 20 years). I recently (2017) asked SV about it, and they said they’d consider reviving it after C11. But I doubt it would be inexpensive, and am not sure it would ever happen.

I’d happily pay for a PG driver. For those waiting for a driver kit from SV, I am happy to offer some quality Rocky Mountain land with ocean views for a very low price.

1 Like

What are the association fees?

No fees. It is all yours. Cash deal.

yes years ago (probably last century) Sean Wilson created a Paradox driver and a dBase driver using the driver kit and (from memory) BDE (Borland Database Engine). That was the only commercial use of the driver kit that I can remember but perhaps others made private use of it.

I don’t know why SV (or was it TS?) stopped selling it - perhaps it caused too much support.

1 Like

Given the amount of time it’s been between the announcement and non-delivery of the Community edition I don’t anticipate SV doing anything with the releasing of the driver kit this century.
If you really want to pursue this the easiest (but not necessarily cheapest) way would be to hire SuRF as a contractor and have him write what you need.

2 Likes

Hi Stephen,
I am curious, what features does Postgres have that are not supported by ODBC?
Thanks!

1 Like

Forgive me for my ignorance-- who is SuRF, and any info about how to get in touch with him? Thanks!

SuRF is Scott Ferrett

1 Like

Scott Ferrett, he was a JPI/Topspeed developer for many years and wrote a lot of the file drivers that we use today.

Thanks! That rang a bell, turns out we had gotten that name in a different conversation. So far have been unable to contact Scott, but will try again.

I’d be interested to see what becomes of this. (I also use Postgres) If you could please report back?