NCDB vs WhyDB?

[arenyashar]

I'm using ArcEmu (version number unknown, but it's the latest off the SVN as of last weekend when I compiled it) and I'm finally at the stage of looking at world databases. I am aware of several different flavors (for a blizzlike server), but most notably NCDB and WhyDB are the ones that seem to be most popular.

What precisely is the differences between them? Where are NCDB's strengths over WhyDB and vice versa? Would a hybrid DB that fuses the best of each DB together work, and if so which tables should I add from NCDB to WhyDB for my own server? And most importantly why?

Thank you in advance,
Aren

[latruwski]

both strengths is stealing stuff from eachother lolz
Seriously DBteams just make stuff on their own, but if they can take stuff from other DBs they will But that is not bad.... i guess
Best thing would be to have a custom DB...
You could start with NCDB for example and add stuff to it that WhyDB has and NCDB has and then there will still be stuff missing or wrong in it... that you can fix yourself

[TheZaronz]

NCDB is probably the best because they get packets from retail and stuff, so they're more blizzlike,

[Hellgawd]

I personally support NCDB, for they have proven to be more consistent with their database.

[latruwski]

NCDB is probably the best because they get packets from retail and stuff, so they're more blizzlike,

lol you think those packets are in NCDB hands only? about 99% of the DBs have that

I have also always supported NCDB more then any other DB... cuz a lot of other DBs are just rippoffs of NCDB... but as i said, you"d better create your own custom DB with a start from NCDB

[Clain]

Actually... the only database that I know has ever sniffed packets(SMSG_QUEST_QUERY_RESPONSE, SMSG_GAMEOBJECT_QUERY_RESPONSE, SMSG_CREATURE_QUERY_RESPONSE, SMSG_ITEM_TEXT_QUERY_RESPONSE, etc) is NCDB because around 90% of the other database teams don't know how to make a packet analyzer to intercept the data . I'm not sure if PSDB did/does/used to... never kept track with them. Although all this has been done and released to the public. Look at Domi's packet analyzer project from WCell, thats a different story and going off track.

I support them all the way because they get things done, get 100% blizzlike data through more than one ways, and so on.

EDIT: Totally forgot about UDB.. they sniff aswell :P

[latruwski]

there is no 100% complete DB anyhow... but what i meant with NCDB not only DB with those packets is if they get leaked, in mather of days all other DBs get them/steal them from NCDB anyway....
PSDB did some too i think that is correct... and private DB developers do too... (Gorm, Bartus, ... )

Anyhow this guy should start out with NCDB and work along with that i think

[Seizerkiller]

UDB has always used packet sniffers.I don't see what's the point in advertising it, you still got to understand the packets.
But /offtopic, ascent db discussion.

[2dgreengiant]

NCDB for ease to install and works with all current emulators.

Whydb for updates i guess.

I could add more to this post but im tired

[thesixth]

I've been thinking about some hybrid DB too.
Currently I'm using DJFredricks Repack with NCDB.
Works like a charm, except from runic powers, a little bugged startinggear and some wierd spawnpoints.
Nothing that took long to fix but....

Sounds fun creating a new database.
There sure could be allot of improovements here and there.

I'm curious, since you guys suggest this as an option even though the Arc-revision still is a questionmark.
This leaves me the impression that it's not a big deal, itcould be done with a couple of hours work but.. gaah.. what does 'create your own Db' actually mean?

A server database is probably nothing more or less than the name proclaims.. a database with info on how the server should act.

But databases and databases....I don't get it.
By observing the execution of world.exe, I took notice that ArcEmu reads the whole damn DBC-database into memmory, and then, directly after that, it loads up the SQL-database, which is basically a thinner, stripped-down and incomplete version of the very same information within the whole exported client-side DBC-files.

I am no genious, but no fool either, there is probably some perfectly logical explanation and some neccessairy reasons behind an answer to that question.
They are probably compliments to eachother and needs to be loaded like this for some reason..Am i wrong?

If I'm not, then I can't figure out why a server should eaven need to bother reading the same pieces of information twice, ?
We surely could use a SERVER database that is independent to a CLIENT-SIDE database, wouldn't we ?

anyways, what I was pondering on was:

If it is suggested to develop your own database I've got to ask; Where should one start? How can this be done?