How is SQLite a lot better than accountData?

[goodiewarrior]

I do not know SQLite and I'd like to know the "BIG" difference between SQLite and AccData.

I also want to as if I could move everything from accData to SQLite.

[Captain Cody]

Faster. And yes it is possible, with the right editor.

[ALw7sH]

accountdata is using sql actually I believe

you can't say that SQLite is better nor accountdata

if you want to save data to account you can use both accountdata and SQLite but I would go for accountdata because it's faster to work with and kinda easier except if I want to show this data in website for example then i'll use MySQL instead

but if you want to save data to serial for example, you can't use accountdata for sure so mostly you'll go for SQLite or MySQL

[Captain Cody]

In general people use SQL because it's easy to transfer from host to host. 'From what I know'

+ You can sync accounts with website and server as said above. Account data is stored in a DB file, so yeh it's praticly the same thing as mySQL.

[Simple0x47]

I do not know SQLite and I'd like to know the "BIG" difference between SQLite and AccData.

I also want to as if I could move everything from accData to SQLite.

I'll recommend you mySQL it's better than SQLite and AccData, but if you cannot use it choose SQLite. AccData it's good for storage information about a player, but if you're going to have vehicles and things like this and you've got to save them into something SQLite it's the correct option.

[Mr_Moose]

Account data is actually an SQLite database running in the mods/deathmatch directory so it's only accessible by the server itself and not from the resources, with a "regular" SQLite database you can use functions like dbConnect and similar allowing you to design your database easier, although in both cases it's still SQLite which is stored in db files in your server directory.

While you're moving away from account Data I'd recommend moving to MySQL as well since it's even more flexible, for instance the fact that multiple applications can access it at the same time (not possible in SQLite), you can have your database on a different server and easily manage/view the data from a web based interface.

[Anubhav]

A BIG difference:

You can actually move your .db files for SQLite for specific data (if you make different .db files for 90% of things).

However, if you copy the file of server's SQL, your some accounts may be removed and be added. I prefer SQL also because it's easy to use. Account data is not my style.