469,268 Members | 976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,268 developers. It's quick & easy.

Major differences between sqlite & mysql?

E.g: less secure, not conforming with sql standard etc. Thanks
Jul 17 '05 #1
3 5818
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>
Jul 17 '05 #2
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
Jul 17 '05 #3
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>

Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by stan k. | last post: by
12 posts views Thread by John Salerno | last post: by
9 posts views Thread by Gilles Ganault | last post: by
2 posts views Thread by Gandalf | last post: by
8 posts views Thread by john6630 | last post: by
3 posts views Thread by Jeff | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.