[sqlite] Network access to SQLite

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

Re: [sqlite] Concurrency, MVCC

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] anyone seen this SQLite related product?

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

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

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

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] Effectiveness of PRAGMA integrity_check;

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] XML translation inquiry

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] XML translation inquiry

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

[sqlite] XML translation inquiry

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] Effectiveness of PRAGMA integrity_check;

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

Re: [sqlite] Effectiveness of PRAGMA integrity_check;

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] TCL and SQLITE

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] Effectiveness of PRAGMA integrity_check;

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] Concurrency, MVCC

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] TCL and SQLITE

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

[sqlite] TCL and SQLITE

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] Concurrency, MVCC

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

Re: [sqlite] Adding SQL commands

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] Adding SQL commands

<[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] Effectiveness of PRAGMA integrity_check;

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] Effectiveness of PRAGMA integrity_check;

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] Concurrency, MVCC

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] FreeBSD and SQLite

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] Effectiveness of PRAGMA integrity_check;

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