sqlite3LocateTable returns generic error code 1 (SQLITE_ERROR) and error
message 'no such table'. This makes it difficult to distinguish this error
from others as in order to find that the table is missing, string parsing
of error message for 'no such table' is required.
the same applies to 'no su
Hi,
I could use the inner join for the "entrys" join and the "items" join
but not the "entry-items" join because each entry can have more than
one item.
WITH a(id, name) AS (VALUES (1, 'A')),
b(id, name) AS (VALUES (1, 'B1'), (1, 'B2'))
SELECT * FROM a INNER JOIN b USING (id);
1|
Hi,
Would anyone be able to confirm what encryption cipher is used when
SetPassword="" is set on database creation?
Regards,
Paul
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/
I am running into a problem with the following use-case:
A host application (which is a black box for me I cannot change) is loading
my plugin binaries which each have SQLite linked statically. When two
plugins now access the same database file from the process of the host
application none of the s
Andy Bennett wrote:
>> foreign key constraints
>
> my experience with other engines taught me that it makes experimenting at the
> monitor harder.
Then don't use them. :) But do you actually want 'wrong' data?
> Are there any efficiency benefits or is it just there to enforce data
> integrity?
> On Jan 23, 2019, at 8:27 AM, Carsten Müncheberg
> wrote:
>
> A host application (which is a black box for me I cannot change) is loading
> my plugin binaries which each have SQLite linked statically. When two
> plugins now access the same database file from the process of the host
> applicat
Carsten Müncheberg wrote:
> A host application (which is a black box for me I cannot change) is loading
> my plugin binaries which each have SQLite linked statically. When two
> plugins now access the same database file from the process of the host
> application none of the serialization mechanisms
I am a Big fan of the recent support for 'SQLite Archive' files.
Basically I was planning to use this as a generic version of
an "Application File Format" (sqlite.org/appfileformat.html).
As far as I can see the Archive Files functionality does always
compress the blobs if it is found that co
On Jan 22, 2019, at 9:02 AM, Simon Slavin wrote:
>
> On 22 Jan 2019, at 3:45pm, Maldonado-Salazar, Carlos
> wrote:
>
>> Is there a way to know when CoreData closes sqlite files?. I’m using
>> CoreData in an iOS app and I set file attributes for sqlite file to be
>> NSFileProtectionCompleteUn
On Oracle solaris 10 sparc with 16GB of memory I was surprised to see :
.
.
.
Time: keyword1.test 229 ms
Time: lastinsert.test 64 ms
Time: laststmtchanges.test 60 ms
(82 ms - want less than 1000) (80 ms - want less than 1000) Time:
like.test 188 ms
Time: like2.test 215 ms
Time: like3.test 56
On 1/23/19, Dennis Clarke wrote:
>
> Perhaps I was mistaken to enable --enable-tempstore=yes during configure ?
>
Maybe. Does it work if you omit that option?
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists
Hi,
I have an sqlite3 database (version 3.25.3) in tmpfs which has many readers
and writers.
The database is running in WAL mode and seems to work efficiently in that
mode.
Since the database files are in a memory based file-system, we don't care
about the usual corruption on power-cycle issues b
On 1/23/19 7:10 PM, Richard Hipp wrote:
On 1/23/19, Dennis Clarke wrote:
Perhaps I was mistaken to enable --enable-tempstore=yes during configure ?
Maybe. Does it work if you omit that option?
I just tried without and also went back to sqlite-src-324 and they
all fail in the same w
On 1/23/19 7:10 PM, Richard Hipp wrote:
On 1/23/19, Dennis Clarke wrote:
Perhaps I was mistaken to enable --enable-tempstore=yes during configure ?
Maybe. Does it work if you omit that option?
The solution seems to be to throw hardware at the problem and then it
goes away. I allocate
Robert Searle wrote:
> We have recently started trying to provide read-only access to the database
> (service run as user with group/other read access permissions under Linux,
> service not database owner) and occasionally get either
> SQLITE_READONLY_RECOVERY or SQLITE_READONLY_CANTINIT responses
On 24 Jan 2019, at 2:37am, Robert Searle wrote:
> occasionally get either
> SQLITE_READONLY_RECOVERY or SQLITE_READONLY_CANTINIT responses to select
> statements
No programmer should be seeing these. They indicate low-level errors that
cannot be handled in a systematic manner. Rather than dea
16 matches
Mail list logo