On Oct 2, 2009, at 12:33 PM, Keith Roberts wrote:
I'm trying to learn the syntax for SQLite, and I'm getting
stuck with the type-def production in:
http://www.sqlite.org/lang_createtable.html
I read it as a type-def production is a sequence of one or
more instances of a terminal symbol -
hallo Sqlite-users,
i want to update a trigger from within another trigger. because there is no
update-trigger statement i tried to drop and recreate my trigger. i
tried this:
CREATE TRIGGER trg_update AFTER UPDATE ON SystemData
BEGIN
DROP TRIGGER trg_TrimMessdataLast;
-- CREATE
I have the following question from the SQLite Mailing List, would be great if
anyone can answer.
How the different view in the mailing list is working:
1) For example from the DB if we have three different views. How will be the
view updated if one Tuple updated or changed from the DB?
On Fri, 2 Oct 2009 10:43:38 +0200, Michael Werber
michael.wer...@promess-gmbh.de wrote:
hallo Sqlite-users,
i want to update a trigger from within another trigger. because there is no
update-trigger statement i tried to drop and recreate my trigger. i
tried this:
CREATE TRIGGER trg_update AFTER
KN The need to change a schema on the fly is usually caused by
KN bad design. What is the probvlem you try to resolve?
the problem is i have a table that should contain only the last xxx
inserts.
to do so i created a trigger:
CREATE TRIGGER trg_TrimMessdataLast
AFTER INSERT ON MessdataAll
It appears that you aren't asking about SQLite, but about nabble.com
mirror of SQLite's mailing lists. Realize that Nabble is in no way
affiliated with SQLite - they are a third party that chooses to
aggregate and archive lots of different mailing lists, including those
where SQLite is
On Fri, 2 Oct 2009 12:18:11 +0200, Michael Werber
michael.wer...@promess-gmbh.de wrote:
KN The need to change a schema on the fly is usually caused by
KN bad design. What is the probvlem you try to resolve?
the problem is i have a table that should contain only the
last xxx inserts.
to do
Keith Roberts wrote:
I'm trying to learn the syntax for SQLite, and I'm getting
stuck with the type-def production in:
http://www.sqlite.org/lang_createtable.html
Should name not be a selection of available type names,
instead of an iteration?
With SQLite, there is no exhaustive list of
I have an issue with a sqlite3 db. I have a table that yields invalid
data in some queries.
Select sales.*
From sales
Where sales.record_type = 1
Order By sales.datetime Desc
Yields the top 124 or so records as all duplicates, and the record_type
column has a 0 in each record. By
So any idea what might have caused this, a good way to fix it, or detect
it at runtime? The other threads that I have read point to either
multithreading issues, or an ungraceful shutdown.
And they're right, except that ungraceful shutdown will hurt your
database only if you set pragma
On 2 Oct 2009, at 2:13pm, Reusche, Andrew wrote:
sqlite pragma integrity_check;
wrong # of entries in index sales_datetime
Which version of SQLite are you using ?
DROP the index then MAKE it again, then do the 'PRAGMA
integrity_check' thing again.
If that didn't help I suspect that that
Is it possible to dump an in-memory sqlite database (or table?) to a
file from within Tcl?
I create it like so:
sqlite3 dbFireData :memory:
and insert a bunch of records, and then commit.
I have tried the following (and variations) -- but no go, kokomo.
($fileOut3 is a handle to a
Hello!
I am not entirely certain this is the right way to proceed, but I haven't
been able to find the appropriate official SQLite forum (if one exists).
I want to create a rather complex AIR application that will have to deal
with a massive database.
My question is:
Is SQLite capable of dealing
On Fri, Oct 2, 2009 at 11:42 AM, Francisc Romano fran...@gmail.com wrote:
Hello!
I am not entirely certain this is the right way to proceed, but I haven't
been able to find the appropriate official SQLite forum (if one exists).
I want to create a rather complex AIR application that will have
Wow. I did not expect such a quick answer...
Is there somewhere I can read exactly how fast and how big databases SQLite
can take, please?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, Oct 2, 2009 at 11:45 AM, Francisc Romano fran...@gmail.com wrote:
Wow. I did not expect such a quick answer...
Is there somewhere I can read exactly how fast and how big databases SQLite
can take, please?
See http://www.sqlite.org/limits.html for how big. You will have to
do your own
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Francisc Romano wrote:
how big databases SQLite can take, please?
Someone told me recently they have 37GB and 66 million rows in their data
set. Another user is using the virtual table functionality together with
synthetic indices to optimise
Very good idea! Thank you!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Does anybody know why just adding the begin/commit here improves
performance? If I have to do a large number of selects like this in my
application, should I always wrap it in a transaction?
This looks like some overhead of your file system. When you don't put
begin/commit around selects then
On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano fran...@gmail.com wrote:
Wow. I did not expect such a quick answer...
Is there somewhere I can read exactly how fast and how big databases SQLite
can take, please?
SQLite uses a b+tree internally, which is logarithmic in complexity.
Every time
On 10/2/09, Pavel Ivanov paiva...@gmail.com wrote:
Does anybody know why just adding the begin/commit here improves
performance? If I have to do a large number of selects like this in my
application, should I always wrap it in a transaction?
This looks like some overhead of your file
It seems a bit disingenuous to claim
there will be no performance gain by putting selects in a transaction,
when sqlite clearly does less work with the transaction (in the form
of not getting the read lock multiple times).
It's pretty ingenuous in fact to silently assume that nobody wants to
On 10/2/09, Pavel Ivanov paiva...@gmail.com wrote:
It seems a bit disingenuous to claim
there will be no performance gain by putting selects in a transaction,
when sqlite clearly does less work with the transaction (in the form
of not getting the read lock multiple times).
It's
On 2 Oct 2009, at 8:40pm, Mike Shal wrote:
Ahh, ok - that makes sense. Does this locking overhead not occur on
other platforms (I've only tried linux -- gentoo and ubuntu), or if
sqlite is built differently?
It's to do with how the platform (OS and hard disk format) support
file locking.
BareFeet wrote:
By contrast (to points 3 and 4), the sqlite3 command line utility
handles multiple table outputs (with different numbers of columns)
fine and seems to understand the types of data if using a mode that
discerns it.
Because it runs these statements one by one using
I am using Pelles C 6.00.4 for Windows on Vista. It doesn't compile and any
help would be appreciated.
/**See also the Introduction To The SQLite C/C++ Interface for an
introductory overview and roadmap to the dozens of SQLite interface
functions.**/
#include stdio.h
#include sqlite3.h
static
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
David Morris wrote:
Building sqliteFirst.obj.
Building SQLiteFirst.exe.
POLINK: error: Unresolved external symbol '_sqlite3_open'.
POLINK: error: Unresolved external symbol '_sqlite3_errmsg'.
POLINK: error: Unresolved external symbol
Gidday,
Building sqliteFirst.obj.
Building SQLiteFirst.exe.
POLINK: error: Unresolved external symbol '_sqlite3_open'.
POLINK: error: Unresolved external symbol '_sqlite3_errmsg'.
POLINK: error: Unresolved external symbol '_sqlite3_close'.
POLINK: error: Unresolved external symbol
Thanks for your reply Roger, but doesn't the inclusion of the sqlite3.h file
do that? If not, could you give me a better example please?
David
Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
David Morris wrote:
Building sqliteFirst.obj.
Building SQLiteFirst.exe.
On Fri, Oct 2, 2009 at 9:01 PM, David Morris dmor5...@bigpond.net.au wrote:
Thanks for your reply Roger, but doesn't the inclusion of the sqlite3.h file
do that?
No, you have to link against the correct library. For example, if you
have your sqlite library under /usr/local/lib, you will add
30 matches
Mail list logo