configure and Makefile have ways to define SQLITE_THREAD_OVERRIDE_LOCK=1
and SQLITE_ALLOW_XTHREAD_CONNECT=1 but those flags are used nowhere in
the source code.
Couldn't them be removed from configure/Makefile too, for the sake of
avoiding confusion?
--
Lapo Luchini - http://lapo.it/
“The
Hello good first introduced me in this mailing list, I'm new here. I
wish somebody would help me with SQLite for S60 Nokia phones. Thanks in
advance and greetings to everyone.
___
sqlite-users mailing list
sqlite-users@sqlite.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/02/2010 03:28 PM, Vicente Minguez Gzbarda wrote:
Hello good first introduced me in this mailing list, I'm new here. I
wish somebody would help me with SQLite for S60 Nokia phones. Thanks in
advance and greetings to everyone.
Hi i made a program on C language who inserts some data on sqlite database, it
works well but after a while (10,15 minutes) it stops to work and throws me
this mistake:
on console:
unknown:11373): Gtk-WARNING **: Error loading theme icon 'gtk-ok' for stock:
No se ha podido cargar el módulo de
On Wed, Sep 1, 2010 at 12:46 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On a personal level, I don't think it is worth it. In the end, you're
still hoping the OS and filesystem will make smart choices about block
allocations. An application shouldn't need to be spending a lot
of time
Hi,
It's pretty hard to make a SELECT from same table, but using two different
aliases for the table and at the same time also getting column names in
results - using Tcl bindings.
The SQL query would be:
select a1.txt, a2.txt
from a a1
join a a2
using (ref)
where a1.lang =
On Wed, Sep 1, 2010 at 5:57 PM, Paweł Hajdan, Jr.
phajdan...@chromium.org wrote:
Additionally, browsers seem to be moving to the multi-process architecture
(Chrome, Firefox, WebKit2), so I wouldn't be surprised if you get more
questions about this in the future, or just more forked copies.
Hello.
Is there a pager for sqlite3 default client ?
sqlite select count(*) from mytable;
37899
sqlite select * from mytable;
...
(too much entries, can't read anything)
...
___
sqlite-users mailing list
On Wed, Sep 1, 2010 at 6:11 PM, Paweł Salawa p...@bitrock.com wrote:
Hi,
It's pretty hard to make a SELECT from same table, but using two different
aliases for the table and at the same time also getting column names in
results - using Tcl bindings.
The SQL query would be:
select a1.txt,
On 2 September 2010 11:24, Arthur Rance arthur_ra...@hotmail.com wrote:
Hello.
Is there a pager for sqlite3 default client ?
sqlite select count(*) from mytable;
37899
sqlite select * from mytable;
...
(too much entries, can't read anything)
...
Not built in to the shell.
But you can
Hi,
we have a java application ( with sqlitejdbc-v056/windows vista) which
runs only once on every PC to fill a new database.
On most machines everything works perfectly, but on some machines the
application fails with either Unable to open database file
or disk I/O error.
The database is of
Hi,
I found a strange behavior of the sqlite 3.7.2 with WAL journal mode.
Yesterday I found my application DB with a -wal file of 1,5GB and a -shm
file of few MB (about 9MB) with a DB file of 1,2GB: in this
situation I got the process memory wasted by mapped file of the -shm
file. It seams
On Thu, Sep 2, 2010 at 8:34 AM, Michele Pradella michele.prade...@selea.com
wrote:
Hi,
I found a strange behavior of the sqlite 3.7.2 with WAL journal mode.
Yesterday I found my application DB with a -wal file of 1,5GB and a -shm
file of few MB (about 9MB) with a DB file of 1,2GB: in this
ok, I'll wait for the walk around.
I always use a BEGIN; COMMIT; transaction but often, after a COMMIT; the
-wal file does not change in size, it seams it's not checkponted.
Anyway do you think that with WAL journal mode I should continue to use
BEGIN; COMMIT; statement? or not?
Il
Yes but none of those functions return the class that the declared type
maps to (SQLITE_TEXT, SQLITE_FLOAT etc), they just return the SQL type
as a string, of which there are umpteen possibilities.
Presumably then Im going to have to map them to the class myself? My
question was, is this the
My reason for doing this is, if a field is null, I still need to know
what class it 'should' have been if it had been storing a value.
Why do you need that? No matter what you declare field can store any
type of data. And in SQLite there's no declared storage class. You
are talking either about
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/02/2010 06:52 PM, Andrew Wood wrote:
Yes but none of those functions return the class that the declared type
maps to (SQLITE_TEXT, SQLITE_FLOAT etc), they just return the SQL type
as a string, of which there are umpteen possibilities.
Michele Pradella wrote:
ok, I'll wait for the walk around.
I always use a BEGIN; COMMIT; transaction but often, after a COMMIT; the
-wal file does not change in size, it seams it's not checkponted.
Anyway do you think that with WAL journal mode I should continue to use
BEGIN; COMMIT;
I have Google-ed references to a utility called ical2sqlite, which claims to be
able to make a database out of an iCalendar data file.
Anyone on this list have any experience with it ?
“Sometimes I think the surest sign that intelligent life exists elsewhere in
the universe is that none of it
On Thu, Sep 2, 2010 at 9:59 AM, Marcus Grimm mgr...@medcom-online.dewrote:
Michele Pradella wrote:
ok, I'll wait for the walk around.
I always use a BEGIN; COMMIT; transaction but often, after a COMMIT; the
-wal file does not change in size, it seams it's not checkponted.
Anyway do
I've not before dealt with ADOdb, but a CMS I'm considering using to
change my company web site uses that. My Google search found one reference
(from 2009) suggesting that ADOdb does not play well with sqlite3. Is this
true (still)?
If I can use it, I'll take a deeper look at the CMS.
-- Forwarded message --
From: Leran Liu j...@phranywhere.com
Date: Thu, Sep 2, 2010 at 12:06 PM
Subject: Question about SQLite
To: d...@hwaci.com
Hi, I have question about the SQLite, do I need to install the exe in order
to use it in the client side? Is there any alternatives
My Spanish isn't perfect but it looks like you're running out of file
descriptors. I.e. you (or a library or module you are using) is creating file
descriptors using e.g. open(2) and never close(2)ing them.
Please forgive typos--I sent this from my smart phone.
On Sep 1, 2010, at 15:34,
Hello
I tried to update 2 colums of my recently added row in my table sites.
The colums are createTime and updateTime, but sqlite only sets
updateTime, the other colum stay plain. Sqlite doesn't complain about
anything so I don't know whats wron.
CREATE TRIGGER insert_sites_createTime
The correct syntax is
UPDATE sites SET createTime = DATETIME('NOW'), updateTime =
DATETIME('NOW')
WHERE rowid = new.rowid;
So I wonder if you made a typo and actually only createTime were
updated when updateTime remained unchanged.
Pavel
On Thu, Sep 2, 2010 at 3:11 PM, Michael Graßl
Am 02.09.10 21:18, schrieb Pavel Ivanov:
The correct syntax is
UPDATE sites SET createTime = DATETIME('NOW'), updateTime =
DATETIME('NOW')
WHERE rowid = new.rowid;
Thanks this works.
So I wonder if you made a typo and actually only createTime were
updated when updateTime
Pavel Ivanov paiva...@gmail.com wrote:
The correct syntax is
UPDATE sites SET createTime = DATETIME('NOW'), updateTime =
DATETIME('NOW')
WHERE rowid = new.rowid;
So I wonder if you made a typo and actually only createTime were
updated when updateTime remained unchanged.
The original
Michael Graßl mich...@grassl.eu wrote:
Am 02.09.10 21:18, schrieb Pavel Ivanov:
The correct syntax is
UPDATE sites SET createTime = DATETIME('NOW'), updateTime =
DATETIME('NOW')
WHERE rowid = new.rowid;
Thanks this works.
So I wonder if you made a typo and actually only
Hi,
How pertinent is this source code (are the calls made in the right order?,...)?
Could this source code be a rather good basis for Asynchronous I/O modules for
SQLite?
Thanks a lot,
Best regards,
Gilles
___
sqlite-users mailing list
On Fri, Sep 3, 2010 at 12:29 AM, Igor Tandetnik itandet...@mvps.org wrote:
The correct syntax is
UPDATE sites SET createTime = DATETIME('NOW'), updateTime =
DATETIME('NOW')
WHERE rowid = new.rowid;
It's interesting, I once did a similar error with UPDATE (typing field1=..
and
On Thu, Sep 02, 2010 at 05:42:17AM +0200, Ben Danper scratched on the wall:
On Wed, Sep 1, 2010 at 12:46 PM, Jay A. Kreibich j...@... wrote:
There is no reason to assume the filesystem
will over-write the existing allocations, rather than just create new
ones, especially if the pages are
31 matches
Mail list logo
