Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-04 Thread Warren Young
On Jan 4, 2020, at 12:23 AM, Mike King wrote: > > This is the subject: > > Hex Password with System.Data.Sqlite (.Net Core) My Python-fu sucks, but I don’t think that can match the administrivia rule: https://gitlab.com/mailman/mailman/blob/master/src/mailman/rules/administrivia.py It

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-03 Thread Simon Slavin
On 4 Jan 2020, at 7:23am, Mike King wrote: > This is the subject: > > Hex Password with System.Data.Sqlite (.Net Core) I suppose the bot thought you wanted to change your password for accessing the mailing list. ___ sqlite-users mailing list

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-03 Thread Mike King
This is the subject: Hex Password with System.Data.Sqlite (.Net Core) Very to the point I’d say :) Cheers On Fri, 3 Jan 2020 at 23:10, Warren Young wrote: > On Jan 2, 2020, at 3:47 PM, Mike King wrote: > > > > ...suspected administrivia! (not sure what that is - > > I guess it's a US

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-03 Thread Warren Young
On Jan 2, 2020, at 3:47 PM, Mike King wrote: > > ...suspected administrivia! (not sure what that is - > I guess it's a US English word but it's certainly not an English one). It’s not defined in any of the mainstream dictionaries I have on my phone — three of them, because I’m a word nerd —

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-03 Thread Keith Medcalf
On Thursday, 2 January, 2020 15:48, Mike King wrote: >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 but I use hex

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Mike King
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

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Simon Slavin
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

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Mike King
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

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Joe Mistachkin
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

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Mike King
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

Re: [sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Joe Mistachkin
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

[sqlite] Question about passwords in System.Data.Sqlite

2020-01-02 Thread Mike King
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