Re: [sqlite] SQLite openning a database

2005-01-13 Thread John Richard Moser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 D. Richard Hipp wrote: > Christian Smith wrote: > >>> /tmp/ is rwx by anyone >>> root stats /tmp/tmpdb.root.1072 (pid==1072) >>> Nonexistant >>> User ln -s /etc/fstab /tmp/tmpdb.root.1072 >>> root creates /tmp/tmpdb.root.1072 >>> fstab erased. >>> >

Re: [sqlite] sql tables. . .?

2005-01-13 Thread John Richard Moser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks. I was considering creating a table for each package identified as category/grp/class/package/version and storing dependencies and files in there; but I decided not to cerate thousands of tables :) I'm still examining the idea, it may be usefu

[sqlite] regression test failure with 2.8.15

2005-01-13 Thread Jolan Luff
hi, i was updating sqlite 2.8.14 -> 2.8.15 and now I get this single regression failure: tcl-2.2... Error: can't read "result(*)": variable isn't array Is this an actual problem or is this a bug in the test itself?

Re: [sqlite] Re: How To Select Mulit Threaded DLL in Visual Studi]

2005-01-13 Thread Rolf Schaeuble
Thanks, but you must have misunderstood my post. I know how to configure projects under both Visual Studio 6 and 2003 (I've been working with VS for quite a few years now). The reason why I asked the OP to exactly specify which option he means is that I found his mail not very precise. To make su

[sqlite] Re: How To Select Mulit Threaded DLL in Visual Studi

2005-01-13 Thread Steve Frierdich
Steve Frierdich wrote: Rolf Attached is a Power Point presentation that shows how to select a Multi Threaded DLL or a Debug Multi Threaded DLL for the user run-time library for a Visaul Studio Project. In short below are the steps to take. In the Power Point are visual representations of the

RE: [sqlite] Good db XML datastructure?

2005-01-13 Thread Ned Batchelder
I touched on a similar topic in my blog: http://www.nedbatchelder.com/blog/200411.html#e20041117T084310 The comments there got distracted onto the question of how to use XML data in a relational database, and pointed off to http://www.sqlxml.org/ and http://www.sqlx.org/ There was a suggestion to

Re: [sqlite] OT: Compiling under Windows

2005-01-13 Thread Rolf Schaeuble
I was guessing that the OP means the option for runtime library. But the question wasn't very precise. If it's really about the choice of runtime library, then you don't have to use "multithreaded dll". You can any version of the runtime. The only thing you should do is to select the same versio

Re: [sqlite] OT: Compiling under Windows

2005-01-13 Thread Keith Herold
In VS 6, we generally find that you need to compile everything with Multithreaded-dll, even the libraries, or you get very strange error messages as the compiler tries to link with conflicting run-time libraries. --Keith On Thu, 13 Jan 2005 20:54:13 +0100, Rolf Schaeuble <[EMAIL PROTECTED]> wrote

[sqlite] Good db XML datastructure?

2005-01-13 Thread Keith Herold
Hi all; I have been trying to find a good XML schema for describing databases, so that I can, among other things, produce documentation for my database format. Is there a good (free) one already out there, that is genarally accepted/used? I'm not looking to export data, just the description of th

Re: [sqlite] OT: Compiling under Windows

2005-01-13 Thread Rolf Schaeuble
What do you mean with "Multithreaded" or "Mulithreaded-DLL" project? Can you explain exactly where you can select between these two options, and whether you are using Visual Studio 6 or 2002/2003? Rolf Schäuble Michael Knigge wrote: Hello, this question is slightly OT here but. I want to com

Re: [sqlite] How efficiently will SQLite work as a queue?

2005-01-13 Thread D. Richard Hipp
Andrew Shakinovsky wrote: I am looking at the PRAGMA auto_vacuum command. How efficient is this (as far as time is concerned. I am not concerned about space)? Autovacuum makes the database a little larger (by a few percent) and it makes DELETE operations a little slower (by about 20%, IIRC). More d

Re: [sqlite] sql tables. . .?

2005-01-13 Thread Christian Smith
On Sat, 8 Jan 2005, John Richard Moser wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >What can be in an SQL table? > >Can tables contain tables? I want to be able to search for a given >package and find what files are in it, search for a file and find what >packages supply it. . . what

[sqlite] How efficiently will SQLite work as a queue?

2005-01-13 Thread Andrew Shakinovsky
I am contemplating using SQLite as a message queueing mechanism, and was wondering whether this would be efficient. In particular, I will be adding new records to a table, while another process removes those records when it is ready to handle that "message". My question relates to possible fragmen

Re: [sqlite] SQLite openning a database

2005-01-13 Thread D. Richard Hipp
Christian Smith wrote: /tmp/ is rwx by anyone root stats /tmp/tmpdb.root.1072 (pid==1072) Nonexistant User ln -s /etc/fstab /tmp/tmpdb.root.1072 root creates /tmp/tmpdb.root.1072 fstab erased. SQLite wouldn't work like that. It would read the file (which is actually /etc/fstab) and determine that

Re: [sqlite] SQLite openning a database

2005-01-13 Thread Christian Smith
On Wed, 12 Jan 2005, John Richard Moser wrote: > >Christian Smith wrote: >> On Tue, 11 Jan 2005, John Richard Moser wrote: >> >>>http://rafb.net/paste/results/jRFmZD25.html >>> >>>While most of this isn't of general interest, I'd like to point out that >>>I create the database by opening it with o

Re: [sqlite] multiple thread concurrency problem with exclusive transaction locks

2005-01-13 Thread Eli Burke
2. disable asserts. I don't know how this is done in C, but I assume that in a release build, asserts are off. Disable asserts() using -DNDEBUG=1. This more than doubles the speed of SQLite. Asserts() are turned off in release builds. We build sqlite3.08 as follows: ./configure --disable-shared

Re: [sqlite] multiple thread concurrency problem with exclusive transaction locks

2005-01-13 Thread D. Richard Hipp
mike cariotoglou wrote: 2. disable asserts. I don't know how this is done in C, but I assume that in a release build, asserts are off. Disable asserts() using -DNDEBUG=1. This more than doubles the speed of SQLite. Asserts() are turned off in release builds. -- D. Richard Hipp -- [EMAIL PROTECTED

Re: Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread [EMAIL PROTECTED]
I use eMbedded Visual C++ 4.0 with de 3.0.8 Wrapper created by Rob Groves that you will find in http://www.codeproject.com/database/CppSQLite.asp and with de WinCE port http://sqlite-wince.sourceforge.net/ created by Nuno Lucas. You will find a manual steb-by-step of install this WinCE port in my

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread Markus Oliver Junginger
Miquel Matas wrote: Please, what kind of application developent do you use me to develop in pocketpc and sqlite 3.0?? Are you asking about the IDE or the application itself? IDE: Embedded Visual Studio 4 and Visual Studio 2003 (it runs on pdas and on desktops). application: it's actually a platf

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread Miquel Matas
Markus Oliver Junginger wrote: D. Richard Hipp wrote: Not true. V2.8 stores the first 240 or so bytes of data for each row on a single disk page and the rest on overflow pages. ... Thanks for the clarification. So, it seems V3.x is the right choice for embedded software, too, and we will migrat

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread Markus Oliver Junginger
D. Richard Hipp wrote: Not true. V2.8 stores the first 240 or so bytes of data for each row on a single disk page and the rest on overflow pages. ... Thanks for the clarification. So, it seems V3.x is the right choice for embedded software, too, and we will migrate to V3.x in the long term. Reg