MySQL or SQLite

[Shockhazard30]

I am starting to learn PHP and MySql are there major advantages to using SQLite over MySQL or vice versa?

[asmith]

I've been coding in PHP for more than 2 years and I've never seen any article/guide/tutorial written for PHP and SQLite.

[Mchl]

I am starting to learn PHP and MySql are there major advantages to using SQLite over MySQL or vice versa?

 

SQLite is a flat file database. It's major advantage is it doesn't require you to install (or have access to) any kind of database server. Other than that, it's capabilities are inferior to MySQL.

 

I've been coding in PHP for more than 2 years and I've never seen any article/guide/tutorial written for PHP and SQLite.

 

Just to prove there's at least one

http://framework.zend.com/docs/quickstart

[kickstart]

Hi

 

My view is it depends on how flexible you want the system to be.

 

For a main database for a system I would use MySQL, taking advantage of its more powerful database.

 

However if I want something compact and easily transferred then I would use SQLite. Indeed I used it recently for transferring data between a desktop application and a php web site.

 

All the best

 

Keith

[Shockhazard30]

Thanks, it sounds like I should familiarize my self with both but lean on MySQL more for functionality. I appreciate it.