L2J On PostgreSQL
Posted: Sun Oct 31, 2010 2:47 pm
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]
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]