PostgreSQL as an alternative to MySQL?

Alreadythere

BeBot Maintainer
Administrator
Grandmaster

Offline

Posts: 1085

Re: PostgreSQL as an alternative to MySQL?

« Reply #15 on: February 21, 2008, 01:27:35 PM »

Quote from: TigerDragon on February 21, 2008, 01:23:16 PM

Yep... pretty much what I was planning.

Ignore my comments then Wink


	Logged

Glarawyn

BeBot Developer
Champion

Offline

Posts: 414

Re: PostgreSQL as an alternative to MySQL?

« Reply #16 on: February 28, 2008, 04:54:05 PM »

For supporting multiple databases, should we be looking at something like PDO, PEAR MDB2, or some abstraction layer?

Looks like PEAR MDB2 supports fbsql, ibase, mssql, mysql, mysqli, oci8, pgsql, querysim, and sqlite.


	Logged

Alreadythere

BeBot Maintainer
Administrator
Grandmaster

Offline

Posts: 1085

Re: PostgreSQL as an alternative to MySQL?

« Reply #17 on: February 28, 2008, 05:30:59 PM »

Something like PDO may help - though that would require a complete rewrite of all DB access too.


	Logged

Glarawyn

BeBot Developer
Champion

Offline

Posts: 414

Re: PostgreSQL as an alternative to MySQL?

« Reply #18 on: February 28, 2008, 08:29:50 PM »

Quote from: Alreadythere on February 28, 2008, 05:30:59 PM

Something like PDO may help - though that would require a complete rewrite of all DB access too.

PDO doesn't look like a complete solution...

Right now our SQL is written for MySQL and only MySQL. It might be generic enough for PGSQL or SQLite, or it may not be. I know in some of my modules I have queries that will only work in MySQL as I've specified the MySQL storage engine to use.

PEAR MDB2 does some sort of abstraction/translation so that the SQL queries will work on any database supported by PEAR MDB2...

I've heard a number of arguments on why PostgreSQL is superior to MySQL, and those arguments just don't apply for what we're doing with BeBot and MySQL. Referential integrity, foreign keys, full transaction logging, and what have you just aren't a concern for BeBot.

If we were to officially support a database other than MySQL my vote would be for SQLite first as it doesn't require running of a database server, thus lowering the requirements for running BeBot significantly. BeBot + SQLite would be something IGN users (poor souls) looking for an upgrade path would go for.


	Logged

Blueeagle

Omnipotent
BeBot Developer
Expert

Offline

Gender: Male

Posts: 313

Re: PostgreSQL as an alternative to MySQL?

« Reply #19 on: February 28, 2008, 08:39:04 PM »

Quote from: Glarawyn on February 28, 2008, 08:29:50 PM

BeBot + SQLite would be something IGN users (poor souls) looking for an upgrade path would go for.

Whistling into a modem would be an upgrade for IGN users. </joke>


	Logged

The only problem that can't be solved by adding another wrapper is having too many wrappers.

Alreadythere

BeBot Maintainer
Administrator
Grandmaster

Offline

Posts: 1085

Re: PostgreSQL as an alternative to MySQL?

« Reply #20 on: February 28, 2008, 08:50:48 PM »

Quote from: Glarawyn on February 28, 2008, 08:29:50 PM

Right now our SQL is written for MySQL and only MySQL. It might be generic enough for PGSQL or SQLite, or it may not be. I know in some of my modules I have queries that will only work in MySQL as I've specified the MySQL storage engine to use.

I think some of the datatypes are pretty MySQL specific. Maybe even a couple of the MySQL queries I used, I haven't checked what is supported by which sql server.

Quote from: Glarawyn on February 28, 2008, 08:29:50 PM

I've heard a number of arguments on why PostgreSQL is superior to MySQL, and those arguments just don't apply for what we're doing with BeBot and MySQL. Referential integrity, foreign keys, full transaction logging, and what have you just aren't a concern for BeBot.

I think all of that could be done with MySQL and InnoDB tables too. Not that we need it, true.

Quote from: Glarawyn on February 28, 2008, 08:29:50 PM

If we were to officially support a database other than MySQL my vote would be for SQLite first as it doesn't require running of a database server, thus lowering the requirements for running BeBot significantly. BeBot + SQLite would be something IGN users (poor souls) looking for an upgrade path would go for.

Would be nice, but I think there would be datatype problems again.

And Blue, thats no joke Tongue


	Logged

Hyde

Rookie

Offline

Posts: 46

Re: PostgreSQL as an alternative to MySQL?

« Reply #21 on: August 08, 2008, 09:16:07 PM »

Just to throw in $.02 from the "I don't do DB work" side of the fence ... anything that would let SQLite work would be very welcome. I wouldn't use it for orgbots or raidbots, but I'd definitely use it for a personal bot. I travel alot and don't like to have to run XAMPP from a USB stick all the time (so I just don't bother). But if it was running SQLite and I could just run the one thing to have it I would definitely use it.

It may be -way- outside the usual scope of BeBot but it would sure be useful.


	Logged

Doctorhyde/Jexyll/Goraud@RK2

Pages: 1 [2] Go Up

BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Development > Feedback and Suggestions > Topic: PostgreSQL as an alternative to MySQL?

« previous next »