Igor Tandetnik wrote:
> On 8/6/2013 5:28 PM, Baruch Burstein wrote:
>> create table tests (id INTEGER PRIMARY KEY, name TEXT UNIQUE);
>> insert into tests values ('test 1');
>>
>> Error: table tests has 2 columns but 1 values were supplied
>>
>> Since the id column is an alias for the rowid, should
Below are the warnings/errors that I see on compiling with the options
-DSQLITE_INT64_TYPE=int
-DSQLITE_32_BIT_ROWID=1
Compilation Output:
---
sqlite3.c: In function 'localtimeOffset':
sqlite3.c:14443:37: warning: integer overflow in expression
sqlite3.c: In function 'parseModi
Thanks Richard for your suggestion.
Well unfortunately, it did not work. Below is the result of the 'Select * from
sqlite_master'.
The rootpage number is incorrect. The 32-bit higher and lower words are
interchanged.
Output:
---
Callback function called:
type = table
name = episodes
t
On 8/6/2013 5:28 PM, Baruch Burstein wrote:
I ran the following 2 commands:
create table tests (id INTEGER PRIMARY KEY, name TEXT UNIQUE);
insert into tests values ('test 1');
and got the following error:
Error: table tests has 2 columns but 1 values were supplied
Since the id column is
I ran the following 2 commands:
create table tests (id INTEGER PRIMARY KEY, name TEXT UNIQUE);
> insert into tests values ('test 1');
>
and got the following error:
Error: table tests has 2 columns but 1 values were supplied
>
Since the id column is an alias for the rowid, shouldn't I be able t
On Tue, Aug 6, 2013 at 12:49 PM, Girish Padharthi <
girish.padhar...@outlook.com> wrote:
> After hours of searching in Google, I came across the right post
> addressing this issue. (May be it was because I hadn't use the right
> keywords before).
>
> http://marc.info/?l=sqlite-users&m=115557417523
After hours of searching in Google, I came across the right post addressing
this issue. (May be it was because I hadn't use the right keywords before).
http://marc.info/?l=sqlite-users&m=115557417523637&w=2
http://sqlite.1065341.n5.nabble.com/Problems-with-sqlite-3-3-6-on-ARM-embedded-platform-t
On Tue, 6 Aug 2013 10:44:49 -0400
Richard Hipp wrote:
> On Tue, Aug 6, 2013 at 10:21 AM, Simon Slavin wrote:
>
> >
> > On 6 Aug 2013, at 3:12pm, Bo Peng wrote:
> >
> > > The problems we have only happens with large databases and it is
> > > difficult to create test cases to reproduce them.
> >
20'th Annual Tcl/Tk Conference (Tcl'2013)
http://www.tcl.tk/community/tcl2013/
September 23 - 27, 2013
Bourbon Orleans Hotel
New Orleans, Louisiana, USA
http://www.bourbonorleans.com/
I am pleased to announce that registration for the Conference is now
open at
http://www.tcl.tk/community
Adding to previous post ...
Ready-to-run binaries are published for the Litex project, under
https://www.assembla.com/spaces/litex/documents
via the link labeled 'litex.zip', at
https://www.assembla.com/spaces/litex/documents/ci_8Yib6ar3AVDab7jnrAJ/download/ci_8Yib6ar3AVDab7jnrAJ
and a .PDF of
Wolfgang Enzinger wrote:
> Assuming you actually do need to compile something, (identity of which
> you provide few good clues), you might consider a package I had good
> luck with, a SQLite wrapper called 'Litex', available at
>https://www.assembla.com/wiki/show/litex
The download links on
On Tue, Aug 6, 2013 at 11:03 AM, Simon Slavin wrote:
>
> On 6 Aug 2013, at 3:44pm, Richard Hipp wrote:
>
> > On Tue, Aug 6, 2013 at 10:21 AM, Simon Slavin
> wrote:
> >
> >> SQLite is not optimised for databases which contain a very large number
> of
> >> tables (hundreds). It has to scan the l
On 6 Aug 2013, at 3:44pm, Richard Hipp wrote:
> On Tue, Aug 6, 2013 at 10:21 AM, Simon Slavin wrote:
>
>> SQLite is not optimised for databases which contain a very large number of
>> tables (hundreds). It has to scan the long list of tables quite a lot.
>> This will lead to low speeds.
>
>
On Tue, Aug 6, 2013 at 10:21 AM, Simon Slavin wrote:
>
> On 6 Aug 2013, at 3:12pm, Bo Peng wrote:
>
> > The problems we have only happens with large databases and it is
> > difficult to create test cases to reproduce them.
>
> SQLite is not optimised for databases which contain a very large numb
On 6 Aug 2013, at 3:12pm, Bo Peng wrote:
> The problems we have only happens with large databases and it is
> difficult to create test cases to reproduce them.
SQLite is not optimised for databases which contain a very large number of
tables (hundreds). It has to scan the long list of tables
Hi, RSmith,
>> One of the problems we have is the performance of analyzing large
>> tables one by one. For example, we are puzzled that it takes from 40
>> seconds to 10 minutes to copy tables with similar sizes from a
>> database to another.
>
> You should be puzzled... that cannot be right unles
Thank you very much for your insights and I agree with you on the role
of diskspeed vs. CPU in this process. However, in the bioinformatics
application I am maintaining, we have huge databases that easily
exceed the size of regular SSD drives (512G for example) and we have
to rely on diskarrarie
Maybe you would like to try group_concat(name)
-Ursprüngliche Nachricht-
Von: adnanayon [mailto:adnan.a...@gmail.com]
Gesendet: Montag, 05. August 2013 18:21
An: sqlite-users@sqlite.org
Betreff: [sqlite] SQLite: group_concat() multiple columns format
My query is here
select abstracts_ite
My query is here
select abstracts_item._id,abstract_author.name,
title,affiliation_number,af_name from
abs_affiliation_name,abstract_affiliation,
abstracts_item,abstract_author,authors_abstract where
abstracts_item._id = authors_abstract.abstractsitem_id and
abstract_author._id = authors_ab
Larry Brasfield writes:
> Assuming you actually do need to compile something, (identity of which
> you provide few good clues), you might consider a package I had good
> luck with, a SQLite wrapper called 'Litex', available at
>https://www.assembla.com/wiki/show/litex
The download links on
Hi all,
I had been trying to make Sqlite work in a target embedded system.
When the application is executed, the Sqlite statements fail to return any
results. On further analysis, it was found that the 64 bit data type is causing
the issue. The cross compilation tool chain used is GCC for ARM fro
21 matches
Mail list logo
