Database Inquiry

[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.

[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.