about mysql

[SkatCh]

hi guys please i have a question , which is better : mysql or sqlite ? , i don't know the difference between them but i think sqlite it's local right , really i need some information thank you .

[tosfera]

depends, what do you want to do? Save a little bit of information or use it as a base of your server?

[SkatCh]

please i want to ask you i create a mysql server i used Xammp and everything is fine , then my friend gave me his drug system script , just i am asking how can i create a table to excute it from admin php page , because when i try to start it the server can't find table in my db. i am sorry for my english.

[xXMADEXx]

IT depends what you want. If you are going for speed, then you should use SQLIte, but if you're going to be editing a lot of data or checking a lot of data manually then I would recommend MySQL. Even if you want to pull data from the database from a remote server, then you should also use MySQL.

[SkatCh]

thank you can you answer the second question please .

[Johnny Killstone]

As long you're not planning to share data between multiple servers I would recommend SQLite, it's faster and easier to use and manage. Also you might try this: http://sourceforge.net/projects/sqlitebrowser/ to edit your SQLite databases. Mysql on the other hand is generally pretty hard to setup but if you have an external host or something it might work.