[NTLUG:Discuss] Discuss Digest, Vol 93, Issue 11

[Ian Davis]

Sqlite has triggers and transaction. It is embedded database for android.  

discuss-request at ntlug.org wrote:

>Send Discuss mailing list submissions to
>	discuss at ntlug.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	http://www.ntlug.org/mailman/listinfo/discuss
>or, via email, send a message with subject or body 'help' to
>	discuss-request at ntlug.org
>
>You can reach the person managing the list at
>	discuss-owner at ntlug.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Discuss digest..."
>
>
>Today's Topics:
>
>   1. OT: SQLite (Fred James)
>   2. Re: OT: SQLite (Stuart Johnston)
>   3. Thanks [Was: OT: SQLite] (Fred James)
>   4. Re: Thanks [Was: OT: SQLite] (Stuart Johnston)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Sun, 12 Sep 2010 15:00:39 -0500
>From: Fred James <fredjame at fredjame.cnc.net>
>To: NTLUG Discussion List <discuss at ntlug.org>
>Subject: [NTLUG:Discuss] OT: SQLite
>Message-ID: <4C8D3167.1030808 at fredjame.cnc.net>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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.
>Thank you
>Regards
>Fred James
>
>
>
>
>------------------------------
>
>Message: 2
>Date: Sun, 12 Sep 2010 15:11:47 -0500
>From: Stuart Johnston <saj at thecommune.net>
>To: discuss at ntlug.org
>Subject: Re: [NTLUG:Discuss] OT: SQLite
>Message-ID: <4C8D3403.8060407 at thecommune.net>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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.
>
>
>
>------------------------------
>
>Message: 3
>Date: Sun, 12 Sep 2010 17:58:45 -0500
>From: Fred James <fredjame at fredjame.cnc.net>
>To: NTLUG Discussion List <discuss at ntlug.org>
>Subject: [NTLUG:Discuss] Thanks [Was: OT: SQLite]
>Message-ID: <4C8D5B25.3070502 at fredjame.cnc.net>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Thank you for your input ... you have confirmed that SQLite is pretty 
>much what I thought it was ... a backend for single user apps., or a 
>platform for prototyping.  To be fair that is exactly what I am looking 
>for in this case
>Thanks again
>Regards
>Fred James
>
>
>
>
>
>------------------------------
>
>Message: 4
>Date: Sun, 12 Sep 2010 19:07:15 -0500
>From: Stuart Johnston <saj at thecommune.net>
>To: discuss at ntlug.org
>Subject: Re: [NTLUG:Discuss] Thanks [Was: OT: SQLite]
>Message-ID: <4C8D6B33.6090702 at thecommune.net>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>On 09/12/2010 05:58 PM, Fred James wrote:
>> Thank you for your input ... you have confirmed that SQLite is pretty
>> much what I thought it was ... a backend for single user apps., or a
>> platform for prototyping. To be fair that is exactly what I am looking
>> for in this case
>
>Just to be fair, SQLite is very good at handling a high level of 
>concurrency for SELECT operations.  This makes it also appropriate for 
>multi-user applications that are mostly read-only, such as many web apps.
>
>
>
>------------------------------
>
>_______________________________________________
>Discuss mailing list
>Discuss at ntlug.org
>http://www.ntlug.org/mailman/listinfo/discuss
>
>
>End of Discuss Digest, Vol 93, Issue 11
>***************************************