Shop-Core icon indicating copy to clipboard operation
Shop-Core copied to clipboard

Move to use RESTful API instead of databases

Open TiBarification opened this issue 3 years ago • 5 comments

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 avatar Apr 20 '22 10:04 TiBarification

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

TiBarification avatar Apr 20 '22 10:04 TiBarification

Do I understand correctly that we are burying SQLite usage?

CrazyHackGUT avatar Apr 20 '22 10:04 CrazyHackGUT

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

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

R1KO avatar Apr 20 '22 11:04 R1KO

Do I understand correctly that we are burying SQLite usage?

Yes

TiBarification avatar Apr 21 '22 08:04 TiBarification

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

Like server crash when database connection goes by timeout?

TiBarification avatar Apr 21 '22 08:04 TiBarification