it's functional. I'm reminded of the
quote from Deng Xiaoping "No matter if it is a white cat or a black cat;
as long as it can catch mice, it is a good cat."
Cheers,
Mike
On Thu, 12 Mar 2020 at 20:18, Richard Hipp wrote:
> I have set up an on-line forum as a replacemen
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 -
> &
UPDATE CASCADE" action is considered to be the
statement causing the trigger to fire, meaning the default conflict
handling policy of ABORT is used? If so, is there any way to write
something like "ON UPDATE CASCADE OR REPLACE"? My current workaround is to
just manually delete from cha
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
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
e that "Each index name must be unique in the database"?
I was able to use the output of the qwk script to create an inspectable
sqlite database without the process generating complaints about named
indexes already existing.
Thanks!
-Mike
__
(This was for a
personal project)
Cheers,
Mike
// setup the regex for tokenising the query.
//
// i. \G means match at the start of where the previous match finished
//
// ii. We used named groups (?<> with names that match the TokenTypes
enum so we can tell which command has been matche
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:
> >
> &
because it's a new code base, it also lacks some features that EF6 has." *3
EF6 is going to be legacy, the best practice is now to use EFCore for new
projects. Is this something which you should be considering putting in your
roadmap?
Thanks,
Mike
sources:
*1
https://devblogs.microso
Hi,
Sorry to chase an answer but is there any plans to support Entity Framework
Core in the roadmap? As I understand it the current version of EF6 is
probably going to be the last and it's likely that MS is going to recommend
people move over to Core.
Cheers,
Mike
On Fri, 15 Nov 2019 at
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
don't
> enjoy using 3rd-party mirrors for searching it. I'd like to propose that we
> upgrade to something more modern and secure like Sympa or mlmmj, or even a
> more drastic system upgrade to something like Redmine -- a project
> tracker + forum.
>
> On Fri,
Apologies if this has been asked before but what is the reason that the SQLite
mailing list archives, linked at
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users, are
private for members only in order to be read? The archives can be viewed at a
mirror such as http://sqlite.10
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
ch on 2019-03-28, but there's no SQLite release on that
date. My theory is that it is resolved in the 3.28 SQLite release (rather than
on that date), but I'd like confirmation as the release notes for 3.27 and 3.28
don't reference it.
Thanks,
Mike Nicolino
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
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
. The beer is bloody good
and very strong. Also, I’m happy to report I didn’t go up in flames when I
went there and purchased a case :)
Cheers (hic!)
Mike
On Thu, 25 Oct 2018 at 11:33, Petite Abeille
wrote:
>
>
> > On Oct 25, 2018, at 8:33 AM, Philip Warner wrote:
> &g
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
Has there been any thought of implementing some kind of stored procedure
feature for SQLite?
Or does this feature exist in some other form, with another name?
--
Mike Clark
Twitter: @Cyberherbalist
Blog: Cyberherbalist's Blog <http://www.cyberherbalist.co>
-
"Free will,
(Sent this about 2 wks ago, but it never posted to the list and no
moderator response either).
--
Mike Clark
Twitter: @Cyberherbalist
Blog: Cyberherbalist's Blog <http://www.cyberherbalist.co>
-
"Free will, though it makes evil possible, is also the only thing that
makes
I found this on Stackoverflow:
DELETE FROM your_table;DELETE FROM sqlite_sequence WHERE name =
'your_table';
But when I try to run it I get "table not found". Has this been superseded?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
}
catch (Exception ex)
{
result = false;
}
}
return result;
}
--
Mike Clark <http://www.mikeclark.co>
y interested in resources that use C#.
I've been working with "Using SQLite" by Jay A. Kreibich, and it's very
useful, but if there's something more advanced I'd love to know about it.
Thanks!
--
Mike Clark <http://www.mikeclark.co>
Twitter
electrons were terribly inconvenienced.
mike(the uber geek)
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I want to write a program that generates insert & update statements for a
table.
what internal table would I query to get the column names in a table?
--
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cg
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
lot easier.
Cheers,
Mike
On Tue, 21 Nov 2017 at 17:20, Paul Sanderson
wrote:
> What about some sort of poll.
>
> Mail lists might work but the additonal functionality offered by a forum (I
> am a member of many) makes them my choice.
>
> Paul
> www.sandersonforensics.c
or tell me how to remove myself
On Sat Jun 17 2017 14:04:02 GMT-0500 (Eastern Standard Time), Mike Henry
wrote:
thanks
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite
thanks
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
what does this error mean and how can I fix it?java.sql.SQLException: opening
db: './MHDB.db': open failed: EROFS (Read-only file system)
On Sat Jun 17 2017 07:17:30 GMT-0500 (Eastern Standard Time), Robert M. Münch
wrote:
On 17 Jun 2017, at 14:10, Igor Tandetnik wrote:
> I don't think so. T
IO if I'm doing an Insert of a
new record.
I appreciate it's a really cheeky thing to ask, but does anybody have an
example of this?
Cheers,
Mike
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org
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
Thanks. I didn't think of "CTEs" either. I need to read up on them.
Mike
> On Sep 12, 2016, at 08:49, Dominique Devienne wrote:
>
>> On Sun, Sep 11, 2016 at 11:48 PM, mikeegg1 wrote:
>>
>> I think Oracle (a long distant memory) has variables like
Duh. What a brilliant idea. Wish I had thought of it. :) Thanks.
Mike
> On Sep 12, 2016, at 08:02, David Bicking wrote:
>
> Sqlite doesn't have variable. While last row id is available other ways, a
> trick to emulate a variable is to create a temp table with one field. You
thing changed that now makes it
possible for the LIKE constraint to be sent to virtual tables?
Thanks,
Mike Nicolino
On 3/5/15, Mike Nicolino wrote:
> I'm using System.Data.SQLite version 1.0.95.0 and have what appears to
> be a bug with Virtual Tables. Queries using 'like'
requirement, I expect it would be easier/safer to make
use of SEE in both System.Data.SQLite and your C++ implementation to ensure the
encryption modules are compatible.
Thanks,
Mike Nicolino
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun
e that the enterprise version of SQLCipher lists
a FIPS version; I was hoping we could keep our current implementation which
uses SEE however).
I'm considering a local modification to SEE to have it call the Windows APIs
rather that doing its own encryption; has anyone tried such a thing before
On 04/06/2016 10:33 AM, Richard Hipp wrote:
> On 4/4/16, Mike Bayer wrote:
>> The "type" column in PRAGMA table_info() is now a blank string when the
>> target object is a view in 3.12.0. In 3.11.0 and prior versions, the
>> typing information is returned,
>>
es at mailinglists.sqlite.org] Im Auftrag von Mike
> Bayer
> Gesendet: Dienstag, 05. April 2016 21:46
> An: sqlite-users at mailinglists.sqlite.org
> Betreff: Re: [sqlite] regression in 3.12.0 vs. 3.11.0, column type
> information in PRAGMA missing
>
>
>
> On 04/05/2016 0
On 04/05/2016 01:19 PM, Richard Hipp wrote:
> On 4/4/16, Mike Bayer wrote:
>> The "type" column in PRAGMA table_info() is now a blank string when the
>> target object is a view in 3.12.0. In 3.11.0 and prior versions, the
>> typing information is returned,
>>
On 04/05/2016 10:43 AM, Cezary H. Noweta wrote:
>
> IMHO, this described by you behavior can be considered as a bug in
> ``PRAGMA table_info'', which takes column's affinity from ``CREATE
> TABLE'' command only as for now.
OK...so *that* is a change. Is *that* by design, and if so should that
The "type" column in PRAGMA table_info() is now a blank string when the
target object is a view in 3.12.0. In 3.11.0 and prior versions, the
typing information is returned,
Version 3.11.0:
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
Connected to a transient in-memo
Hello,
I am using SQLite in a Windows environment. The file storing the database is on
a Windows 2008 server.All other file access to this server is reasonably fast.
However, when doing simple SELECTS and INSERTS/UPDATESit is noticeably slower
on a network. I am talking about 50 records.
Now I h
Hello,
I am trying to troubleshoot a problem that I'm having with a program
usingSQLite over a wireless network.? I know that wireless networks can
havetheir own sets of issues that cause database access problems.
What is happening is that something that takes 1 or 2 seconds on a wirednetwork
wi
faster than
SQLite, after I get the average value, how can I return the result immediately
without SQLite going through the aggregator avg()?
What are your queries like when you "pass arbitrary specialized queries
directly to my virtual table"?
Thanks,
-C.Lin
2015-06-17 8:48 GMT-07:0
The override of match() trick works pretty well for cases like this. I've
overridden match in my virtual table implementation to allow me to pass
arbitrary specialized queries directly to my virtual table modules for cases
that I know the virtual table can do a better job that SQLite on that qu
Hellom,
I am using the c# variant of sqlite (system.sqlite.data.org) and am using a
connection string similar to this:
public static string OMconnectionString = "datasource=database.db; Default
Timeout=20; PRAGMA busy_timeout = 600; PRAGMA synchronous=Off";
I then use the following statements to
es at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe
Mistachkin
Sent: Tuesday, May 12, 2015 8:43 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] System.Data.SQLite, Virtual Tables, and
ThreadAbortException Issues
Mike Nicolino
Hey Everyone,
For reference I'm using version 1.0.95.0 of System.Data.SQLite.
I've got System.Data.SQLite embedded in our cloud web service using virtual
table modules to access our various data sources. Our IIS is configured to
abort requests that exceed a maximum time threshold (required for
(expected, ok)
3.8.7.2: 1 row (wrong)
3.8.9: 1 row (wrong)
Tested with Windows shell binaries.
Mike
dex Bug in system.data.sqlite/sqlite
with 'like'
On Mar 5, 2015, at 12:30 PM, Mike Nicolino
wrote:
> I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a
> bug with Virtual Tables. Queries using 'like' in the where clause are not
> gett
ite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: Thursday, March 05, 2015 10:46 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite
with
1.0.96.0 is already released and its bug fix only per the release notes:
System.Data.SQLite version 1.0.96.0 (with SQLite 3.8.8.3) is now available on
the System.Data.SQLite website:
https://system.data.sqlite.org/
Further information about this release can be seen at
https://system.
I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a bug
with Virtual Tables. Queries using 'like' in the where clause are not getting
the like clause passed to BestIndex as a query constraint. Specifically:
- Simple query: select * from foo where name like 'a%
Okay, I blocked the sqlite-users at sqlite.org address in the to address
so if it is sent alone, it will be blocked.
On Mon, Mar 2, 2015 at 9:46 PM, Mike Owens wrote:
> Oh okay. I see. I'll look into it.
>
> On Mon, Mar 2, 2015 at 9:23 PM, Darren Duncan
> wrote:
>>
&g
This is a test. The sqlite-users at sqlite.org address has been blocked.
Only sqlite-users at mailinglists.sqlite.org should be allowed through.
Mike
Duncan
>
>
> On 2015-03-02 7:10 PM, Mike Owens wrote:
>
>> The problem is that this is the very bone of contention in the reply-to
>> religious war. Is it not? I may be wrong, but I thought this is the very
>> setting that people get so defensive about changing. As we ha
> On 2015-03-02 6:14 PM, Mike Owens wrote:
>
>> On Mon, Mar 2, 2015 at 5:27 PM, R.Smith wrote:
>>
>>> Ah, thank you, all makes sense now. If you change the first option to YES
>>> then nobody else's quirky reply-to headers will get into the list, and
>>
still peak through.
>
That's as much as I'll say about that.
> Thanks again Mike for the list maintenance and the quick replies!
>
My pleasure. The SQLite community is a delight to work with. It's always
seemed to be composed of intelligent, well-behaved people.
>
;s are doing this. I just answered an off-list email from
somebody and the reply to was set to the sqlite-users at sqlite.org email,
which makes me think it is the MUA and not Mailman.
Mike
gt; thinking there is not a single good reason to keep the situation (unless
> someone can show the opposite).
>
>
>
>
>> On 2015-03-02 10:37 AM, Mike Owens wrote:
>>
>>> For what it is worth, the move to mailinglists.sqlite.org is a result of
>>> th
List" button (Thunderbird) which replies
> > correctly,
>
> Note that that is considered extremely anti-social in many cases,
> because it cuts some people out of discussions entirely. See
> http://david.woodhou.se/reply-to-list.html for a full discussion.
>
> --
> dwmw2
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
Mike
Please remove me from all of your email lists.
Thanks
and I expect it'll go through.
>>
>> Simon.
>>
>>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
Mike
This sounds like a problem with the connection string being passed to
SQLiteConnection. Your attached package didn't come through, so could you send
the connection string you're using?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On
gt;SQLiteModule.DeclareTable
> >
> >I have always wondered why people will insist on using human readable
> >column names (with embedded spaces and special characters) in the
> >implementation layer (SQL code) instead of the presentation layer
> >(user interface)
Figured this one out. DeclareTable doesn't like any 'quoting' around the
column names in the sql. It works fine with just straight column names.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Mike Nicolino
I'm getting an exception calling SQLiteModule.DeclareTable that seems to imply
the 'create table' sql being passed is invalid: "SQL logic error or missing
database". Yet using that same sql on the same connection as a create table
call succeeds. Reviewing the virtual table docs don't imply the
Does anyone by chance know of an example of implementing virtual tables with
System.Data.Sqlite? The help docs are decent, but seeing an example
implementation would be quite helpful to tie it all together.
Thanks!
___
sqlite-users mailing list
sqlit
I still get the crashes even after adding the pragma.
My connection string looks like:
public static string OMconnectionString = "URI=file:omm.db; PRAGMA busy_timeout
= 15000"
Is there anything else I can try?
Mike
On Wednesday, November 26, 2014 10:34 AM, Simon Slavin
wrote:
e any other
PRAGMA or connection string
statements that can help with this concurrency issue?
Thanks
Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am using Sqlite.NET client in C#. How would I go about defining a sqlite busy
timeout handler?
Thanks
Mike
On Monday, November 10, 2014 1:35 PM, Tim Streater
wrote:
On 10 Nov 2014 at 18:22, Mike McWhinney wrote:
> So SQLite shouldn't be used at all on a network? Aren
So SQLite shouldn't be used at all on a network? Aren't there any other
provisions to handled the locking errors if/when
they occur?
On Monday, November 10, 2014 12:10 PM, Roger Binns
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/10/2014 09:41 AM, Mike McWhi
SQLiteCommand command = new SQLiteCommand(sql, OMConnection.sqConn);
int numRowsAffected = 0;
SQLiteTransaction tran;
tran = OMConnection.sqConn.BeginTransaction(false);
numRowsAffected = command.ExecuteNonQuery();
command.Dispose();
BestIndex/xFilter skeleton
might look like? I walked though "ext/misc/amatch.c" from the
www.sqlite.org/src/artifact tree, but I'm a little lost.
Thanks,
Mike Beddo
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On
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
sposing of all objects (data readers,
tables, commands) after use.
Thanks
Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I thought the SQLite mailing list included traffic that discussed
System.Data.SQLite
I am not sure if there are any forums specifically for the ADO .NET provider
and support. I will google
to see if I can find the proper reference.
Mike
On Thursday, October 30, 2014 12:00 PM, Simon Slavin
meout when the database
gets locked?
Thanks
Mike
On Wednesday, October 29, 2014 5:26 PM, Mike McWhinney
wrote:
I will let you know if this fixes the problem. So far I have not had any
locking issues. I will see tomorrow when it
receives more usage and traffic from other users
e
c# ADO provider, version 1.0.94.0 (version 3.8.6 of SQLite).
One thing is that I have tried a method where I open the database and leave it
open through out the life
of the program (open it when I start the program and close on exit). Should I
perhaps change this so that
I open the da
s idea:
https://www.mail-archive.com/sqlite-users@sqlite.org/msg85934.html
something like that seems like its probably a necessary first step to being
able to build a JSON index on disk.
On Tue, Oct 21, 2014 at 4:29 PM, Nico Williams
wrote:
> On Tue, Oct 21, 2014 at 2:13 PM, Mike Jarmy wrote:
similar to how Postgres does it.
On Tue, Oct 21, 2014 at 2:47 PM, Nico Williams
wrote:
> On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne
> wrote:
> > On Tue, Oct 21, 2014 at 3:38 PM, Mike Jarmy wrote:
> >
> >> Has there been any discussion of adding JSON indexing
-)
On Tue, Oct 21, 2014 at 11:35 AM, Cory Nelson wrote:
> On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne
> wrote:
>
> > On Tue, Oct 21, 2014 at 3:38 PM, Mike Jarmy wrote:
> >
> > > Has there been any discussion of adding JSON indexing to sqlite,
> similar
Has there been any discussion of adding JSON indexing to sqlite, similar to
the way Full Text Search and R-Tree are available?
Postgres 9.4 beta has a very nice facility for creating indexes on json
column types:
http://www.postgresql.org/docs/9.4/static/datatype-json.html
It would be extremely
Pro I am using the
Mountain Lion OS X 10.8.5. I can't make your program download to complete this
week's homework assignment to turn in by Wednesday morning. Can you please
guide me to making this work?
Mike Seabrook
602-717-7462.
___
sq
1 - 100 of 493 matches
Mail list logo
