Re: [sqlite] very slow fdsync() calls

On 20/03/2014 5:14 p.m., Nico Williams wrote: On Wed, Mar 19, 2014 at 8:03 PM, Jono Poff wrote: On 12/03/2014 12:01 p.m., Nico Williams wrote: ZFS recordsize Hi Nico, I have one (or two) last question(s)... All I need to do is prevent a single process ('process

[sqlite] System.Data.SQLite version 1.0.92.0 released

System.Data.SQLite version 1.0.92.0 (with SQLite 3.8.4.1) 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] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Stefano Ravagni wrote: > > The application run well, so good! The HasRows properties return TRUE as > far as i close datareader explicity > Excellent. > > I hope after new compilation of library, i'll just have to reference the > system.Data.SQLite.dll and not all x86 contents...is

Re: [sqlite] very slow fdsync() calls

On Wed, Mar 19, 2014 at 8:03 PM, Jono Poff wrote: > On 12/03/2014 12:01 p.m., Nico Williams wrote: >> >> ZFS recordsize > > Hi Nico, > > I have one (or two) last question(s)... > > All I need to do is prevent a single process ('process A') from being time > bound by

Re: [sqlite] Problem with Update from associated table.

Did you try saying your request directly? update tblRequest set reference = (select min(Created) from tblEventLog where RequestID = tblRequest.ID) where Created is null; * note that this will set null any references already null for which the

[sqlite] Problem with Update from associated table.

Hi folks, I have a problem! The scripts below are are partly based on guidance I found on the web, and as I started iterating to try to get a resolution. They are not elegant! But here 'tis. Using 3.8.3.1 - could not see any issues related to my problem in later updates so haven't yet upgraded

Re: [sqlite] very slow fdsync() calls

On 12/03/2014 12:01 p.m., Nico Williams wrote: ZFS recordsize Hi Nico, I have one (or two) last question(s)... All I need to do is prevent a single process ('process A') from being time bound by making fsync() calls that clash with fsync() calls from other processes using other files in the

Re: [sqlite] subquery performance

