On Apr 11, 2009, at 3:03 AM, Dave Toll wrote:
> Hello list
>
> I am sometimes seeing the error SQLITE_CORRUPT with message
> "database disk image is malformed", when I attempt CREATE TEMP
> TRIGGER. My test spawns 5 threads, each of which modifies and
> queries its own table in a common dat
Hi Günther,
> I need to join 2 tables A and B on 3 columns, ie.
>
> "select A.4, B5 where A1 = B1 and A2 = B2 and A3 = B3"
>
> the columns B1, B2, B3 are individually indexed, I also have an
> index of
> (B1,B2,B3).
> The query is very slow, I don't understand why, can someone please
> tell
Hi,
I need to join 2 tables A and B on 3 columns, ie.
"select A.4, B5 where A1 = B1 and A2 = B2 and A3 = B3"
the columns B1, B2, B3 are individually indexed, I also have an index of
(B1,B2,B3).
A has about 23000 rows and B about 17000.
The query is very slow, I don't understand why, can someo
John Machin wrote:
> On 16/03/2009 5:48 PM, Pierre Chatelier wrote:
>>> A few hundred blocks of raw data? Blocksize approx 300K bytes?
>>> Database
>>> created and dropped by the same process? 500 blocks is approx 150M
>>> bytes; why not keep it in a hash table in memory? If you keep it in a
>>>
Hello list
I am sometimes seeing the error SQLITE_CORRUPT with message "database disk
image is malformed", when I attempt CREATE TEMP TRIGGER. My test spawns 5
threads, each of which modifies and queries its own table in a common database
(each thread uses a separate connection from sqlite3_ope
Alberto Simões wrote:
> I was just wondering, is it a good idea to bundle SQLite in the Perl Module?
> Wasn't it better to use the system version, if it is available? (well,
> I think this isn't done as I have it on the system and DBD::SQlite
> just compiled it...)
This was discussed, and it was d
I was just wondering, is it a good idea to bundle SQLite in the Perl Module?
Wasn't it better to use the system version, if it is available? (well,
I think this isn't done as I have it on the system and DBD::SQlite
just compiled it...)
Cheers
Alberto
2009/4/10 Alberto Simões :
> Hello.
>
> Thank
Hello!
On Friday 10 April 2009 16:23:43 D. Richard Hipp wrote:
> On Apr 10, 2009, at 5:58 AM, Alexey Pechnikov wrote:
> > Note: TCL interface binds all as text values
>
> False. The following TCL script is proof by counter-example:
>
> package require sqlite3
> sqlite3 db :memory:
> s
"Gheorghita Suciu"
wrote in message
news:80bfa2aa0904090603o6a5b5b44uf0cda774631c0...@mail.gmail.com
> I'm trying to find which column is the primary key column for a table
> inside an sqlite database.
PRAGMA table_info(tableName);
Note that a primary key may be comprised of more than one column
On Apr 10, 2009, at 5:58 AM, Alexey Pechnikov wrote:
>
> Note: TCL interface binds all as text values
False. The following TCL script is proof by counter-example:
package require sqlite3
sqlite3 db :memory:
set x [expr {1+2}]
db eval {
CREATE TABLE t1(x);
INSERT INTO
Hello.
Thank you for this new update. Thanks for taking into consideration my
request on collations. Yupy!
On Thu, Apr 9, 2009 at 6:01 PM, Stefan Evert
wrote:
> Thanks a lot, Darren!
>
> This version also fixes the problems I've been having with segfaults
> in the create_function test that I've
Thanks a lot, Darren!
This version also fixes the problems I've been having with segfaults
in the create_function test that I've been worried about. I've only
tried version 1.22_02, but according to the change log, the bug was
fixed before the public release of 1.20.
Best,
Stefan
Hello,
I'm trying to find which column is the primary key column for a table inside
an sqlite database.
If anyone knows a way to achieve that, please reply.
Thanks,
Gicu
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
Hello!
Note: TCL interface binds all as text values and we can't use typeof()
function (typeof returns 'text' for all fields). So we may use manual cast() to
field datatype instead.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-user
Hello!
This function doesn't work:
sqlite> select userkey_uninstall();
SQL error: database table is locked
static void userkey_uninstallFunc(sqlite3_context *context, int argc,
sqlite3_value **argv){
sqlite3 *db;
int rc; /* Result code */
const char zSql[]
I'm not familiar with MinGW and MSYS and with C/C++ in general. I don't know
if a must do something special to build this dll for windows mobile
application.
Thibaut
2009/4/10 Jay A. Kreibich
> On Thu, Apr 09, 2009 at 04:34:53PM +0200, Thibaut Gheysen scratched on the
> wall:
>
> > I have found
On Thu, Apr 09, 2009 at 04:34:53PM +0200, Thibaut Gheysen scratched on the wall:
> I have found the "extension-functions.c" in the
> contrib page of the SQLite website but I'm not able to build it for windows
> ce. Anybody can help me ?
What specific problems are you having? I was able to comp
17 matches
Mail list logo
