PureBasic Forums - English

I've got the following problem:

I'd like to write a database client program,
but database is not on the local machine but
only on remote host.
The database server is MySQL.

Is it possible to do it by PB?

Yes. Install the MySQL ODBC drivers and use the procedure from the database library in PB..

rogal79 wrote:I've got the following problem:

I'd like to write a database client program,
but database is not on the local machine but
only on remote host.
The database server is MySQL.

Is it possible to do it by PB?

Yes, it's suprisingly easy i've found, now that I've done it too. Many people in the forum run MySql and swear by it.

I'm running a library book management program being used remotely and locally by friends and family. MySQL server is running on my machine and no problems at all.

I swear by PostgreSQL (www.postgresql.org). MySQL died and took my data with it one too many times.

Karbon wrote:I swear by PostgreSQL (www.postgresql.org). MySQL died and took my data with it one too many times.

I had a conversation like this with an Oracle employee, lots of heat there :):) Still, I haven't had any problems (to date) and I know a lot of (really big) sites haven't either.

I'm using the current (stable) release of the server and client. What release were you using?

I don't like MySQL at all. It's a fast and suitable database for Internet applications, but to use it as an internal database for your company, it's possible, but it's really NOT the best solution. It misses triggers, stored procedures, not very good protecting data against corruption, not free when you use it in a commercial application (unless that same application is open source, yeah right), just a small SQL-92 set, etc.

I use Firebird, 100% free, doesn't that feel great! I can great server/client applications without paying one dime!
It has everything MySQL has but a lot more. It's slightly slower than MySQL, but for that you get a lot of data integrity in return. I can run it single user, client/server, they even have an embedded version.

Maintenance? Zero. Running? Always. Data corruption? What's that?

About MySQL; I've visited some Borland newsgroups and get the impression that 90% think MySQL is free. Only some smart Borland employees belonged to the 10%.
In reality, if you use MySQL more than just storing your private CD collection, you have to pay, simple as that. And that is a VERY important factor that should be taken in account when you start comparing MySQL with other databases.

wings wrote:if you use MySQL more than just storing your private CD collection, you have to pay, simple as that. And that is a VERY important factor that should be taken in account when you start comparing MySQL with other databases.

That is a little extreme Wings.

From MySQL web site:

The software from MySQL AB listed below is licensed under the GNU General Public License (GPL) and is provided "as is" and is without any warranty.

You need to purchase commercial non-GPL MySQL licenses:

* If you distribute MySQL Software with your non open source software,
* If you want warranty from MySQL AB for the MySQL software,
* If you want to support MySQL development.

if you can decide what database you want to use, give firebird (opensource & free to use) a try!
http://www.firebirdsql.org/

Pharao,

thanks a lot for that link. I sort of lost sight of InterBase over the years; I didn't know that Firebird is the open source continuation of InterBase.
What I like about it, is that it scales nicely from embedded usage up to enterprise deployement.
Too bad that the dll that you need for embedded apps is over 1 Mb large. SQLite is very nice in that respect. I guess it's a matter of 'horses for courses'.

Do you use Firebird with PureBasic? If so, can you please write some notes about how to get up and running with this combination?

By myself I run a MySQL Server 24/7, Web server 24/7 with php support, Ftp server (only when needed, like.. when I go out of home and I need to catch stuff from my server or pc, I just use FTP and/or Radmin). I used to run many other services, but they are useless right now... I'm just waiting to move, and get a better upstream line.

Fangbeast wrote:

Karbon wrote:I swear by PostgreSQL (www.postgresql.org). MySQL died and took my data with it one too many times.

I had a conversation like this with an Oracle employee, lots of heat there :):) Still, I haven't had any problems (to date) and I know a lot of (really big) sites haven't either.

I'm using the current (stable) release of the server and client. What release were you using?

In all fairness this was several years ago now. I had some trouble about 6 months ago with a crash corrupting the database but I successfully restored from a backup. I don't remember what version it wasbut I'm sure it wasn't their latest and greatest.

I've never (yes, never) had PostgreSQL screw any of my data up and I've been using it since the mid 6.X versions. It provides all the power, speed and reliability I've ever needed. It's also released under the BSD license so there aren't any GPL entanglements. PG is developed by a core group of people (IE not everyone with WinCVS!) so I sleep better at night knowing that it is very stable.

MySQL has it's uses for sure - I use it for a few things but don't (and never will) trust it for mission critical stuff. I know I'm probably just holding an old grudge too long but you know what they say - once bitten, twice shy

There's a low cost, small footprint (about 1mb) SQL server available here:

http://www.colourfull.com/multidb.html

the 3 user version is completely free so why not give it a go.