Postgres Connection Component

[dve83]

Hi,

I've noticed some thread saying that the Postgres Connection was disabled somewhere in verison 0.9 until further testing. Has there been any progress on making this available in the 64bit version of lazarus IDE?

many thanks
regards
dve83

[snorkel]

I believe it works.  I recall trying it out and had no issues aside from the fact it does not have the ability to receive notifications from the server.

I use PGDac from www.devart.com  works great and does not use libpq.dll or .so, it uses the PGSQL wire protocol directly, worth every penny.

[dve83]

Hi and many thanks for the reply. I've heard that devart component set is well worth the purchase. However, I am still in the very initial stages of my reasearch into lazarus as an alternative IDE (for 64bit and other platform deployment). I have installed the 64 bit version of lazarus and the 64bit version of Postgres (also very new to postgres). Under the SQLDB tab, however, I can find no database connection component for Postgres (I only see MYSQL and SQLLite connections). After some goolging, I found some related threads that mentioned the component was removed at some stages due to being untested thus far. I was hoping that it would soon become available for 64bit lazarus? - I really like to see how its fairs, before considering the devart / or any other component sets.

Many thanks again - any further input appreciated
Danie

[BigChimp]

What versions do you use? See signature.

Current trunk doesn't have Postgresql connectors.

You can upload a patch to the bugtracker to enable the postgresql component in Lazarus; for Laz you need to go to components\sqldb, and perhaps edit the makefiles, but certainly

Code: [Select]

{$IFNDEF win64}
{$DEFINE HASMYSQL4CONNECTION}
{$DEFINE HASORACLECONNECTION}
{$DEFINE HASPQCONNECTION}
{$DEFINE HASSQLITE3CONNECTION}
{$ENDIF}in registersqldb.pas

FPC trunk would need altering:
packages\fcl-db\src\sqldb\postgres

Code: [Select]

{ Drivers only for the following OSes }
Targets.DefaultOS:=[win32,openbsd,netbsd,freebsd,darwin,linux,haiku];

If applying a patch, please also specify a download location for the PostgreSQL 64 bit driver for windows; that will help with testing.

If you don't feel up to writing a patch, you can still open an FPC and a Lazarus feature request/bug on the bug tracker, indicating postgresql works for you on 64 bit windows and you want a driver for it. Indicate your OS/Lazarus/FPC version, as well as the location of the Postgresql driver, and as a courtesy, you could copy the details I wrote above.

If the patch is applied, you'll find it in snapshot versions of Lazarus trunk + FPC 2.7.1

[dve83]

Hi, thanks for the reply.

Im on the official release
lazarus-1.0-fpc-2.6.0

as well as the latest official Postgres release for 64bit (seems only 64bit for windows at this stage)

I will consider my options (checkout of trunk/source and making changes / bugtracker) and will post any related links if I have any.

Many thanks

[BigChimp]

More Danie,

Thanks for posting bug 23096! I think I'll have a go at writing up some patches...

Groete,
BigChimp

[dve83]

BigChimp,

no problem. Sorry I can't be of more immediate help with the patch - I'd might look into providing some contributions 'code wise' at a later stage - after I find my way around this new IDE / its structures.

Groete
Danie

[BigChimp]

No problem, Danie,

Just uploaded an FPC patch against FPC trunk (2.7.1) to http://bugs.freepascal.org/view.php?id=23096
Also a Lazarus patch (currently untested) to http://bugs.freepascal.org/view.php?id=23098

Groete,
BigChimp

[BigChimp]

FPC patch has been applied in r22607

[dve83]

Awesome news. Thank you for the very quick response.
I will try it out as soon as I can.

Kind Regards
Danie

[dve83]

Hi, apologies for my ignorance. I noticed the patches were applied to FPC 2.7.1 and trunk/source for lazarus.
Are there any compiled snapshots for these? Or must they be built from sources? (ie. I checkout everything and compile myself). Or perhaps another question - are their any estimates to the release of snapshots for these? Not yet sure of how the release cycles work.

Many thanks so far. Greatly appreciated.
Kind Regards
Danie

[BigChimp]

Ther's the Daily Snapshots (see link to the left on this page). The download links there indicate which versions were used to build them.

Snapshots are built from current trunk versions (as well as a version based on FPC fixes 2.6/2.6.1 instead of FPC trunk).

There is a roadmap/release plan somewhere on the wiki, something like post 1.0 roadmap or something that had a diagram of how releases would go in the near future.
No planned dates etc as far as I know and with 1.0.2 just released I wouldn't expected another version to be released quickly.

I'd give the daily snapshot a try.

[BigChimp]

Actually, the Laz patch was only applied yesterday!??!