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 vis
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 constraint, then use the SQLite tool to '.read'
>> the
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));";
...
> if names is currentl
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 SQL command file.
Why no
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 information
On 16 Apr 2014, at 6:24pm, Joseph Yesselman wrote:
> 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"
Why not use six REAL columns in a table, with an index consisting of all six
columns
> 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 Postgre
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 n
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 Ha
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, but it's beyond my c
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, Win
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 database from an SQL
>> command dump or CSV files
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 SQLite
> understands yo
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 UNIQUE(major,minor,date) ?
Yes.
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 "versionen.sq3" having a table
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
>
> CREATE TABLE version (maj
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 notebo
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 results will be.
> Would is
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 into
anything SQLite
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 Ha
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 the
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 discover
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
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:
http://sqlite.1065341.n5.nabble.com/TRANSACTIONs-tp23854p75089.html
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 executed
25 matches
Mail list logo