On 3/19/2014 3:50 PM, Sander Jansen wrote: What does the EXECUTE LIST and EXECUTE SCALAR mean? A subquery is a select statement enclosed in parentheses. It's a list subquery if it's a right-hand-side operand of IN or NOT IN operators, and a scalar subquery otherwise (because only a single

Re: [sqlite] subquery performance

On 19 Mar 2014, at 7:50pm, Sander Jansen wrote: > SELECT * FROM tracks WHERE (SELECT id FROM artists WHERE name LIKE 'John > Williams') IN (performer,conductor,composer); The art of using JOIN is obviously dead. The is a classic case of a UNION of three JOINs. Also,

[sqlite] subquery performance

Hi, Given the following two tables: TABLE tracks ... composer REFERENCES artists(id) conductor REFERENCES artists(id) performer REFERENCES artists(id) TABLE artists id name I'm trying efficiently to find a list of tracks given the name of an artist (used in composer or conductor or performer).

Re: [sqlite] Using ICU case folding support

On Wed, Mar 19, 2014 at 8:36 AM, Alex Loukissas wrote: > On Wed, Mar 19, 2014 at 8:32 AM, Dan Kennedy wrote: > >> On 03/19/2014 09:44 PM, Aleksey Tulinov wrote: >> >>> >>> I've created test database: >>> >>> >>> sqlite> CREATE TABLE test (x COLLATE

Re: [sqlite] Using ICU case folding support

On 03/19/2014 05:32 PM, Dan Kennedy wrote: home-grown tokenizer named "unicode61" that folds case in the same unicode-aware way as nunicode. If the unicode standard changes to define more pairs of case equivalent characters, we will not be able simply upgrade "unicode61". For the same reasons -

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

Hello Joe, yesterday i tryed the StickyHasRows properties passed on connection string... As in your suggestion, i add reference to new 1.0.92 version and i also copy all files in x86 directory in my BIN directory. The application run well, so good! The HasRows properties return TRUE as far

Re: [sqlite] Opening and closing an SQLITE3 db in PHP

On 19 Mar 2014 at 12:45, Simon Slavin wrote: > On 19 Mar 2014, at 11:21am, Tim Streater wrote: > >> So I could do: $dbh = new sqlite3 ($dbname, SQLITE_OPEN_READONLY); ?? > > Yes. I think that's the way you're meant to do it if you really do want >

Re: [sqlite] Using ICU case folding support

On 19 Mar 2014, at 3:36pm, Alex Loukissas wrote: > Thanks everyone for your comments. IIUC, the correct way of going about > what I want to do is to use BINARY collation on the column I'm interested > in and when I want to do unicode-aware case-insensitive lookups, they >

Re: [sqlite] Using ICU case folding support

On Wed, Mar 19, 2014 at 4:36 PM, Alex Loukissas wrote: > On Wed, Mar 19, 2014 at 8:32 AM, Dan Kennedy wrote: > Thanks everyone for your comments. IIUC, the correct way of going about > what I want to do is to use BINARY collation on the column I'm

Re: [sqlite] Using ICU case folding support

On Wed, Mar 19, 2014 at 8:32 AM, Dan Kennedy wrote: > On 03/19/2014 09:44 PM, Aleksey Tulinov wrote: > >> >> I've created test database: >> >> >> sqlite> CREATE TABLE test (x COLLATE NOCASE); >> sqlite> INSERT INTO test VALUES ('s'); >> sqlite> INSERT INTO test VALUES

Re: [sqlite] Using ICU case folding support

On 03/19/2014 09:44 PM, Aleksey Tulinov wrote: I've created test database: sqlite> CREATE TABLE test (x COLLATE NOCASE); sqlite> INSERT INTO test VALUES ('s'); sqlite> INSERT INTO test VALUES ('S'); sqlite> INSERT INTO test VALUES ('ё'); -- Russian e with diacritic sqlite> INSERT INTO test

Re: [sqlite] Using ICU case folding support

On 03/19/2014 07:55 PM, Aleksey Tulinov wrote: On 03/18/2014 10:02 PM, Alex Loukissas wrote: Alex, I suppose I can declare the column as BINARY and use LOWER( ) in my select statements. Browsing through the code though, I do see uses of u_foldCase in certain places, which leads me to

Re: [sqlite] Using ICU case folding support

On 03/18/2014 10:02 PM, Alex Loukissas wrote: Alex, I suppose I can declare the column as BINARY and use LOWER( ) in my select statements. Browsing through the code though, I do see uses of u_foldCase in certain places, which leads me to believe that what I want may be already there. I'll try

Re: [sqlite] Opening and closing an SQLITE3 db in PHP

On 19 Mar 2014, at 11:21am, Tim Streater wrote: > So I could do: $dbh = new sqlite3 ($dbname, SQLITE_OPEN_READONLY); ?? Yes. I think that's the way you're meant to do it if you really do want readonly. > 3) Is the lock always released if I do $dbh->close(); ? > >>

Re: [sqlite] Snippet function with Distinct query fails

My guess is that your windows version does not have the fts3 extension loaded/compiled in. -Ursprüngliche Nachricht- Von: Gopalan M [mailto:mgopa...@sofist.com] Gesendet: Mittwoch, 19. März 2014 10:46 An: sqlite-users@sqlite.org; supp...@sqlite.org Betreff: [sqlite] Snippet function with

[sqlite] WARNING: 'Makefile.in' seems to ignore the --datarootdir setting

When compiling tclsqlite using the TEA build scripts, a warning is displayed: ... config.status: creating Makefile config.status: WARNING: 'Makefile.in' seems to ignore the --datarootdir setting config.status: creating pkgIndex.tcl ... Explanation why this happens can be found

[sqlite] Snippet function with Distinct query fails

Sir, am using the Snippet function in my SQL select command to get a list of snippets matching my text search. This query works fine under LINUX. *QUERY* select distinct judge, snippet(VjudgeS,'','') from vjudges where judge MATCH 'Shah' However, it fails in windows. Please let me know what

Re: [sqlite] Opening and closing an SQLITE3 db in PHP

On 19 Mar 2014 at 00:53, Simon Slavin wrote: >> 1) I start with $dbh = new sqlite3 ($dbname); Am I right in thinking that >> this does not explicitly open the db (and hence acquire a lock), but that the >> db is opened and the default lock (SQLITE_OPEN_READWRITE | >>

Re: [sqlite] Opening and closing an SQLITE3 db in PHP

On 03/19/2014 06:49 AM, Tim Streater wrote: Part of my app will, at user request, read some data from an SQLite db and also some files from disk, and send it all out on the network. This may in some cases take several minutes, at the end of which the db gets updated here and there. While this