What database are we going to use ?

Content and general development discussion, including maps, quests, and server code from the development team.
Post Reply
User avatar
Usiu
Peon
Peon
Posts: 15
Joined: Sun Mar 06, 2005 7:39 pm
Location: Poland
Contact:

What database are we going to use ?

Post by Usiu » Sun May 08, 2005 7:21 am

I suggest Postgresql

* Its easy to configure
* Stable, popular and powerful
* Good documentation
* libpq can be compiled on windows (http://www.sql.org/sql-database/postgre ... win32.html)

Any other suggestions ?
User avatar
gene
Peon
Peon
Posts: 28
Joined: Tue Aug 10, 2004 7:35 pm

Post by gene » Sun May 08, 2005 7:39 am

PostgreSQL is under the GPL.
MySQL is under the BSD license.

Here's a nice comparison of the two: http://www.devx.com/dbzone/Article/20743

I'm a fan of MySQL, but that's only personal preference. I've yet to use postgre, so I can't speak on technical differences myself.

I do love that BSD license, though.
User avatar
nym
Novice
Novice
Posts: 116
Joined: Wed Aug 18, 2004 11:01 am
Contact:

Post by nym » Sun May 08, 2005 10:30 am

I think SQLite will be put in use immediately, while other DBMS bindings would come later. As SQLite is: a) fast. b) small

When it comes to DBMS, i would use PostgreSQL over MySQL anyday. Especially when PostgreSQL is the most standard compliant SQL available (Postgre is on its way to SQL:2003 compliance, and MySQL misses out _alot_). But when it comes to performance, MySQL wins hands down against PostgreSQL (as most cut down software does). When it comes to licensing, i think PostgreSQL is the better of the two (as BSD can be proprietorized).

Wow.. 110010 posts..
YOU ARE READING THIS!
User avatar
Usiu
Peon
Peon
Posts: 15
Joined: Sun Mar 06, 2005 7:39 pm
Location: Poland
Contact:

Post by Usiu » Sun May 08, 2005 11:28 am

So we need a c++ wrapper for sqlite3
added wrapper by Ren? Nyffenegger.

So the thread is closed :)
User avatar
gene
Peon
Peon
Posts: 28
Joined: Tue Aug 10, 2004 7:35 pm

Post by gene » Sun May 08, 2005 6:31 pm

What are you intending on using the database for, client or server?

If the source for the database software isn't modified, licensing doesn't matter (except that it's free).
User avatar
Bjørn
TMW Adviser
TMW Adviser
Posts: 1430
Joined: Thu Dec 09, 2004 7:50 pm
Location: North Rhine-Westphalia, Germany
Contact:

Post by Bjørn » Sun May 08, 2005 9:37 pm

Only the server will store persistent dynamic data in a database, it doesn't concern the client which doesn't need to remember dynamic data across sessions.
User avatar
clsdaniel
Peon
Peon
Posts: 4
Joined: Wed Jul 06, 2005 6:40 am

Database Backend

Post by clsdaniel » Wed Jul 06, 2005 6:46 am

You could look the the ODK project, which offers a database agnostic access, and has C++ bindings, works on Linux, *BSD and Windows, and currently supports SQLite, MySQL and PostgreSQL, SQLite3 plugin is on development and will support other databases as well, transparently.

Ok, that was a shameless plug, but there is the advantage that i'm the developer ;), and can help providing any feature and coding for the project.

Site: http://odkit.sourceforge.net
E-Mail: clsdaniel@gmail.com
User avatar
ElvenProgrammer
TMW Adviser
TMW Adviser
Posts: 2526
Joined: Tue Apr 13, 2004 8:11 pm
Location: Italy
Contact:

Post by ElvenProgrammer » Wed Jul 06, 2005 9:00 am

Oh I thought it was already supporting SQLite3. We're "using" it, so I guess the first thing to do would be add support for it, if we decide to use odk.
User avatar
Verious
Peon
Peon
Posts: 42
Joined: Sat Apr 23, 2005 8:31 pm
Location: Online
Contact:

Post by Verious » Wed Jul 06, 2005 2:38 pm

I would suggest only selecting from database applications that support stored procedures and triggers as these can greatly increase performance (especially if the database is moved to a different machine than the server), improve security, and significantly improve data integrity and consistency.
User avatar
nym
Novice
Novice
Posts: 116
Joined: Wed Aug 18, 2004 11:01 am
Contact:

Post by nym » Thu Jul 07, 2005 3:06 am

Eh? I wouldn't really worry: there is a generic database interface which kindjal has written, which currently has backends for MySQL, PostgreSQL and SQLite3. Support for more databases will be added later if needed.
YOU ARE READING THIS!
Post Reply