What database are we going to use ?
Forum rules
This forum houses many years of development, tracing back to some of the earliest posts that exist on the board.
Its current use is for the continued development of the server and game it has always served: TMW Classic.
What database are we going to use ?
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 ?
* 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 ?
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.
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.
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..
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!
Database Backend
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
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
- ElvenProgrammer
- Founder
- Posts: 2526
- Joined: 13 Apr 2004, 19:11
- Location: Italy
- Contact: