Major differences between sqlite & mysql?

[Ruby Tuesday]

E.g: less secure, not conforming with sql standard etc. Thanks

[Andy Hassall]

On Thu, 19 Feb 2004 12:56:22 -0500, "Ruby Tuesday" <ru**********@yahoo.com>
wrote:

E.g: less secure, not conforming with sql standard etc. Thanks

http://www.hwaci.com/sw/sqlite/

vs.

http://www.mysql.com/documentation/m...ter/index.html

--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

[David Jackson]

Andy Hassall <an**@andyh.co.uk> wrote in message news:<51********************************@4ax.com>. ..

On Thu, 19 Feb 2004 12:56:22 -0500, "Ruby Tuesday" <ru**********@yahoo.com>
wrote:

E.g: less secure, not conforming with sql standard etc. Thanks

http://www.hwaci.com/sw/sqlite/

vs.

http://www.mysql.com/documentation/m...ter/index.html

This issue is also addressed on the sqlite webpage:
http://sqlite.org

The long and short of it is, if you have MySQL available use it.
If your hosting company doesn't include it as part of their standard
package or like Value Web (http://valueweb.com) charge your
$17.95/month, and want towack you for another $15.00/month for a MySQL
database....find a new hosting company.

HTH,
David

[Ruby Tuesday]

Thanks Andy.

Suppose that I have a php apps that is require user to update his/her
information in the database. Since SQLite is a file with, presumably
writeable to everyone. Then anyone can just mess up the database file which
contain data for other user as well. How do you protect the file/database
from being overwritten by just anyone?

If we make the file readable only, not only the user but the dba won't be
able to modify the database. Please advise. Thanks

"Andy Hassall" <an**@andyh.co.uk> wrote in message
news:51********************************@4ax.com...

On Thu, 19 Feb 2004 12:56:22 -0500, "Ruby Tuesday" <ru**********@yahoo.com> wrote:

E.g: less secure, not conforming with sql standard etc. Thanks

http://www.hwaci.com/sw/sqlite/

vs.

http://www.mysql.com/documentation/m...ter/index.html

--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>