Essentials icon indicating copy to clipboard operation
Essentials copied to clipboard

Published 20 hours ago • verified publisher icon cuberite

SQLite rewrite

Open bennasar99 opened this issue 9 years ago • 5 comments

Rewrite jails, homes and warps to use SQLite. I don't know SQLite, so I won't do it soon, maybe some day if I learn. Any volunteer?

bennasar99 avatar May 22 '15 18:05 bennasar99

Just curious, what exactly is the advantage of SQLite?

mathiascode avatar May 22 '15 23:05 mathiascode

Faster access to data. Right now essentials is using ini files, which, specially in the case of jails, can be slow.

bennasar99 avatar May 23 '15 17:05 bennasar99

How is the jail done then? Does it check the INI file when the player moves or when the player joins? If it checks it when the player moves, then I suggest creating a cPlayerState object just like WorldEdit. In there you can save if the player is in jail or not.

NiLSPACE avatar May 23 '15 17:05 NiLSPACE

I'm not quite sure, it's been a long time since I coded and tested it for the last time. I will have a look. Anyway, SQL would be better.

bennasar99 avatar May 23 '15 17:05 bennasar99

Yes, SQL would be better, but it's still better to save if someone is jailed in memory.

NiLSPACE avatar May 23 '15 18:05 NiLSPACE