Database Inquiry

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

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

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