Re: [sqlite] How to fix Syntax - Check exists

On Sat, Apr 17, 2010 at 12:10 AM, gretty wrote: > > Hello > > I am a programmer using SQLite3 to create a database for an application. I > have been running into some problems with my SQL queries which I dont think > are correct. Can you check them & correct them where

[sqlite] How to fix Syntax - Check exists

Hello I am a programmer using SQLite3 to create a database for an application. I have been running into some problems with my SQL queries which I dont think are correct. Can you check them & correct them where relevant? Right now only one table exists, its layout is like so: [quote] Table =

Re: [sqlite] Locking under various Windows versions

Robert, Makes sense. Some background ... I'm again looking into how to handle locking under Silverlight, and was looking into the WINCE method for ideas. The isolatedstoragefilestream under NET.4 claims to support the Lock method, (see

Re: [sqlite] Locking under various Windows versions

WinCE has no lockfile support, so it's fudged on the device by means of a shared memory block to handle the locking. If you open a SQLite database on a network share from a CE device, then it will not be able to use the network share's locking mechanisms. In short, don't do it. -Original

[sqlite] Locking under various Windows versions

I am trying to determine if SQLite holds an exclusive lock on a database opened under Windows-CE, will that lock be honored by a connection opened under another version of Windows? What about the opposite case? When the database is first opened under Windows 7, an exclusive lock is acquired,

Re: [sqlite] Please help test the latest query planner changes

On Apr 16, 2010, at 11:52 AM, Max Vlasov wrote: > > SELECT StihiAuthors.Id As AuthId, StihiAuthCandidates.Date as Date, > StihiAuthCandidates.Num as Num FROM StihiAuthors > INNER JOIN StihiAuthCandidates ON > StihiAuthors.Id=StihiAuthCandidates.AuthorId > LEFT JOIN StihiPoems ON

Re: [sqlite] Please help test the latest query planner changes

> We are looking forward to your feedback, both positive and negative. > > Mr D. Richard Hipp found some time to compare this variant with the direct predecessor (3.6.23_1) Both dlls were compiled with Borland command-line compiler with identical options I tested a simple multiply lookup driven

Re: [sqlite] SQLite and .Net 4.0 configuration

These are questions about System.Data.SQlite data provider and should be asked at their forum found here http://sqlite.phxsoftware.com/forums/ On Thu, Apr 15, 2010 at 7:37 PM, Berryl wrote: > Hi Anyone & Everyone; > > Below is a message I posted on StackOverflow. I am guessing no

Re: [sqlite] FTS3 Appropriate usage

On Fri, Apr 16, 2010 at 3:24 AM, Alexey Pechnikov wrote: > And you can use my patches for zlib-compression for FTS3. I'm planning to make > the "fts3z" extension because I want to use as original FTS3 > as FTS3 with compression together. Back when I was working up fts1, I

Re: [sqlite] Data optimization with GLOB, virtual deletes

On 16 Apr 2010, at 1:17pm, Mike Goins wrote: > Table structure: > CREATE TABLE tb_file (tb_file_key INTEGER NOT NULL PRIMARY KEY > AUTOINCREMENT , basename TEXT, extension TEXT, path TEXT, deleted > INTEGER default 0 ); > > Index: > CREATE INDEX fullpath_idx on tb_file (basename, extension,

Re: [sqlite] Data optimization with GLOB, virtual deletes

On Fri, Apr 16, 2010 at 8:17 AM, Mike Goins wrote: > Query: > SELECT tb_file_key, basename, extension, path FROM tb_file WHERE >  basename GLOB 'a*' AND  extension GLOB 'b*' AND path GLOB 'c*' AND > deleted = 0 ORDER BY tb_file_key DESC; Apologies for responding to

Re: [sqlite] Index and GLOB

>> Is the "explain query plan" lying when it says it will use the index? >> Can I just slap a trailing "*" on the end of each parameter for it >> really use the index? >> > I'm not sure what you mean by "lying". When I try EXPLAIN QUERY PLAN > on a GLOB 'b' example, it reports that it will not

[sqlite] Data optimization with GLOB, virtual deletes

Sorry, this may look a bit familiar. Table structure: CREATE TABLE tb_file (tb_file_key INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT , basename TEXT, extension TEXT, path TEXT, deleted INTEGER default 0 ); Index: CREATE INDEX fullpath_idx on tb_file (basename, extension, path, deleted); Example

Re: [sqlite] FTS3 Appropriate usage

Hello! On Thursday 15 April 2010 11:21:17 Jens wrote: > I'd appreciate any feedback you might have one this. Also, does anyone > have experience with sqlite+ft3 and high-availability solutions? Has > anyone done any benchmarking of fts3? I did test FTS3 on about 400 millions of records and there

[sqlite] SQLite and .Net 4.0 configuration

Hi Anyone & Everyone; Below is a message I posted on StackOverflow. I am guessing no response are because noone there knows. Thanks for any help 1) Which SQLite dll?? I *think* it is