since d7 drupal core supports the use of sqlite natively. meaning if you use sqlite you do not need mysql that is correct. but sqlite is slower than mysql. som programms like lightroom store their data in sqlite too.
its a *.sqlite file and you can open it with for example http://sqlitebrowser.sourceforge.net/
and play around.
i would not really recommend running a bigger website on sqlite.
Small websites, especially those run on low-end hosting or maybe shared environment, will get the most benefits of SQLite. For example, a cheap VPS with only 256MB RAM or less with SQLite will have more memory allocated for webserver or cache rather than database engine.
Also, you may consider to use proper database engine for query intensive website, even if your website is small.
Comments
since d7 drupal core supports
since d7 drupal core supports the use of sqlite natively. meaning if you use sqlite you do not need mysql that is correct. but sqlite is slower than mysql. som programms like lightroom store their data in sqlite too.
its a *.sqlite file and you can open it with for example http://sqlitebrowser.sourceforge.net/
and play around.
i would not really recommend running a bigger website on sqlite.
It depends on the environment
Small websites, especially those run on low-end hosting or maybe shared environment, will get the most benefits of SQLite. For example, a cheap VPS with only 256MB RAM or less with SQLite will have more memory allocated for webserver or cache rather than database engine.
Also, you may consider to use proper database engine for query intensive website, even if your website is small.