[xiaoniao]

so.... who is similar? who is faster? who is better.........................................

[Stuntff]

Mysql

[WhiteGhost]

SQlite,Thats what am going to use. with feedback its better and faster

[Vince]

Both have substantial advantages and what you choose is largely dependent on how much data you want to store and how you want to access said data. If you have a relatively small amount of data to store then SQLite is a good choice. However, if you have lots of data and/or if you want to access it externally (e.g. a website) then MySQL is appropriate.

[Luicy.]

Stop using MySQL, Sure it is better to get data over to PHP and easier, But it's an another Language, Don't spend time on SQL if you're working with PWN.. Go with some INI or something else.

[F1N4L]

I agree with @Vince.
There is no "best", each will suit your needs the way you need.
An example: Integrate the database to an UCP, the easiest way would be to MySQL.
A server without requiring integration and it is relatively easier to handle without external programs or plugins is SQLite.
So the choice depends on need and not what is the best!

[xiaoniao]

Thanks, i got it.

[Naruto_Emilio]

You can actually integerate a UCP if the website hosting server is on the same server of samp, otherwise I would definetly choose MySQL because its easier to integrate with API systems such as paypal api to make automated vip system or making your own UCP without the pain to find tutorials about how to integrate an SQLite db into UCP, which would take alot of time, and @Meller I guess that INI saving is an old thing to me, MySQL is much better than INI saving because it offers alot of features that can turn your server into a new level, INI is basic, and made for basic people which only wants to save and load people's saved data, and its a bit more complicated than using MySQL, because you get an interface included (phpmyadmin) or any other DB software that can manipulate the database.

[PrO.GameR]

Quote:

Originally Posted by Meller Stop using MySQL, Sure it is better to get data over to PHP and easier, But it's an another Language, Don't spend time on SQL if you're working with PWN.. Go with some INI or something else.

[sarcasm] Stop using jet engines to fly around the world, it's whole other technology, go ride horses if you want to go to your supermarket.[/sarcasm]


Whichever suits your needs is gonna be it, there are advantages as well as disadvantages. I like working with MySQL because in the end it won't be limited by much, MySQL is used more widely while SQLite is easier to handle.

tl;dr MySQL offers more tools, SQLite is easier to work with(not really, they are pretty much the same, very minor and negligible differences in this term).

[Vince]

INI files themselves are seriously misused. The format was originally invented to store a few configuration settings, not entire lists of data. And then there's the major drawback of not being able to group and sort efficiently.