Sqlite And Mysql anyone tell me their difference

[frozen.fish 0]

Hello all!Would like to know the difference between SQLite and mySQL. Which is better to use?Honestly would like to know if server load will be lower with SQLite..Thanks a lot! B)

[kittycatlover763 0]

i'm not exactly sure which one would be better to use.but with sqlite writing querys is a lot more faster and easier. also they say "noobs" are better left with sqlite. As long as you don't intend to share the database with any other server or of the sorts >.>all i advise to you is don't use mysql if you seem to have a basic understanding of sqlite. i use Postgresql , but i think either Postgresql or sqlite are good choices. to answer your other question , i would say NO. server load will be faster on sqlite. actually now i think it's best to use sqlite ;D *hits self in head for being so confusing* xD

[mahesh2k 0]

Both databases are different yet accepts same standard sql syntax. Only thing that is different about sqlite is that it is lightweight,flat file based database. Read more about SQLite here. MySQL is more of server and it is more suitable for scalable applications. Performance of mySQL in enterprise & scalable application is more and reliable than SQLite. SQLite is more suitable for desktop applications. SQLite is most of time used for graphical programs, desktop apps, app that wants to store and ship embedded database.

If you're looking for SQLite as embedded database or portable database then you should check out HSQLdb, H2, Apache derby. If you like SQLite then you'll find these databases useful as well.