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 t
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 meant to be.
>CREATE IND
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
> than the binary/text mo
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 still
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, David Barrett wrote:
>
>
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 th
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:
>
> There 4 objects:
>
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 me
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 much time
> when it executes
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
>> that every time when I co
10 matches
Mail list logo