Re: [sqlite] The term "flat-file" as applied to sqlite

2006-09-26 Thread Nathaniel Smith
On Tue, Sep 26, 2006 at 08:05:34PM +0200, [EMAIL PROTECTED] wrote: > Maybe a structured Textfile is a flatfile, if > possibly readable as a tableview. But it is so > only in humans view and humans understanding. Well, and English is a language used by humans to convey their understandings to

Re: [sqlite] UNICODE Support

2006-08-05 Thread Nathaniel Smith
On Fri, Aug 04, 2006 at 10:02:58PM -0700, Cory Nelson wrote: > On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote: > >On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote: > > > >> But, since you brought it up - I have no expectations of SQLite > >> integrating a full Unicode locale library, however

Re: [sqlite] Reading the same table from two threads

2006-07-26 Thread Nathaniel Smith
On Wed, Jul 26, 2006 at 02:32:58PM +, [EMAIL PROTECTED] wrote: > It has been suggested that I add a mutex to every SQLite > database connection. This would cause access to a database > connection to automatically serialize even when two or more > threads try to use that connection at once,

Re: [sqlite] unsuscribe

2006-05-31 Thread Nathaniel Smith
On Wed, May 31, 2006 at 01:42:48PM -0500, Bob Dankert wrote: > Especially considering they are all spelling the word wrong with the > same mis-spelling. Wild guess: the list actually receives a lot more of these messages than you see, but mailman has the ability to filter out messages that were

[sqlite] checking 'PRAGMA integrity_check'

2006-05-10 Thread Nathaniel Smith
Background: Monotone has a "db check" command, that goes through and verifies that everything in the database is valid and accessible. While our existing tests basically hit every row of every table, so most things should be caught, we didn't previously call sqlite's "PRAGMA integrity_check". In

[sqlite] Re: semicolon in string (was Re: [sqlite] File locking additions)

2006-03-09 Thread Nathaniel Smith
On Thu, Mar 09, 2006 at 10:00:50AM +0200, Roger wrote: > Hello guys. > > I have a small problem.I am trying to write some sql queries. Whenever i > put a semicolon, sqlite returns an error immediately.for instance if i > select as follows > > Select Name||" "||Surname||" ; "||Address as "Details

Re: [sqlite] Running App state in db?

2006-03-01 Thread Nathaniel Smith
On Thu, Mar 02, 2006 at 12:18:21AM +0100, Elrond wrote: > I intended to only put the locks as such in the db. > When it comes to a new lock, I'll select all relevant old > locks, that might conflict, handle the conflict check in > app logic and finally insert a new lock record. (all inside > a

Re: [sqlite] Strange execution times

2006-02-21 Thread Nathaniel Smith
On Wed, Feb 22, 2006 at 01:13:19AM +0200, Ulrich Schöbel wrote: > I tried the 10 reps expecting even more. Then came the surprise: > only 67 microsecs. > > My first feeling was, something like a busy disk or so came > in just when I tried the 100 reps. But the results were reproducible, >

[sqlite] Re: [Monotone-devel] [sqlite] disk locality (and delta storage)

2006-02-11 Thread Nathaniel Smith
On Fri, Feb 10, 2006 at 07:06:27PM -0500, [EMAIL PROTECTED] wrote: > Daniel Carosone <[EMAIL PROTECTED]> wrote: > > Wiki pages doesn't seem so hard, they're pretty much text documents > > stored in a VCS anyway. > > There are some complications. Each wiki page acts if it where > its own

[sqlite] Re: [Monotone-devel] Re: [sqlite] disk locality (and delta storage)

2006-02-11 Thread Nathaniel Smith
Thanks for this detailed email! I've been a bit crazy with codecon the last week, and most of what I have to say is "hmm, lots to think about here", so, yeah :-). I did want to reply to your VCS system comments, though: On Tue, Feb 07, 2006 at 10:17:54AM -0500, [EMAIL PROTECTED] wrote: > What

Re: [sqlite] Tracing Statements...

2006-02-11 Thread Nathaniel Smith
On Sat, Feb 11, 2006 at 03:37:11AM -0500, Tim Murison wrote: > I would like to be able to generate a log of all sql statements executed > by my program. > > Unfortunately all of my queries use parameters, and I would like to get > the full query (all parameters replaced with their sqlite3_bind_*

Re: [sqlite] disk locality

2006-02-07 Thread Nathaniel Smith
On Wed, Feb 01, 2006 at 08:56:37PM -0800, Joe Wilson wrote: > Another question... Does Monotone still Base64 encode all its data before > putting it into blobs? > If so, using raw binary SQLite blobs would likely give Monotone a 33% speedup > and smaller > database. It does, actually, but

Re: [sqlite] disk locality (and delta storage)

2006-02-07 Thread Nathaniel Smith
Thanks for the helpful reply. Sorry I've taken so long to get back to this; I've had some hardware trouble and am only catching up on email now... On Wed, Feb 01, 2006 at 07:27:06AM -0500, [EMAIL PROTECTED] wrote: > Nathaniel Smith <[EMAIL PROTECTED]> wrote: > > I was wondering if

Re: [sqlite] querying hierarchy

2006-01-30 Thread Nathaniel Smith
On Sun, Jan 29, 2006 at 08:30:57AM +0100, Marten Feldtmann wrote: > Databases like DB2, MaxDB or Oracle offer you these recursive > SQL statements. The main winning is, that you execute ONE query > and retrieves all rows belonging to a sub tree, which is MUCH > faster, that to execute multiple