You are using text columns as primary keys and referencing them directly in
foreign keys. This is probably not what you want, because it duplicates the
text key. Also, with foreign keys enabled, your join is not accomplishing
anything more than a direct select from joining_table, just with more
Hi List,
I have a relational table setup where I've built indexes but I'm still
seeing very slow join times on middling amounts of data. I'm guessing
I'm doing something wrong but I can't see what. (SQLite: 3.24.0)
Simplified schema as below.
The ids are 16 character hex strings. I've
On 26/11/2019 02:49, David Raymond wrote:
Dr Hipp replied to this 2 days ago with this:
Documentation fix https://www.sqlite.org/docsrc/info/a2762f031964e774
will appears in the next release.
".header" is an abbreviation for ".headers" and does exactly the same thing.
AFAIK all dot
Not the reason for the slowdown, but note that both of these are redundant:
CREATE INDEX IF NOT EXISTS data_table__data_id__pk_idx ON data_table (
data_id
);
CREATE INDEX IF NOT EXISTS ignore_me__ignored_id__pk_idx ON ignore_me (
ignored_id
);
...because you declared them as the
Greetings!
I am trying to load a DLL to the DOS tool, but it's failing. I am trying,
sqlite> .load c:\PMOProjects\sqlite3libIN sqlite3_decimal_init
Error: The specified module could not be found.
Any help would be greatly appreciated. Also, if I would like to use the call,
int
On 26 Nov 2019, at 1:37pm, Luca Scurati wrote:
> I'm trying to create a program that communicates with a SQLite database
> encrypted by a password. If I try with a db without any password it work, but
> with a database with password, after connecting, when executing the query it
> gives the
Over three years ago I asked if the official CLI tools could be compiled as a
64-bit exe.
http://sqlite.1065341.n5.nabble.com/64-bit-SQLite3-exe-tp90771.html
I thought I would ask again...
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
I'm trying to create a program that communicates with a SQLite database
encrypted by a password. If I try with a db without any password it work,
but with a database with password, after connecting, when executing the
query it gives the error "File is not a database"
I've tried both with
On 26 Nov 2019, at 10:54pm, Enzo Madda wrote:
> Id appreciate constructive feedback or questions, thanks!
Your project is a feeder library to a SQL engine. So you might want to add to
your documentation something about how your users can avoid SQL injection
vulnerabilities. Or how your
Ah, you have missing dependancies. You need to make sure that the dependencies
can be loaded. When Windows attempts to load the module all the dependencies
must be loaded as well, otherwise the loader cannot return a handle to the
loaded module. If no module handle is returned then the
Ah-hah!
Keith Medcalf, on Tuesday, November 26, 2019 03:58 PM, wrote...
>
>
> Ah, you have missing dependancies. You need to make sure that the
> dependencies can be loaded. When Windows attempts to load the module
> all the dependencies must be loaded as well, otherwise the loader
> cannot
Keith Medcalf, on Tuesday, November 26, 2019 02:57 PM, wrote...
>
>
> Escape the reverse solstice with a duplicate reverse solstice (\ -> \\) or
> replace them
> with normal solstice (\ -> /) since Windows recognizes either as the path
> separator.
> The CLI, like most things, parses escape
Jose Isaias Cabrera, on Tuesday, November 26, 2019 03:44 PM, wrote...
> Keith Medcalf, on Tuesday, November 26, 2019 03:38 PM, wrote...
> > What is the canonical name of the file you are trying to load?
>
> c:\PMOProjects\libsqlite3decimal.dll
>
> As shown by the dir command,
>
> 15:40:36.57>dir
Hello,
Ive been working on something called the SQLite Message Passing Interface,
or SMPI for short.
It allows you to use SQLite from Javascript code in React Native apps.
There is an introduction at https://sqlitempi.com/.
Id appreciate constructive feedback or questions, thanks!
Enzo
Escape the reverse solstice with a duplicate reverse solstice (\ -> \\) or
replace them with normal solstice (\ -> /) since Windows recognizes either as
the path separator. The CLI, like most things, parses escape sequences on
input.
Same applies to the C API function. You specify the full
What is the canonical name of the file you are trying to load?
For example, if you are trying to load the file "jitterbug.dll" from the
directory "c:\a\b\c" then the canonical filename is "c:\a\b\c\jitterbug.dll"
It seems that you are being told that "c:\PMOProjects\libsqlite3decimal.dll"
>
>
Keith Medcalf, on Tuesday, November 26, 2019 03:38 PM, wrote...
>
>
> What is the canonical name of the file you are trying to load?
c:\PMOProjects\libsqlite3decimal.dll
As shown by the dir command,
15:40:36.57>dir c:\PMOProjects\libsqlite3decimal.dll
Volume in drive C is Windows
Volume
I ecnrypt the db through the DB Browser for SQLCipher tool. If I try to
access the database from this application, it works.Do you have any other
method for encrypt a SQLite db?
Il giorno mar 26 nov 2019 alle ore 18:55 Simon Slavin
ha scritto:
> On 26 Nov 2019, at 1:37pm, Luca Scurati wrote:
>
On 27 Nov 2019, at 7:22am, Luca Scurati wrote:
> I ecnrypt the db through the DB Browser for SQLCipher tool. If I try to
> access the database from this application, it works.Do you have any other
> method for encrypt a SQLite db?
SQLite databases can be encrypted in many different ways.
The
Anyway I found another library called Mono.Data.Sqlite that recognize the
SetPassworg and ChangePassword method (the two libraries listed above did
not recognize them) but it gives me the following error: Unable to find an
entry point named 'sqlite3_key' in DLL 'sqlite3'
Do you have any idea?
Il
Ok, thanks!
Il giorno mer 27 nov 2019 alle ore 08:29 Simon Slavin
ha scritto:
> On 27 Nov 2019, at 7:22am, Luca Scurati wrote:
>
> > I ecnrypt the db through the DB Browser for SQLCipher tool. If I try to
> access the database from this application, it works.Do you have any other
> method for
21 matches
Mail list logo
