On 2014-03-25 18:52, Larry Brasfield wrote:
> Going in, it is best to not read too much into your code running
> "pretty well" on a Unix platform. Have you run your code with
> Valgrind (or equivalent) on that platform? If not, doing so may help
> you uncover a bug which affects behavior more
Hello,
when trying to use foreign keys I'm running into a problem. It could be
that I hit some general limitation, but then again the error that I'm
seeing could also be issued if the database with the table of the
referenced foreign key is not attached.
Here's what I'm trying to do.
I have
Hello Pavel,
thanks for your reply.
On 2010-08-18 20:39, Pavel Ivanov wrote:
>> Summary: how can I use foreign keys across database boundaries? Is it at
>> all possible?
>
> No. It's logically incorrect action, so it's impossible. If you want
> consistency of your tables to be automatically
Hi Pavel,
I think I guess that I understand what your point is.
On 2010-08-18 21:18, Pavel Ivanov wrote:
> This is exactly the reason why it's not logical action: SQLite will
> check constraint only in those places where it knows that something is
> changed and constraint can be violated. And it
Hi,
I'm having a table of file names along with hashes and so on. In order
to make sure that we keep a record, I had put a trigger on UPDATE and
INSERT which would set the column 'modified' (REAL, Julian day) to the
time of the change. However, this slows down any INSERTs (even those
seemingly
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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Hi there,
just a few minutes ago I ran a VACUUM on a DB file and the size before
was 2089610240 and afterwards 2135066624. Is this normal?
Thanks,
// Oliver
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (MingW32)
Hi,
using Opera I receive the following error:
> Could not connect to remote server
>
> You tried to access the address https://sqlite.org/lang_attach.html, which is
> currently unavailable. Please make sure that the web address (URL) is
> correctly spelled and punctuated, then try reloading
Hey folks,
the problem still exists (or rather again). Shortly after my initial
email someone decided to turn the redirect to HTTPS off again, but now
it's back, only the certificate chain hasn't been fixed.
OpenSSL gives me:
$ openssl s_client -connect www.sqlite.org:443
CONNECTED(0003)
On 2012-05-01 20:41, Baruch Burstein wrote:
> It is already wrapped in a transaction.
> I seem to remember seeing somewhere that the .import command doesn't
> understand escaping, e.g.
>
> "one","two,three"
>
> will get imported as
>
> "one" | "two | three"
>
> (the quotes are part of
On 2012-05-02 14:06, peter korinis wrote:
> Thank you all.
> Look like I'm stuck with the CLI though I have contacted Nucleon software
> support ... tried CLI yesterday but need more practice.
> Is there a good reference book you would recommend for SQLite?
Absolutely. The one by Mike Owens was a
Re-sending because the list still complains about PGP signatures.
Original Message
Subject: Re: [sqlite] Licence
Date: Tue, 22 May 2012 20:55:06 +
On 2012-05-22 20:48, Net Surfer wrote:
>> Just a quick question. To sell an application that uses SQLite, do i need
>> to
Hello,
I have a decision to make about how to store dates that may not be
entirely accurate inside an SQLite DB. There are two options I came up with:
1. store "exact" date plus (in separate column) value for accuracy
2. store date range corresponding to original accuracy
The accuracy can be
14 matches
Mail list logo