Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread Liz Steel
Hello again, I'm not sure if you received my last email, so I'm sending it to the list in the hope that someone can help me. You say that I shouldn't get a corrupt database when I pull the power, but I am consistently getting this. I am using SQLite version 2.8.9 using the C++ interface

RE: [sqlite] FreeBSD and SQLite

2004-04-15 Thread Jaroslaw Nozderko
Hi Al, could you please provide more information ? (FreeBSD version, SQLite version, what are the problems, etc.). First of all, is it FreeBSD 4.x or 5.x ? Usually 4.x is used for production purposes, I didn't try it. However, I don't remember serious problems with several recent versions of

Re: [sqlite] Concurrency, MVCC

2004-04-15 Thread Mark D. Anderson
On Wed, 14 Apr 2004 08:13:39 -0400, "D. Richard Hipp" <[EMAIL PROTECTED]> said: >* Support for atomic commits of multi-database transactions, > which gives you a limited kind of table-level locking, > assuming you are willing to put each table in a separate > database. and

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread D. Richard Hipp
Liz Steel wrote: Hello again, I'm not sure if you received my last email, so I'm sending it to the list in the hope that someone can help me. You say that I shouldn't get a corrupt database when I pull the power, but I am consistently getting this. I am using SQLite version 2.8.9 using the

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread D. Richard Hipp
D. Richard Hipp wrote: (1) Change to version 2.8.13. (2) Describe in detail what kind of changes you are making to the database as you pull the power. (3) Send me one of your corrupt databases for analysis. (4) Begin with a database that passes a "PRAGMA integrity_check". Do whatever it

Re: [sqlite] Adding SQL commands

2004-04-15 Thread Bertrand Mansion
<[EMAIL PROTECTED]> wrote : > I have a similar problem with character encoding in the current SQLite > versions, by the way. I store UTF-8 encoded data from a Python program > using PySQLite using a prepackaged SQLite, but since the prepackaged > libsqlite is built without SQLITE_UTF8, I can't

Re: [sqlite] Adding SQL commands

2004-04-15 Thread Joel Rosdahl
Bertrand Mansion <[EMAIL PROTECTED]> writes: > <[EMAIL PROTECTED]> wrote : > >> I have a similar problem with character encoding in the current >> SQLite versions, by the way. I store UTF-8 encoded data from a >> Python program using PySQLite using a prepackaged SQLite, but since >> the

Re: [sqlite] Concurrency, MVCC

2004-04-15 Thread Christian Smith
On Wed, 14 Apr 2004, Doug Currie wrote: >Wednesday, April 14, 2004, 1:16:54 AM, Andrew Piskorski wrote: > >> How could this be extended to support table locking and PostgreSQL's >> default "read committed" isolation level? Would the smallest locking >> granularity possible in Currie's design be

[sqlite] TCL and SQLITE

2004-04-15 Thread shamil_daghestani
I'm just getting around to using SQLITE to see how it performs. Therefore, I'm just a beginner. I have a couple of questions about it: I downloaded the TCL binding and did pkg_mkIndex to create the pkgIndex.tcl file. Then I did "package require sqlite", I got version "2.0". However, I see from

Re: [sqlite] TCL and SQLITE

2004-04-15 Thread Christian Smith
On Thu, 15 Apr 2004 [EMAIL PROTECTED] wrote: >I'm just getting around to using SQLITE to see how it performs. Therefore, >I'm just a beginner. > >I have a couple of questions about it: I downloaded the TCL binding and did >pkg_mkIndex to create the pkgIndex.tcl file. Then I did "package require

Re: [sqlite] Concurrency, MVCC

2004-04-15 Thread Andrew Piskorski
On Thu, Apr 15, 2004 at 02:16:01PM +0100, Christian Smith wrote: > Right tool for the job. Multiple writers has client/server database > written all over it. KISS. No, not true, at least not when the multiple writers are all threads within one single process, which appears to be the common case

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread Greg Miller
Liz Steel wrote: You say that I shouldn't get a corrupt database when I pull the power, but I am consistently getting this. I am using SQLite version 2.8.9 using the C++ interface running on Windows XP Home. Is there anything I can do to stop this happening? If you have an IDE hard drive

Re: [sqlite] TCL and SQLITE

2004-04-15 Thread shamil_daghestani
Thanks Christian. I figured something just wasn't right... Total processing time dropped from 207 to just 0.7 seconds SD "Christian Smith"

