More Database Connector

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
Schobaer
User
User
Posts: 16
Joined: Sat Mar 06, 2004 9:36 am
Location: Germany

More Database Connector

Post by Schobaer »

Such as UsePostgreSQLDatabase() I wish
- UseMSSQLDatabase() for direct use Microsoft SQL-Server
- UseAccessDatabase() for direct use Microsoft Access DBs
- UseMySQLDatabase() for direct use MySQL-Server (I know there are Libs for using)
- UseFBSQLDatabase() for direct use Firebird/Interbase
neseir
User
User
Posts: 10
Joined: Fri Jun 11, 2010 10:48 am

Re: More Database Connector

Post by neseir »

Hi

I would also love to see a UseFBSQLDatabase() connector !

//Eirik
User avatar
Bisonte
Addict
Addict
Posts: 1305
Joined: Tue Oct 09, 2007 2:15 am

Re: More Database Connector

Post by Bisonte »

hmmmm....

http://www.firebirdsql.org/en/odbc-driver/
http://dev.mysql.com/downloads/connector/odbc

and the MS Things are build in Windows...

If you want to have this as native support,
you have to tell the companies, that they give away
their products and made them open-source ;)
PureBasic 6.21 (Windows x64) | Windows 11 Pro | AsRock B850 Steel Legend Wifi | R7 9800x3D | 64GB RAM | RTX 5080 | ThermaltakeView 270 TG ARGB | build by vannicom​​
English is not my native language... (I often use DeepL.)
neseir
User
User
Posts: 10
Joined: Fri Jun 11, 2010 10:48 am

Re: More Database Connector

Post by neseir »

Hi Bisonte

Firebird sql is opensource. If possible I prefer native connectors instead of ODBC (FireBird is available on Win, Mac and Linux etc. Don't now the status of iODBC on linux but I think using a FireBird client lib directly is the best option). Regarding the other databases listed I think the PureBASIC team already have stated some problems with the implementation of a MySQL connector due to licenses restriction. MS SQL and Access are Windows only and probably supported as well using the ODBC connector vs a dedicated connector.

Regards
Eirik
User avatar
K1m0n
User
User
Posts: 13
Joined: Tue Jun 07, 2011 5:38 pm

Re: More Database Connector

Post by K1m0n »

Hi.
+1 for Firebird library support.
It would complement PureBasic well,
and provide a second option for an embedded db (other than SQLite).
**Disclaimer**
Any views or opinions expressed represent the official view of the voices in my head.
User avatar
Fangbeast
PureBasic Protozoa
PureBasic Protozoa
Posts: 4789
Joined: Fri Apr 25, 2003 3:08 pm
Location: Not Sydney!!! (Bad water, no goats)

Re: More Database Connector

Post by Fangbeast »

Regarding the other databases listed I think the PureBASIC team already have stated some problems with the implementation of a MySQL connector due to licenses restriction.
MariaDb is a "drop-in" replacement for MySQL by the Author of MySQL and is apparently (as far as I can see) free of license restrictions. That might be a way to go.

http://mariadb.org/
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
sphinx
Enthusiast
Enthusiast
Posts: 120
Joined: Thu Oct 26, 2006 6:34 pm
Contact:

Re: More Database Connector

Post by sphinx »

+1 for Firebird here, it would be a great integration for PureBasic (embedded and server database)!
Post Reply