Major differences between sqlite & mysql?

[Ruby Tuesday]

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

[Andy Hassall]

Re: Major differences between sqlite & mysql?

On Thu, 19 Feb 2004 12:56:22 -0500, "Ruby Tuesday" <rubytuezdayz@y ahoo.com>
wrote:
[color=blue]
>E.g: less secure, not conforming with sql standard etc. Thanks[/color]

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

vs.

http://www.mysql.com/documentation/mysql/bychapter/index.html

--
Andy Hassall <andy@andyh.co. uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk > / <http://www.andyhsoftwa re.co.uk/space>

[David Jackson]

Re: Major differences between sqlite &amp; mysql?

Andy Hassall <andy@andyh.co. uk> wrote in message news:<515a30p70 pq65he5v0tfsqmc 16ho2eh7v2@4ax. com>...[color=blue]
> On Thu, 19 Feb 2004 12:56:22 -0500, "Ruby Tuesday" <rubytuezdayz@y ahoo.com>
> wrote:
>[color=green]
> >E.g: less secure, not conforming with sql standard etc. Thanks[/color]
>
> http://www.hwaci.com/sw/sqlite/
>
> vs.
>
> http://www.mysql.com/documentation/m...ter/index.html[/color]
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....fin d a new hosting company.

HTH,
David

[Ruby Tuesday]

Re: Major differences between sqlite &amp; mysql?

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" <andy@andyh.co. uk> wrote in message
news:515a30p70p q65he5v0tfsqmc1 6ho2eh7v2@4ax.c om...[color=blue]
> On Thu, 19 Feb 2004 12:56:22 -0500, "Ruby Tuesday"[/color]
<rubytuezdayz@y ahoo.com>[color=blue]
> wrote:
>[color=green]
> >E.g: less secure, not conforming with sql standard etc. Thanks[/color]
>
> http://www.hwaci.com/sw/sqlite/
>
> vs.
>
> http://www.mysql.com/documentation/m...ter/index.html
>
> --
> Andy Hassall <andy@andyh.co. uk> / Space: disk usage analysis tool
> <http://www.andyh.co.uk > / <http://www.andyhsoftwa re.co.uk/space>[/color]