Re: [sqlite] Random locking errors using Sqlite.NET

2014-11-04 Thread Mike King
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

Re: [sqlite] Database Grammar 101

2014-02-05 Thread Mike King
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

Re: [sqlite] Proposed enhancement to the sqlite3.exe command-line shell

2014-02-10 Thread Mike King
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

Re: [sqlite] Question : how to retrieve a byte array

2014-04-29 Thread Mike King
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

[sqlite] Warning when querying FTS3 table

2013-01-12 Thread Mike King
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

Re: [sqlite] match on single column but with multiple value

2013-02-10 Thread Mike King
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.

[sqlite] Stemming Query

2013-02-12 Thread Mike King
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

Re: [sqlite] Stemming Query

2013-02-12 Thread Mike King
Thanks for a quick answer. On Tuesday, 12 February 2013, Richard Hipp wrote: > On Tue, Feb 12, 2013 at 5:50 PM, Mike King > <making1...@gmail.com<javascript:;>> > wrote: > > > Is there any way to turn stemming on/off for a FTS3 table? I create my > FTS3 >

[sqlite] FTS3 prefix wildcard

2013-02-22 Thread Mike King
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

Re: [sqlite] Sqlite .net 4.0 provider needed

2013-03-06 Thread Mike King
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 > > >

Re: [sqlite] Sqlite .net 4.0 provider needed

2013-03-06 Thread Mike King
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 > > > > --

Re: [sqlite] How to write store-procedure in SQLite.net

2013-03-25 Thread Mike King
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

[sqlite] Possible enhancement request.

2012-01-13 Thread Mike King
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

[sqlite] GROUP BY question

2012-05-24 Thread Mike King
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;

Re: [sqlite] GROUP BY question

2012-05-24 Thread Mike King
Thanks everyone! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-17 Thread Mike King
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,

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King
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 <making1...@gmail.com <javascript:;>> > wrote: > > > I'm using the la

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King
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 <sql...@mistachkin.com> wrote: > &g

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King
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 <sql...@mistachkin.com> wrote: > > Mike King wrote: >> >> Thanks - sorry to be a pain but is this on the roadmap for the future? >&

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King
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 <d...@sqlite.org> wrote: > On Thu, Oct 18, 2012 at 9:03 AM, Mike King <making1...@gmail.com> wrote: > >

Re: [sqlite] How to get row number of an ID in sorted results

2016-11-13 Thread Mike King
so I can calculate the page. Cheers On Sun, 13 Nov 2016 at 23:26, Igor Tandetnik <i...@tandetnik.org> 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 un

[sqlite] How to get row number of an ID in sorted results

2016-11-13 Thread Mike King
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

Re: [sqlite] How to get row number of an ID in sorted results

2016-11-13 Thread Mike King
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 <i...@tandetnik.org> wrote: > On 11/13/2016 12:29 PM, Mike King wrote

Re: [sqlite] How to get row number of an ID in sorted results

2016-11-13 Thread Mike King
a record based on the sort criteria. Thanks for your help On 13 November 2016 at 19:47, Igor Tandetnik <i...@tandetnik.org> 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 an

Re: [sqlite] How to get row number of an ID in sorted results

2016-11-13 Thread Mike King
to effectively do the same query in code surely? Thanks again Mike On Sun, 13 Nov 2016 at 18:55, R Smith <rsm...@rsweb.co.za> wrote: > > > On 2016/11/13 7:29 PM, Mike King wrote: > > I have a table (test) with 3 columns (ID - auto incrementing, Value1 - > Text > > a

[sqlite] Incremental BLOB IO

2017-03-14 Thread Mike King
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

Re: [sqlite] Many ML emails going to GMail's SPAM

2017-11-21 Thread Mike King
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

Re: [sqlite] Use with Visual Studio

2018-07-09 Thread Mike King
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

Re: [sqlite] BF Interpreter

2018-03-01 Thread Mike King
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

Re: [sqlite] Regarding CoC

2018-10-25 Thread Mike King
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

Re: [sqlite] Regarding CoC

2018-10-25 Thread Mike King
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.

Re: [sqlite] Help!

2018-11-06 Thread Mike King
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)

Re: [sqlite] Typo

2018-12-25 Thread Mike King
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

Re: [sqlite] Typo

2018-12-25 Thread Mike King
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 :) > >

Re: [sqlite] SQlite.NET.chm

2019-01-09 Thread Mike King
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

Re: [sqlite] library interfering with input function when running in python console

2019-03-22 Thread Mike King
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,

Re: [sqlite] SQLite4 version

2019-05-29 Thread Mike King
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

Re: [sqlite] RFE: allow parameters in PRAGMA statements

2019-06-11 Thread Mike King
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: >

Re: [sqlite] Entity Framework Core support

2019-11-17 Thread Mike King
net/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 to c

Re: [sqlite] Entity Framework Core support

2019-11-17 Thread Mike King
, 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 > ___ sqlit

[sqlite] Entity Framework Core support

2019-11-14 Thread Mike King
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

Re: [sqlite] Securing user supplied SQL statements in a single process

2019-12-12 Thread Mike King
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

Re: [sqlite] Securing user supplied SQL statements in a single process

2019-12-12 Thread Mike King
this was 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

Re: [sqlite] Securing user supplied SQL statements in a single process

2019-12-12 Thread Mike King
egex.Escape(bool.TrueString.Substring(0, 1))})| (?{Regex.Escape(bool.FalseString.Substring(0, 1))})| (?\))| (?,)| (?=)| (?\>)| (?\<)| (?\())"; On Thu, 12 Dec 2019 at 20:06, Mike King wrot

Re: [sqlite] Entity Framework Core support

2019-11-18 Thread Mike King
ts / 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: > > > > "It needs t

[sqlite] Hex Password with System.Data.Sqlite (.Net Core)

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

[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

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

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

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

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

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

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 - > &

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Mike King
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.