-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/19/2011 09:25 PM, Frank Chang wrote:
>
>I wanted to thank Roger Binns for solving my problem.
You are welcome :-)
> I was able to determine the sqlite database was corrupted
Just to be clear for people finding this thread in the future,
Hi Tom,
Thanks for the kind words. Also thanks for the bug report, I'll investigate &
fix that.
However, could I ask that any future comments/bugs are sent off-list please? Dr
Hipp was kind enough to let me place an announcement on the mailing list, but I
feel it's a bit impolite to continue d
Hi Ben,
In reply to your announcement of Base 2:
> Just a short message to announce that version 2.0 of Base, our Mac SQLite GUI
> is now available.
The new version looks great. Congrats :-)
> It's a major upgrade, the highlight of which is the ability for the app to
> view, create & alter ta
I wanted to thank Roger Binns for solving my problem. Using sqlite3_request,
I was able to determine the sqlite database was corrupted when I didn't issue a
BEGIN EXCLUSIVE before beginning to insert the 5.4 million rows. Evidently, the
use of BEGIN EXCLUSIVE prevents my transaction from bei
On Thu, Feb 10, 2011 at 6:04 PM, Richard Hipp wrote:
> There needs to be a time when there are no read or write transactions using
> the WAL so that it can reset, and you need to run PRAGMA wal_checkpoint
> during that time. Otherwise the WAL will grow without bound.
>
> See also the RESET option
Who would I talk to if I wanted to contribute to the System.Data.Sqlite
project? We use this code in an enterprise environment and would like to
contribute our changes to the community.
Please NOTE: This electronic message, including any attachments, may include
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/19/2011 04:04 PM, Simon Slavin wrote:
> An alternative to the 'straight SQLite' solution would be to write your own
> routine to dump to disk instead of using the backup API. I have no idea
> whether this would be better or worse,
It would be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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!
Unless your time has no value, I'd suggest using this:
http://w
Pavel, I am fully aware of clone(2). But clone() is not standard, and the
modern Linux pthreads implementation is faithful to the pthreads
specification. POSIX threads are schedulable threads of execution that
share a process' address space. I will grant that my advice regarding
vfork() is based
On 19 Feb 2011, at 11:40pm, Robert Hairgrove wrote:
> This works fine, but I would like to offer the user the option to
> encrypt the database before writing it to disk. If it is encrypted, they
> would need to decrypt it again when it was loaded into memory (duh!)
An alternative to the 'straigh
My application (written in C++ together with the Qt libraries) uses an
in-memory database which is stored to disk using the SQLite backup API
at the end of a session or at periodic intervals (i.e. auto-save
functionality) and loaded from disk into the memory database at program
startup.
This works
> Rather, I meant that Windows processes are comparable to
> Unix processes (concurrent threads of execution in isolated address
> spaces), and that Windows threads are comparable to Unix threads
> (concurrent threads of execution in common address spaces). I'm not
> an expert on Windows, but I do
Nico, it looks like your don't understand what you are saying.
> Windows and Unix processes and threads have similar semantics, and thus
> roughly comparable performance envelopes.
Windows processes and threads don't have similar semantics, unix
processes (and threads) are not comparable to Windo
>Date: Fri, 18 Feb 2011 06:13:37 -0800 (PST)
>From: Marian Cascaval
>
>I'm suspecting there's something wrong with Studio Express C++.
>I use both 2008 and 2010 and I notice on 2008 that the IDE loses track of
code
>in case of large source files. Sometimes comments that should have a
certain
>colo
Hi List,
Just a short message to announce that version 2.0 of Base, our Mac SQLite GUI
is now available.
It's a major upgrade, the highlight of which is the ability for the app to
view, create & alter tables with support for *all* table- and column-level
constraints.
You can read the full ann
On Saturday, February 19, 2011 at 10:17 AM, Black, Michael (IS) wrote:
> sqlite> create virtual table data using fts4(content text);
> sqlite> insert into data values('one two');
> sqlite> insert or replace into data(content) select content||' three four'
> from data where docid=1;
>
> The doc
I think I already know the answer to this...but is it possible to append text
to an FTS row without doing some sort of subselect?
Even with the subselect what;s the best way to do this? I seem unable to find
a single-liner that works.
sqlite> create virtual table data using fts4(content te
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 articulable
> suspicion. Note that “probable cause” doesn’t imply co
>Date: Fri, 18 Feb 2011 13:12:09 +
>From: "Black, Michael (IS)"
>
>I'm of the opinion that all such warnings should be permanently fixed.
Such warnings do point to potential problems.
>And not by disabling the warning but by fixing the code (explicit casts for
example).
>
>How many people try
Just 30 years of developing C code and too-many-to-count projects where we
always had a goal of zero-warnings no matter what switch you used. It's really
hard (as the SQLite guys can attest I'm sure) to make a cross-platform system.
We use each compiler's capabilities as they are all different
20 matches
Mail list logo
