DB project?

[Riven]

As an old mangos user and compiler, I think a DB project must be done separately to assure maximum efectivity and fast pace. when DB is considered and reworked, it would be nice to begin a DB project, as mangos have.
when we are provided with a world sql, work can begin.
So, a question, will developers make DB too? we can do a DB project for eq2emulator?

[LethalEncounter]

That is a great idea. I agree with you that a DB project is needed and that it needs to be done by a team outside of the development team. When I get a chance I'll right some parsers that can parse EQ2 Collector log files and produce usable data as a result. It wont be right away as my priority is to bug fix right now, but I'll try to get something soon for anyone that wants to help out in creating a master database.

[Riven]

Nice to hear that. Then, a message to the users, anyone with SQL knowledge and EQ2 player wants to make a DB group with me? If anyone wants to hear more, PM me or answer here, we can dicuss theories while waiting for more info from Devs.
I'll provide web and forum

[Diamente]

I know the database schema is still in an almost constant state of change right now, but you can get the schema as it is now (or whenever you run it) by downloading the db updates from the LS at www.eq2emulator.net and doing:
mysqldump --no-data --opt eq2 > eq2_database_schema.sql
Obviously, if you wanted to grab data also, you'd nix the "--no-data" argument.
Along similar lines, I wouldn't mind helping out with a DB project whenever that ball gets to a point it can roll.

[John Adams]

I have what I feel is extensive knowledge of databases in general - no DBA, but definitely know my way around comfortably. I would be willing to contribute to a DB project for EQ2. Creds: I was one of the original DB designers for the EnB project, which was all from memory since EnB shut down 2 years ago or more...
I am not willing to enter data "from memory" (again heh), it would have to be collected data from the live game for the most accuracy - and thus, waiting for LE's parser. There should be no big hurry, since getting a stable core is more important than spawning NPCs imo.
But I'll offer my assistance regardless.

[Aaden]

Riven: talk to me on irc about starting a DB development group similar to PEQ DB's for eqemu.
Irc.eqemulator.net #eq2emu send a pm to Aaden

[LethalEncounter]

I know the database schema is still in an almost constant state of change right now, but you can get the schema as it is now (or whenever you run it) by downloading the db updates from the LS at www.eq2emulator.net and doing:
mysqldump --no-data --opt eq2 > eq2_database_schema.sql
Obviously, if you wanted to grab data also, you'd nix the "--no-data" argument.
Along similar lines, I wouldn't mind helping out with a DB project whenever that ball gets to a point it can roll.

Because of the constant flux in DB structure right now, the parser would save ALL the information into separate specific tables. The information in these tables could then be used to create the tables that EQ2Emulator uses. In this way, we could ensure that we have the information for previously unknown fields and we dont have to recollect it. (Assuming they dont add new fields in the expansion)

[Riven]

You can always release sql updates to DB having it in-sync.