What is the purpose of urls.origin_id?
You need indexes on foreign keys. They do not make themselves.
>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Zack Weinberg
>Sent: Thursday, 6 February, 2014 13:40
>To: sqlite-user
On 6 Feb 2014, at 8:39pm, Zack Weinberg wrote:
> CREATE TABLE url_strings (
>id INTEGER PRIMARY KEY,
>urlTEXT NOT NULL UNIQUE
> );
>
> CREATE TABLE canon_statuses (
>id INTEGER PRIMARY KEY,
>status TEXT NOT NULL UNIQUE
> );
>
> CREATE TABLE urls
I have a database with this (partial) schema:
CREATE TABLE origins (
id INTEGER PRIMARY KEY,
label TEXT NOT NULL UNIQUE
);
CREATE TABLE url_strings (
id INTEGER PRIMARY KEY,
urlTEXT NOT NULL UNIQUE
);
CREATE TABLE canon_statuses (
id
Denis Burke wrote:
>
> We are now going to offer a 64-bit version of our app. As a result I need
> a 64bit version (I believe) to bundle with my 64bit Windows app which uses
> System.Data.SQLite of the 64-bit flavor. When I follow these same steps
> and use the AMD 64-bit cl.exe with Visual Stu
re: extension percentile.c
I can compile successfully by putting percentile.c in the same directory as
the amalgamation and giving the Visual Studio Command Prompt the command
"cl percentile.c -link -dll -out:percentile.dll". And the output works
well with a 32-bit app.
We are now going to offer
massimo.sign...@it.abb.com wrote:
>
> Bridge references System.Data.SQLite and tries to connect to a SQLite
> database but it can't because of the System.Interop.dll not found error.
>
The System.Data.SQLite native library pre-loading feature used to use the
base directory for the application
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/02/14 23:15, big stone wrote:
> APSW looks indeed great for specialised installations.
The intention behind APSW is a Python wrapper for SQLite3. It does
everything the SQLite way where applicable. It advances with SQLite
meaning new versions
On Thu, Feb 6, 2014 at 5:36 PM, Richard Hipp wrote:
> a UNION or UNION ALL and (2) there is exactly one self-reference in the
> right-hand SELECT of the UNION or UNION ALL.
>
i see now that my example isn't actually recursive due to (2).
Thanks for the detailed explanation!
--
- stephan b
Documentation updated in an attempt to make this point clearer.
On Thu, Feb 6, 2014 at 11:36 AM, Richard Hipp wrote:
>
>
>
> On Thu, Feb 6, 2014 at 6:19 AM, Stephan Beal wrote:
>
>> Hi, all,
>>
>> these docs:
>>
>> http://www.sqlite.org/draft/lang_with.html
>>
>> state that a CTE select must be
On Thu, Feb 6, 2014 at 6:19 AM, Stephan Beal wrote:
> Hi, all,
>
> these docs:
>
> http://www.sqlite.org/draft/lang_with.html
>
> state that a CTE select must be two UNION'd selections,
It says that a *recursive* CTE must have a UNION or UNION ALL. An ordinary
CTE is not subject to that requi
On 6 Feb 2014, at 7:15am, big stone wrote:
> If we wish to have SQLite + Python combination to become "reference choice"
> in education, I would think that priority list should be :
Just to remind you that you're posting to the SQLite list. Most of those are
things that would be done by the P
Hi all,
what is needed to have application IDs registered in the magic.txt file,
as listed under the #pragma application_id?
Any formal process needed, or is an email to someone enough to do it?
Oh, and btw. there seems to be some difference between the definition
used in the magic file
(http://
Hello all.
I have a pretty basic question about threads and SQLite, here
is the short version:
When opening multiple connections to the same database using
SQLITE_OPEN_SHAREDCACHE, will SQLite automatically serialize
write transactions to the same DB while multiple connections
are attempting to p
Fixed now. Tnx.
On Wed, Feb 5, 2014 at 5:50 PM, Hautzenroeder, Brenna M
wrote:
> In the documentation for the WITH clause (
> http://www.sqlite.org/lang_with.html), under the "Controlling Depth-First
> Versus Breadth-First Search Of a Tree Using ORDER BY" section, there is a
> small error in th
Federal University Oye Ekiti conduct Third Matriculation this February visit
http://www.fuoye.edu.ng for more details
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/ORDER-BY-issue-v3-8-2-amalgamtion-tp73605p73704.html
Sent from the SQLite mailing list archive at Nabble.co
In the documentation for the WITH clause
(http://www.sqlite.org/lang_with.html), under the "Controlling Depth-First
Versus Breadth-First Search Of a Tree Using ORDER BY" section, there is a small
error in the example given:
WITH RECURSIVE
under_alice(name,level) AS (
VALUES
Hi, all,
these docs:
http://www.sqlite.org/draft/lang_with.html
state that a CTE select must be two UNION'd selections, but the following
query seems to work regardless of whether or not i've got one or two
SELECTs:
(requires a Fossil repo database and one or more valid wiki page names from
tha
Hello,
we encountered a DLL not found error in this special case, hope you guys
can help us.
We have a 32 bit Delphi application which calls via COM interface a .NET
DLL called let's say "Bridge".
Bridge references System.Data.SQLite and tries to connect to a SQLite
database but it can't becau
18 matches
Mail list logo