[sqlite] Substring question

I need to select a substring of a column that starts 1 character after a colon in the column and continues to the end of the column. For example, if the column contained "abc:xyz" I want the select statement to return only "xyz" (the characters after the colon). The substr function requires

[sqlite] Turn off journal if no transaction

Hi, I don't use transactions in my app, is the data safe from failure if I turn off the journal? The insert isn't concurrent and I'm using System.Data.SQLite (.net) Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] 3.7.7, URI filenames, and UNC paths

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/24/2011 08:28 AM, Cheetah wrote: > The documentation clearly states that using an authority other than > localhost is not permitted. This was a deliberate decision when the feature was originally proposed. The original spec was that the

Re: [sqlite] Indexes on columns

Ahh..ok, thanks for the response everyone. I really appreciate the help here :). On Fri, Jun 24, 2011 at 11:10 AM, Igor Tandetnik wrote: > On 6/24/2011 1:58 PM, logan...@gmail.com > wrote: > > Sorry, but seems like I'm missing something here. > > > > From my understanding

Re: [sqlite] [Bug]Type mismatch in call to sqlite3MPrintf

On Fri, Jun 24, 2011 at 2:17 PM, Arushi Aggarwal wrote: > Hi all, > > While using sqlite to test a dynamic type tracking tool for LLVM that we > are > developing, we found the following bug in sqlite. > > I have sqlite version 3.7.6.3, and in the following call to

Re: [sqlite] .NET4 is available?

Second problem I've discovered is that with previous library I was able to create an Entity Data model while with the latest is not possible the server explorer does not work. From: Massimo Savazzi [mailto:massimo.sava...@gmail.com] Sent: Friday, 24 June, 2011 21:29 To: 'sh...@sqlite.org';

Re: [sqlite] .NET4 is available?

Shane, Thank you very much for your email. I've unistalled the old .NET4 libraries and installed the new ones. I've updated project references and DLLs distributed with the app. Can you help me as when I try the new app I get this error: See the end of this message for details on

[sqlite] ANN: C#-SQLite 3.7.6.3

C#-SQLite has been updated to release 3.7.6.3 and is now ready for use. The 6/24/2011 release features: * Updated to SQLite version 3.7.6.3 * Silverlight support * Windows 7 Phone It now runs 58,100 of the tcl testharness tests without errors. The project is located at

[sqlite] [Bug]Type mismatch in call to sqlite3MPrintf

