On 02/21/2011 09:38 AM, Simon Slavin wrote:
>
> On 21 Feb 2011, at 1:47am, Roger Binns wrote:
>
>> On 02/20/2011 02:48 PM, Todd Shutts wrote:
>>> The application
>>> never used more than 10MB and it is currently using 57+MB and continues
>>> to climb.
>>
>> The single most likely explanation is thi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/2011 06:23 PM, Jay A. Kreibich wrote:
> On Sun, Feb 20, 2011 at 05:23:09PM -0800, Roger Binns scratched on the wall:
>> If you want to use SQL then use Postfix.
>
> I might suggest PostgreSQL instead.
> (Sorry, Roger, I couldn't resist.)
On Sun, Feb 20, 2011 at 05:23:09PM -0800, Roger Binns scratched on the wall:
> If you want a close match to the Python object model then use MongoDB.
>
> If you want to use SQL then use Postfix.
I might suggest PostgreSQL instead.
Postgres is likely to give you much better results than th
On 21 Feb 2011, at 1:47am, Roger Binns wrote:
> On 02/20/2011 02:48 PM, Todd Shutts wrote:
>> The application
>> never used more than 10MB and it is currently using 57+MB and continues
>> to climb.
>
> The single most likely explanation is this is WAL in action, the memory is
> from a memory m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/2011 02:48 PM, Todd Shutts wrote:
> However; memory usage is growing like crazy.
It is a very frequent occurrence that what people think is being measured is
not what is actually being measured. Make sure you understand exactly what
the too
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/2011 04:47 PM, BareFeetWare wrote:
> How can I best scroll though the results of an arbitrary select query?
If you have infinite time and memory then there is no problem. You haven't
stated your constraints or how arbitrary "arbitrary" reall
On 21 Feb 2011, at 12:47am, BareFeetWare wrote:
> How can I best scroll though the results of an arbitrary select query?
Suppose the results of the SELECT change between your original decision to do
the scrolling and the time the user decides to scroll. Should what's shown on
the display refl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/2011 04:55 PM, Stef Mientki wrote:
> still want to see if a simple client/server setup would solve my current
> problems
There is no such thing as "simple" client/server. You have to worry about
issues like authentication and authorization
On Sun, Feb 20, 2011 at 7:39 PM, Samuel Adam wrote:
> [I]f SQLite can *guarantee* no SIGFPE *ever*—under any possible inputs,
> period, bar none ... that should also be documented.
>
SQLite attempts to intercept division by 0.0, replacing the result with
NULL, but otherwise trusts the C compiler
hello,
knowing that SQllite is not a client/server database,
still want to see if a simple client/server setup would solve my current
problems for the moment
(because I love the simplicity of SQLlite,
and planned to go to a client / server database in the future)
Now I wonder if anyone has consi
Anyone, anyone, Bueller?
Here's a short version:
How can I best scroll though the results of an arbitrary select query?
Below is the detailed version of my question.
Any help appreciated.
Thanks,
Tom
BareFeetWare
From: BareFeetWare
Date: 16 February 2011 12:05:47 AM AEDT
To: General Di
On Sun, 20 Feb 2011 14:51:12 -0500, Nico Williams
wrote:
> On Sun, Feb 20, 2011 at 6:24 AM, Samuel Adam wrote:
[big snip]
>> Any numerics experts (which I am not) or fp-software gurus care to chime
>> in? *If* I am correct in my inductive hypothesis that the SQLite core
>> may
>> in rare ci
On Sun, 20 Feb 2011 14:46:06 -0500, Nico Williams
wrote:
> On Sun, Feb 20, 2011 at 6:28 AM, Samuel Adam wrote:
>> On Sat, 19 Feb 2011 17:12:31 -0500, Pavel Ivanov
>> wrote:
>>
>>> [snip] On
>>> Windows it’s different - process is much more heavy-weight object than
>>> thread and involves much
I inherited an application which used SQLite 3.5.8 running on Windows
2000. I upgrade to version 3.7.5 of the dll and added pragma statement
to use WAL. There was an immediate and significant performance
increase. However; memory usage is growing like crazy. The application
never used more tha
You can also convert:
ATTACH DATABASE x AS y KEY z
to:
SELECT sqlite_attach(x, y, z)
where the parameters can be turned into bind arguments. Then embedded
quotes won't be an issue.
-scott
On Sun, Feb 20, 2011 at 11:31 AM, Pavel Ivanov wrote:
> I believe doubling the single quote inside th
On 21/02/2011, at 3:20 AM, skywind mailing lists wrote:
> in your comparison chart it would also be nice to see which software is able
> to support SQLite extension. A couple of them do not support the FTS nor
> RTree capabilities of SQLite.
Sure, I'd be happy to add that. How do you suggest th
On Sun, Feb 20, 2011 at 6:24 AM, Samuel Adam wrote:
> I’m not writing anything multithreaded right now. But next month or next
> year, the humble little SQL user functions I now make could grow up and
> get plugged into something bigger. And before I longjmp(), I like to know
> with certainty wh
On Sun, Feb 20, 2011 at 6:28 AM, Samuel Adam wrote:
> On Sat, 19 Feb 2011 17:12:31 -0500, Pavel Ivanov
> wrote:
>
>> [snip] On
>> Windows it’s different - process is much more heavy-weight object than
>> thread and involves much bigger system load to support it. There’s an
>> official general adv
I believe doubling the single quote inside the string literal should help.
Pavel
On Sun, Feb 20, 2011 at 2:23 PM, Sam Carleton
wrote:
> This is a bit crazy and I know the ideal way would be to not allow the
> apostrophy in the first place but, my focus is easy of use for my customers,
> as comp
This is a bit crazy and I know the ideal way would be to not allow the
apostrophy in the first place but, my focus is easy of use for my customers,
as compared to easy for me...
I had a customer that saved their SQLite database here:
D:/My Events/President's Day/event.sqlite
My software uses ATT
>Date: Fri, 18 Feb 2011 07:34:06 -0800
>From: Jim Morris
>
>A correlated sub-query might work for you.
>
>SELECT
>[Analyzers].[AnalyzerID]
>, [Analyzers].[Name] AS [Analyzer]
>, [Analysis].[AnalysisID]
>, [Analysis].[ScanID]
>, [Analysis].[Timestamp]
>, [Analysis].[EndTime]
Hi Tom,
in your comparison chart it would also be nice to see which software is able to
support SQLite extension. A couple of them do not support the FTS nor RTree
capabilities of SQLite.
Hartwig
Am 20.02.2011 um 07:19 schrieb BareFeetWare:
> Hi Ben,
>
> In reply to your announcement of Base
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I am using sqlite 3.7.3 and have noticed the following behavior (which
cause me some headaches).
My DB is owned by a different user (www) and I as root insert some data.
Using pragma journal=delete, the journal file gets created as whoever
sta
Come to think of it that should work. I was storing terms in single rows and
had to allow for duplicates. But converting to FTS relieves that as there are
two flows in the code where it knows when a record is new or old so I don't
have to worry about the "record already exists" for this case..
I don't know if it works for your data...but you don't need to do all 5.4M in
one batch.
You should test doing it in different batch sizes -- like 1000 at a time (and
let other processes do their thing potentially). That way you won't lock them
out. But I think your other selects need to use t
On Sat, 19 Feb 2011 10:37:42 -0500, Afriza N. Arief
wrote:
> On Sat, Feb 19, 2011 at 6:27 AM, Samuel Adam wrote:
>
>> A FAQ[2] isn’t enough, as we can see.
>>
>> To put it another way: Bug reporters should have probable cause before
>> they bug others. A compiler warning is only a reasonable
On Sat, 19 Feb 2011 17:12:31 -0500, Pavel Ivanov
wrote:
> [snip] On
> Windows it’s different - process is much more heavy-weight object than
> thread and involves much bigger system load to support it. There’s an
> official general advice for Windows: better create a new thread in the
> same proc
[In general reply to interesting answers by Messrs. Williams and Binns:]
The potential SIGFPE in my case is optionally raised by a numeric library
as part of its error-handling mechanism; its manual expressly suggests
installing a signal handler and longjmp()ing back to find out what went
wr
On 20 Feb 2011, at 11:28am, Roger Binns wrote:
> And if your customers care then they will already have existing solutions
> for encryption and protection which includes dealing with incapacitation of
> users, system administration, backups etc. It is not a good idea to defeat
> those.
And give
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/2011 02:32 AM, Robert Hairgrove wrote:
> There are certain parts of an SQLite database or page header (the first
> 100 bytes, for example) which have known values. I think it is perhaps
> even dangerous to encrypt this data, at least with the
On 20 Feb 2011, at 10:52, Robert Hairgrove wrote:
> On Sun, 2011-02-20 at 09:35 +, Philip Graham Willoughby wrote:
>> For this task I would use AES-256 in counter mode with an appropriate nonce
>> (the counter is trivially derived from the file offset of the block to be
>> read/written). Th
On 20 Feb 2011, at 10:32, Robert Hairgrove wrote:
> On Sun, 2011-02-20 at 09:35 +, Philip Graham Willoughby wrote:
>> On 20 Feb 2011, at 09:10, Robert Hairgrove wrote:
>>
>>> I am not starting from scratch doing my own encryption; there are enough
>>> open source libraries publicly available
On Sun, 2011-02-20 at 09:35 +, Philip Graham Willoughby wrote:
> For this task I would use AES-256 in counter mode with an appropriate nonce
> (the counter is trivially derived from the file offset of the block to be
> read/written). The key should be derived from the user's password using
>
On Sun, 2011-02-20 at 09:35 +, Philip Graham Willoughby wrote:
> On 20 Feb 2011, at 09:10, Robert Hairgrove wrote:
>
> > I am not starting from scratch doing my own encryption; there are enough
> > open source libraries publicly available which are good enough for my
> > purposes.
>
> And all
On 02/20/2011 01:10 AM, Robert Hairgrove wrote:
> I saw that, but I find it a little intrusive, programmatically speaking,
> from a licensing standpoint.
Why don't you ask DRH then since you won't be the first to want to include
SEE with QT and a commercial app?
> I am not starting from scratch d
On 20 Feb 2011, at 09:10, Robert Hairgrove wrote:
> I am not starting from scratch doing my own encryption; there are enough
> open source libraries publicly available which are good enough for my
> purposes.
And all of them offer approximately no security if you use them incorrectly.
For this t
File permissions on database files created by the library libsqlite3
on Unix/Linux are created with a mask setting that restricts
permissions beyond what the user may expect from the current umask
setting.
In the file src/os_unix.c a mask is defined as:
** Default permissions when creating a new
On Sat, 2011-02-19 at 17:08 -0800, Roger Binns wrote:
> On 02/19/2011 03:40 PM, Robert Hairgrove wrote:
> > But before I "try this at home", I thought I would ask if there are any
> > caveats I should be aware of? Thanks for any helpful advice!
Thanks, Roger ... those are great links!
> Unless yo
38 matches
Mail list logo
