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

🚀 [Feature] Add SQLite database to DB dump #1812

Closed
gtker opened this issue Feb 23, 2023 · 0 comments · Fixed by #1815
Closed

🚀 [Feature] Add SQLite database to DB dump #1812

gtker opened this issue Feb 23, 2023 · 0 comments · Fixed by #1815
Labels
feature New feature or request

Comments

@gtker
Copy link
Contributor

gtker commented Feb 23, 2023

🚀 Feature

Add an SQLite database in addition to the raw sql files in order to make access to database contents easier for more people, and provide better grounds for long term archival.

Benefits, Purpose

As I enumerated in the cmangos issue:

  • Loading an SQLite database is significantly easier than standing up a MySQL database and loading from that which means that the database contents are available to more developers, and significantly less effort.
  • The SQLite library has bindings in most languages and is easily embedded into statically compiled files. This means that even the lowest spec computing unit can probably load an SQLite DB.
  • SQLite files are recommended by the Library of Congress for archival purposes, and SQLite itself is supported through to 2050 and quite likely even further. This means that even if MySQL bitrots and is unable to load the SQL files, the SQLite database is very highly likely to still be accessible and be supported.

Implementation

I'm thinking something similar to what I did for cmangos:

  1. Download awk and sqlite.
  2. Clone mysql2sqlite
  3. Run mysql2sqlite with awk and pipe into sqlite
  4. Zip up and release.

Total size for all databases would be:

  • 38 MB for .zip
  • 23 MB for .7z

.zip is currently used so I'm assuming that's what would be preferred.

Let me know if this isn't wanted, otherwise I will come up with a PR soon-ish.

@gtker gtker added the feature New feature or request label Feb 23, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
gtker pushed a commit to gtker/vmangos-core that referenced this issue Feb 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant