Re: [sqlite] [sqlite-dev] Is there an option to not lock during transaction?

2011-06-16 Thread Florian Weimer
* Pavel Ivanov: > To answer your original question: if you disable shared cache, start > reading transaction on one connection and start writing transaction on > the other connection then you'll be able to read on the first > connection database in the state it was before writing transaction. > Bu

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

2011-06-16 Thread Kevin Yoo
Jean-Christophe, Thanks for your response. The backup feature looks promising. If we can figure out how to access it within Django then it looks like it is what we need. Kevin Yoo Certification Lead Wurldtech Security Technologies 1680-401 West Georgia St. Vancouver, BC, V6B 5A1   Phone: (604

[sqlite] AUTO: Bret Patterson/Austin/IBM is out of the office (returning 06/17/2011)

2011-06-16 Thread Bret Patterson
I am out of the office until 06/17/2011. I'm out of the office but checking email once or twice a day and will respond to any high importance issues as quickly as possible. Note: This is an automated response to your message "sqlite-users Digest, Vol 42, Issue 16" sent on 06/16/2011 6:00:01.

Re: [sqlite] how do I select on a field that contains text and digits eg: "chr19:200"

2011-06-16 Thread David Lyon
Thank you for everyones help, it was most useful much appreciated ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Breaking a string into two

2011-06-16 Thread Igor Tandetnik
BareFeetWare wrote: > I have some source data that includes a "Silo And Region" column of two words > appended together, such as 'NorthPlains', > 'SouthPlains', 'NorthSlopes', 'SouthSlopes' etc. I want to split them into > two columns. > > How can I do this in SQLite? A regex or offset/positio

Re: [sqlite] Breaking a string into two

2011-06-16 Thread Simon Slavin
On 16 Jun 2011, at 5:27am, BareFeetWare wrote: > There could be dozens of each but the main issue is that I don't know what > they are until I get the data. That's what I meant by: > >>> I don't know all of the parts (ie "Silo Group" and "Region") until I bring >>> in the Import. > > So I can

Re: [sqlite] sqlite seems to hang while indexing

2011-06-16 Thread Wiktor Adamski
> I was trying to create an index on an integer column in a very large > table with over 400,000,000 rows on an Ubuntu ... I > increased the cache size to 2 but to no avail. That's only 200M of cache and your table is much larger. Sqlite can't index/sort efficiently lare data on disc - you