As an occasional poster I like the idea of a forum as for me it's easier to
dip in and follow threads (after lots of years of using System.Data.Sqlite
I'm reluctantly moving over to using the Microsoft drivers because it
supports EF Core).
For the look and feel, it's plain but it's functional. I'm
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 -
> &
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 encrypt
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
0 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
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
S
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
?N)|
(?{Regex.Escape(bool.TrueString.Substring(0,
1))})|
(?{Regex.Escape(bool.FalseString.Substring(0,
1))})|
(?\))|
(?,)|
(?=)|
(?\>)|
(?\<)|
(?\())";
On Thu, 12 Dec 2019
possible and I just added my experiences to show it is
possible with a little thought.
Cheers
On Thu, 12 Dec 2019 at 19:29, Warren Young wrote:
> On Dec 12, 2019, at 6:08 AM, Mike King wrote:
> >
> > ...I decided on a simple subset of
> > SQL and then wrote a parser using a r
I had to do something similar. I’m the end I decided on a simple subset of
SQL and then wrote a parser using a regex as the tokeniser. The output was
SQL. By doing it this way I could validate field names and make sure all
values were correctly formatted and escaped.
Cheers
On Thu, 12 Dec 2019 at
;"; // rekey sets / changes password
//command.Parameters.Clear();
//command.ExecuteNonQuery();
optionsBuilder.UseSqlite(conn);
}
}
Cheers,
Mike
On Mon, 18 Nov 2019 at 01:24, Joe Mistachkin wrote:
>
> Mike King wrote:
> >
> &
ft.com/dotnet/announcing-ef-core-3-0-and-ef-6-3-general-availability/
*2 https://github.com/aspnet/EntityFramework6/issues/834
*3 https://docs.microsoft.com/en-us/ef/efcore-and-ef6/
On Sun, 17 Nov 2019 at 23:08, Joe Mistachkin wrote:
>
> Mike King wrote:
> >
> > Sorry t
00:02, Mike King wrote:
> Hi All,
>
> I can see System.Data.Sqlite supports Entity Framework 6. Are there any
> plans to support Entity Framework Core?
>
> Apologies if this is a basic question!
>
> Cheers,
>
> Mike
>
___
Hi All,
I can see System.Data.Sqlite supports Entity Framework 6. Are there any
plans to support Entity Framework Core?
Apologies if this is a basic question!
Cheers,
Mike
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://maili
I’ve got a similar issue. I user user_version to store a .net version
object I’ve serialised as an int. I convert them to/from text to get them
in and out using the pragma. It would be a nice to have for pragmas to
support parameters.
Cheers
On Tue, 11 Jun 2019 at 14:43, Wout Mertens wrote:
> H
Would it make sense for DRH to rename V4 to something else? For the
uninitiated it’s not always apparent that V3 is what you should be using.
Cheers
On Wed, 29 May 2019 at 14:03, Warren Young wrote:
> On May 29, 2019, at 6:16 AM, Simon Slavin wrote:
> >
> > There may one day be a release of SQ
I think this is a problem with the Python SQLite wrapper you are using not
SQLite itself. Maybe a better place to ask would be on their mailing list.
Also, consider giving a bit more detail as to why it fails as this may help
them diagnose the issue.
Cheers
Mike
On Fri, 22 Mar 2019 at 15:10, Ant
From memory a file is marked as blocked by a hidden file stream attached to
the file. That’s why using cp removed the block as I guess it doesn’t
understand file streams.
Cheers
On Wed, 9 Jan 2019 at 21:49, Simon Slavin wrote:
> On 9 Jan 2019, at 9:33pm, Don V Nielsen wrote:
>
> > Is the chm f
Sadly by the time you get here it will be over for another year. Still
seasons greetings from the UK.
On Tue, 25 Dec 2018 at 13:45, Richard Hipp wrote:
> On 12/25/18, Mike King wrote:
> > It’s
> > Christmas Day so surely you deserve a mince pie and a fine single malt :)
>
>
Surely I speak for all of when I say I hope you have a fantastic Christmas
Richard and thanks for everything you do. Do you ever stop though? It’s
Christmas Day so surely you deserve a mince pie and a fine single malt :)
Cheers
On Tue, 25 Dec 2018 at 11:18, Richard Hipp wrote:
> Thanks. Fixed
Hi,
Surely it’s just a case of attaching the database file as an attachment to
the e-mail.
Cheers
On Tue, 6 Nov 2018 at 19:52, am...@juno.com wrote:
> November 6, 2018 Dear Good People: I would be most appreciative if any of
> you how know how to take a database in database (not structure) for
I’m more a Mr Creosote kind of guy. Wafer thin mint anybody? :)
On Thu, 25 Oct 2018 at 12:08, Petite Abeille
wrote:
>
>
> > On Oct 25, 2018, at 12:59 PM, Mike King wrote:
> >
> > The beer is bloody good and very strong.
>
> "Beer is proof that Go
I’m a good atheist but I love the CoC. Not bothered by the religious bits
but I get the sentiment. I guess it appeals to my British sense of irony
and odd sense of humour :)
As for the Trappist beer our local Monastery (St Bernards, Whitwick) has
just started the first trappist brewery in the uk.
Same here. Again, I download it from the main system.data site. No problems
at all.
Cheers
On Mon, 9 Jul 2018 at 06:57, Chris Locke wrote:
> I use system.data.sqlite.dll (taken from here:
> https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki)
> with no problems in both VS 201
Wow. That’s impressive
On Thu, 1 Mar 2018 at 09:49, Chris Locke wrote:
> "Thats the beauty of it. It doesn't *do* anything." ;)
>
>
>
> On Thu, Mar 1, 2018 at 6:55 AM, Gary Briggs wrote:
>
> > Thanks to the help the other day with the strange concatentation result.
> >
> > I was referring to
In the UK we’ve still got a threaded conferencing service called CIX must
be over 30 years old now (it was based on BIX / Cosy). The joke is it’s the
UKs oldest online social network :)
Another vote for a threaded forum here. I do try and keep up with the ML
but if it was threaded it would be a lo
Hi,
I'm trying to understand incremental BLOB IO using the latest
System.Data.Sqlite and C#.
I've got some test code working where I can execute a query and using a
data reader get a SQLiteBlob object and read the blob back. However, I'm
not clear as to how I can use incremental IO if I'm doing a
so I can calculate the page.
Cheers
On Sun, 13 Nov 2016 at 23:26, Igor Tandetnik wrote:
> On 11/13/2016 6:17 PM, Mike King wrote:
> > Sorry to reply again so soon. I'm just playing about with your query. The
> > values in Value1 and Value2 are not unique so I don't th
Sorry to reply again so soon. I'm just playing about with your query. The
values in Value1 and Value2 are not unique so I don't think your method
would work.
Cheers,
On 13 November 2016 at 19:47, Igor Tandetnik wrote:
> On 11/13/2016 12:29 PM, Mike King wrote:
>
&
ery to select
a record based on the sort criteria.
Thanks for your help
On 13 November 2016 at 19:47, Igor Tandetnik wrote:
> On 11/13/2016 12:29 PM, Mike King wrote:
>
>> So, after some experimentation, I'm using a temporary table to hold the
>> ordered IDs and then gett
ve to effectively do the same query in code surely?
Thanks again
Mike
On Sun, 13 Nov 2016 at 18:55, R Smith wrote:
>
>
> On 2016/11/13 7:29 PM, Mike King wrote:
> > I have a table (test) with 3 columns (ID - auto incrementing, Value1 -
> Text
> > and Value2 - Text).
I have a table (test) with 3 columns (ID - auto incrementing, Value1 - Text
and Value2 - Text). After doing an order by in a select query I'd like to
know the row number that contains a particular ID.
(The real world use is this: I have an application which displays paged
lists of results. If you
Are you accessing data off the share as well? The Sqlite website is quite
categoric that this is not a recommended mode of operation. Also given the
database locks when a record is written it is entirely possible one user is
locking the table.
Cheers,
Mike
On Tuesday, 4 November 2014, Mike McWhin
I'm not sure this sounds like a SQLite issue but I think File.ReadAllBytes
and File.WriteAllBytes in the System.IO namespace may do what you want.
Cheers,
On 28 April 2014 22:58, Denis Bezeau wrote:
> Hi, I am currently working on a video game using sqlite3, and I am having
> an issue when sa
Why not show the warning on exit only if an in memory database is in use.
Likewise by default open in memory unless a path is specified.
On Monday, 10 February 2014, Richard Hipp wrote:
> On Mon, Feb 10, 2014 at 12:51 PM, > wrote:
>
> > I second the idea of a kind of "WARNING: All your work will
I've followed this thread with some interest and I think you are all
wrong... All discussion should be in English, that's UK English as spoken
by us Brits not the bastardisation of our glorious language that is
American English.
I put it to the list that Colour should be spelt with a U, same for
C
SQLite doesn't have stored procedures. If you are using a .Net language
such as C# then you can create your own custom functions which may do what
you want. See the link below for an example.
http://stackoverflow.com/questions/172735/create-use-user-defined-functions-in-system-data-sqlite
On 25
Use the official System.Data.Sqlite provider.
http://system.data.sqlite.org
Cheers,
Mike
On 6 March 2013 11:44, moumita wrote:
> Hi,
>
> I want to user sqlite .net 4.0 provider. from where get that one? Please
> help me in this regards.
>
> Thanks,
> Moumita
>
>
>
> --
> View this message in co
Use the official System.Data.Sqlite provider.
http://system.data.sqlite.org
Cheers,
Mike
On 6 March 2013 11:44, moumita wrote:
> Hi,
>
> I want to user sqlite .net 4.0 provider. from where get that one? Please
> help me in this regards.
>
> Thanks,
> Moumita
>
>
>
> --
> View this message i
Hi All,
A user wants to be able to query my FTS3 database using a preceeding
wildcard. From reading back through the mailing list it looks like SQLite
may not support this (for very understandable reasons) but I cannot find
any mention of this in the docs. Is this limitation?
To get round this I
Thanks for a quick answer.
On Tuesday, 12 February 2013, Richard Hipp wrote:
> On Tue, Feb 12, 2013 at 5:50 PM, Mike King
> >
> wrote:
>
> > Is there any way to turn stemming on/off for a FTS3 table? I create my
> FTS3
> > table as follows:
> >
> >
Is there any way to turn stemming on/off for a FTS3 table? I create my FTS3
table as follows:
CREATE VIRTUAL TABLE FreeText USING fts3(Content TEXT NOT NULL,
tokenize=porter)
I'd like to be able to offer the option of whether to use stemming when
searching (much like some other freetext databases
Select * from tbl where col1 in ('a', 'b', 'c')
On Sunday, 10 February 2013, e-mail mgbg25171 wrote:
> Sorry if this is a very basic question but I'm just wondering if there's a
> more elegant way of doing this
>
> select * from tbl where col1 = 'a' or col1 = 'b' or col1 = 'c'
>
> i.e. selectin
Hi All,
I'm using the latest System.Data.SQlite downloaded from the website.
When I query a FTS3 table (called FreeText) using the code below I get
the following warning in the VS output window.
SQLite error (1): no such table: main.FreeText_stat
>From reading the docs I believe FreeText_stat is
I'd missed that - The devil is always in the detail (cue Homer Simpson "DOH!")
Thanks again and sorry to be a nuisance
On 18 October 2012 14:35, Richard Hipp wrote:
> On Thu, Oct 18, 2012 at 9:03 AM, Mike King wrote:
>
>> At the moment it's difficult to tel
At the moment it's difficult to tell but I envisage 3-4gb being the maximum.
Cheers,
Mike
On 18 October 2012 13:17, Joe Mistachkin wrote:
>
> Mike King wrote:
>>
>> Thanks - sorry to be a pain but is this on the roadmap for the future?
>> (For the thing I'm p
Thanks - sorry to be a pain but is this on the roadmap for the future?
(For the thing I'm playing with this is the difference between storing
images in the database or storing them in the filesystem).
Cheers,
On 18 October 2012 11:23, Joe Mistachkin wrote:
>
> Mike King wrote:
&
That's great to know but is this supported in system.data.sqlite or is
there any plans to do so?
Cheers
On Thursday, 18 October 2012, Simon Slavin wrote:
>
> On 17 Oct 2012, at 11:59pm, Mike King >
> wrote:
>
> > I'm using the latest System.Data.Sqlite with c# a
Hi All,
I'm using the latest System.Data.Sqlite with c# and .Net 4.
Is there any method of writing to a BLOB in byte array chunks rather
than in one big lump? (I can see how using SQLiteDataReader GetBytes I
can read a blob back in chunks).
Best Regards,
_
Thanks everyone!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Is this Select statement valid? In Oracle, it wouldn't be because
what is the aggregate of A. Is this behavior defined anywhere?
create table T (A,B);
insert into T (A,B) values (1,3);
insert into T (A,B) values (2,3);
select A,B
from T
group by B;
Hi All,
This is my first post here so please be gentle!
I'd like to make a suggestion for a future enhancement.I'm using the latest
System.Data.Sqlite and C#, I've got a small database with a freetext (FTS3)
table. When I query this table I use the Offsets function to get the
position of the matc
52 matches
Mail list logo
