[sqlite] Creating Indexes

2008-08-05 Thread Jeffrey Becker
I have a table 'SiteMap' defined as : Create Table SiteMap ( NodeID blob not null PRIMARY KEY, Title text NOT NULL UNIQUE, Url text NOT NULL ); I'd like to index on the node's parent value as defined by the expression ancestor(NodeID,1). 'ancestor' being a user defined

Re: [sqlite] Creating Indexes

2008-08-06 Thread Jeffrey Becker
On Wed, Aug 6, 2008 at 4:10 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > On Tue, 05 Aug 2008 17:22:05 -0500, you wrote: > >>Jeffrey Becker wrote: >>> I have a table 'SiteMap' defined as : >>> >>> Create Table SiteMap >>> ( >>>

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Jeffrey Becker
On Thu, Aug 7, 2008 at 2:13 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > > On Thu, 7 Aug 2008 13:26:07 -0400, drh wrote: > > [snip] > >>So I'm giving some thought to removing feature (3) above and >>disallowing double-quoted string literals. My concern is, though, >>that this might break many

[sqlite] implementing a vfs

2008-08-15 Thread Jeffrey Becker
Are pointers sqlite3_file structures considered 'invalid' after Close has been called on them? If not, at what point can I free memory associated with them? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Using SQLite as an application file format (C++)

2008-08-18 Thread Jeffrey Becker
Personally I'd skip the 'auto-saving' feature. Lots of users are used to being able to mess around with whatever safe in the knowledge that when they quit their changes will go away. More over, unless cross-session undo is a stated goal it provides little value while potentially balooning

Re: [sqlite] Using SQLite as an application file format (C++)

2008-08-18 Thread Jeffrey Becker
protected long ObjectID{get;set;} protected object getValue(string propertyName); protected void setValue(string propertyName, object value); } On Mon, Aug 18, 2008 at 7:39 PM, Darren Landrum <[EMAIL PROTECTED]> wrote: > Jeffrey Becker wrote: >> As a solut

[sqlite] vfs implementation question

2008-08-19 Thread Jeffrey Becker
Should the xLock member of sqlite3_io_methods object block until the lock can be acquired? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] vfs implementation question

2008-08-19 Thread Jeffrey Becker
So in the cases where the lock cant be acquired, the built in vfs implementations return SQLITE_BUSY? On Tue, Aug 19, 2008 at 9:16 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Aug 19, 2008, at 9:02 AM, Jeffrey Becker wrote: > >> Should the xLock member of sqlite3_io

Re: [sqlite] vfs implementation question

2008-08-19 Thread Jeffrey Becker
, Richard Klein <[EMAIL PROTECTED]> wrote: > D. Richard Hipp wrote: >> On Aug 19, 2008, at 9:02 AM, Jeffrey Becker wrote: >> >> >>> Should the xLock member of sqlite3_io_methods object block until the >>> lock can be acquired? >> >> xLock does

Re: [sqlite] Reducing SQLite Memory footprint(!)

2008-08-20 Thread Jeffrey Becker
More over, the memory usage reported by process explorer is subject to the vagrancies of the windows memory allocator. Generally the memory usage you see reported in tools is quite a bit higher than the actual memory usage of your application. First off windows manages memory in fixed size

Re: [sqlite] Reducing SQLite Memory footprint(!)

2008-08-22 Thread Jeffrey Becker
At one point I wrote some vbscript to generate a table declaration and insert statements for a csv. I might be able to dig it up if you dont mind vbscript. On Fri, Aug 22, 2008 at 1:58 PM, Brown, Daniel <[EMAIL PROTECTED]> wrote: > I just ran Dennis's test databases through the test application

Re: [sqlite] Reducing SQLite Memory footprint(!)

2008-08-22 Thread Jeffrey Becker
Ok, I couldnt find the script but heres something started. On Fri, Aug 22, 2008 at 6:02 PM, Brown, Daniel <[EMAIL PROTECTED]> wrote: > That script would be great :) > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey

Re: [sqlite] Get transaction number

2008-08-26 Thread Jeffrey Becker
I dont believe sqlite supports named transactions. As such there wouldnt be any identifier to get. On Tue, Aug 26, 2008 at 4:47 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > Hello! > > How can I get transaction identifier or number (my programm lang is tcl)? > > Best regards, Alexey. >

Re: [sqlite] Writing an image to the database as a BLOB

2008-08-29 Thread Jeffrey Becker
Are you able to load and save the bitmap to a file? On Fri, Aug 29, 2008 at 2:13 PM, Jared Miller <[EMAIL PROTECTED]> wrote: > Hello, > > I am having trouble figuring out how to successfully write an image to the > SQLite database as a Blob, using C++. > > I have an HBITMAP that I would like to

Re: [sqlite] Error A0A

2008-09-08 Thread Jeffrey Becker
Are you using the native api or one of the wrappers? On Mon, Sep 8, 2008 at 9:58 AM, Dan <[EMAIL PROTECTED]> wrote: > > On Sep 8, 2008, at 1:47 PM, [EMAIL PROTECTED] wrote: > >> >> I'm using multiple connections to sqlite database from more threads >> in my application. Few customers reports

Re: [sqlite] Vista frustrations

