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

[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

[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

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

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

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. . .

[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

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

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

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

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