[Crossplatform] MySQL Wrapper

Post by **Fred** » Thu Jul 23, 2009 2:44 pm

I was looking for a "professional" database support. With ODBC you can already use mysql and such, but it's not build-in and can be problematic with crossplatform. The alternative to mysql is Postgresql which is an high peformance, totally free and reliable database server. So stay tuned

.

Xombie · Post by **Xombie** » Thu Jul 23, 2009 4:03 pm

I've been using PostgreSQL and PB at work for a very large project and have been extremely pleased with it. I use it natively rather than through ODBC.

Thalius · Post by **Thalius** » Fri Jul 24, 2009 10:01 am

i agree PGSQL is a very good Alternative while beeing Opensource. Also offers excellent performance. In some Points not that sophisticated as MySQL but if you dont need complex Transaction and Replication Mechanics then PG does the job aswell.

thanos · Post by **thanos** » Sat Jul 25, 2009 7:03 am

Coolman wrote:+1, Firebird is an excellent choice

+1
But it is not the easiest choice to run web sites.
At least for now.
Regards

Thanos

Coolman · Post by **Coolman** » Sat Jul 25, 2009 1:14 pm

For windows :

Firebird version 2.1.2 install = 7 mo
Firebird version 2.1.2 embedded (no install) = 5 mo

Postgresql version 8.4.0 zipped = 33 mo

the choice is quickly made, firebird seems more appropriate given the PureBasic a lightweight package ...

thanos · Post by **thanos** » Thu Aug 06, 2009 4:49 pm

Fred wrote:I was looking to integrate native mysql support to PB via a database plugin, and while browsing the libmysql sources, i saw it was licensed as GPL. After a few search on google, even PHP5 removed native support of mysql because of license constraint.

What does it means ? It means than if you use this lib (dll or statically linked) in a non-GPL program you have a to buy a license to mysql. That's quite disappointing for such a 'free' database manager. Just wanted to let you know to avoid bad surprises.

Fred,
what about Firebird?
Is it completely free, without any problems with its license, robust, almost zero administration etc.
Regards.

Thanos

Thalius · Post by **Thalius** » Thu Aug 06, 2009 4:59 pm

Firebird & Postgres ( for advanced stuff ) would be nice. FireBird doesent have quiet that SQL Featureset. Postgres comes close to MySQL however versioning support could be a pain in the nards.

Maybe some kind of C# import converter would be a nifty idea - maybe one day ill do one if i need it. Currently i need to see that i dont burn out on wrapping stuff etc.

Currently planning a 3d strategy game framework for fun first anyway - tho ill use SQLite for that as its perfectly suitable and very comffy to use.

Cheers,
Thalius

t57042 · Post by **t57042** » Sat Jan 12, 2013 2:06 pm

Why not use MARIADB?

electrochrisso · Post by **electrochrisso** » Sun Jan 13, 2013 2:21 am

t57042 wrote:Why not use MARIADB?

Looks extremely bloated to me, definitely not an engine to be used for developing software that need to be downloaded and used by the general audience.

infratec · Post by **infratec** » Sun Jan 13, 2013 7:49 pm

electrochrisso wrote:Looks extremely bloated to me, definitely not an engine to be used for developing software that need to be downloaded and used by the general audience.

It's same 'bloated' as MySQL and Postgres.
So no reason to do it not.

Or should Fred remove Postgres because it's to bloated for the general audience

[ironic mode on]
Oh, and when I'm general too, he can also remove the complete 3D stuff from PB: I never used it up to now.
[ironic mode off]

Bernd

electrochrisso · Post by **electrochrisso** » Mon Jan 14, 2013 1:53 am

infratec wrote:
electrochrisso wrote:Looks extremely bloated to me, definitely not an engine to be used for developing software that need to be downloaded and used by the general audience.
It's same 'bloated' as MySQL and Postgres.
So no reason to do it not.

Or should Fred remove Postgres because it's to bloated for the general audience

[ironic mode on]
Oh, and when I'm general too, he can also remove the complete 3D stuff from PB: I never used it up to now.
[ironic mode off]

Bernd

The 3D stuff is not bloated, its a fraction of a, MARIADB, 140mb download, for win32 and 260mb for win64, and it all fits into the PB installer, including the examples. I mean, hello, who is going to download, install, or even use these bloated DB when SQLite will do 99.9% of what is needed at under 1mb.

infratec · Post by **infratec** » Mon Jan 14, 2013 8:10 am

electrochrisso wrote:The 3D stuff is not bloated...

This was only an example, that not everything which is not usefull for you maybe useful for others

And If I have to add the directx dll it is also a bit 'bloated'.

electrochrisso wrote:...I mean, hello, who is going to download, install, or even use these bloated DB when SQLite will do 99.9% of what is needed at under 1mb.

And if you write an application for a company you copy the sqlite database always arround from one PC to the next

I always have to use Postgres or MySQL (ODBC or the dll depending on what the customer want)

Oh, that's my last comment about that.
[ironic mode on] I don't want to bloat this thread more than needed.[ironic mode off]

Live and Let live(Die)

Bernd

PureBasic Forums - English

[Crossplatform] MySQL Wrapper

Re: [Crossplatform] MySQL Wrapper

Re: [Crossplatform] MySQL Wrapper

Re: [Crossplatform] MySQL Wrapper

Re: [Crossplatform] MySQL Wrapper

Re: [Crossplatform] MySQL Wrapper