How does the Database work?

[MugenTwo]

I am trying to understand how this system works.

Does it have it's own embedded database? Because I am seeing sqllite in the code and i also see the shkeeper.sqllite

What is the mariadb that is in the helm chart? I tried removing that DB and it still seems to be working.
It seems to have it's own init script:

[github-actions]

Official Statement from the SHKeeper Development Team

We would like to clarify that the SHKeeper development team consists solely of the following:

• @vsyshost
• @dmytro-samoylenko
• @Olxndr
• @yukonet

It is managed through our official GitHub account https://github.com/vsys-host

We NEVER:

• Share or redirect users to unofficial or suspicious links.
• Request private keys, funds, or other sensitive information.

If you encounter any comments, issues, or users claiming to represent SHKeeper and sharing external links or providing questionable support, please report them immediately. These individuals are not affiliated with the SHKeeper team.

For accurate information and official support, please refer only to:

Our GitHub account: https://github.com/vsys-host/shkeeper.io
Our official SHKeeper website: https://shkeeper.io/
Our official VSYS Host website: https://vsys.host/

Thank you for your understanding and vigilance.

SHKeeper Development Team

[yukonet]

Hello,

mariadb is used for crypto pods (if such cryptocurrencies are enabled by config):

• tron-shkeeper (partially)
• ethereum-shkeeper
• bnb-shkeeper
• xrp-shkeeper
• polygon-shkeeper
• avalanche-shkeeper

shkeeper pod uses sqlite file

[MugenTwo]

Hi @yukonet ! Thanks for the info! Is there a way for shkeeper pod to use another DB (like the mariadb, postgres, mysql, etc)? If such is the case, do you perhaps have any guide on that? I can see that there is a config.py that we could potentially pass parameters to

[vsyshost]

Hi @yukonet ! Thanks for the info! Is there a way for shkeeper pod to use another DB (like the mariadb, postgres, mysql, etc)? If such is the case, do you perhaps have any guide on that? I can see that there is a config.py that we could potentially pass parameters to

Unfortunately, we haven't tested it on other DBs, so if you simply replace the database in the configuration, there is a chance that it may not work.

[MugenTwo]

I've been trying this with Postgres and I think so far it's working.
The only change I had to make was the things related to bcrypt.
Some DB flavours dont allow storing these kinds of information as plain text.

For example:

So far I've tried the major operations like payment request, withdraw, etc. and it seems to be working.

If you are interested, I can work on a PR. But please let me know how you would like me to make the DB connection info to be provided. I personally passed them through ENV var and passed it as "env" in the kubernetes deployment.