I tend to use my hobby code as an excuse to play with and learn the stuff
that I don’t use in the daily grind. It also helps me keep up to date
(hence .Net core 3.1). So, to answer your question encryption is important
:)
Cheers
Mike
On Fri, 3 Jan 2020 at 01:27, Simon Slavin wrote:
> On 3 Jan
Hi,
We found an assertion failed in sqlite. And this assertion seems not to be
fixed completely. Here’s the POC:
—
CREATE TABLE v0 ( v8 FLOAT , v7 UNIQUE ON CONFLICT ROLLBACK GENERATED ALWAYS
AS( v6 ) , v6 INT , v5 INT UNIQUE GENERATED ALWAYS AS( NULL ) , v4 INTEGER
UNIQUE , v3 DOUBLE PRIMARY
On 3 Jan 2020, at 12:44am, Mike King wrote:
> Ok thanks. As this is a hobby project I don't have any cash for commercial
> extensions.
So the question becomes whether you actually need encryption in your hobby
project, or you were just using encryption because you started off with an
Ok thanks. As this is a hobby project I don't have any cash for commercial
extensions.
Cheers
On Fri, 3 Jan 2020 at 00:18, Joe Mistachkin wrote:
>
> Mike King wrote:
> >
> > Should I be using a specific encryption extension? When I used the .Net
> > Framework SQLite lib I always used the
Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s) performance
increase.
Changing the threading mode or the indirection level of the mutexes calls seems
to have no significant effect.
--
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about
Mike King wrote:
>
> Should I be using a specific encryption extension? When I used the .Net
> Framework SQLite lib I always used the encryption that came with it.
>
The CryptoAPI-based encryption included with System.Data.SQLite is a
legacy feature, has known issues, and is officially
I'll be honest I'm not sure. I'm using the whatever encryption comes with
the nuget package for Core 3.1.
Should I be using a specific encryption extension? When I used the .Net
Framework SQLite lib I always used the encryption that came with it.
Cheers
On Thu, 2 Jan 2020 at 22:57, Joe
On 1/2/20, Barry Smith wrote:
> One thing that really stands is “creates 64 threads that operate on
> independent tables in the sqlite database, performing operations that should
> be almost entirely independent.”
>
Looking at the main.c file
Which encryption extension are you using?
Sent from my iPhone
> On Jan 2, 2020, at 5:48 PM, Mike King wrote:
>
> Hi,
>
> This is my third attempt to send the following message to the list and each
> time it gets rejected as suspected administrivia! (not sure what that is -
> I guess it's a
Hi,
This is my third attempt to send the following message to the list and each
time it gets rejected as suspected administrivia! (not sure what that is -
I guess it's a US English word but it's certainly not an English one).
I'm porting some code from .Net 4.8 to .Net Core 3.1 using the latest
One thing that really stands is “creates 64 threads that operate on independent
tables in the sqlite database, performing operations that should be almost
entirely independent.”
But that’s not how SQLite works - at least not when writing data. SQLite takes
a lock on the entire database, there
I asked for some information from Emery Berger about his video talk on
performance where he said they got a 25% improvement in SQLite performance.
Here is the reply I got back.
I know there has been a lot of talk about what can and cannot be done with the
C calling interface because of
Hi,
We found an undefined behavior in sqlite. Here’s the POC:
—
DELETE FROM zipfile WHERE NULL BETWEEN ( 2) AND 1 ;
—-
When compiled with `-fsanitize=address`, it got a crash. We found that it’s
because it tries to use `fopen64(NULL, “ab+”)` in zipfileBegin. And fopen64
with NULL seems an
Dr. Hipp, and the SQLite team, the sqlite-users group, happy new year! I wish
the best for everyone here, but better yet, that you find TRUE not be FALSE.
josé
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
D Burgess, on Wednesday, January 1, 2020 08:19 PM, wrote...
>
> > I’ve spent too much time lately trying to figure out or debug
> hellacious C spaghetti code
>
> And I’ve spent too much time lately trying to figure out or debug
> hellacious C++ spaghetti code
>
> Someone who writes bad C, will
Hi all,
I believe that I have found a bug in the virtual table bytecode generation
when OR constraints are present and argvIndex is set in xBestIndex but the
application does not actually filter fully.
The problem seems to be in not setting/unsetting the non-null flag
correctly
I'm porting some code from .Net 4.8 to .Net Core 3.1 using the latest
System.Data.Sqlite. How do I change / set a database password if my
password is a byte array? (It looks like I can use Pragma Key= if my
password is text).
Many Thanks, Happy New Year and apologies if this has been asked before
El 31/12/19 a les 4:06, Keith Medcalf ha escrit:
On Monday, 30 December, 2019 19:29, Michael Falconer
wrote:
As we approach the end of yet another year ( and indeed decade ).
Technically, every year is the end of a decade, if one means the immediately
preceding ten years.
However, if
> Obviously the character(s) responsible for dates etc were NOT C programmers!
No, they still using Roman Numerals instead of Indian Numbers and were
oblivious of the number 0. As indeed Abu Dschaʿfar Muhammad ibn Musa
al-Chwārizmī published his book "De numero Indorum" (the earliest latin
19 matches
Mail list logo