Re: [sqlite] Fsync or fdatasync performs slowly

On 01/19/2015 01:19 PM, Stephen Chrzanowski wrote: > What kind of times are you looking at, and, what is the data being written > to? > > On Sun, Jan 18, 2015 at 9:49 PM, Wei, Catherine > wrote: > >> Hi, I'm running a software in a set-up box with linux system and find >>

Re: [sqlite] Fsync or fdatasync performs slowly

What kind of times are you looking at, and, what is the data being written to? On Sun, Jan 18, 2015 at 9:49 PM, Wei, Catherine wrote: > Hi, I'm running a software in a set-up box with linux system and find > that every time when I commit transaction, sqlite takes too

[sqlite] Fsync or fdatasync performs slowly

Hi, I'm running a software in a set-up box with linux system and find that every time when I commit transaction, sqlite takes too much time when it executes fsync or fdatasync function. What could be the possible reasons? I've removed the disk from my set-up box and sqlite data are all saved in

Re: [sqlite] About database structure

could wish someone would propose a truly deep database design question... everyone tells me I'm no DBA but anyway you have already created it and filled it, but the syntax is wrong On Sun, Jan 18, 2015 at 6:10 PM, YAN HONG YE wrote: > I don't know how to create this table:

[sqlite] About database structure

I don't know how to create this table: There 4 objects: Aa, bb,cc, res Aa is name of a1,a2,a3,a4,a5 type Bb is name of b1,b2,b3,b4,b5 type Cc is only 1,0 type Res is result value If a1 and b1 and cc=1,then the value is 10; If a1 and b1 and cc=0,then the value is 5; If a2 and b1 and cc=1,then

Re: [sqlite] Whish List for 2015

Got it, so this should work fine, so long as I'm careful to always re-add the collate functions to each database handle before accessing the table with that index. Cool, thanks! -david On Sun, Jan 18, 2015 at 1:16 PM, Simon Slavin wrote: > > On 18 Jan 2015, at 8:29pm,

Re: [sqlite] Whish List for 2015

Hi, Adding JSON to SQLite (like in PostgreSQL) ultimately needs a JavaScript parser - and that seems to be against the goal of SQLite being slim. But what about adding a data type "hash table", i.e. set of keyvalue pairs (also known as hstore, dictionary or associative array)? Would'nt this

[sqlite] OT: cmd.exe (was: sqlite3 tool bug)

On Sat, 17 Jan 2015 20:20:06 + Graham Holden wrote: > > I'm skeptical of the notion that cmd.exe is diddling with your data > > I would echo this: it's good at mangling the command-line, but I've > not been aware of it ever mangling data sent to a file/stream (other >

Re: [sqlite] Whish List for 2015

On 18 Jan 2015, at 8:29pm, David Barrett wrote: >SELECT createNewJSONCollationFunction( "FooCollationSequence", "foo" ); >SELECT createNewJSONCollationFunction( "BarCollationSequence", "bar" ); Those two might be okay depending on what the quoted values are

Re: [sqlite] Whish List for 2015

Incidentally, I just added this last night to a project I'm working on -- my first custom function! Once again I'm impressed with the power of sqlite as I went from concept to working implementation in just 2 hours. I'm using a JavaScript-style query syntax, where you just directly dereference