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
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
>>> (
>>>
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
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
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
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
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
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
, 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
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
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
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
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.
>
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
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
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
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
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
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
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]>
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
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
>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,
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)
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
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
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: "
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
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 ...)
>> >
>> >
>> >
>
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
30 matches
Mail list logo