Re: [sqlite] Concurrency, MVCC

2004-04-15 Thread Christian Smith
On Thu, 15 Apr 2004, Andrew Piskorski wrote: >On Thu, Apr 15, 2004 at 02:16:01PM +0100, Christian Smith wrote: >> Right tool for the job. Multiple writers has client/server database >> written all over it. KISS. > >No, not true, at least not when the multiple writers are all threads >within one

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread Andrew Piskorski
On Thu, Apr 15, 2004 at 08:33:14AM -0500, Greg Miller wrote: > support that. The FreeBSD folks tried to solve this by turning off write > caching by default. Unfortunately, this hurt performance so much they > had to turn it back on and just recommend SCSI drives for important data. Why, do

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread Greg Miller
Andrew Piskorski wrote: On Thu, Apr 15, 2004 at 08:33:14AM -0500, Greg Miller wrote: support that. The FreeBSD folks tried to solve this by turning off write caching by default. Unfortunately, this hurt performance so much they had to turn it back on and just recommend SCSI drives for important

[sqlite] XML translation inquiry

2004-04-15 Thread rich coco
this is a bit off topic i suppose, but here goes... does anyone know of an open-source translation toolkit that ultimately would generate code to map XML to/from SQL? Or maybe i am not phrasing the question properly. What I am looking for is a translation layer between the use of relational

Re: [sqlite] XML translation inquiry

2004-04-15 Thread Andrew Piskorski
On Thu, Apr 15, 2004 at 01:47:01PM -0400, rich coco wrote: > the goal would be to abstract out of the application the entire > DB schema and allow the application to work exclusively with XML - > and the generated methods - wrt not only data representation and > transport but data storage and

Re: [sqlite] XML translation inquiry

2004-04-15 Thread rich coco
please tell me more...as in why it's a bad idea. performance? are the in-memory translations really that cpu intensive? what if the data sets are never very large? thanks, - rich Andrew Piskorski wrote: On Thu, Apr 15, 2004 at 01:47:01PM -0400, rich coco wrote: the goal would be to abstract

Re: [sqlite] XML translation inquiry

2004-04-15 Thread Andrew Piskorski
On Thu, Apr 15, 2004 at 02:37:13PM -0400, rich coco wrote: > >>the goal would be to abstract out of the application the entire > >>DB schema and allow the application to work exclusively with XML - > >>and the generated methods - wrt not only data representation and > >>transport but data storage

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread D. Richard Hipp
Greg Miller wrote: Liz Steel wrote: You say that I shouldn't get a corrupt database when I pull the power, but I am consistently getting this. I am using SQLite version 2.8.9 using the C++ interface running on Windows XP Home. Is there anything I can do to stop this happening? If you have an

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-15 Thread Greg Miller
D. Richard Hipp wrote: From what I am told, most IDE drives do signal the OS when the data reaches the platter. I'm also told that the Linux fsync() call does not return until it gets that signal. The Windows FlushFileBuffers(), on the other hand, does not wait for the data to get to platter.

Re: [sqlite] Concurrency, MVCC

2004-04-15 Thread Doug Currie
Thursday, April 15, 2004, 9:16:01 AM, Christian Smith wrote: > On Wed, 14 Apr 2004, Doug Currie wrote: >>One way to get table level locking without a great deal of pain is to >>integrate the shadow paging ideas with BTree management. Rather than >>using page tables for the shadow pages, use the

[sqlite] anyone seen this SQLite related product?

2004-04-15 Thread Darren Duncan
I don't know if the creator is on this list, but just now I saw an article on the MacCentral website about a SQLite manager program written with the RealBasic RAD tool. http://www.sqlabs.net/ Thought I'd mention it. -- Darren Duncan

Re: [sqlite] Concurrency, MVCC

2004-04-15 Thread Mark D. Anderson
On Thu, 15 Apr 2004 20:16:32 -0400, "Doug Currie" <[EMAIL PROTECTED]> said: > I used this design in a proprietary database in the late 1980s. The > only reason I didn't consider modifying SQLite this way up until now > is that I was anticipating BTree changes for 3.0, so I confined my > efforts

[sqlite] Network access to SQLite

2004-04-15 Thread Aaron Patterson
I'm working on a project, and I thought it would be of some interest to people in this group. I've written an Apache module used for giving access to an SQLite database over a network. I have also written a perl DBD driver so that the SQLite server can be accessed in perl. The homepage is