PostGreSQL : are you interested in a wrapper for PB4 ?

Flype · Post by **Flype** » Fri Jun 16, 2006 4:46 pm

at work, i'll migrate our SGBDR from MySQL to PostGreSQL.
since purebasic use ODBC it should be easy.

i would like to make a wrapper for the 'libpq.dll'.

maybe some of you might be interested.

http://www.postgresql.org/

Flype · Post by **Flype** » Sat Jun 17, 2006 2:10 am

well, i'm suprised because it was not too hard.

so i made a PostgreSQL 8.1 wrapper for PB4.

works ok at home, but still in beta stage.

grab it here :
http://www.purebasic.fr/english/viewtop ... highlight=

Flype · Post by **Flype** » Sat Jun 17, 2006 9:22 am

just a little information that i didn't know:

Oracle Announces the Acquisition of PostgreSQL to improve it and keep it open-source :
http://www.postgresqlfr.org/files/oracle.html

Pantcho!! · Post by **Pantcho!!** » Sat Jun 17, 2006 9:28 am

THanks flype it sure will be usefull

z3phir2003 · Post by **z3phir2003** » Sat Jun 17, 2006 9:31 am

great job 10x for releasing the code

Flype · Post by **Flype** » Sat Jun 17, 2006 9:49 am

Yes, i hope it will be useful for pbusers.

Also, i think i will make a wrapper for the FireBird 1.5 SGBDR
as it is provided with a SDK, it should be as easy as MySQL 5 and PostgreSQL 8.1.
http://www.firebirdsql.org

I think we (pb-users) can bring to PureBasic 4.0 a collection
of ready-to-use SGBDR wrappers for the communauty making purebasic a little more professional.

Just an idea, if i understood well the subsytem functionality of purebasic, it should be possible to implement subsystems for Native ODBC / MySQL / PostgreSQL / FireBird / SQLite / Tsunami / and so on, with the advantage of using native database commands. Do you think it is do-able ?

It must be a good think even if the ODBC is also a simple and good way.

Post by **Fred** » Sat Jun 17, 2006 1:35 pm

Yes, the subsystem idea is the way to go, you just have create a new directory in Subsystems\ named 'MySQL' and put the new Database lib in it. Then specifified 'MySQL' in the subsystem field and it should work

.

Flype · Post by **Flype** » Sat Jun 17, 2006 1:48 pm

thanks fred,
and should i program the new database.lib in C/C++
or can it be done with TailBite ?

what's happened if all native commands are not implemented ?

Post by **Fred** » Sat Jun 17, 2006 2:51 pm

It can be done with Tailbite, it's just a regular purelibrary. If you don't implement all the commands of the original lib, then the compiler with tells 'This function isn't a command, macro etc..' as the original lib is simply ignored.

Dare · Post by **Dare** » Sat Jun 17, 2006 2:58 pm

Hi Flype.

Thanks for this.

blueb · Post by **blueb** » Sat Jun 17, 2006 4:48 pm

Thanks Flype.

Having various database tools at our disposal should really help to make PureBasic noticed in the programming community.

Thanks again,
--blueb