On 04/08/2015 04:49 AM, Scott Hess wrote:
> On Thu, Sep 11, 2014 at 8:58 AM, Dan Kennedy wrote:
>> Fts5 is still in the experimental stage at the moment.
>>
>> If anybody has any ideas for useful features, or knows of problems with FTS4
>> that could be fixed in FTS5, don't keep them to yourself!
//create table
sql="create table em(name text primary key,age text,pts text);"\
"create table l(name text primary key,fame text);";
//insert values
sql="insert into em values(44,20,1);"\
"insert into em values(11,20,2);"\
"insert into em values(5,21,3);"\
"insert into l values(11,11);"\
"i
Sairam Gaddam wrote:
> sql="create table em(name text primary key,age text,pts text);"\
> "create table l(name text primary key,fame text);";
>
> sql = "select * from em,l where l.fame=em.age";
>
>4 Once 0 130 00
>5 OpenAutoindex230 k(3,nil,ni
>
> Why does data-only sync exist? Is it a perf thing? Reliability? Other?
Performance. On Linux/ext4 fdatasync() flushes only the file's contents
instead of flushing contents + metadata as fsync() would do. For some
workloads this can be a 2x improvement.
Best,
Thiemo
On Mon, Apr 6, 2015 at 7:
The example below is s subset of my ical storage database which has
problems with foreign keys. Although I tried a lot I couldn't figure out
why the foreign key doesn't work. I took the example from the
documentation and compared to my two tables, there is no major
difference or I don't see the
On 2015-04-09 12:00 AM, Gustav Melno wrote:
> The example below is s subset of my ical storage database which has
> problems with foreign keys. Although I tried a lot I couldn't figure
> out why the foreign key doesn't work. I took the example from the
> documentation and compared to my two ta
Thanks for the help. Adding a trailing underscore helped also. I'm still
wondering why insertion worked at all because defining oid as column
name with the type VARCHAR should result in an error on execution.
>
>
> On 2015-04-09 12:00 AM, Gustav Melno wrote:
>> The example below is s subset of m
You are always welcome.
SQLite is not strongly typed - you are very welcome to store an integer
in a text field (in fact it results in only using the data associated
with the smallest integer internal type that can hold the value, so a
clear advantage in the embedded world). You are also welcom
On 9 Apr 2015, at 6:04pm, Gustav Melno wrote:
> Thanks for the help. Adding a trailing underscore helped also. I'm still
> wondering why insertion worked at all because defining oid as column name
> with the type VARCHAR should result in an error on execution.
The three names for the integer
On 2015-04-09 07:57 PM, Simon Slavin wrote:
> On 9 Apr 2015, at 6:04pm, Gustav Melno wrote:
>
>> Thanks for the help. Adding a trailing underscore helped also. I'm still
>> wondering why insertion worked at all because defining oid as column name
>> with the type VARCHAR should result in an er
I tried suggested and see the correct query.. so i am not sure whats going
wrong.. any insight..
query is select kindex from TBL where dn=?
select kindex from TBL where dn=?
debug information string a/b/c/d size 8
Error Insert : sqlite3_bind_blob, Error code : 25
snprintf(command, 512, SELECT_DN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am the author of a Python wrapper for SQLite. As part of my
documentation build process I link function names to the relevant page
in the SQLite doc. I also have to wrap all constants - eg making sure
that all SQLITE_LIMIT_ ones are wrapped and poi
On 4/9/15, Roger Binns wrote:
> These are the details of what I need:
>
> For each function, its name, the doc page and fragment, and ideally a
> few word description of it (the title on the doc page is fine).
>
> For each family of constants (eg result codes, extended result codes,
> run time lim
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/09/2015 05:42 PM, Richard Hipp wrote:
> On 4/9/15, Roger Binns wrote:
>> A JSON or XML file with that would make my life a lot easier.
>
> JSON/XML? Seriously? We eat our own dogfood here, thank you!
> When you get the data it will be in an S
Hi Folks:
I just downloaded the latest amalgamated source and got the following error.
Do I need to change or set someting in the environment?
$ cd sqlite/sqlite-amalgamation-3080900
$ gcc -DSQLITE_THREADSAFE=0 shell.c sqlite3.c -ldl
sqlite3.c: In function `winGetTempname':
sqlite3.c:37577: e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/09/2015 06:43 PM, Simon Slavin wrote:
> Hmm. We could add an output mode to the shell tool which outputs
> in JSON format. And by "We" I mean someone who can write good C,
> which isn't me.
Get yourself a time machine, go back 6 years, and enj
16 matches
Mail list logo