Anyone know what happened to tpsql?
lazarus / 16-Databases

----------------------------------------------------------------------
snorkel · 2012-02-06 16:29

http://wiki.lazarus.freepascal.org/TPSQL

None of the download links work.

----------------------------------------------------------------------
BigChimp · 2012-02-06 16:46

Don't know, but you do realize there's built-in connectivity to
PostgreSQL using the SQLDB components?

----------------------------------------------------------------------
snorkel · 2012-02-06 17:53

yes, I know, but from reading the page about tpsql, it kind of sounded
like it didn't need libpq.dll and used tcp/ip only for communicating
with the server.  Just wanted to check it out.

----------------------------------------------------------------------
Leledumbo · 2012-02-07 01:43

Quoteyes, I know, but from reading the page about tpsql, it kind of
sounded like it didn't need libpq.dll and used tcp/ip only for
communicating with the server.Where is that stated? AFAIK you'll need
the respecting client library in order to access certain databases,
and that's applicable to all supported databases (unless you try to
create it yourself, which AFAIK no one is crazy enough to do it). It
would be required, either statically (the IDE compiled with references
to the dll as in sqlite package) or dynamically (only when needed as
with other dbms).

----------------------------------------------------------------------
ttomas · 2012-02-07 11:56

Quote(unless you try to create it yourself, which AFAIK no one is
crazy enough to do it)
DevArt is carazy enough, do it with PdDac, also working with lazarus
http://www.devart.com/pgdac/

----------------------------------------------------------------------
ttomas · 2012-02-07 12:00

I find this working link
http://es.sourceforge.jp/projects/sfnet_lazarus-
ccr/downloads/Code%20and%20Component%20Packages/PSQL%200.4.6/psql-laz-
package-0.4.6.tar.gz/

----------------------------------------------------------------------
Leledumbo · 2012-02-07 14:21

QuoteDevArt is carazy enough, do it with PdDac, also working with
lazarusOK, that means my knowledge is not wide enough.
Man, this DevArt guy is crazy...

----------------------------------------------------------------------
snorkel · 2012-02-07 21:57

Quote from: Leledumbo on February 07, 2012, 02:43:17 amQuoteyes, I
know, but from reading the page about tpsql, it kind of sounded like
it didn't need libpq.dll and used tcp/ip only for communicating with
the server.Where is that stated? AFAIK you'll need the respecting
client library in order to access certain databases, and that's
applicable to all supported databases (unless you try to create it
yourself, which AFAIK no one is crazy enough to do it). It would be
required, either statically (the IDE compiled with references to the
dll as in sqlite package) or dynamically (only when needed as with
other dbms).

It doesn't state that, but it also doesn't say libpq.dll is a
requirement, it simply says over IP.   Yes the Devart PostgreSQL
components work over IP using the wire protocol and don't need
libpq.dll and they totally rock for PostgreSQL. It's super nice to be
able to write a PostgreSQL app and not have to worry about deploying
libpq.dll and it's dependencies.
I actually have a copy, but you need the source code version to use
with Lazarus/Freepascal.

----------------------------------------------------------------------
JD · 2012-02-08 14:52

This is very interesting to me because PostgreSQL is one of three
databases that I use - the others being SQLite and Firebird. But is
this free?

----------------------------------------------------------------------
Zoran · 2012-02-08 20:26

Quote from: JD on February 08, 2012, 03:52:16 pmBut is this free?

No. See: http://www.devart.com/pgdac/editions.html
Only professional edition, which comes with source code, works with
Lazarus/FPC.

----------------------------------------------------------------------
JD · 2012-02-08 21:47

Quote from: Zoran on February 08, 2012, 09:26:03 pmQuote from: JD on
February 08, 2012, 03:52:16 pmBut is this free?

No. See: http://www.devart.com/pgdac/editions.html
Only professional edition, which comes with source code, works with
Lazarus/FPC.

Too bad. Anyway there's always Zeos and Lazarus' SQL component.