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]

Originally Posted by Kingly_Krab

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]

Originally Posted by Secrets

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]

Originally Posted by Secrets

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]

Originally Posted by 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.

Would it have to be ODBC what about OLEDB?

[sorvani]

Originally Posted by jsr

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/1...s-performance/

-- http://www.craigkerstiens.com/2013/0...s-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...inute-edition/

Have a good one,
Gary