[NTLUG:Discuss] OT: SQLite

[Stuart Johnston]

On 09/12/2010 03:00 PM, Fred James wrote:
> This query may be only partially off topic ... I am shall be limiting
> the OS choice to Linux
> I am seeking comment ... why would I not want to use SQLite? Of course,
> comments as to why I might wish to use SQLite are welcome as well.
> I do have some experience with Oracle and MySQL, and other types of
> databases in general.

The main limitation of SQLite is that it does not support concurrent 
write transactions.  This may not be a problem, depending on your 
application.

I also does not enforce data type constraints.  This is mostly a matter 
of personal preference.