Hi all, While using sqlite to test a dynamic type tracking tool for LLVM that we are developing, we found the following bug in sqlite. I have sqlite version 3.7.6.3, and in the following call to sqlite3MPrintf zStmt = sqlite3MPrintf(db, "CREATE%s INDEX %.*s", onError==OE_None ? "" : "

Re: [sqlite] Indexes on columns

On 6/24/2011 1:58 PM, logan...@gmail.com wrote: > Sorry, but seems like I'm missing something here. > > From my understanding it looks like for Integer ID columns that are PK > SQLite doesn't generate any indexes. Is this true? It's true in a narrow technical sense, but it doesn't matter in

Re: [sqlite] Indexes on columns

On 24 Jun 2011, at 6:58pm, logan...@gmail.com wrote: > From my understanding it looks like for Integer ID columns that are PK > SQLite doesn't generate any indexes. Is this true? > > If the above is true then I want to create an index to improve the perf of > my queries that are run against it.

Re: [sqlite] Indexes on columns

On Jun 24, 2011, at 1:58 PM, logan...@gmail.com wrote: > Sorry, but seems like I'm missing something here. > > From my understanding it looks like for Integer ID columns that are PK > SQLite doesn't generate any indexes. Is this true? > No, what you think is not true. SQLite does generate an

Re: [sqlite] Indexes on columns

Sorry, but seems like I'm missing something here. >From my understanding it looks like for Integer ID columns that are PK SQLite doesn't generate any indexes. Is this true? If the above is true then I want to create an index to improve the perf of my queries that are run against it. Thanks,

Re: [sqlite] Query with UNION on large table

Hi Rense, >Thanks for this idea. In fact, the purpose of my original query is >exactly to reduce the database. The 800 mln rows were exported from >another source, and I was hoping to be able to use sqlite to manage >this massive amount of data (e.g., removing redundant information) >before I

Re: [sqlite] Query with UNION on large table

Jean-Christophe, Thanks for this idea. In fact, the purpose of my original query is exactly to reduce the database. The 800 mln rows were exported from another source, and I was hoping to be able to use sqlite to manage this massive amount of data (e.g., removing redundant information) before I

[sqlite] 3.7.7, URI filenames, and UNC paths

Reading the release notes and documentation for SQLite 3.7.7, I noticed what I believe may be an oversight / minor problem with the URI filename support when using SQLite on a Windows platform. The documentation clearly states that using an authority other than localhost is not permitted.

[sqlite] system.data.sqlite x86 vs x64 GAC potential fix!

I've had numerous issues with the "wrong" version of SQLite being installed in the GAC. eg I make my app x86 and use the x86 SQLite dll and have that in my app directory. but the .net framework _always_ prefers to load from the GAC so the the x64 system.data.sqlite is installed my app loads it

Re: [sqlite] [BUG?] unexpected effect of view nesting on type conversion

> Just thought I should add that the problem seems to be gone with the > just released version 3.7.7, but it's not mentioned in the release notes. It's not in release notes but it's in the timeline. See http://www.sqlite.org/src/info/91e2e8ba6f and http://www.sqlite.org/src/info/0b3174e0b1.

Re: [sqlite] SQLite version 3.7.7 released

On 24 Jun 2011, at 12:04pm, D. Richard Hipp wrote: > SQLite version 3.7.7 is now available on the SQLite website: > > http://www.sqlite.org/ > > A list of changes is available at > > http://www.sqlite.org/releaselog/3_7_7.html In section 3.3 of http://www.sqlite.org/uri.html could

Re: [sqlite] Query with UNION on large table

Rense, >As for the ranges of n1 and n1: they are both roughly between 6 >and 1200 . > >Here are the results of EXPLAIN QUERY PLAN SELECT n1, n2 FROM table1 >Where n1 < n2 INTERSECT SELECT n2, n1 FROM table1 Where n2 < n1; > >1|0|0|SCAN TABLE table1 (~437976176 rows) >2|0|0|SCAN TABLE

Re: [sqlite] Indexes on columns

logan...@gmail.com wrote: > Yes, that's exactly what it is. Here is the definition of one of the table: > > CREATE TABLE [Attributes] ( > [Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > [Name] VARCHAR(50) NOT NULL > ) > > Will creating explicit index on Id fix this issue? What issue? Why

Re: [sqlite] [BUG?] unexpected effect of view nesting on type conversion

>>> I've run into a phenomenon I don't understand where view nesting affects >>> types. >>> Seen in sqlite 3.7.6.3 >> sqlite-3.6.23 does NOT show this behavior. > After further reflection, I am going to go out on a limb and suggest > that the behavior described in the OP is a regression. The

[sqlite] SQLite version 3.7.7 released

SQLite version 3.7.7 is now available on the SQLite website: http://www.sqlite.org/ A list of changes is available at http://www.sqlite.org/releaselog/3_7_7.html Further information about this release can be seen at http://www.sqlite.org/news.html Please post on the SQLite

Re: [sqlite] Indexes on columns

Yes, that's exactly what it is. Here is the definition of one of the table: CREATE TABLE [Attributes] ( [Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(50) NOT NULL ) Will creating explicit index on Id fix this issue? Thanks. On Thu, Jun 23, 2011 at 11:07 PM, Dan Kennedy

Re: [sqlite] Indexes on columns

On 06/24/2011 12:26 PM, logan...@gmail.com wrote: > Hello, > > My understanding is that an index is automatically created on any column > that is used in the primary key (or a composite index is created if the key > is composed of different columns). If this is correct then why don't I see >