|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-04-2014, 05:13 AM
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
Database Inquiry
I'm curious: if people could run eqemu on something other than MaridDB/MySQL what would people like to see?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-04-2014, 08:09 AM
|
![Tabasco's Avatar](image.php?s=f538cb078ac2716c6b656aff7e5b48c4&u=110689&dateline=1411509503) |
Discordant
|
|
Join Date: Sep 2009
Posts: 269
|
|
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?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-04-2014, 02:48 PM
|
![werebat's Avatar](image.php?s=f538cb078ac2716c6b656aff7e5b48c4&u=143213&dateline=1421183982) |
Hill Giant
|
|
Join Date: Oct 2010
Posts: 143
|
|
Postgresql would be my choice.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-04-2014, 09:19 PM
|
![Secrets's Avatar](image.php?s=f538cb078ac2716c6b656aff7e5b48c4&u=75358&dateline=1253491419) |
Demi-God
|
|
Join Date: May 2007
Location: b
Posts: 1,448
|
|
postgres
or mssql server
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-04-2014, 09:38 PM
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,590
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-05-2014, 12:50 AM
|
![Secrets's Avatar](image.php?s=f538cb078ac2716c6b656aff7e5b48c4&u=75358&dateline=1253491419) |
Demi-God
|
|
Join Date: May 2007
Location: b
Posts: 1,448
|
|
Quote:
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-05-2014, 01:02 AM
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,590
|
|
Quote:
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-05-2014, 08:02 AM
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-06-2014, 06:37 AM
|
Hill Giant
|
|
Join Date: Aug 2008
Location: melbourne
Posts: 187
|
|
Quote:
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 ![Smile](http://www.eqemulator.net/forums/images/smilies/icon_smile.gif)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-06-2014, 08:31 AM
|
Sarnak
|
|
Join Date: Jan 2014
Location: United Kingdom
Posts: 53
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-06-2014, 09:07 AM
|
![provocating's Avatar](image.php?s=f538cb078ac2716c6b656aff7e5b48c4&u=81582&dateline=1410009195) |
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Quote:
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?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-06-2014, 03:05 PM
|
Dragon
|
|
Join Date: May 2010
Posts: 966
|
|
Quote:
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 ![Smile](http://www.eqemulator.net/forums/images/smilies/icon_smile.gif)
|
The 80's called. they want their flat files back.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-06-2014, 07:37 PM
|
Demi-God
|
|
Join Date: Aug 2010
Posts: 1,743
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
02-06-2014, 08:17 PM
|
Hill Giant
|
|
Join Date: Aug 2008
Location: melbourne
Posts: 187
|
|
Quote:
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)
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:35 PM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |