This is the way I normally create my shopping database, but this leads to
thousands of duplicates.
CREATE TABLE shopping(item TEXT,units TEXT,quantity TEXT,category TEXT,shop
TEXT,aisle TEXT,price TEXT,total TEXT,date TEXT,note TEXT,record INTEGER
PRIMARY KEY AUTOINCREMENT)
'item' is the full
Just when I thought I was hitting the home stretch, I came across an
aggregate query test that I'm not sure how to solve. LINQ generated the
following query programmatically:
-- Begin auto-generated query
SELECT
1 AS [C1],
[Project2].[ProductID] AS [ProductID],
[Project2].[ProductName] AS
>
>
> It is not a bug because sqlite3FaultEndBenign() is used during testing
> only. And the tests in which this function are used only run a single
> thread.
>
Recompile with -DSQLITE_OMIT_BUILTIN_TEST=1 to completely disable the
EndBenign() function and its friends. Or omit the
On Jun 30, 2008, at 5:41 PM, Andrew de los Reyes wrote:
>
> I added some logging to investigate how this happens, and found
> that sqlite3FaultBeginBenign() and sqlite3FaultEndBenign() are being
> called
> with -1 as the only argument by many threads simultaneously.
>
> I added code to log
Shawn Wilsher <[EMAIL PROTECTED]> wrote:
> I was wondering if we could set the value that an AUTOINCREMENT starts
> at for temporary tables. Right now we are looking at having to manage
> it ourselves, but if we could use sqlite to handle it, as long as it
> starts at the right value, that would
Looks like you can insert and delete a row to set whatever you want as the
starting number:
sqlite> create table t1 (oid integer primary key autoincrement, a);
sqlite> insert into t1 values (100, 'foo');
sqlite> delete from t1;
sqlite> insert into t1 (a) values ('bar');
sqlite> select * from t1;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
> http://www.sqlite.org/draft/doc/35to36.html
Where is the appropriate place to discuss 3.6 issues? For example in my
case I have very strong feelings about error codes vs return values in
the VFS api.
Roger
-BEGIN
On Mon, Jun 30, 2008 at 6:41 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> The default TEMP_STORE is 1, not 0. The default "PRAGMA temp_store"
> is 0. TEMP_STORE=1 means that temporary storage defaults to a file
> but can be overridden by the temp_store pragma.
Alright, cool.
> Temporary
On Jun 30, 2008, at 4:48 PM, Shawn Wilsher wrote:
> Hey all,
>
> Over at mozilla we are looking into using more temporary tables, and
> likely want them all to be in memory as opposed to files. I was
> looking at http://sqlite.org/pragma.html#pragma_temp_store, and
> noticed the table, which
When I try a similar query (i.e, no type comparison), I get the same
results as you:
sqlite> SELECT eid,type FROM EVENTS WHERE eid<=3261976 ORDER BY eid DESC
LIMIT 1;
3261976|21
CPU Time: user 0.00 sys 0.027996
sqlite> EXPLAIN QUERY PLAN SELECT eid,type FROM EVENTS WHERE
eid<=3261976
Hey all,
I was wondering if we could set the value that an AUTOINCREMENT starts
at for temporary tables. Right now we are looking at having to manage
it ourselves, but if we could use sqlite to handle it, as long as it
starts at the right value, that would be ideal.
Cheers,
Shawn
Hi, I think I may have discovered a bug in SQLite3. It is a timing bug that
is easily reproduced with my (unfortunately proprietary) code. I'll try to
describe the situation as best as possible. This is using SQLite source
from http://www.sqlite.org/sqlite-source-3_5_9.zip running on Mac OS X 10.5
Hey all,
Over at mozilla we are looking into using more temporary tables, and
likely want them all to be in memory as opposed to files. I was
looking at http://sqlite.org/pragma.html#pragma_temp_store, and
noticed the table, which seems to imply that if TEMP_STORE is either
zero or not defined,
Hi list.
I'm currently making modifications to a project, and want to add SQLite3 to
it.
I'm using VS6, have the sqlite3.h and sqlite3.c in the same directory, and
this is the code:
#include "sqlite3.h"
bool TestSQLite()
{
sqlite3 *db;
int rc;
rc =
On Jun 30, 2008, at 2:37 PM, Andrea Connell wrote:
> Any ideas? It's driving me crazy why SQLite is this much slower on
> UNIX
> boxes, while other applications maintain their speed.
What filesystem are you using on the unix boxes? Are you *sure* you
are not using NFS?
D. Richard Hipp
I'm still struggling with this issue. I've tried compiling on Solaris
and get similar results. On Windows SQLite is twice as fast as our
in-house database system, but on HP and now Solaris it is over 6 times
slower than ours. There must be something I am missing here.
I've tried increasing the
On Sun, 29 Jun 2008 23:32:47 -0700 (PDT), you wrote:
>
>I tried to export the the SQL command exported from DBDesigner4 is not going
>to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
>can connect to SQLite server.
>
>I tried to download the source code from SQLite CVS.
That is fantastic Igor.
Thankyou.
All I need to do now is work out how to get an update query to use a select
query to update the records from stats_memory to stats_static after doing
the link.
I think google may be able to help me with that.
Thankyou for your time.
=)
Igor Tandetnik wrote:
>
There is no Sqlite server. It is embedded.
winstonma wrote:
> I tried to export the the SQL command exported from DBDesigner4 is not going
> to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
> can connect to SQLite server.
>
> I tried to download the source code from
Dom Dom wrote:
Hi,
I already asked some weeks ago fabforce.net about the ability to connect
sqlite and dbdesigner.
The answer was as follows
Bye
Dominique
Sorry, we never got the SQLite support finished. We now have the successor
application out, MySQL Workbench, and we might add
Hi,
I already asked some weeks ago fabforce.net about the ability to connect
sqlite and dbdesigner.
The answer was as follows
Bye
Dominique
> Sorry, we never got the SQLite support finished. We now have the successor
> application out, MySQL Workbench, and we might add SQLite support there
winstonma wrote:
Thanks for the reply. However I downloaded the CVS and tried to compile from
source, I can't find out anything related to server or client.
Oh, I must have missed the part about client/server. You misunderstand
the nature of SQLite. There is no server and no client. SQLite
Thanks for the reply. However I downloaded the CVS and tried to compile from
source, I can't find out anything related to server or client.
Mihai Limbasan wrote:
>
> winstonma wrote:
>> I tried to export the the SQL command exported from DBDesigner4 is not
>> going
>> to run on SQLite. But
winstonma wrote:
I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no clue
how to build the
c.panel wrote:
Hello,
I execute a statement and want to have rowid(s) of each row like a :
"select rowid,* from mytable;"
how can I do this with C API ?
thanks !
There's nothing special about selecting ROWIDs in the C API - you just
use the query you posted above like you would use any
I tried to export the the SQL command exported from DBDesigner4 is not going
to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4
can connect to SQLite server.
I tried to download the source code from SQLite CVS. However I have no clue
how to build the SQLite server from
26 matches
Mail list logo
