Database Inquiry

[KLS]

I'm curious: if people could run eqemu on something other than MaridDB/MySQL what would people like to see?

[Tabasco]

I've used sqlite for small self-contained applications and tinkered a little with postgres. I'm not aware of any other viable open source databases and I prefer mysql simply because it's familiar.

Is there a better option that isn't commercial?

[werebat]

Postgresql would be my choice.

[Secrets]

postgres

or mssql server

[Kingly_Krab]

I saw a really cool system on private servers of Dekaron, they used CSV files in order to store information, I thought that was pretty cool, rather than a database idea. Although, if we have to use a database, I'd like MSSQL.

[Secrets]

I saw a really cool system on private servers of Dekaron, they used CSV files in order to store information

those are koreans who don't know how to code.

my point still stands.

[Kingly_Krab]

those are koreans who don't know how to code.

my point still stands.
Oh I know, obviously they wouldn't have to do that if they had MSSQL or MySQL, but I just thought it was a cool idea for a replacement.

[KLS]

Bleh I was really hoping no one would say MSSQL! ODBC is so gross.

No promises but we're looking at redoing some of the underlying database structures we use on the servers to be easier to use and less prone to error. In that process I thought it might be cool if we supported other databases where we could. If it is practical which has yet to be seen of course and is why I asked.

[jsr]

those are koreans who don't know how to code.

my point still stands.

Is the racial description relevant as well? In my experience, systems at the bleeding edge use flat files for storage rather than a SQL based DB.

But for emu I'd say postgresql as well :)

[moofta]

At work we use MSSQL and Oracle, and having use MySQL because of my monkeying around with EqEmu we're switching some of the mssql instances to mysql!

I'm interested in people's choices of postgresql - what advantages does it have over mariadb/mysql for this project?

If you want "flatfile" then you can think of NoSQL databases like MongoDb/CouchDb, but that really depends on whether you read way more than you write, and I suspect it's more like 60/40 read/write? (pure speculation on my part). The bonus in NoSQL is that sharding is usually built in, or simple to implement - although I'm not sure how many eqemu servers host on multiple machines in reality.

[provocating]

Bleh I was really hoping no one would say MSSQL! ODBC is so gross.

No promises but we're looking at redoing some of the underlying database structures we use on the servers to be easier to use and less prone to error. In that process I thought it might be cool if we supported other databases where we could. If it is practical which has yet to be seen of course and is why I asked.

Would it have to be ODBC what about OLEDB?

[sorvani]

Is the racial description relevant as well? In my experience, systems at the bleeding edge use flat files for storage rather than a SQL based DB.

But for emu I'd say postgresql as well :)

The 80's called. they want their flat files back.

[lerxst2112]

Having worked on two commercial MMOs that used flat binary files for all their storage I can tell you it is a horrible horrible idea that you will regret every day.

[jsr]

The 80's called. they want their flat files back.


Did they ask for their joke as well? ;)

I never suggested emu use flat files, I was making a point that using files (and being from Korea, how did that get through?) does not equal bad programming. Appreciate the context though so it didn't need to be said (my file comment)

[rhyotte]

PostgreSQL

For those curious about it:
-- http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/

-- http://www.craigkerstiens.com/2013/01/10/more-on-postgres-performance/

These make for a decent read on some of the up's and downs.

Also, this is kind of nice:
-- http://www.chesnok.com/daily/2013/11/13/everyday-postgres-tuning-a-brand-new-server-the-10-minute-edition/

Have a good one,
Gary

[bushman77]

Yah id say postgresql, been building a webpapp based off of this and it is indeed faster than mysql db. The commands arent too much different either.

[Akkadius]

Yah id say postgresql, been building a webpapp based off of this and it is indeed faster than mysql db. The commands arent too much different either.

I really doubt it

[demonstar55]

I really doubt it
It really depends what you're doing. PostgreSQL's Query Optimizer is better (much?) in some cases, but MySQL has made improvements there. PostgreSQL isn't really optimized for just reads, which a lot of our data is, but a good chunk of that we cache out in the shared_memory stuff :P