Re: [sqlite] Autocommit in "with" query: bug or feature?

Hi again, To answer the question in the title : - yes, the "autocommit" bug is buggy with "with", http://bugs.python.org/issue21718 - it is also buggy with comments at the beginning of the 'select'. The "autocommit" feature was a false good idea, but as sqlite3 arrived like that in the

Re: [sqlite] Autocommit in "with" query: bug or feature?

ie, this will work: isolation_level = None and explicitly "BEGIN" transactions ... import sqlite3 def displayDBcontents(): query = "select * from PERSON" c.execute(query) print for row in c: print '%-4s %-10s' % (row[0],row[1]) # We create and fill the STAFF database conn =

Re: [sqlite] Autocommit in "with" query: bug or feature?

Hi Jean-Luc, All your problem is that you must use conn.isolation_level = None With conn.isolation_level = "" , the default of sqlite3, nothing related with transaction will work. Just try with : * this program : https://github.com/stonebig/sqlite_bro/blob/master/sqlite_bro.py (or pip install

Re: [sqlite] think I need better error-handling guidance in the C API

On Sat, 5 Jul 2014 17:48:41 +0100 Klaas V wrote: > James K. Lowden wrote: > > >If the answer to every question, concern, and suggestion is that it > >already works for millions of programs, there is no point in > >discussion or further development.  Just use what's there

Re: [sqlite] Can't make SQLite work

as we start low a more simple solution if recent features are needed http://www.macports.org/ sudo port install sqlite3 best On Sun, Jul 6, 2014 at 10:27 AM, Richard Hipp wrote: > On Sat, Jul 5, 2014 at 3:46 PM, Mike Seabrook Sr > wrote: > > > Hi

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

what's the syscall set behind the scene might help, os? On Sun, Jul 6, 2014 at 6:04 PM, Srikanth Bemineni < bemineni.srika...@gmail.com> wrote: > Hi, > > Is it possible for any SQLLite developer to explain the locking mechanism > in case of the shared connections, specifically table level

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

Hi, Is it possible for any SQLLite developer to explain the locking mechanism in case of the shared connections, specifically table level locking, how I can debug this and find out who is holding the lock. ? Srikanth Bemineni On Thu, Jul 3, 2014 at 12:47 PM, Srikanth Bemineni <

[sqlite] sqlite-3.8.5: is auto index created multiple times for a single statement?

Hi, while preparing this statement create table gpBestellvorschlagInfo as select GanttPlanID , BestellterminRaw , case when not ( select max(HinweisCodiert) from Bestellvorschläge where ArtikelOID = o.ArtikelOID and HinweisCodiert <> 1 ) is null then ( select

Re: [sqlite] think I need better error-handling guidance in the C API

Klaas V wrote: > BTW (someone else wrote this): to call a program 'crappy' sounds a wee > bit megalomanic... :-) Are you denying that crappy programs exist in the world, or are you saying that they do exist but that stating something true about them is megalomaniacal? Keeping in mind that

Re: [sqlite] Autocommit in "with" query: bug or feature?

Python 2.7.8 cannot run your program using the shipped version of SQLite. It does not support either multiple valued inserts nor the WITH statement. Did you just "drop in" a new version of the sqlite3.dll? While this (dropping a new version of sqlite3.dll) will work fine mostly, the dbapi2

Re: [sqlite] Autocommit in "with" query: bug or feature?

On 2014/07/05 21:55, Jean-Luc Hainaut wrote: Hi, Context: Python 2.7.6, Windows XP, SQLite v3.8.5. The following test program suggest that "with" queries automatically execute a commit, as if they were DDL statements. I hope this is a bug, otherwise, this side effect considerably reduces

Re: [sqlite] Autocommit in "with" query: bug or feature?

Jean-Luc Hainaut wrote: > Context: Python > > The following test program suggest that "with" queries automatically > execute a commit, as if they were DDL statements. SQLite itself does not differentiate between DDL and DML statements; when there are no explicit transactions, every statement gets

Re: [sqlite] Can't make SQLite work

On Sat, Jul 5, 2014 at 3:46 PM, Mike Seabrook Sr wrote: > Hi there, > > I am a Masters student at Grand Canyon University. We are to download your > product. You can download the executable free of charge directly from the > SQLite project Web site at http://sqlite.org,

[sqlite] missing doc for FTS feature "^"

Hi, I accidentally found the following interesting feature in the Change history : 2011-11-01 (3.7.9) If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document. ** Potentially Incompatible

[sqlite] Autocommit in "with" query: bug or feature?

Hi, Context: Python 2.7.6, Windows XP, SQLite v3.8.5. The following test program suggest that "with" queries automatically execute a commit, as if they were DDL statements. I hope this is a bug, otherwise, this side effect considerably reduces the interest of this query. Best regards

[sqlite] Can't make SQLite work

Hi there, I am a Masters student at Grand Canyon University. We are to download your product. You can download the executable free of charge directly from the SQLite project Web site at http://sqlite.org, which also provides extensive documentation and tutorials on its usage. Yet only MacBook

[sqlite] SQLITE query not working

Hi All, I encounter problem with the below SQL (it does not turn data from my database): SELECT l.link_id, l.cat, l.bi_direction, l.frm_coord_id, l.to_coord_id, r.name, l.start_jtn_elev, l.end_jtn_elev, r.id, r.code, r.prefix FROM Links l, Links_Index x, Roads r WHERE l.link_id = x.link_id AND

Re: [sqlite] Multiple reads and writes to a single DB connection from multiple threads

On 06/02/2014 08:36 PM, Hick Gunter wrote: If you compile with SQLITE_THREADSAFE=1 then multiple calls from different threads will be serialized by SQLite. "Serialized" means that only one thread at a time will be allowed to run within SQLite; API calls from other threads will block until the

Re: [sqlite] Basic SQLite/EF6 question

On 7/5/2014 12:38 PM, Joe Mistachkin wrote: Do you see the System.Data.SQLite option in the Data Connections dialog within Server Explorer in Visual Studio? Yes, and I can see my tables, etc. too. Which version and edition of Visual Studio are you using? Microsoft Visual Studio

Re: [sqlite] Multiple reads and writes to a single DB connection from multiple threads

Thanks, Keith. I did not realize even read calls will be serialized with SQLITE_THREADSAFE=1. Your explanation makes it clear all calls (read/write) will be serialized with this SQLITE_THREADSAFE=1. -- View this message in context: