On 12/1/06, Isaac Raway <[EMAIL PROTECTED]> wrote:
> Because our project needs to be ported to windows - the /dev/shm is not an
> option - because win2000 does not support any temporary memory based file
> system.
Not so.
"FILE: Ramdisk.sys sample driver fo
Because our project needs to be ported to windows - the /dev/shm is not an
option - because win2000 does not support any temporary memory based file
system.
Not so.
"FILE: Ramdisk.sys sample driver for Windows 2000"
http://support.microsoft.com/kb/257405
Even includes C code, along with a bina
On 11/28/06, Nicolas Williams <[EMAIL PROTECTED]> wrote:
On Tue, Nov 28, 2006 at 03:03:58PM -0600, Isaac Raway wrote:
> Use an index on the table with your key values and call "INSERT OR
> UPDATE INTO t(...) VALUES(...)" for all creation and update
> operations. Unl
m Services, Inc.(TM)|Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
-
To unsubscribe, send email to [EMAIL PROTECTED]
----
On 11/27/06, LuYanJun <[EMAIL PROTECTED]> wrote:
Can anybody give a simple example for domestrating ?
I am puzzled by this topic, how does a music file be sotred in DB as BLOB
type?
You can insert /any/ kind of data into a SQLite database (or most any other
sort of DB for that matter). Here's
AIL PROTECTED]> wrote:
On 11/27/06, Isaac Raway <[EMAIL PROTECTED]> wrote:
> I'd like to strongly second this. Avoid NULL columns, even at apparent
cost.
> Having a valid default value is always better. If a design appears to
> require NULL values, then the design is likely
t; so they are permenently there? It might be a dumb question but i
> cant
> > >> >> find the answer anwhere?!
> > >> >
> > >> > They are "permanently there" from the very moment you create
them.
> All
> > >> > changes are written to the database file when a transaction is
> > >> > committed, or at
How much work is potentially involved in implementing more complete ALTER
TABLE support? Specifically DROP COLUMN and ALTER COLUMN.
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
http://blueapples.org - blog
http://stonenotes.com - personal knowledge management
Name='Peter')
>
>nothing is selected
>
>what do i wrong ?
>thx
---------
To unsubscribe, send email to [EMAIL PROTECTED]
-
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
http://blueapples.org - blog
http://stonenotes.com - personal knowledge management
eric convention, perhaps all odd
values are local, all even ones remote, etc. Any thoughts on this?
On 11/19/06, John Stanton <[EMAIL PROTECTED]> wrote:
Isaac Raway wrote:
> I am looking at a design that will require syncing a disconnected SQLite
DB
> file on client's machines t
lients automatically. Has anyone does this kind of syncing? I realize I'm
somewhat light on details, but I'm not really even sure exactly what this
system will need to do: it's more of a framework really.
At any rate, anyone have experience syncing SQLite DB files?
--
Isaac Raway
E
re any way to filter by a byte position within the BLOB?
Any help is appreciated. Thanks very much for your time.
-Gabe
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
only when there isnt a
simpler way.
This thread has covered just about all approaches I can think of :-) thanks
for the reponses.
S
On 10/27/06, Isaac Raway <[EMAIL PROTECTED]> wrote:
>
> Why don't you design the table with a unique row ID, stored in an
> integer field, then
e the same physical laws
> as us ordinary mortals.
>
> I see no reason to ever perform a dataabase search twice.
>
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
http://blueapples.org - blog
http://stonenotes.com - personal knowledge management
---
On 10/25/06, Christian Smith <[EMAIL PROTECTED]> wrote:
A better solution would be to transfer the contents of the table being
updated to a temporary table, then recreate the original tables sans the
surplus columnn:
It may not be quick for large tables, but how often are you going to be
updatin
generic column names and mapping them to a list of the "actual" names.
It would be *very* nice to see these features added to sqlite before I
finish this feature, but I imagine this has been requested before...
Isaac
On 10/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"
the Delphi bindings?
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
http://blueapples.org - blog
http://stonenotes.com - personal knowledge management
the Delphi bindings?
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
of the task for the beginning and end, and only
perform them once.
Robert
-
To unsubscribe, send email to [EMAIL PROTECTED]
---------
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
http://blueapples.org - blog
http://stonenotes.com - personal knowledge management
Robert Simpson wrote:
Please have a look at it and poke some holes in it.
Upon a quick readthrough I noted that the filename is concated into the
Mutex name as-is. This is potentially dangerous given that Windows file
systems are not case sensitive and yet according to the CreateMutex
docu
[EMAIL PROTECTED] wrote:
Isaac Raway <[EMAIL PROTECTED]> wrote:
CREATE TABLE t1(a UNIQUE, b UNIQUE, c DEFAULT 3);
INSERT INTO t1 VALUES(1,1,1);
INSERT INTO t1 VALUES(2,2,2);
REPLACE INTO t1(a,b) VALUES(1,2);
SELECT c FROM t1;
The statement sequence above should generate a
[EMAIL PROTECTED] wrote:
Isaac Raway <[EMAIL PROTECTED]> wrote:
[I]nstead of dropping the row existing, [the REPLACE algorithm should]
simply update the provided fields in place, leaving the unmodified fields
as is. I'd call this behavior OR UPDATE as it would be exactly equivalen
I am using a pretty simple INSERT OR REPLACE query. I noticed this bit
in the description of the ON CONFLICT syntax for REPLACE:
> When a UNIQUE constraint violation occurs, the pre-existing rows that
are causing the constraint violation are removed prior to inserting or
updating the current r
23 matches
Mail list logo
