Re: [sqlite] sqlite for 16bit

2007-06-15 Thread Ulrik Petersen
nizhnik/databases.html (Scroll down to the bottom.) Btw, did you mean 32 bits instead of 23 bits? Cheers, Ulrik Petersen -- Ulrik Petersen http://ulrikp.org -- Homepage http://emdros.org -- Emdros is a text database engine -

Re: [sqlite] Lemon parser generator question

2007-05-04 Thread Ulrik Petersen
. In Lemon, the tokenizer drives the parser, not the other way around. For more information, you can see the sources of SQLite, which includes a document on Lemon, or you can read this: http://www.hwaci.com/sw/lemon/lemon.html HTH Ulrik Petersen Medi Montaseri wrote: Hi, Firstly

Re: [sqlite] sqlite and borland c++ builder

2007-04-29 Thread Ulrik Petersen
iler that emits code with C calling conventions. This enables calling C code from within C++. As you probably know, calling conventions have to do with, among other things, the way function parameters are put on the stack, and the way any return value is returned. HTH Regards, Ulrik Pete

Re: [sqlite] sqlite and borland c++ builder

2007-04-29 Thread Ulrik Petersen
Hi Jon, is it not an option to build SQLite with a C compiler, then call it from within C++? Regards, Ulrik Petersen Jonathan Kahn wrote: Even when I try to build a new dll I get errors with attach.c and it says cannot convert 'void *' to 'Db *', no matter what route I take I always hit

Re: [sqlite] Where could i find?

2007-02-02 Thread Ulrik Petersen
4) Update to something that was prior to 2.0. Since 2.0 was started on or around 2001-09-16, the following will work: cvs update -D '2001-09-01' . Notice the dot at the end. HTH Ulrik Petersen http://emdros.org -- Emdros is a corpus query system Cesar Rodas wrote: > I just

Re: [sqlite] fast Java solution?

2006-07-17 Thread Ulrik Petersen
might want to roll your own JNI code after all, especially if you want to do custom things with callbacks. Might be worth a look. HTH Ulrik Petersen

Re: [sqlite] Need sql query help

2006-06-25 Thread Ulrik Petersen
in each hash-map. That would make your lookup-times be O(m), where m is the number of letters to search for, rather than O(n), where n is the number of words. HTH Ulrik Petersen

Re: [sqlite] Scrolling thru an index

2006-03-22 Thread Ulrik Petersen
Hi JP, JP wrote: Anyway, maybe separate topic, I tried to create a "snapshot" window of the above using plain SQL, but it doesn't seem to work on Sqlite 3.3.4: CREATE TABLE clients (custid integer primary key, lastname varchar(50)); CREATE INDEX cidx ON (lastname); (insert 10,000 records

Re: [sqlite] Sqlite and Java

2006-01-19 Thread Ulrik Petersen
I think Noël may be talking about Apache Derby, formerly IBM Cloudscape: http://db.apache.org/derby/ Regards, Ulrik Petersen

Re: [sqlite] converting a mysql database

2005-11-04 Thread Ulrik Petersen
Hi Dave, Dave Dyer wrote: I'm taking a test cut at converting a existing mysql database to sqlite. I dumped the mysql database, tweaked the prototype into slite format, and converted the escape characters in the data to standard sql format. Here's what happens when I attempt an import:

Re: [sqlite] how to secure SQLite database

2005-10-05 Thread Ulrik Petersen
. Hipp, the creator of SQLite, has a very reasonably priced solution. See http://www.hwaci.com/sw/sqlite/prosupport.html Ulrik Petersen -- Ulrik Petersen, Denmark

Re: [sqlite] questions from a new user

2005-09-10 Thread Ulrik Petersen
of the sourcecode. If you are on a Unix/Linux box, you can do make doc and it will be built for you in doc/. Cheers, Ulrik -- Ulrik Petersen, Denmark

Re: [sqlite] Please test on Win95/98/ME

2005-09-06 Thread Ulrik Petersen
against unicows if they need win9x support and you can stick to only using the W functions. http://www.microsoft.com/globaldev/handson/dev/mslu_announce.mspx I like this solution a lot. This is probably what I will end up doing unless somebody can suggest a good reason not to. -- D. Richard Hipp <[EMAIL PROTECTED]> -- Ulrik Petersen, Denmark

Re: [sqlite] Linker Error when trying to use Sqlite with GCC

2005-08-23 Thread Ulrik Petersen
**argv) { struct sqlite *pilotLog; pilotLog = sqlite_open("logbook.dat", 0, NULL); sqlite_close(pilotLog); How about using sqlite3_open and sqlite3_close ? HTH Ulrik P. -- Ulrik Petersen, Denmark

Re: [sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

2005-08-20 Thread Ulrik Petersen
, not on Windows, I've found. However, increasing the page size beyond 4096 does nothing for me in terms of increased performance. Cheers, Ulrik P. -- Ulrik Petersen, Denmark

RE: [sqlite] Linking libsqlite statically

2005-08-15 Thread Ulrik Petersen
Hi, > There are libsqlite3.a, libsqlite3.la, and libsqlite3.so files > in /usr/lib/ Could you show us the exact command line you are trying to use when running g++ ? I'm especially interested in the version where you give the /usr/lib/libsqlite3.a fully qualified filename on the commandline.

Re: [sqlite] how to force a database to be corrupted

2005-07-09 Thread Ulrik Petersen
://www.sqlite.org/lockingv3.html Scroll down to section 6.0 "How To Corrupt Your Database Files". Ulrik Petersen -- Ulrik Petersen University of Aalborg, Denmark http://ulrikp.org/

Re: [sqlite] Lemon grammar question

2005-06-08 Thread Ulrik Petersen
. { DoSomethingAfterEverything(T,I,R); } temp ::= DoSomethingRightAfterIdent(...how would I access TYPE/INDENT from here..); but it doesn't quite work for this case... Any ideas? /Ludvig HTH Ulrik Petersen -- Ulrik Petersen, PhD student, MA, B.Sc. Aalborg University, Denmark

Re: [sqlite] Basic Text Bind Question

2005-06-07 Thread Ulrik Petersen
; ); I think it stops right here, because you've got fname twice. That induces an error. Also, I'd execute each statement by itself. HTH Ulrik Petersen -- Ulrik Petersen, PhD student, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Newbie sql: query and joining more than two tables

2005-06-05 Thread Ulrik Petersen
e.org/php2004/page-001.html On slide 48, it starts talking about how to organize your WHERE clauses for using indexes: http://www.sqlite.org/php2004/page-048.html HTH Ulrik P. -- Ulrik Petersen, PhD student, MA, B.Sc. Aalborg University, Denmark

Re: [sqlite] beginner's question

2005-06-05 Thread Ulrik Petersen
':memory:' AS mynameforthememorydatabase; HTH Ulrik P. -- Ulrik Petersen, PhD student, MA, B.Sc. Aalborg University, Denmark http://ulrikp.org/

Re: [sqlite] Error while loading shared libraries: libsqlite.so.0

2005-05-04 Thread Ulrik Petersen
e? libsqlite.so.0 should just be a soft link to libsqlite.so.0.8.6 ln -s libsqlite.so.0.8.6 libsqlite.so.0 should do the trick. HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] does sqlite run on 64 bit?

2005-04-29 Thread Ulrik Petersen
can't tell you how to make it work. What platform are you trying to run it on? Ulrik Petersen -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Double quotes in C++ SQL statements

2005-04-26 Thread Ulrik Petersen
testtable(Name,OtherID,Number,Notes) VALUES ("Another Name",12,4758.3265,"More notes");"; One solution would be to use 'Some Name' and 'Here are some notes' -- the SQL standard says that 'this is a literal string' whereas "this is a delimited (column) name". See a

Re: [sqlite] SQLite on Motorola Power PC

2005-04-20 Thread Ulrik Petersen
guess you would need to install Linux, because Mac OS doesn't know ELF, but then just about every PPC Mac should be able to compile SQLite. Thomas -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark Homepage: http://ulrikp.org

Re: [sqlite] Callback when table contents have changed

2005-04-19 Thread Ulrik Petersen
ith SQLite, is it? Frank. Isn't that what triggers are for? Perhaps you could couple a trigger with a user-defined function. HTH Ulrik -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Version 3.2.0

2005-03-24 Thread Ulrik Petersen
s systems. You may use this option multiple times on the command line: it affects library searching for -l options which follow it. This option also implies --unresolved-symbols=report-all. [snip] HTH Ulrik Petersen -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface

2005-03-02 Thread Ulrik Petersen
Steve Frierdich wrote: Does anyone know how to add a column to an sqlite database through the sqlite utility interface. I tried the SQL statement , ALTER TABLE table Name ADD column variable, and it did not work. Anyone know any other way? Thanks Steve http://www.sqlite.org/faq.html#q13

Re: [sqlite] database encryption

2005-02-27 Thread Ulrik Petersen
schema). [snip] Also, any other solution available ? Dr. Hipp himself offers an encryption-enhanced version for a fee: http://www.hwaci.com/sw/sqlite/prosupport.html It can't get much better than getting it straight from the author ;-). Cheers, Ulrik Petersen

Re: [sqlite] lobjc

2005-02-26 Thread Ulrik Petersen
installing and reinstalling dev-c++. HTH Ulrik Petersen -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Re: sqlite performance variationin linux and windows

2005-02-25 Thread Ulrik Petersen
Hi, Neelamegam Appadurai wrote: Hi, Thanks for the quick response and the interest you're showing, I am testing the performance of linux and windows using a. same testing data for both. b. db schema is common for both. c. though the test is conducted on two different machines but the machine

Re: [sqlite] Syntax error ?

2005-02-24 Thread Ulrik Petersen
me file --- --- -- 0main /projects/test/contacts 1temp /var/tmp/sqlite_ZFSmuMGwKY4qVLY This is the same in SQLite 3. HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-24 Thread Ulrik Petersen
over which it is that causes the speed increase). This has given a speed increase for me. Not a factor 2, mind you, but still a speed increase. Also, you might try increasing the SQLite page cache size on Windows. HTH Ulrik Petersen -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Write issues on some computers?

2005-02-23 Thread Ulrik Petersen
reported to be a bad idea for keeping SQLite databases. Just a thought. Ulrik Petersen -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] New to SQLite...............2

2005-02-22 Thread Ulrik Petersen
nload page: http://www.sqlite.org/download.html HTH Ulrik Petersen

Re: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Ulrik Petersen
Hi again, Brown, Dave wrote: Is it possible to create the behaviour of a sequence with SQLite? I need to do something like this: [pseudocode] var id = SELECT next_val FROM my_sequence; INSERT INTO table1 VALUES(id, ...); INSERT INTO table2 VALUES(id, ...); I forgot to say that if you want to

Re: [sqlite] Making a SEQUENCE?

2005-02-21 Thread Ulrik Petersen
Hi Dave, Brown, Dave wrote: Is it possible to create the behaviour of a sequence with SQLite? I need to do something like this: [pseudocode] var id = SELECT next_val FROM my_sequence; INSERT INTO table1 VALUES(id, ...); INSERT INTO table2 VALUES(id, ...); This should return the next value, AND

Re: [sqlite] Is it bug?

2005-02-19 Thread Ulrik Petersen
Witold Czarnecki wrote: sqlite> select typeof(round(1)); text Is it bug? What version? Ulrik Petersen

Re: [sqlite] Best way to check for existence of a table?

2005-02-14 Thread Ulrik Petersen
hanks again, Richard. SELECT COUNT(*) etc. should return a tuple with one column, not an error message. You then retrieve that tuple. If the value in the tuple is 0, then the table does not exist. If the value is 1, then it does exist. HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University

Re: [sqlite] Problem with this simple example

2005-02-14 Thread Ulrik Petersen
Ulrik Petersen wrote: b) Compile with -DTHREAD_SAFE. Sorry, that should have been: b) Make sure that SQLite has been compiled with -DTHREAD_SAFE. Ulrik P.

Re: [sqlite] Problem with this simple example

2005-02-14 Thread Ulrik Petersen
Hi Dave, Dave Furey wrote: Below is a very simplied example of what I'm trying to do with a recursive routine call: == sqlite3_prepare (hDB,CstrCommand,strlen(CstrCommand),,); while ( sqlite3_step(ppStmt) == SQLITE_ROW ) { sqlite3_prepare

Re: [sqlite] VACUUM question

2005-02-13 Thread Ulrik Petersen
used it many times, and my Emdros project, which uses SQLite 2.8.15, takes advantage of it. I don't know whether the problem Derrell was referring to exists in 2.8.15, though. Ulrik P. -- Ulrik Petersen, Denmark Emdros -- the text database engine for analyzed or annotated text http://emdros.org/

Re: [sqlite] Re: [Bulk] Re: [sqlite] [OT] SQL: limit a query by sum(val)?

2005-02-12 Thread Ulrik Petersen
as SQLite3. Otherwise, why don't you supply a .bat file that does the job? It can, of course, be run from within your program. HTH Ulrik Petersen -- Ulrik Petersen, Denmark

Re: [sqlite] SQLite3 and version 2.1 DBs

2005-02-08 Thread Ulrik Petersen
other goodies in the contrib section: http://www.sqlite.org/contrib HTH Ulrik Petersen -- Ulrik Petersen, Denmark

Re: [sqlite] Do _ErrMsg strings have to be freed?

2005-02-08 Thread Ulrik Petersen
List, sorry about that. I misread Nathan's post, and so came up with a bogus answer. Never try to answer technical questions when it's 03:45am for you ;-). Ulrik Petersen Randall Fox wrote: On Mon, 7 Feb 2005 18:14:42 -0800, you wrote: Does this var pMsg: PChar; .. pMsg

Re: [sqlite] Do _ErrMsg strings have to be freed?

2005-02-07 Thread Ulrik Petersen
of this forum is also unexpectedly pleasant most of the time. Kudos to everyone on this list who answers questions with kindness and insight. HTH Ulrik Petersen -- Ulrik Petersen, Denmark MA, B.Sc

Re: [sqlite] Make error installing sqlite3.0.8 on Solaris 9 (Sparc)

2005-02-02 Thread Ulrik Petersen
directory, or did you untar it over an existing directory? The latter might give you the behavior you experienced. Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] debugging a locking problem

2005-01-30 Thread Ulrik Petersen
Jason Jobe wrote: I did find some where I wasn't doing that but I think I got them all. Sometimes I use sqlite3_exec; other times, when I need to get the rows I use sqlite3_step (with the finalize). Then perhaps you are calling sqlite3_exec in between an sqlite3_step and its corresponding

Re: [sqlite] compiling the demo example

2005-01-30 Thread Ulrik Petersen
Alex Bartonek wrote: LOL.. ok I'm getting farther... the problem was in my makefile.. I can actually create a executable (SuSE 9.2) but when I run it I get: ~/workspace/test> ./a.out ./a.out: error while loading shared libraries: libsqlite3.so.0: cannot open shared object file: No such file or

Re: [sqlite] Sqlite with MFC SDI

2005-01-30 Thread Ulrik Petersen
frameworks are very similar. Except that WxWidgets is richer, clearner, and more modern. And cross-platform, too. HTH Ulrik P. -- Ulrik Petersen, Denmark

Re: [sqlite] Memory usage (3.1.0 alpha)

2005-01-30 Thread Ulrik Petersen
Hi Clive, To: sqlite-users@sqlite.org cc:(bcc: clive/Emultek) Subject: Re: [sqlite] Memory usage (3.1.0 alpha) Hi Clive, [EMAIL PROTECTED] wrote: I am benchmarking sqlite3 as a potential database for Windows and embedded applications. I am running the following code in a Rapid

Re: [sqlite] Memory usage (3.1.0 alpha)

2005-01-29 Thread Ulrik Petersen
Hi Clive, [EMAIL PROTECTED] wrote: I am benchmarking sqlite3 as a potential database for Windows and embedded applications. I am running the following code in a Rapid development environment that calls the equivalent sqlite3 functions in a Window's DLL that I built from the release . I am seeing

Re: [sqlite] ATTACH in memory

2005-01-26 Thread Ulrik Petersen
Hi Ricard, Ricard Pillosu wrote: Hi all, Just reading the sqlite-user mailing list I found here http://www.mail-archive.com/sqlite-users@sqlite.org/msg01521.html that there is a way to dump from memory databases to file databases. What we are trying in our database is to ATTACH a read-only

Re: [sqlite] synchronizing databases across LAN

2005-01-24 Thread Ulrik Petersen
the job easier). The maximum number of nodes (n) would not exceed 15. I am not sure it runs in Windows, but this might be worth looking at: http://raa.ruby-lang.org/project/rq/ HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Ulrik Petersen
Hi Daniele, Ulrik Petersen wrote: Only in sqlite-3.0.8-nullimport/: config.h Only in sqlite-3.0.8-nullimport/: config.log Only in sqlite-3.0.8-nullimport/: config.status Only in sqlite-3.0.8: doc Only in sqlite-3.0.8-nullimport/: libtool Only in sqlite-3.0.8-nullimport/: Makefile Only in sqlite

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Ulrik Petersen
Hi Daniele, Daniele Nicolucci (Jollino) wrote: Il giorno 22 gen 2005, alle 18:16, Ulrik Petersen ha scritto: As you can see, sqlite3_bind_text is used for all columns. You would have to write some ad-hoc code inside the loop that checked whether the value in azCol[i] was "null"

Re: [sqlite] How to .import NULL values?

2005-01-22 Thread Ulrik Petersen
used for all columns. You would have to write some ad-hoc code inside the loop that checked whether the value in azCol[i] was "null" or "NULL", and then used sqlite3_bind_null if that was the case, instead of sqlite3_bind_text. Search for the string "import" in the s

Re: AW: [sqlite] sqlite3_column_tablename

2005-01-22 Thread Ulrik Petersen
ng clarify what you want. I don't know whether you can do what you want already, or whether it's a real feature-request. Regards, Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] sqlite3_column_tablename

2005-01-22 Thread Ulrik Petersen
r any given column name, show me the table from which it came": This is not a one-to-one mapping, but a one-to-many mapping. In what circumstances do you know the column name but not the table name? Please elaborate. Regards, Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Version 3.1.0 API suggestion: sqlite3_commit()

2005-01-21 Thread Ulrik Petersen
et() routine resets a prepared SQL statement so that it can be executed again." HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc.

Re: [sqlite] expression syntax

2005-01-18 Thread Ulrik Petersen
you want the sqlite3_bind_int API. Look it up on the www.sqlite.org website. HTH Ulrik -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark Homepage: http://ulrikp.org

Re: [sqlite] Newbie help

2005-01-18 Thread Ulrik Petersen
/www.parinya.ca/ HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark Homepage: http://ulrikp.org

Re: [sqlite] LOCK problem in 2.8

2005-01-17 Thread Ulrik Petersen
two different sqlite structures. HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Syntax problem in where clause of Select statement

2005-01-17 Thread Ulrik Petersen
Hi Anirban, Anirban Sarkar wrote: Hi all, I have a variable xyz with the value 100. I want to write a sql statement in sqlite where the variable xyz should be in the 'where' clause. For eg: select * from 'tablename' where 'fieldname' = $xyz What language are you using? You might want to use the

Re: [sqlite] regd. sqlite 3

2005-01-12 Thread Ulrik Petersen
ready been finalized or on one that had previously returned SQLITE_ERROR or SQLITE_DONE. Or it could be the case the the same database connection is being used simultaneously by two or more threads." Is any of this true? HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] regd. sqlite 3

2005-01-12 Thread Ulrik Petersen
k function" API? Or the "sqlite3_prepare/sqlite3_step/sqlite3_finalize" API? The API is described here: http://www.sqlite.org/capi3.html HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] speed

2005-01-10 Thread Ulrik Petersen
the other big databases. You should check that indices are used (using the EXPLAIN statement) whenever possible. HTH Ulrik P. -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] URGENT : library routine called out of sequence

