Sqlite or MySQL?

[Ecstacy]

Hey,

I got a question about what is the best to use, Sqlite or MySQL?
What are the Pros and what are the Cons?

 

[Ninja]

database - SQLite vs MySQL - Stack Overflow

 

[zbizu]

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

 

[Ecstacy]

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!

 

[Limos]

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

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.

 

[dchampag]

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