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
-
.
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
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
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
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
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
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
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
I think Noël may be talking about Apache Derby, formerly IBM Cloudscape:
http://db.apache.org/derby/
Regards,
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:
. 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
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
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
**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
,
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
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.
://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/
. {
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
; );
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
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
':memory:' AS mynameforthememorydatabase;
HTH
Ulrik P.
--
Ulrik Petersen, PhD student, MA, B.Sc.
Aalborg University, Denmark
http://ulrikp.org/
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
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
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
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
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
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
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
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
installing and reinstalling dev-c++.
HTH
Ulrik Petersen
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
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
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
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
reported to be a bad idea for keeping SQLite databases.
Just a thought.
Ulrik Petersen
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
nload page:
http://www.sqlite.org/download.html
HTH
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
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
Witold Czarnecki wrote:
sqlite> select typeof(round(1));
text
Is it bug?
What version?
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
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.
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
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/
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
other goodies in the contrib section:
http://www.sqlite.org/contrib
HTH
Ulrik Petersen
--
Ulrik Petersen, Denmark
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
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
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
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
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
frameworks are very similar. Except that WxWidgets is richer,
clearner, and more modern. And cross-platform, too.
HTH
Ulrik P.
--
Ulrik Petersen, Denmark
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
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
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
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
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
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"
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
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
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
et() routine resets a prepared SQL statement so
that it can be executed again."
HTH
Ulrik P.
--
Ulrik Petersen, MA, B.Sc.
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
/www.parinya.ca/
HTH
Ulrik P.
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
Homepage: http://ulrikp.org
two
different sqlite structures.
HTH
Ulrik P.
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
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
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
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
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
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
ilar.
HTH
Ulrik
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
Homepage: http://ulrikp.org
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
action. This command
has no effect on an in-memory database."
HTH
Ulrik
--
Ulrik Petersen, MA, B.Sc.
University of Aalborg, Denmark
> 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.
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
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
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
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
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
, 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
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/>
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
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
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/>
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
, 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
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/
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
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.
>>
>
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
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
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)
-
90 matches
Mail list logo