Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database integration #9

Open
LuaxY opened this issue Jul 22, 2015 · 6 comments
Open

Database integration #9

LuaxY opened this issue Jul 22, 2015 · 6 comments
Assignees
Milestone

Comments

@LuaxY
Copy link
Owner

LuaxY commented Jul 22, 2015

Access to MySQL database.
TrinityCore (WoW Emulator) have good database integration, this can be an inspiration.

@LuaxY LuaxY self-assigned this Jul 22, 2015
@LuaxY LuaxY added this to the Fondation milestone Jul 22, 2015
@The-Broccoli
Copy link

You're going to sniff the files from the original server via packet sniffing?

@LuaxY
Copy link
Owner Author

LuaxY commented Jul 22, 2015

Which files are you talking about?

@The-Broccoli
Copy link

sorry I mean,
not files but information for the database

@LuaxY
Copy link
Owner Author

LuaxY commented Jul 22, 2015

I'm not sure to understand your question.
This "issue" is about integration of database in emulator, to access on some data like accounts, characters, items...

I think I will use TrinityCore database implementation for CawotteSrv with prepared statement.

@respu
Copy link

respu commented Jul 22, 2015

Their impl is basic but works. However the main drawback is the way they cache statements which is tedious and tend to be error prone. I find chromium sqllite's cached statement impl more elegant (i.e https://github.com/nwjs/chromium.src/blob/nw12/sql/connection.h).
You can also think of using webscale mysql client which provide async api to deal with mysql based servers.

@LuaxY
Copy link
Owner Author

LuaxY commented Jul 23, 2015

Thanks for your suggestion. I have read header files, it look like interesting.
I will produce UML schema for database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants