On Thu, Sep 9, 2010 at 1:01 AM, Andrew Wood wrote:
> Because I'm writing glue code between the SQLite API and a higher level
> library which provides a standard API across several DBMSs.
>
>
Have in mind that storage class is not a 'type', it's more like an effective
way to store values compactly
Hi, do you have some news about the wasted memory? have you found the
reason for the windows backend?
do you think it could be due to the windows implementation of the mmap?
Il 02/09/2010 16.46, Richard Hipp ha scritto:
> On Thu, Sep 2, 2010 at 9:59 AM, Marcus Grimmwrote:
>
>> Michele Pradella
Quoth Hemant Shah , on 2010-09-08 20:55:29 -0700:
> Both of these processes are sibling and have same database
> handle.
No, don't do that.
http://www.sqlite.org/faq.html#q6
And :memory: databases are not shared between processes, AFAIK.
Why are there two processes anyway? You could just use o
vacuum is a no-op for in memory database.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/8/10, Woody & Yuni Ho wrote:
From: Woody & Yuni Ho
Subject: Re: [sqlite] In memory database and locking.
To: "General Discussion of SQLite Database"
Date: Wednesday, September 8, 2010, 11:08 PM
Have
Have you tried issueing a vacum after n deletes?
Woody wizard at large(I'm in shape. Round is a shape)
Connected by MOTOBLUR™ on T-Mobile
-Original message-
From: Hemant Shah
To: General Discussion of SQLite Database
Sent: Wed, Sep 8, 2010 21:03:21 PDT
Subject: Re: [sqlite] In memory d
I forgot to mention, that I have set pragma journal_mode to off and for every
insert I doprepare -> step -> finalize -> COMMIT.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/8/10, Hemant Shah wrote:
From: Hemant Shah
Subject: [sqlite] In memory database and locking.
To: sqlite-users@sqli
Folks,
I am trying to write an application that reads packets from the network and
inserts it into sqlite database, I have a unique key which is combination of
couple of columns. I want to find re-transmitted packets so I rely on the fact
that if I violate unique key constraint then I have found
Quoth Oliver Schneider , on 2010-09-09 00:12:43 +:
> > Can't you just include the modified value within your UPDATE or
> > INSERT statement? Or is the modified column in a separate table?
>
> Guess I'll do that. SQLite is just so convenient even from command line,
> that I thought it'd be bett
On 2010-09-09 00:15, Igor Tandetnik wrote:
> This updates all the rows in the table, not just the one for which the
> trigger was fired. You want something along the lines of
>
> UPDATE file SET modified=julianday('now')
> where file.rowid = new.rowid;
Ouch. Thanks for shedding some light on this
I will be out of the office starting 2010/09/09 and will not return until
2010/09/16.
Thank you for your message.
During my absence, you can contact my direct colleague Nicolas Bonte at
following mail: nicolas.bo...@awtce.be
Best
___
sqlite-users mail
Simon Slavin wrote:
> I was attempting to find a value which would always coerce directly to the
> affinity of the column, so when you read it back out
> it would always be the 'proper' type. My theory would be that this one value
> could be used to betray the affinity of every
> column in a ta
On 9 Sep 2010, at 1:13am, Igor Tandetnik wrote:
> Simon Slavin wrote:
>> What would happen if you wrote a row with '1.1' for every value, then used
>> sqlite3_column_type when you read it back out ?
>> Assuming that it was possible (i.e. no TRIGGER or UNIQUE prevented it).
>
> It depends. If
Oliver Schneider wrote:
> Hmm, strange. These are the triggers I used:
>
> CREATE TRIGGER IF NOT EXISTS file_change AFTER UPDATE OF hash,name,path
> ON file
> BEGIN
>UPDATE file SET modified=julianday('now');
> END;
This updates all the rows in the table, not just the one for which the tri
Simon Slavin wrote:
> On 9 Sep 2010, at 12:01am, Igor Tandetnik wrote:
>
>> sqlite3_column_type returns the type of the value in the given column and
>> the current row. The type reported by
>> sqlite3_column_type may change from row to row. It is largely unrelated to
>> the type "you originall
Thanks for your reply.
> Can't you just include the modified value within your UPDATE or
> INSERT statement? Or is the modified column in a separate table?
Guess I'll do that. SQLite is just so convenient even from command line,
that I thought it'd be better to automate that part to figure out if
On 9 Sep 2010, at 12:01am, Igor Tandetnik wrote:
> sqlite3_column_type returns the type of the value in the given column and the
> current row. The type reported by sqlite3_column_type may change from row to
> row. It is largely unrelated to the type "you originally intended the column
> to be
On Wed, Sep 08, 2010 at 07:01:19PM -0400, Igor Tandetnik wrote:
> Schrum, Allan wrote:
> > I guess I'm confused as to why sqlite3_column_type() would not work? It
> > works for me on queries and I get back either
> > SQLITE_INTEGER, SQLITE_FLOAT, or SQLITE3_TEXT. While I know the types could
> >
Schrum, Allan wrote:
> I guess I'm confused as to why sqlite3_column_type() would not work? It works
> for me on queries and I get back either
> SQLITE_INTEGER, SQLITE_FLOAT, or SQLITE3_TEXT. While I know the types could
> be coerced to something else, at least it is an
> answer of what you orig
On Wed, Sep 8, 2010 at 5:01 PM, Andrew Wood wrote:
> Because I'm writing glue code between the SQLite API and a higher level
> library which provides a standard API across several DBMSs.
>
> In other DBMSs even if a field contains null you can still ask the API
> what type it 'should' have been
On 8 Sep 2010, at 10:36pm, Jay A. Kreibich wrote:
> I also have to say that handling NULLs as a value-less type is a very
> clean and handy model.
Today at work I had to thoroughly investigate a program I wrote long ago and
look for places where NULL, undefined, -1 and 'false' might appear th
I guess I'm confused as to why sqlite3_column_type() would not work? It works
for me on queries and I get back either SQLITE_INTEGER, SQLITE_FLOAT, or
SQLITE3_TEXT. While I know the types could be coerced to something else, at
least it is an answer of what you originally intended the column to b
> Trigger is a plain text remembered and executed at certain points of
> time. If you know your maximum number of employees at the time when
> you create trigger then just put it there instead of question mark. If
> you wanted to change that maximum at each trigger execution then it
> won't work th
On Wed, Sep 08, 2010 at 10:01:48PM +0100, Andrew Wood scratched on the wall:
> Because I'm writing glue code between the SQLite API and a higher level
> library which provides a standard API across several DBMSs.
>
> In other DBMSs even if a field contains null you can still ask the API
> what
Because I'm writing glue code between the SQLite API and a higher level
library which provides a standard API across several DBMSs.
In other DBMSs even if a field contains null you can still ask the API
what type it 'should' have been if something *had* been put in it.
Without this ability, I
> I intended to use sqlite3_bind_int() to bind the maximal number of employees
> a department can contain to the template. The C program works without error.
> However, the trigger does not work when I insert into the employees table.
> I used the latest sqlite-3.7.2. Is this a bug of SQLite? Or
Hi everyone,
My C program has a CREATE TRIGGER statement which contains a template "?":
CREATE TABLE employees (
employee_id INTEGER PRIMARY KEY,
dep_id TINYINT,
score FLOAT
);
CREATE TRIGGER on_ins_employee AFTER
INSERT ON employees
WHEN ? < (SELECT count(1) FROM employees WHERE dep_id =
Igor Tandetnik wrote:
> Zack Weinberg wrote:
[...]
>> Is it possible to do this operation in one SQLite statement?
>
> insert or replace into observations
> values (:src, :dest, :verb,
> coalesce(
>(select occurrences from observations
> where src=:src and dest=:dest and verb=:verb),
>
On Tue, Sep 7, 2010 at 4:45 AM, Simon Slavin wrote:
> On 7 Sep 2010, at 4:34am, Zack Weinberg wrote:
>
>> I'm not subscribed to the mailing list, please cc: me on replies.
>
> No. If you don't read a mailing list, don't post to it.
I have one question. You should not demand that I take on an un
Thanks, "Zaher Dirkey"!
Only,
PRAGMA journal_mode = TRUNCATE
solves my problem.
By some way the O.S. is locking the one off the journals and the program
can't delete it.
--
Atenciosamente/Regards,
Israel Lins Albuquerque
Desenvolvimento/Development
Polibrás Brasil Software Ltda.
No. I use sqlite in proprietary application, not the shell!
I use cegcc to compile sqlite.
- "ydlu" escreveu:
> Hi:
> Could you give me some info how you use SQLite in WinCE 6.0? Do you convert
> the shell program to WinCE? I mean run "Sqlite3.exe" in WinCE.
> If you run x86 platform,
Hi , I am SORRY for my delay to reply . damned vacations .
Yes . is the limit , indeed often It deletes the newer one and not the
last or random deleting . I have often an allmost full HD . Is it a cause ?
However this I would to ask if is possible to regain the history / bookmarks
delet
31 matches
Mail list logo