L2J On PostgreSQL

If something doesn't fit in any other forum then post it here.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
Eduard
Posts: 15
Joined: Tue Jun 03, 2008 2:09 pm
Location: Lithuania, Vilnius

L2J On PostgreSQL

Post by Eduard »

Hello guys, today I have started porting whole l2j database into PostgreSQL. You ask why?
The answer is quite simple:
* With recent release of PostgreSQL 9 it got replication support <3
* It's a myth that PostgreSQL is slower than MySQL. If fine tuned it can outperform MySQL.
* On PostgreSQL we have more ''freedom'' with using indexes. It doesn't introduce huge overheads when updating datasets. No more huge waiting times when issuing select's on big datasets.
* Currently l2j database is not using even simplest things to ensure data integrity and consistency in database. Actually it can be done in MySQL, but i already see more cons to port everything into PostgreSQL and do it there.

So, im opening a project, which will be aiming at adding full PostgreSQL support into MySQL.

http://code.google.com/p/l2jserver-on-postgresql/

Everyone with medium/advance knowledge of MySQL/PostgreSQL is free to join.
email me at: [email protected]
Image
Post Reply