2008-09-17 Thread Jeffrey Becker
SQLite in general and the .Net provider in particular are most often shipped as components of other applications. I dont think having developers tell their end users to disable superfetch is a viable solution. As much as I hate to propose this maybe a runtime check is in order to see what the OS

Re: [sqlite] Vista frustrations

2008-09-17 Thread Jeffrey Becker
I am running vista my personal pc. I'll try to take a look into how not having this flag affects performance when I get home. On Wed, Sep 17, 2008 at 5:29 PM, Robert Simpson <[EMAIL PROTECTED]> wrote: > Ideally, at least on non-CE platforms, I'd like see SQLite not give the OS > any hints about

Re: [sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread Jeffrey Becker
Try creating an index on settings(rate) On Thu, Sep 18, 2008 at 12:46 PM, chris <[EMAIL PROTECTED]> wrote: > I'm at a loss and need some guidance. My queries are taking way longer than > I can use but I'm not sure what steps to take next. > > I'm using SQLite 3.6.2 on a small reasonable

Re: [sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread Jeffrey Becker
Actually I think you can drop the index on just rate. On Thu, Sep 18, 2008 at 3:12 PM, John Stanton <[EMAIL PROTECTED]> wrote: > I would get rid of your separate columns for day, month and year and use > the Sqlite date format and use an index on it. > > chris wrote: >> I'm at a loss and need

Re: [sqlite] Date/Time Pains

2008-09-22 Thread Jeffrey Becker
Instead of doing julianday('now') why not put a text-based timestamp into whatever object you're queueing up and pass that into the julianday() function to convert it to a real. On Mon, Sep 22, 2008 at 9:51 AM, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/22/08, jason weaver <[EMAIL PROTECTED]>

Re: [sqlite] Specifing which index to use. Was: Performance/bug in multikey 'group by' in 3.6.2

2008-09-22 Thread Jeffrey Becker
First, I have to agree that this is very 'un-rdbmsish'. I understand that sometimes the programmer really does know better than the DB engine which indexes it should use. However, the RDBMS is fundamentally an abstraction layer. I think the policy other dbms systems have of making these things

Re: [sqlite] Network concurrency question

2008-09-25 Thread Jeffrey Becker
The long and short of it is that SQLite uses the os File-Locking APIs for concurrency. Network File systems vary wildly in the reliability of their implementations of these APIs. If you already have a server application why not simply force all database access through that? On Thu, Sep 25, 2008

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Jeffrey Becker
What do you mean by "Mapping". There are several api wrappers for sqlite written in C++. See http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers On Thu, Sep 25, 2008 at 1:31 PM, Sherief N. Farouk <[EMAIL PROTECTED]> wrote: >> Does anyone know of any tools that are either open source or

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Jeffrey Becker
>From what I remember of CodeSmith I dont see any reason why you couldnt simply write templates that put out C++ rather than C# or VB.Net. If push really came to shove and you didn't have an excessively complicated DB you could write one in vbscript pretty easily. On Thu, Sep 25, 2008 at 2:49 PM,

Re: [sqlite] seeking storage design assistance

2008-09-30 Thread Jeffrey Becker
ORM is always a tricky business. My experience is that unless the entity is very very simple, it's often inappropriate to attempt to do 1 row = 1 entity mapping. If things are collections of points, then by all means have a points table. A lot of this type of stuff can be made easier by 1)

Re: [sqlite] Failure on big sqlite tables

2008-10-02 Thread Jeffrey Becker
1) what is the timeout for php? The default timeouts are generally pretty low, often 5 seconds or less. 2) What type of indexes do you have on these tables? Indexes speed up query performance vastly. 3) Query performance is generally _much_ more sensitive to how many rows a table has rather than

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
IIRC powershell doesnt automatically load every assembly in the GAC. How are you loading the System.Data.SQLite assembly? On Thu, Oct 9, 2008 at 8:51 AM, <[EMAIL PROTECTED]> wrote: > Hello, > > I looked unavailingly around for hours to get SQLite and Powershell working > together. > > Is there

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
PSSnapin, but that doesn't work. > (... PowerShell-Snap-In "System.Data.SQLite" is not installed ...) > > > > Original-Nachricht ---- >> Datum: Thu, 9 Oct 2008 10:03:07 -0400 >> Von: "Jeffrey Becker" <[EMAIL PROTECTED]> >> An: "

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
ta.SQLite.SQLiteConnection] cannot be found. > Make sure assembly containing this type is loaded. > > [messages retranslated from german] > > > ---- Original-Nachricht >> Datum: Thu, 9 Oct 2008 11:04:36 -0400 >> Von: "Jeffrey Becker" <[EMAIL PROTEC

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
now. >> > How should I do this? >> > I think that's the point. >> > >> > As I mentioned I tried manually with Add-PSSnapin, but that doesn't >> work. >> > (... PowerShell-Snap-In "System.Data.SQLite" is not installed ...) >> > >> > >> > >

Re: [sqlite] howto setup SQLite with Powershell ?

2008-10-09 Thread Jeffrey Becker
Technically there's nothing stopping you from using sqlite3.exe in the same way you'd use it in a unix shell script. On Thu, Oct 9, 2008 at 2:54 PM, Helga Lachmann <[EMAIL PROTECTED]> wrote: > The original problem is given in the topic. > The System.Data.SQLite provider (which I currently can't