2005-01-09 Thread Ulrik Petersen
the error "library routine called out of sequence" or a corrupted database. This could well be the problem. Please see this FAQ: http://www.sqlite.org/faq.html#q8 Cheers, Ulrik P. -- Ulrik Petersen, Denmark

Re: [sqlite] Sqlite installation problems

2004-12-28 Thread Ulrik Petersen
ilar. HTH Ulrik -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark Homepage: http://ulrikp.org

Re: [sqlite] VACUUM function problem

2004-12-27 Thread Ulrik Petersen
D.W. wrote: Thanks for your reply. I have just checked the version. It's 2.8.15. There's no active transaction. Do you have another idea? How do you verify that nothing happens? Ulrik -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] VACUUM function problem

2004-12-27 Thread Ulrik Petersen
action. This command has no effect on an in-memory database." HTH Ulrik -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark

Re: [sqlite] Sequences In SQLite

2004-12-08 Thread Ulrik Petersen
> Is there anything like serial sequences in SQLite? What I want to do is > have a primary interger key that auto-increments as records are added to > a table. http://www.sqlite.org/faq.html#q1 http://www.catb.org/~esr/faqs/smart-questions.html Ulrik P.

Re: [sqlite] commas in columns and temporary tables

2004-12-04 Thread Ulrik Petersen
otes" if you want to escape commas inside of it. You say that the DLL uses regular expressions to comma-delimit the table. Depending on how the DLL does it, it is maybe possible to specify a language in regular expressions that takes care of not splitting on a comma if that comma is embedded in double quotes. HTH Ulrik -- Ulrik Petersen, Denmark

Re: [sqlite] commas in columns and temporary tables

2004-12-02 Thread Ulrik Petersen
your escape sequences. > As for my question about temporary tables: How long does SQLite keep the > temporary tables around? Only for 1 query? Or until the table hasn't > been modified for X amount of time? Or something I haven't thought of > yet... Can't answer this one, sorry. Ulrik -- Ulrik Petersen, Denmark

Re: [sqlite] Help compiling sqlite2

2004-12-01 Thread Ulrik Petersen
t for why. > And in Linux, have I to manually add -lpthread to the Makefile? I don't know about this, but it would probably be in TARGET_CFLAGS if you need to add it. That would add it to the TCC Makefile variable, which in turn would add it to LTLINK, which is used when linking the libraries and

Re: [sqlite] Why does my query take so long

2004-12-01 Thread Ulrik Petersen
ot; version, especially if you put an index on the column. If you look at the VM code with EXPLAIN, you will see why. > > Lloydie-t Ulrik P. -- Ulrik Petersen, Denmark

Re: [sqlite] [ANN] SQLcrypt 1.0

2004-11-21 Thread Ulrik Petersen
Dennis Volodomanov wrote: Hi all, Is anyone using the mentioned library? Is it stable and fast? Are there any other similar products for SQLite v3? Can't answer the first question, but Dr. Hipp, the author and designer of SQLite, offers a version of SQLite (both 2.8 and 3.0) that does

Re: [sqlite] upgrade?

2004-11-20 Thread Ulrik Petersen
Hi Michael, Michael Hunley wrote: Hi, I am currently using SQLite v 2.8.13 for a commercial product for Palm Handhelds. I am noticing some performance issues; most notably when I do a database validate() to verify my integrity at app open and close. I see that version 3.0.8 has some code

Re: [sqlite] sqlite project--working with table structure

2004-11-20 Thread Ulrik Petersen
, you see, if I am right, and you don't have an autoincrement field to ORDER BY, then your columns may be inserted out of order, and thus retrieved out of order, and so your table will have a different column order when you inserted the rows representing the columns. HTH Cheers, Ulrik -- Ulrik Petersen, Denmark

Re: [sqlite] Speeding up quer

2004-11-16 Thread Ulrik Petersen
the columns that seem to be boolean values to INTEGER and store "0" and "1" instead of "Yes" and "No". Because of the way SQlite 2 stores these things (namely as strings), this will most likely save you some space. Ulrik -- Ulrik Petersen, Denmark Homepage: <http://www.hum.aau.dk/~ulrikp/>

