• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Sqlite or MySQL?

sqlite: impossible to edit when server is online(good in security, bad when you want to fix something quickly without restarting server), some queries from lua scripts may not work or may not be accurate
mysql: possible to access via phpmyadmin/other tools(?) and can be edited when server is online, if you don't secure it by dropping 'pma' user and some shit some noobish hackers can edit players, accounts(which means they can get god), houses, house items, guilds and other things you have in sql
 
sqlite: impossible to edit when server is online(good in security, bad when you want to fix something quickly without restarting server), some queries from lua scripts may not work or may not be accurate
mysql: possible to access via phpmyadmin/other tools(?) and can be edited when server is online, if you don't secure it by dropping 'pma' user and some shit some noobish hackers can edit players, accounts(which means they can get god), houses, house items, guilds and other things you have in sql

I see, so the best option would be to use MySQL.
Thanks for the answer!
 
sqlite: impossible to edit when server is online(good in security, bad when you want to fix something quickly without restarting server), some queries from lua scripts may not work or may not be accurate
mysql: possible to access via phpmyadmin/other tools(?) and can be edited when server is online, if you don't secure it by dropping 'pma' user and some shit some noobish hackers can edit players, accounts(which means they can get god), houses, house items, guilds and other things you have in sql

You can edit the database with SQLite when the server is online in TFS 0.3 and 0.4 :p

Althought with SQLite you have less options when it comes to ACC makers for websites. I know gesior supports SQLite, but there are also some that don't.
 
Last edited:
MySQL can handle larger loads, and can be just as secure as SQLite, do not open the port for mysql in firewalls, use programs like navicat or some freeware rather than phpmyadmin if you do not know how to set up phpmyadmin securely
 
Back
Top