Hello,
I have two sqlite databases. (db1, db2)
I try to write a trigger in db1 which inserts data to a table in db2.
In the sqlite docu there is a section about "Temp Triggers".
"...Except, it is possible to create a TEMP TRIGGER on a table in another
database."
CREATE TE
Hello.
I am a newbie both to sqlite and tcl. I would like to learn how to run the
test suite, so that later, when I start modifying the source code (e.g. to
make a customized subset), I can verify that I have not broken anything.
Is there a document somewhere that describes how to run the
ANIEL writes:
Howdy all!
I am just writing tonight to let you know that a project of mine has
opened up to being open source -- ManagedSQLite. It is a light wrapper
around SQLite 3.4.0 that was originally written by Rob Groves. I have
added support for Unicode to his wrapper, then added my Ma
Dear All,
I have just started using the SQLite Db in my applications. My application
runs under MIPS processor. I have generated the Sqlite3.dll and Sqlite3.lib
file for the MIPS processor and it is geting compiled. When i use
Sqlit3_Open function to open a DB, it fails with the error message
Dear All,
i have developed an application using SQLite which runs in the pocket pc
device. My application has to show some messages in a list box (custom
build) while moving forward im able to move the records one by one in the
recordset. But when i move upwards im not able to move to the
query does
it mean the execution time for our query is 40 secs because we are
retrieving the records soon once gets executed.
Regards
Kartthi
Stephen Oberholtzer wrote:
>
> On Tue, May 27, 2008 at 9:06 AM, sqlite <[EMAIL PROTECTED]>
> wrote:
>
>>
>> Dear All,
>
Dear All,
We are using SQLite for our application development which would be deployed
in a pocket pc.Here we are using a query which has three Inner joins and
using sqlite3_prepare and sqilte3_step function to prepare the records and
to fetch the records.By executeing the Query and we moves to
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a query which has three
>> Inner joins
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc.Here we are using a inner join query which takes
different time during different executions, the query which we using in our
application is
"SELECT DISTINCT MT.PcNo, MT.SubPcNo, MT.Br
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a inner join query which
>> takes
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc of type DTX 10 processor ARMV4T.Also we have
generated the lib file specific for ARM processor using the LIB.exe with the
parameters DEF:sqlite3.def MACHINE:ARM and the sqlite3.lib and sqlite3
Dear Virgilio,
Thanks for your Quick reply, we dont know how to enable the funtional level
linking using SQLite with eVC, so kindly tell us how to enable the same.
Thanks & Regards,
kartthikeyan
Virgilio Alexandre Fornazin-2 wrote:
>
> IF you are using SQLite with eVC, you mu
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the "unresolved exteral symbol sqlite3_open referenced in function" error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the "unresolved exteral symbol sqlite3_open referenced in function" error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T
:
>
> IF you are using SQLite with eVC, you must enabled function level linking,
> because
> ARM linkers had a bug before eVC SP4 that generated corrupt image files.
>
> On Thu, Jun 12, 2008 at 9:39 AM, sqlite <[EMAIL PROTECTED]>
> wrote:
>
>>
>> De
Hello,
When using sqlite-3.3.4 with windows I get the following strange behaviour.
create table Muppet (Kermit float);
insert into Muppet values (100);
select * from Muppet;
100.0
As you see it returns 100.0 instead of only 100. This happens in windows
xp but not in win ce.
Anyone know how to
I want to know the type of a column, ie.:
INTEGER, TEXT, REAL or BLOB
There seems to be no function to do this.
I can get the "declared type" of a column but
that's not easy to decipher as SQL has a zillion
data types.
I tried "sqlite3_column_type()" but that function
only works when there's
Eric Scouten wrote:
No such thing, really. In SQLite the data types are associated with the
cell, not the column.
Yes, I saw that. I'm not sure it's a good "feature".
The "declared type" of a column that you've found is used to establish
preferences for
Eric Scouten wrote:
SQLite derives that by parsing the string that you've already found.
I found the method in section 2.1 of this page:
http://www.sqlite.org/datatype3.html
> I think it does store that in some internal fashion, so
> it's not *re-parsing* it constantly,
[EMAIL PROTECTED] wrote:
sqlite <[EMAIL PROTECTED]> wrote:
Eric Scouten wrote:
SQLite derives that by parsing the string that you've already found.
I found the method in section 2.1 of this page:
http://www.sqlite.org/datatype3.html
> I think it does store that in some intern
Eric Scouten wrote:
On 10 May 2006, at 16:31, sqlite wrote:
Eric Scouten wrote:
No such thing, really. In SQLite the data types are associated with
the cell, not the column.
Yes, I saw that. I'm not sure it's a good "feature".
Depends on your application. For us, it&#
ched upon
briefly in 'SQLite in 5 Minutes Or Less'.
I think real problem is that you have a function
called "column_type" which doesn't actually return
the type of a column. This is counter-intutive.
If you could make it return the column "affinity"
between the
Roger Binns wrote:
The types point still baffles me. If your code already
knows which column it is dealing with then surely the
code should know what type to expect. (Eg if you are
dealing with a column named 'title' then you would
expect a string)
Let me explain what I was doing...
I was
John Stanton wrote:
As you postulated, Sqlite's approach is indeed more rational.
Most SQL implementations use fixed-size records
so it makes more sense for them to enforce each
column's data type exactly - inserting a string
into a column which can only hold a single char
isn't very useful.
Joe Wilson wrote:
I also agree with Ralf's proposal for sqlite3_column_affinity().
(Not that a vote on this topic will likely make a difference. ;-)
I don't think you need a new function, just make
the existing one do the obvious thing right after
you call "prepare".
--- Ralf Junker <[EMAI
the 'id' column 'unique' as a client may have more than one
name...
What is the recommended way to do this with SQLite?
PS: I'm not wrong in thinking that IF EXISTS (...) THEN ...
isn't implemented, am I? I couldn't get the sqlite3 interpreter
to accept any stat
re than one
> > name...
>
> However you can specify that the name/id pair is unique ...
> PRIMARY KEY (name, id)
>
> Regards,
> MikeW
Excellent!
Thanks, I didn't know that...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
All:
For comparison I tried several combinations of query orders and indices.
I found both indices and the join clause sequence make significant
differences in execution time. Using SQLiteSpy with SQLite v3.6.1 on
Windows XP.
I have two tables:
GPFB with 34830 rows, 10 columns with a 4-column
Hello all,
I'm compiling sqlite 3.6.13 with Visual 2003, and RunTime Check
activated, and it gives this error :
Run-Time Check Failure #1 -
A cast to a smaller data type has caused a loss of data. If this was
intentional, you should mask the source of the cast with the appropriate
bi
> This is probably not a bug. There are places in the SQLite code where
> we deliberately discard all but the lower 8 bits of an integer. But,
> if you like to tell us *where* in the code this occurs, I'll be happy
> to verify it for you.
In sqlite3.c big file,
D. Richard Hipp a écrit :
> This is not error in the SQLite code. The code here is correct. The
> bug is in your compiler.
Sorry but I don't agree at all.
> Adding a work-around so that this will work in your compiler makes the
> code rather more complicated:
&g
e a code review.
PS C:\rev\src\sqlite3\src> fossil info
project-name: SQLite
repository: c:\rev\fossil\sqlite3.f
local-root: C:/rev/src/sqlite3/
user-home: : C:/Users/rev/AppData/Local
project-code: 2ab58778c2967968b94284e989e43dc11791f548
server-code: 2fa7c8b2762294d28396292f74c7b94c
The docs for sqlite3_bind_blob() states that passing in SQLITE_STATIC
mean that the blob data will be around until "SQLite has finished with
it." But when exactly is this? For an INSERT/UPDATE, is it when the
statement is executed, or the current transaction commmited, or some
other time?
s a table name within the select_stmt. Both of these
are separate from table-valued functions (parameterized views) though.
_______
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
The documentation for the xCreate and xConnect methods for virtual tables give
the incorrect type.
It says "char**argv" but the actual type should be "const char*const*argv".
___
sqlite-users mailing list
sqlite-users@mailingl
ting the sqlite3_interrupted() function (or whatever you want to call
it) should be very easy to implement. However, it must be added into the
extension loading mechanism, so if I do it by myself then it will be
incompatible.
___
sqlite-users mailing list
sqli
rgc,char**argv) {
if(argc!=3) return 1;
if(sqlite3_open(":memory:",&db)) return 1;
count=strtol(argv[1],0,0);
sqlite3_set_authorizer(db,xAuth,0);
printf("%d\n",sqlite3_exec(db,argv[2],0,0,0));
return 0;
}
___
sqlite-users
if it doesn't already.
_______
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
lang_expr.html, and lang_select.html mention window functions at all
except as part of the syntax diagram in lang_expr.html (although window
definitions are also mentioned in lang_select.html, not window functions)
___
sqlite-users mailing li
particular
database.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
uot; will be the same order.
(I also have a table "ART" where "AN" is the rowid, and again the order by
"TIME" will be the same order.)
How can you make SQLite to make that assumption in order to optimize the query?
(It should be done presumably without adding another
sqlite-users@mailinglists.sqlite.org wrote:
> Your schema implies that there can be more than one TIME for any GNAME and AN
> combination (otherwise the primary key would not need to include alle three
> fields). This contradicts your statement that AN and TIME are "the
sqlite-users@mailinglists.sqlite.org wrote:
> It's quite often (for me, at least) the case I need to do something like this
> from the command line:
>
> >sqlite3.exe my.db "insert into t values(`simple field','multi-line text
> >copied
> >from som
761D8
MetadataHash=-1228563750
COM32on64.exe is VB6 ActiveX exe that loads my VB6 dll. This is needed as
this dll is called from 64 bits Excel and that can't access that 32 bit VB6
dll the
normal way. This loading of the VB6 dll via COM32on64.exe is not the
problem as the dll works all fine, until i
I have some proposals for feature requests for virtual table mechanism of
SQLite. Some of this can be useful when accessing remote data over the
internet or whatever. Here is the list:
* A new method "xInterrupt", called when sqlite3_interrupt() is called.
This can be used to cancel
On Wed, Oct 28, 2015 at 11:22 AM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 28.10.2015 18:52, General Discussion of SQLite Database wrote:
>
>> Hence, we have token the radical approach of denying the sender email
>
On Wed, Oct 28, 2015 at 1:32 PM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 2015-10-28 10:52 AM, General Discussion of SQLite Database wrote:
>
>> The reason for this change is to combat the "Alexa" spam. For the
: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence
On 28 October 2015 at 19:42, SQLite
wrote:
> On Wed, Oct 28, 2015 at 11:22 AM, General Discussion
On Wed, Oct 28, 2015 at 1:46 PM, SQLite <
sqlite-users at mailinglists.sqlite.org> wrote:
> Is this over-reacting a bit. I have had one email from alexa (about
> 3/4 weeks ago). If it starts to become a real problem then do
> something about it - until then I would think w
Actually looking at this thread (in gmail) since the policy change is
a very retrograde step - all messages are displayed as from SQLite.
There are numerous scenarios where I want to see the name of the
sender (not necessarily the email address) so that I can pick and
choose which messages I
On 28 Oct 2015, at 7:36pm, General Discussion of SQLite Database wrote:
> Has anybody received email from Alexa since the policy change? I have not
Nor me. I reliably got one for every post I made for about a week before the
change.
Simon.
lite3_reset(ins);
sqlite3_bind_blob(sel,1,"test",4,NULL);
if(SQLITE_ROW != sqlite3_step(sel)) {
printf("no results? %s\n",sqlite3_errmsg(db));
} else {
printf("Got ID %d\n",sqlite3_column_int(sel,0));
}
return 0;
}
-
_reset(ins);
sqlite3_bind_blob(sel,1,"test",4,NULL);
if(SQLITE_ROW != sqlite3_step(sel)) {
printf("no results? %s\n",sqlite3_errmsg(db));
} else {
printf("Got ID %d\n",sqlite3_column_int(sel,0));
}
sqlite3_reset(sel);
return 0;
}
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
27;t ready for production, because if the quality of
sqlite3 is indication, I'm going to really enjoy using it!
Charles
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
4418) at
> runlsm.cpp:41 (gdb) print pNext
> $1 = (ShmChunk *) 0x
>
>
>
> It's a pity that LSM isn't ready for production, because if the quality of
> sqlite3 is indication, I'm going to really enjoy using it!
>
> Charles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
database file mid-transaction.
I'm also seeing a similar problem in which it silently discards entries, but I
haven't been able to narrow down an example for you. Let me know if that would
be helpful and I'll try harder.
What could I do to improve LSM?
Charles
__
c (lsm_unix.c:472)
==1741==by 0x4046C5: lsmMallocZero (lsm_mem.c:50)
==1741==by 0x404730: lsmMallocZeroRc (lsm_mem.c:69)
In a more complex program, lsm seems to leak memory to no bounds, causing my
application.
Are bug reports against LSM even helpful?
Charles
______
Test.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
his case,
> For which OS platform is the generated binary?
> for 32bits win OS or 64bits win OS?
32 bits.
Charles
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I don't know if it will actually cause problems, but is the
"?command.Dispose()" needed? Doesn't the "using" handle disposing?
Graham
Sent from Samsung Mobile
Original message
From: Artem
Date: 28/04/2015 14:29 (GMT+00:00)
To: General
I don't know if it actually causes a problem, but isn't the
"?command.Dispose()" not needed? Doesn't the "using" take care of disposing?
Graham.
Sent from Samsung Mobile
Original message
From: Artem
Date: 28/04/2015 14:29 (GMT+00:00
hi,
SQLite version 3.3.13 is now available in the usual place:
...
As always, please let me know if you find any problems.
building 3.3.13 on osx, all's seemingly well, except the process still
fails to build/install one file,
% cd /usr/ports/sqlite_build
% ls doc/whentouse
Hi all
Is there a way to detect if a transaction is active on the current connection?
Basically the equivalent of "PQtransactionStatus" in postgresql.
I need that to automate rollback or commit depending on other variables within
my application while keeping the connection open.
Thanks!
Nicola
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Tuesday, March 27, 2007 1:50:51 PM
> Subject: Re: [sqlite] Transaction detection...
>
>
> [EMAIL PROTECTED] wrote:
> > Hi all
> >
- Original Message
> MemPage bitfield patch below.
>
> sizeof(MemPage) on Linux:
>
> original: 84
> patched: 76
> ...
> Break-even for memory is 904/8 = 113 MemPage structs allocated.
I didn't look at the code, so mind me :)
If the MemPage are malloced individually (instead of b
- Original Message
> From: Dennis Cote <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, May 30, 2007 12:09:25 PM
> Subject: Re: [sqlite] sqlite internal structs don't make use of C bitfields?
> You may want to look at how the isInited fiel
Hi all
I am trying to put in place a simple replication process to copy a database
from one machine to an other.
The table I have is something like
CREATE TABLE sn2uid(sn VARCHAR(100) NOT NULL, uid INTEGER NOT NULL, PRIMARY KEY
(sn));
CREATE INDEX uidindex on sn2uid ( uid )
Where the (sn,uid) p
> - Original Message
> From: Joe Wilson <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Monday, June 11, 2007 8:36:32 PM
> Subject: Re: [sqlite] Database replication question
>
>
> Large bulk inserts with more than one index (implicit or expli
- Original Message
From: Martin Jenkins <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, June 22, 2007 2:00:45 PM
Subject: Re: [sqlite] Capturing output from SQLlite with variables in a BASH
script
litenoob wrote:
> Hi, I'm wondering how to write a BASH sc
Hello, everybody
I have the following problem: I have the following tables:
Months
--
CREATE TABLE 'Months'
(
IDMonth INTEGER PRIMARY KEY NOT NULL,
MonthRef INTEGER
);
(where MonthRef is the date of the first day of the month - created in the code)
C
>
> - Original Message
> From: Zbigniew Baniewski <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Thursday, July 26, 2007 4:12:00 PM
> Subject: Re: [sqlite] Problem with SQLite FastCGI module "malformed database
> schema"
>
>
>
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Tuesday, September 4, 2007 3:32:38 PM
> Subject: Re: [sqlite] 3.5.0 alpha TryEnterCriticalSection linker error
>
>
> =?ISO-8859-1?Q?Daniel_
CREATE TRIGGER atest_2 AFTER INSERT ON Test
BEGIN
INSERT INTO Log(s) VALUES('atest_2');
END;
INSERT INTO Test(s) VALUES('Test');
SELECT rowid,* FROM log;
Returns the following on both windows (3.6.14) and linux (3.4.2):
1|btest_2
2|btest_3
3|btest_1
4|atest_2
5|atest_3
6|atest_
____
From: pierr
To: sqlite-users@sqlite.org
Sent: Tuesday, 30 June, 2009 2:42:16 PM
Subject: Re: [sqlite] first few characters of varchar() corrupted when
SELECTing from a C++ program?
uralmazamog wrote:
>
> Greetings,
>
> maybe it's just me bei
I should have looked harder...
"The order of arbitrary."
http://www.mail-archive.com/sqlite-users@sqlite.org/msg17641.html
From: "freshie2004-sql...@yahoo.com.au"
To: sqlite-users@sqlite.org
Sent: Tuesday, 30 June, 2009 2:31:40 PM
Subje
(embarrassed)
printf("testValue=(%s)\n", testValue);
From: John Machin
To: General Discussion of SQLite Database
Sent: Tuesday, 30 June, 2009 4:51:09 PM
Subject: Re: [sqlite] first few characters of varchar() corrupted when
SELECTing from a C++ pr
dings.
end loop
sqlite3_finalize();
See sqlite_bind_[](), sqlite_reset(), sqlite_clear_bindings() in manual
From: knightfeng
To: sqlite-users
Sent: Friday, 3 July, 2009 5:02:57 PM
Subject: [sqlite] How to do 5,000,000 "select"s as fast as possible
Dea
Hi All,
As part of a project I am toying with writing I
needed undo/redo functionality, so have ended up writing a loadable
extension for sqlite which implements undo/redo functionality entirely
within the database using custom functions. Kind-of a C implementation
of http://www.sqlite.org
main.mytable(col1,...colN) SELECT col1,...colN FROM dbA.myothertable
COMMIT
DETACH dbA
sqlite3_close B.db
Cheers!
From: Wenton Thomas
To: sqlite-users@sqlite.org
Sent: Saturday, 4 July, 2009 7:31:55 PM
Subject: [sqlite] problem with SQLITE_BUSY
Now in my
but
With, sqlite3.dll version 3.6.16:
colname match 'tetons -bend -jackson -oxbow* -parks' no longer works
correctly. It acts like only the last negated token is being used and results
have bend, jackson and oxbow* tokens in them.
I used SQLite Expert to test this on the same sqlite database
Dan, thank you for the additional information, it's most helpful. I'll let
you know what I find out.
BTW, any reason that doc is not on the SQLite Web site? It would help a lot
of people understand the old and new query syntax better.
Craig
> >
> > Did an FTS3 update ch
Dan, updating to sqlite3.dll version 3.6.17 did fix the problem.
Also, I should clarify what I meant by having the query syntax doc on the
sqlite web site. It is indeed on the web site, but I spent a lot of time
yesterday trying to find a document just like it and couldn't. It just needs
I sent this last night, but it didn't post on the list. Trying again to make
sure this is working.
-- Original Message --
Received: 08:40 PM MDT, 08/27/2009
From: cscs-sql...@usa.net
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Conditional tri
- Original Message
> From: John Stanton <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, November 14, 2007 11:43:48 AM
> Subject: Re: [sqlite] Re: Threads
>
> If you machine has a single disk it fundamentally does not have parallel
> I/O.
ìì ìê° sqlite-users@sqlite.org ë¡ë¶í° ì¤ë ë©ì¼ì ìì ì ê±°ë¶íììµëë¤.
_
--- Begin Message ---
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error,
'Connection' object has no attribute 'autocommit'
I´ve had a google for this and its seems like it may be a bug python-sqlite or
sqlite bug , but also I tri
Hi all,
Hopefully you can help, while running sqlite version 3.5.5
Two seperate threads each attempt to run a vacuum command against the same db.
Each thread has an independent connnection to the db.
One thread succeeds and the other gets a return code of 1 (SQLITE_ERROR) from
ìì ìê° sqlite-users@sqlite.org ë¡ë¶í° ì¤ë ë©ì¼ì ìì ì ê±°ë¶íììµëë¤.
_
--- Begin Message ---
Hi all,
Hopefully you can help, while running sqlite version 3.5.5
Two seperate threads each attempt to run a vacuum
ìì ìê° sqlite-users@sqlite.org ë¡ë¶í° ì¤ë ë©ì¼ì ìì ì ê±°ë¶íììµëë¤.
_
--- Begin Message ---
sqlite-users@sqlite.org wrote:
> Hi all,
>
> Hopefully you can help, while running sqlite version 3.5.5
>
&g
sqlite-users@sqlite.org wrote:
> Hi all,
>
> Hopefully you can help, while running sqlite version 3.5.5
>
> Two seperate threads each attempt to run a vacuum command against the same
> db. Each thread has an independent connnection to the db.
>
> One thread succe
es work.
Thanks, Si.
-
Get the name you always wanted with the new y7mail email address.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
<[EMAIL PROTECTED]> wrote:
> The problem (I suspect) is that you have an index on Table3.
> As you insert to records into Table3, those record go at the
> end, which is very efficient. But the index entries have to
> be inserted in index order, which means they get scattered
> out all through the
- Original Message
From: Jay Sprenkle <[EMAIL PROTECTED]>
On 5/1/06, Ivan Voras <[EMAIL PROTECTED]> wrote:
> > I've spent a long time debugging low performance of an
> > application that uses :memory: database and have found
> > that sqlite v2
Hi all
As discussed before, I have performance issues when using sqlite on big (multi
gig) databases.
I am still trying to use sqlite as the main db because it simplifies deployment
so much.
The main reason seems to be that inserting in the btree is very slow (even
using transactions) because
Hello, everybody
I have the following problem: I have a table that contains "Events", with the
related date and time:
Fields:
EventID
EventDate
EventTime
I would like to "group" these records by day, returning all the "times" of the
events, like:
EventID, EventDate, EventTime1, EventTime2, E
Hello, and thanks for the reply.
I dont' know PHP, but I can understand that you are suggesting to "manually"
iterate the records to find the events, and group them by day. Is this right?
"C.Peachment" <[EMAIL PROTECTED]> ha scritto: What is wrong with using:
select EventID, EventDate, Event
ag = IAmBoss) FROM Employees;
What I get is an error indicating:
"SQLite error 1 - no such column: IAmBoss"
How can I solve this? Any help is appreciated
Thanks and kind regards,
Marco
Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
> this:
>
> SELECT IDContractLevel, IDContractLevel > 4 as IAmBoss, (SELECT * FROM Bosses
> WHERE Flag = IAmBoss) FROM Employees;
>
> What I get is an error indicating:
>
> "SQLite error 1 - no such column: IAmBoss"
Could you post the definition of the table E
- Original Message
From: Unit 5 <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, November 9, 2006 8:02:51 AM
Subject: RE: [sqlite] Insert statement taking too long
> --- Robert Simpson <[EMAIL PROTECTED]> wrote:
> > You need to create an index
- Original Message
From: Christian Smith <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, November 9, 2006 8:38:51 AM
Subject: Re: [sqlite] indexes in memory
> chetana bhargav uttered:
> > Hi,
>
> > I have a question regrading indexes,
> >
1 - 100 of 242 matches
Mail list logo