Re: [sqlite] Speeding up quer

2004-11-16 Thread Ulrik Petersen
Hi there, > I am have a problem with a query which may well have over 200,000 records. > I > have building a website using PHP and PHP is timing out after 30secs due > the > the size of the call_data table (I think). Is there anyway I can improve > the > following query so that it is faster. I

Re: [sqlite] SQLite V2 CAPI Reference

2004-10-29 Thread Ulrik Petersen
with much more experience of SQLite would help me overcome my > problem > > Thank you in advance. http://www.sqlite.org/c_interface.html Ulrik -- Ulrik Petersen, Denmark

Re: [sqlite] Sample code

2004-10-29 Thread Ulrik Petersen
got that the online version does not use SQLite 3. Email me off-list if you want a copy of the code that uses SQLite 3. Ulrik -- Ulrik Petersen, Denmark Homepage: <http://www.hum.aau.dk/~ulrikp/>

Re: [sqlite] Sample code

2004-10-29 Thread Ulrik Petersen
dros project, which is under the GPL: http://emdros.org/preview/index.php?dir==emdros-1.2.0.pre79.tar.gz You'll want to concentrate on EMdF/sqliteconn.cpp and EMdF/conn.cpp (the header files are include/sqliteconn.h and include/conn.h) HTH Ulrik P. -- Ulrik Petersen, Denmark

Re: [sqlite] Index Usage

2004-10-28 Thread Ulrik Petersen
, and then do BETWEEN 10 AND 14 I guess I should have made that clear. Cheers, Ulrik -Original Message- From: Ulrik Petersen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 10:28 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Index Usage William, William Hachfeld wrote: Hi, Have

Re: [sqlite] Index Usage

2004-10-28 Thread Ulrik Petersen
ing the double index, and only indexing "begin", since for these queries, the "end" part is redundant (i.e., not used) in the index. Cheers, Ulrik -- Ulrik Petersen, MA, B.Sc. Emdros -- the text database engine for analyzed or annotated text http://emdros.org/

Re: [sqlite] Page sizes other than 1024 bytes

2004-10-26 Thread Ulrik Petersen
rformance increase with larger page sizes (I've verified this empirically, too, for 4096 and 16384). However, if others have experienced the same as I have, it might be good to add something to the comment in pager.h about 4096 being a better page size on Win9X. HTH Ulrik Petersen -- Ulrik

Re: [sqlite] Degradation of performance in SQLite 3?

2004-10-05 Thread Ulrik Petersen
Dr. Hipp, > Ulrik Petersen wrote: >> >> has anyone experienced less performance with SQLite 3.0.7 over 2.8.13 on >> the same data? That is what I am experiencing. I'd appreciate help in >> figuring out why and perhaps what I can do about it. >> >

[sqlite] Degradation of performance in SQLite 3?

2004-10-05 Thread Ulrik Petersen
table, namely the word_gut table). I use the sqlite3_prepare/step interface, with sqlite3_column_XXX calls to get the data. Has anyone experienced anything similar? Can anyone suggest ways I could improve the above schema and/or indexes? Thanks in advance. Ulrik Petersen PS: Kudos to Dr. Hipp

[sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115

2004-05-22 Thread Ulrik Petersen
Hello all, Michael Roth wrote: > and I wrote: - Microsoft Visual C++ Toolkit 2003. Microsoft recently released their compiler and toolchain for free download: http://msdn.microsoft.com/visualc/vctoolkit2003/ Check the license! It is not really fair! Don't use this toolchain. Oops, I hadn't read

[sqlite] Newbie --question about multiple PCs accessing sqlite

2004-05-20 Thread Ulrik Petersen
Hello Shamil, [EMAIL PROTECTED] wrote: I do not have a C++ compiler If you are using Linux or some other Unix-like environment, you can get g++ (i.e., gcc) for free. If you are using Windows, there are several options for getting one (also for free): - Mingw or Cygwin (google for each) -