Re: [sqlite] cannot set connection while a datareader is active

Ops... i'm not able to do this, never used first and don't know c# so well to understand the project. Can i try somes others way from my project?? Have you idea about why with the same code the sqlite provider is the only wich give me this error? Could depend from a query ? But i don't obtain

Re: [sqlite] deleting dupicate rows

On 17 Apr 2014, at 1:21am, James K. Lowden wrote: > Simon Slavin wrote: > >> If you really want to do it in the TABLE definition, use the SQLite >> shell tool to '.dump' the table as a set of SQL commands, edit the >> dump file to add that

Re: [sqlite] WITHOUT ROWID problem and large number of row updating

On Wed, 16 Apr 2014 10:24:51 -0700 Joseph Yesselman wrote: > sql = "CREATE TABLE two_way(" \ > "id VARCHAR(50) NOT NULL," \ > "names VARCHAR(2000)," \ > "rs VARCHAR(3000)," \ > "ds VARCHAR(2000)," \ > "sugs VARCHAR(2000), " \ > "PRIMARY KEY (id));";

Re: [sqlite] deleting dupicate rows

On Wed, 16 Apr 2014 16:27:01 +0100 Simon Slavin wrote: > If you really want to do it in the TABLE definition, use the SQLite > shell tool to '.dump' the table as a set of SQL commands, edit the > dump file to add that constraint, then use the SQLite tool to '.read' > the

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Joe i cannot find the way for follow the command object properties you > saycould you tell me what and how to observe exactly please ? > You might need to add the System.Data.SQLite project(s) to the solution in order to be able to see full debugging

Re: [sqlite] SQLite for single user data manipulation

> Hello 'Liters! > > I'd like to move to SQLite from Postgres, but have two quick questions. > > I'm a social scientist looking to manipulate a large dataset (5 billion > transactions, 700gb). I do not need multiple connections, and will only > ever run one query at a time. > > I started in

[sqlite] WITHOUT ROWID problem and large number of row updating

Hi All, I have two problems, the first one is probably very simple but I could not find anything online telling me how to fix it. I would like to use the WITHOUT ROWID statement as my primary key is a string in the format of 6 coordinates. example: "0.0 1.0 3.0 1.6 2.4 0.0" I am using c++, but

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 21.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, tryed to change the code in the IF expression but nothing change I would ask if you seen the screenshot i attached somes days ago because it show what happen From debugger Datareader result CLOSED and

Re: [sqlite] SQLite for single user data manipulation

On Wed, Apr 16, 2014 at 6:13 PM, RSmith wrote: > > On 2014/04/16 03:39, Nick Eubank wrote: > >> I started in Postgres, but discovered that in Windows one cannot increase >> some of the per-query RAM memory caps above 2gb (I know -- I would love to >> switch operating systems,

Re: [sqlite] SQLite for single user data manipulation

On 2014/04/16 03:39, Nick Eubank wrote: I started in Postgres, but discovered that in Windows one cannot increase some of the per-query RAM memory caps above 2gb (I know -- I would love to switch operating systems, but it's beyond my control). So I'm thinking of moving to SQLite. Firstly,

Re: [sqlite] SQLite for single user data manipulation

On 16 Apr 2014, at 4:42pm, Dominique Devienne wrote: > On Wed, Apr 16, 2014 at 3:41 PM, Simon Slavin wrote: >> I would recommend that you download the SQLite shell tool and get to know it >> a little. Not only is it useful in creating a SQLite

Re: [sqlite] SQLite for single user data manipulation

On Wed, Apr 16, 2014 at 3:41 PM, Simon Slavin wrote: > I would recommend that you download the SQLite shell tool and get to know it > a little. Not only is it useful in creating a SQLite database from an SQL > command dump or CSV files, but it allows you to test whether

Re: [sqlite] deleting dupicate rows

On 16 Apr 2014, at 4:02pm, Christoph P.U. Kukulies wrote: > Am 16.04.2014 15:57, schrieb Richard Hipp: >> >> CREATE UNIQUE INDEX version_idx1 ON version(major,minor,date); > > Though this seems to work, could I achieve this also by a table constraint, > like

Re: [sqlite] deleting dupicate rows

Am 16.04.2014 15:57, schrieb Richard Hipp: On Wed, Apr 16, 2014 at 9:46 AM, Christoph P.U. Kukulies wrote: Maybe been asked a hundred times but Im seeking for an elegant way to get rid of duplicate rows which had been entered during development. I have a database

Re: [sqlite] deleting dupicate rows

On Wed, Apr 16, 2014 at 9:46 AM, Christoph P.U. Kukulies wrote: > Maybe been asked a hundred times but Im seeking for an elegant way to get > rid of duplicate rows which had been entered during development. > I have a database "versionen.sq3" having a table created by > >

[sqlite] deleting dupicate rows

Maybe been asked a hundred times but Im seeking for an elegant way to get rid of duplicate rows which had been entered during development. I have a database "versionen.sq3" having a table created by CREATE TABLE version (major TEXT, minor TEST, date DATE) Due to running across an iPython

Re: [sqlite] Lock before beginning SELECT statement

On 15 Apr 2014, at 1:47pm, MikeD wrote: > If another thread deletes/updates or inserts while a SELECT statement is > processing the results could > be unpredictable? Only if your timing is unpredictable. If you know which command is issued first, you know what the

Re: [sqlite] SQLite for single user data manipulation

On 16 Apr 2014, at 2:39am, Nick Eubank wrote: > -- am I going to have problems using all 16gb of ram on my Windows 8 > machine for data manipulations if I switch to SQLite? Or will SQLite set me > free? If you're talking about per-query memory cap, then that won't figure

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 21.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, tryed to change the code in the IF expression but nothing change I would ask if you seen the screenshot i attached somes days ago because it show what happen From debugger Datareader result CLOSED and

Re: [sqlite] Lock before beginning SELECT statement

On 4/15/2014 8:47 AM, MikeD wrote: If another thread deletes/updates or inserts while a SELECT statement is processing the results could be unpredictable? Is that other thread using the same connection as the SELECT, or a different connection? If the latter (two separate connections), than

[sqlite] SQLite for single user data manipulation

Hello 'Liters! I'd like to move to SQLite from Postgres, but have two quick questions. I'm a social scientist looking to manipulate a large dataset (5 billion transactions, 700gb). I do not need multiple connections, and will only ever run one query at a time. I started in Postgres, but

Re: [sqlite] Lock before beginning SELECT statement

Is this true? A SELECT statement acquires a SHARED lock which block writers anyway. Source: http://sqlite.1065341.n5.nabble.com/Multiple-SELECTs-and-single-SELECT-and-TRANSACTION-td12752.html -- View this message in context: http://sqlite.1065341.n5.nabble.com/TRANSACTIONs-tp23854p75091.html

[sqlite] Lock before beginning SELECT statement

If another thread deletes/updates or inserts while a SELECT statement is processing the results could be unpredictable? Would issuing a BEGIN IMMEDIATE before a SELECT statement solve this? -- View this message in context:

Re: [sqlite] Lock before beginning SELECT statement

SELECT automatically handles locking? https://www.sqlite.org/lockingv3.html If multiple commands are being executed against the same SQLite database connection at the same time, the autocommit is deferred until the very last command completes. For example, if a SELECT statement is being