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

Move to use RESTful API instead of databases #128

Open
TiBarification opened this issue Apr 20, 2022 · 5 comments
Open

Move to use RESTful API instead of databases #128

TiBarification opened this issue Apr 20, 2022 · 5 comments

Comments

@TiBarification
Copy link
Contributor

TiBarification commented Apr 20, 2022

Is your feature request related to a problem? Please describe.
As we know there are a bunch of issues related to driver connection in MySQL of SourceMod, late loading items etc...

Describe the solution you'd like
Create and use separate BackEnd part that can use any database and proceed work with prepared contracts.
Expected issues:

  • high latency
  • more libs to support payloads in format as json, xml
  • additional skills with optimization

Describe alternatives you've considered
Use local database, but it is not a solution for large database.

Additional context
Maybe implement sockets connection to synchronize items between gameserver & database.

Profits

  • More secure layers, flexible access in a future
  • Code will remain open source and use another license, premium features can be moved to another builds, so there no prohibit of GPLv3
  • Less dependent on database drivers of SourceMod.
@TiBarification
Copy link
Contributor Author

@R1KO @CrazyHackGUT need your opinion (please use english).

@CrazyHackGUT
Copy link
Contributor

Do I understand correctly that we are burying SQLite usage?

@R1KO
Copy link
Contributor

R1KO commented Apr 20, 2022

Не знаю имеет ли это смысл.
Чтобы это реализовать гибко технических должен быть отдельный модуль Storage, от которого зависит Core. И этот Storage будет реализовать интерфейс отвечающие за персистентное хранилище.

И уже этот Storage реализовать как SQL (MySQL/SQLite), либо API (restful/любое другое).
Но это будет сложно для конечного пользователя. Та и проблемы с базой не настолько критические и частые чтобы уделять этому столько времени

@TiBarification
Copy link
Contributor Author

Do I understand correctly that we are burying SQLite usage?

Yes

@TiBarification
Copy link
Contributor Author

Та и проблемы с базой не настолько критические

Like server crash when database connection goes by timeout?

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

No branches or pull requests

3 participants