Re: [sqlite] Adding WHERE to query --> database disk image is malformed

Unique is implemented (as it must be) via a unique index. CREATE TABLE ItemTable ( "key" text UNIQUE, value blob NOT NULL ); is equivalent to CREATE TABLE ItemTable ( "key" text, value blob NOT NULL ); CREATE UNIQUE INDEX sqlite_autoindex_ItemTable_1 on ItemTable (key); You should be

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

Oh, I just realized that, although Igor’s suggestion “fixed” the problem, this database definitely does not contain any indexes. The schema dump is simply this… CREATE TABLE ItemTable ( "key" text UNIQUE, value blob NOT NULL ); ___ sqlite-users

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

On 2014 Jun 23, at 21:49, Igor Tandetnik wrote: > One possibility: the query with WHERE clause attempts to use some index, > while the query without doesn't. > > Try this query: > > SELECT * FROM itemTable WHERE +key = 'profileName' ; > > Note the + sign - this

Re: [sqlite] Adding WHERE to query --> database disk image is malformed

On 6/23/2014 11:16 PM, Jerry Krinock wrote: How can it be that adding a WHERE clause to a successful query causes ‘database disk image is malformed’? One possibility: the query with WHERE clause attempts to use some index, while the query without doesn't. The data corruption happens to

[sqlite] Adding WHERE to query --> database disk image is malformed

How can it be that adding a WHERE clause to a successful query causes ‘database disk image is malformed’? My database has one table named `itemTable`. This table has two columns, `key` which is type text and `value` which is type blob. There are two rows of data. Their `value` blobs are

[sqlite] System.Data.SQLite version 1.0.93.0 released

System.Data.SQLite version 1.0.93.0 (with SQLite 3.8.5) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] Update a BLOB

> On 23 Jun 2014, at 4:10pm, Carlos Ferreira wrote: > > To access Blobs I use the direct access BLOB api from SQLite. > > However, what is the best way to update a record that contains a BLOB, and > the only goals is to update the BLOB... > > The BLOB may shrink or

[sqlite] Update a BLOB

Hello, One question. To access Blobs I use the direct access BLOB api from SQLite. However, what is the best way to update a record that contains a BLOB, and the only goals is to update the BLOB... The BLOB may shrink or increase...and that is the reason why I cannot use the BLOB Write

[sqlite] SQLite and BLOBs

Hello, I found this reference in this link: http://stackoverflow.com/questions/676524/how-to-update-piecewise-a-blob-in-sqlite " This is not directly an answer to your question, but I have some experience using random access for (big) blobs in SQLite, and I advise you against using it, if

Re: [sqlite] Data visibility problem

On 23 Jun 2014, at 11:17am, João Ramos wrote: > On Mon, Jun 23, 2014 at 10:58 AM, Simon Slavin wrote: > >> Are you finalizing all these SQL commands (or using _exec() which amounts >> to the same thing) ? > > Yes, I double checked and everything is

Re: [sqlite] Planner chooses incorrect index

On 06/23/2014 05:48 AM, João Ramos wrote: Here you go: sqlite_stat1 (before - good planning) HistoryEntry idx_HistoryEntry_uri_historyOrder 14992 44 5 HistoryEntry idx_HistoryEntry_historyOrder_historyTimestamp 14992 6 2 HistoryEntry idx_HistoryEntry_sourceType_sourceId 14992 2999 2

Re: [sqlite] Data visibility problem

On 6/23/2014 5:43 AM, João Ramos wrote: If multiple connections in shared cache mode are treated as a single "real" connection, should I change the thread mode to Serialized? What mode do you use now? In any case, I doubt the thread mode has any bearing on the problem. The scenario may occur

[sqlite] Where can I find JDBC for 3.8.2 or later?

I am looking for a JAVA sqlite JDBC version 3.8.2 or later, for Linux Rinat Hadashi - Intel Israel (74) Limited This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s).

Re: [sqlite] Planner chooses incorrect index

Here you go: sqlite_stat1 (before - good planning) HistoryEntry idx_HistoryEntry_uri_historyOrder 14992 44 5 HistoryEntry idx_HistoryEntry_historyOrder_historyTimestamp 14992 6 2 HistoryEntry idx_HistoryEntry_sourceType_sourceId 14992 2999 2 sqlite_stat1 (after - bad planning) HistoryEntry

[sqlite] System.Data.SQLite.EF6.SQLiteProviderServices should be public

Hi, .NET provider for sqlite should have public Instance property of System.Data.SQLite.EF6.SQLiteProviderServices. Currently it is private. In order to use it with Entity Framework code configuration. Why this is a problem: http://stackoverflow.com/a/23237737/1107786 Thanks

Re: [sqlite] Data visibility problem

On Mon, Jun 23, 2014 at 10:58 AM, Simon Slavin wrote: > > On 22 Jun 2014, at 11:33pm, João Ramos wrote: > > > What happens is this: - a thread acquires the write DB connection - that > > thread inserts a new row in a table and gets its id - > > Are

Re: [sqlite] Data visibility problem

On 22 Jun 2014, at 11:33pm, João Ramos wrote: > What happens is this: - a thread acquires the write DB connection - that > thread inserts a new row in a table and gets its id - Are you finalizing all these SQL commands (or using _exec() which amounts to the same thing) ?

Re: [sqlite] Data visibility problem

If multiple connections in shared cache mode are treated as a single "real" connection, should I change the thread mode to Serialized? I tough this "single" connection was in terms of page cache and would not have any implications on how the connections are accessed (or not) concurrently,

Re: [sqlite] Question about opening database files

Hello Richard, thanks for the response and explanation. adil On Sun, Jun 22, 2014 at 04:51:27PM -0400, Richard Hipp wrote: > On Sun, Jun 22, 2014 at 10:47 AM, Adil Hasan wrote: > > > Hello, > > I would like to add sqlite to a workflow. But, I cannot directly open the > >

[sqlite] Link error using SQLite 3.8.5

> Hi Experts, > Did you try to compile and link your program with SQLite 3.8.5 with > SQLITE_OMIT_WAL macro predefined? The compilation was successfully complete. > But it would report a link error and complain it could not find the > definition for unixGetpagesize function. I checked the