Posts: 551
Threads: 122
Joined: Nov 2009
Reputation:
0
Which one is more reliable/faster. I am needing SQL for testing purposes. But, I'll have to get MySQL on my PC. Would SQLite work temp?
Posts: 1,498
Threads: 19
Joined: Jun 2009
Reputation:
0
Just use MySQL; you can install it easily on your home pc using XAMPP.
Posts: 2,862
Threads: 11
Joined: Mar 2008
Reputation:
0
MySQL is obviously more reliable and faster. All in all, it's separate server just to operate with database. SQLite is just a "file" basically. MySQL also has plenty of very useful integrated functions to use.
However, they are both much better choices than simple files.
Posts: 551
Threads: 122
Joined: Nov 2009
Reputation:
0
Well, I am looking into it. I really don't want it, but if it's best then I will. I didn't plan on using MySQl until i get hosted.
Posts: 973
Threads: 11
Joined: Mar 2008
Reputation:
0
*Waits for ****** to jump in here*
I'd go with mysql, its slower, but its a lot easier to integrate with other projects. One issue i have with sqlite is that its just terrible with big loads, and its a pain to use the database for your site.
Posts: 551
Threads: 122
Joined: Nov 2009
Reputation:
0
Well, I am mainly just testing some stuff. But I just realized I made some code that needs the MySQL plugin I use. So i definatly have to use that. I may just use the SQL on my VPS, but I don't know yet.
Posts: 61
Threads: 1
Joined: Jul 2010
Reputation:
0
You can't compare the two. SQLite was built for smaller databases (such as 300~ properties or w/e).
If you're using this for accounts on your server, and your server is larger, then go for MySQL, it'll be easier to integrate in your website using PHP as well.