Re: [sqlite] Question about passwords in System.Data.Sqlite
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 looks like what actually happened is that “password” happened to be the first word on a line followed by two other words. (Thus “(2, 2)” at the top of that file.) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 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 — but it’s only a matter of time > before it’s added. > > It’s appeared five times in the Corpus of Contemporary American English > since 2001, and that’s a lagging indicator of usage in the wider culture: > > https://www.english-corpora.org/coca/ > > The term was commonly used at the high water mark of Usenet, the mid > 1990s. There are 156 hits on faqs.org, which serves the old Usenet FAQs. > > There’s a crowdsourced definition here, which is correct by my > understanding of the term: > > https://www.wordnik.com/words/administrivia > > …but to drag this back on topic for the mailing list, the definition that > matters is this one: > > > https://mailman.readthedocs.io/en/latest/src/mailman/rules/docs/administrivia.html > > You’d have to tell us the subject you sent twice before for us to tell you > which GNU Mailman administrivia rule you got caught by. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 — but it’s only a matter of time before it’s added. It’s appeared five times in the Corpus of Contemporary American English since 2001, and that’s a lagging indicator of usage in the wider culture: https://www.english-corpora.org/coca/ The term was commonly used at the high water mark of Usenet, the mid 1990s. There are 156 hits on faqs.org, which serves the old Usenet FAQs. There’s a crowdsourced definition here, which is correct by my understanding of the term: https://www.wordnik.com/words/administrivia …but to drag this back on topic for the mailing list, the definition that matters is this one: https://mailman.readthedocs.io/en/latest/src/mailman/rules/docs/administrivia.html You’d have to tell us the subject you sent twice before for us to tell you which GNU Mailman administrivia rule you got caught by. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 passwords. Assuming it is supported then one sends blobs the way one always sends arbitrary blobs: pragma key=X'0123456789ABCDEF'; -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 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 > encrypted database. > > There are free encryption extensions for SQLite. But the world doesn't > seem to have standardised on any one of them. Which suggests that there's > not one of them much better than the others. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 encrypted database. There are free encryption extensions for SQLite. But the world doesn't seem to have standardised on any one of them. Which suggests that there's not one of them much better than the others. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 encryption that came with it. > > > > The CryptoAPI-based encryption included with System.Data.SQLite is a > legacy feature, has known issues, and is officially unsupported. It is > being retained only for the purpose of backward compatibility with legacy > applications that make use of it. It has not been ported to .NET Core, > nor has it been tested there. > > You might want to look into the commercial SEE extension, which does work > with System.Data.SQLite on .NET Core for all supported platforms. > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 unsupported. It is being retained only for the purpose of backward compatibility with legacy applications that make use of it. It has not been ported to .NET Core, nor has it been tested there. You might want to look into the commercial SEE extension, which does work with System.Data.SQLite on .NET Core for all supported platforms. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 Mistachkin wrote: > > 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 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 > > 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 passwords. > > > > Thanks > > ___ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about passwords in System.Data.Sqlite
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 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 > 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 passwords. > > Thanks > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users