I think one of the most lacking aspects of the documentation are
examples. Perhaps this is better addressed in the proposed tutorial, but
not all the "SQL Syntax" pages make it clear how to use the statement,
especially the more complex ones like SELECT, and expressions.
The datetime use is
D. Richard Hipp wrote:
> On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote:
>> This is a bit off-topic for the mailing list, so please feel free
>> to send stuff directly to the address below.
> It would be good, I think, to have a public record of this
> conversation. We
Why not include a section "User Contributed Notes" (in the style of the php
doc) besides each page of the SQLite man pages?
specially those devoted to:
1. List Of Objects
2. List Of Constants
3. List Of Functions
From: D. Richard Hipp [mailto:[EMAIL
ok. I think I see what you are suggesting. You want to provide a
mechanism to create memory files that SQLite thinks are disk
filesthat way you could create multiple connections to them.
an interesting idea. However, that may be more effort that I can
justify at this point. I'll think
On Apr 19, 2008, at 5:44 PM, Jay A. Kreibich wrote:
> This is a bit off-topic for the mailing list, so please feel free
> to send stuff directly to the address below.
It would be good, I think, to have a public record of this
conversation. We can create an [EMAIL PROTECTED]
On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
> mikeobe wrote:
> > i found it boring to learn how to use sqlite, maybe we can write a
> > tutorial for it, with examples, it will be much easier for the
> > beginner to start with sqlite.
> Agreed - I had to learn
Imagine the following cenario (I assume you know c++ stdlib)
A map of strings (filenames) to in-memory file handlers (the objects that
will handle the shared memory or heap files).
These files handlers will exists until the process exists and do not receive
a delelefile() vfs call.
I don't immediately see how that would solve the problem.
The limitation of interest here (based on my perhaps limited
understanding) is that locking has file-level granularity. I don't
immediately see how a VST implementation would allow for changing the
locking granularity of the overall
what about creating a VFS for such task ? Can be accomplished in many ways,
using heap memory, shared memory... not so easy to do, but not much
complicated too... locking can be provided by multiple-readers
single-writers locks strategies, etc...
On Sat, Apr 19, 2008 at 2:29 PM, James Gregurich
oh good! That isn't the version that ships with Leopard, but I can
live with deploying my own version as part of my app.
Will l get the writer parallelism I'm after as long as each thread
writes exclusively into its own attached db?
in other wordstwo bulk insert operations going on
Agreed - I had to learn from the 5 minute introduction (which I was
later told was a poor way of doing it), and then by using the reference,
which leaves a lot to be desired when it comes to having little
knowledge of SQLite - and it's still giving me trouble now!
On Apr 19, 2008, at 6:06 AM, James Gregurich wrote:
> I'll ask this question. The answer is probably "no," but I'll ask it
> for the sake of completeness.
> Suppose I created an in-memory db. I use the attach command to
> associate an additional in-memory db. Suppose I assign the main db
On Fri, Apr 18, 2008 at 08:59:17PM -0500, John Stanton wrote:
> Use a function and convert the IP address from dotted format to a 32 bit
> unsigned integer. You can AND and OR these to establish inclusion and
That doesn't get you the prefix length. If you represent the
NO make file found in that zip, downloaded from the official website...
sqlite-users mailing list
"Mike Johnston" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I'm in a loop processing the result set using sqlite3_step. I need to
> insert/update the same sqlite database but a different table. I
> can't get the write lock while I have this active statement I'm using
I received a task to investigate feasibility of using sqlite database
located on a server in an internal windows network.
I know this is not most recommended scenario but I still have to do
Let us assume this case:
2 machines are accessing sqlite database located on a third
Thanks - that seems to have fixed it
D. Richard Hipp wrote:
> On Apr 19, 2008, at 9:19 AM, Toby Roworth wrote:
>>> What value are you passing as the 4th argument to
>>> sqlite3_open_v2()? (I assume you are using sqlite3_open_v2()
>>> since that seems the mostly likely way to get this
On Apr 19, 2008, at 9:19 AM, Toby Roworth wrote:
>> What value are you passing as the 4th argument to
>> sqlite3_open_v2()? (I assume you are using sqlite3_open_v2()
>> since that seems the mostly likely way to get this error.)
> I'm passing a blank string - this would appear to be the
D. Richard Hipp wrote:
> On Apr 19, 2008, at 7:41 AM, Toby Roworth wrote:
>> When attempting to open a database, I am getting a "no such vfs"
>> What is likely to be causing this - a quick search suggested that vfs
>> may stand for virtual file system - is this right?
On Apr 19, 2008, at 7:06 AM, pinco palletto wrote:
> update register
> set note = (select ORT.note from old_register ORT
> where ORT.person_id = person_id and ORT.document_id = document_id)
> where exists (
> select ORT.* from old_register ORT
> where ORT.person_id = person_id and
On Apr 19, 2008, at 7:41 AM, Toby Roworth wrote:
> When attempting to open a database, I am getting a "no such vfs"
> What is likely to be causing this - a quick search suggested that vfs
> may stand for virtual file system - is this right?
> Any help would be appreciated
When attempting to open a database, I am getting a "no such vfs" error.
What is likely to be causing this - a quick search suggested that vfs
may stand for virtual file system - is this right?
Any help would be appreciated
I have to update a 'note' field of a 'register' table with the values from the
correspective entries of an 'old_register' table.
The 'old_register' table is shorter than 'register', I mean it has less
records, but every primary key's value in 'old_register'
is also the value of one
-BEGIN PGP SIGNED MESSAGE-
P Kishor wrote:
> I have a rather opaque application that is calling my db. Is there
> something I can turn on in SQLite that will log all the statements
> executed against it?
If you are using Linux then you can use the ltrace program to trace
On Fri, 18 Apr 2008 15:59:14 -0600, Dennis Cote wrote:
> Christof Meerwald wrote:
>> Currently, I am thinking of storing start and end IP addresses as a blob in
>> the database - that way I would be able to use the "between" operator in
>> selects, e.g.
>> select X'c0a81234' between X'c0a8'
Mail list logo