Re: [sqlite] system.data.sqlite example code?

[rajatgaikwadzh]

I think this is an informative post and knowledgeable. I would like to thank
you for the efforts you have made in writing this article
Packers and Movers in Delhi   



-
[url=https://www.aryawartapackers.com]packers and movers in delhi[/url]
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite Verson 111

[Urs Wagner]

I found the version 111 but it is still not working.
I assume the problem is with the latest Visual Studio 2017 version. Earlier 
versions worked.
 
I installed Visual Studio 2015 Community.
I made a test project.
 
EF 6.3 I couldn't correctly install because of an msbuild error. No idea what 
the reason is.
I installed EF 6.4 instead. Then I installed the System.Data.SQLite NuGet 
package.
As a consequence I had to manually remove the Entity Framework 6.3 error 
statement in the csproj file.
 

At last I a had to add this provider in the app.config file:
 

  
 
Now it works as wished.
 
Urs
 

Gesendet: Montag, 13. Januar 2020 um 20:12 Uhr
Von: "Urs Wagner" 
An: sqlite-users@mailinglists.sqlite.org
Betreff: [sqlite] System.Data.SQLite Verson 111
Hello
 
Can I download somewhere System.Data.SQLite Version 111 (the older version).
I should generete a edmx of an existing database.
 
Thanks Urs
___
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] System.Data.SQLite Verson 111

[Urs Wagner]

Hello
 
Can I download somewhere System.Data.SQLite Version 111 (the older version).
I should generete a edmx of an existing database.
 
Thanks Urs
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.112.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.112.0 (with SQLite 3.30.1) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at
mailinglists.sqlite.org) if you encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] system.data.sqlite example code?

[jones510]

Nice to see about the information here, thanks for sharing
https://trainsrunningstatus.live



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.111.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.111.0 (with SQLite 3.28.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at
mailinglists.sqlite.org) if you encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] system.data.sqlite example code?

[johnalexa]

Thanks for your post, If you want to know more about Programming or want 
Programming Help
  , We are
here 24*7



-
[url=https://www.greatassignmenthelp.com/programming-assignment-help]Programming
 Help[/url]

--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.110.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.110.0 (with SQLite 3.27.2) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at
mailinglists.sqlite.org) if you encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.Sqlite Encryption Cipher

[Mattock Paul extern]

Hi,
Would anyone be able to confirm what encryption cipher is used when 
SetPassword="" is set on database creation?

Regards,
Paul
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [System.Data.SQLite] BusyTimeout and DefaultTimeout are not picked up from the connection string

[Phani Rahul Sivalenka]

Hello,

The question is related to the System.Data.SQLite library's connection
string parsing.

We have defined the connection string as follows:

data
source=;DateTimeKind=Utc;Version=3;Pooling=True;Synchronous=Off;journal
mode=Memory;busytimeout=30001;default timeout=31

When a new SQLiteConnection instance is created using the above connection
string, the BusyTimeout and DefaultTimeout are still shown as 0 and 30
respectively on that connection. However, once we open the connection by
calling .Open() method, the values from the connection string are seen in
connection properties.

Expected busy timeout when a db lock occurs is now 30 sec as per the
connection string and as reflected on the connection object. But when we
log the elapsed time from the opening of the connection to its timing out
after the db lock error (inside the catch block) we see that the timeout is
around 60 sec.

--
var stopwatch = Stopwatch.StartNew();
try
{
var conn = new SQLiteConnection(ConnectionString);
// Busy Timeout = 0, Default Timeout = 30

conn.Open();
// Busy Timeout = 30001, Default Timeout = 31

// DB lock while executing the command created on this connection
}
catch
{
log(stopwatch.ElapsedMilliseconds); // around 6
stopwatch.Stop();
}
---

Please let me know if we are doing anything wrong.

Thanks in advance.
Rahul
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.109.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.109.0 (with SQLite 3.24.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

This release features full support for .NET Core v2.0 on Windows, macOS, and
Linux.  The .NET Framework v4.7.2 and Mono v5.12 are also supported.

Please post on the SQLite mailing list (sqlite-users at
mailinglists.sqlite.org) if you encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite version 1.0.108 - .NET 2.0 no service pack compatibility

[Joe Mistachkin]

It may work without Service Pack 2; however, it has not been tested in that 
configuration.

Sent from my iPhone

> On Jun 20, 2018, at 7:45 AM, Bianchi Lorenzo  
> wrote:
> 
> Hi everybody,
> 
> We are currently using the SQlite.dll version 1.0.98 x86 for .NET 2.0, and it 
> seems to be working also on old PCs with .NET 2.0 basic, without Service 
> Pack. We are thinking to upgrade to version 1.0.108 since it has support for 
> both x86 and x64, but I don't know if Service Pack 2 for .NET 2.0 is required 
> for this version or not. Can you help me?
> 
> Thanks in advance,
> Lorenzo.
> ___
> 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] System.Data.SQLite version 1.0.108 - .NET 2.0 no service pack compatibility

[Bianchi Lorenzo]

Hi everybody,

We are currently using the SQlite.dll version 1.0.98 x86 for .NET 2.0, and it 
seems to be working also on old PCs with .NET 2.0 basic, without Service Pack. 
We are thinking to upgrade to version 1.0.108 since it has support for both x86 
and x64, but I don't know if Service Pack 2 for .NET 2.0 is required for this 
version or not. Can you help me?

Thanks in advance,
Lorenzo.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.108.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.108.0 (with SQLite 3.22.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at
mailinglists.sqlite.org) if you encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.107.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.107.0 (with SQLite 3.22.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at
mailinglists.sqlite.org) if you encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.106.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.106.0 (with SQLite 3.21.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.106.0 pre-release packages now available

[Joe Mistachkin]

Pre-release packages of System.Data.SQLite version 1.0.106.0 are now
available on the System.Data.SQLite website:

 https://system.data.sqlite.org/

Please click on the "Pre-Release Download" link in order to view the
available pre-release packages.

Further information about this upcoming release can be seen at:

 https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with these pre-release packages.

--
Joe Mistachkin @ https://urn.to/r/mistachkin
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.105.2 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.105.2 (with SQLite 3.19.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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.105.1 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.105.1 (with SQLite 3.18.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.105.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.105.0 (with SQLite 3.18.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.data.SQLite documentation

[Graham Holden]

I've seen those symptoms with other CHM files if they're on a network share. If 
that's the case for you, try copying to a local drive.
Graham


Sent from my Samsung Galaxy S7 - powered by Three
 Original message From: Mickey Feldman  
Date: 23/02/2017  12:45  (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org 
Subject: [sqlite] System.data.SQLite documentation 
I am not able to read SQLite.NET.chm, I see only the left hand panel, 
but not the expanded contents.  Is this a known issue, or perhaps an 
issue with Windows 7? Is this documentation available anywhere else or 
in some other format?



-- 
M. Feldman

---

Vigil Health Solutions Inc.

www.vigil.com

Toll Free: 877-850-1122

Phone: 250-383-6900

Fax: 250-383-6999
___
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] System.data.SQLite documentation

[Drago, William @ CSG - NARDA-MITEQ]

> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Mickey Feldman
> Sent: Thursday, February 23, 2017 7:46 AM
> To: sqlite-users@mailinglists.sqlite.org
> Subject: [sqlite] System.data.SQLite documentation
>
> I am not able to read SQLite.NET.chm, I see only the left hand panel, but not
> the expanded contents.  Is this a known issue, or perhaps an issue with
> Windows 7? Is this documentation available anywhere else or in some other
> format?
>
>

Did you unblock it? Right click on the file, select properties, then check the 
Unblock box.

--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l3t.com

CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

Effective immediately my new email address is william.dr...@l3t.com. Please 
update your records.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.data.SQLite documentation

[Mickey Feldman]

I am not able to read SQLite.NET.chm, I see only the left hand panel, 
but not the expanded contents.  Is this a known issue, or perhaps an 
issue with Windows 7? Is this documentation available anywhere else or 
in some other format?




--
M. Feldman

---

Vigil Health Solutions Inc.

www.vigil.com

Toll Free: 877-850-1122

Phone: 250-383-6900

Fax: 250-383-6999
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column

[Burtsev, Dmitriy]

Windows 7 64bit
SQLite version 3.17.0
sqlite-netFx46-static-binary-x64-2015-1.0.104.0

Note: The code is working correctly with Devart ODBC driver for SQLite 2.1.4
The problem is with System.Data.SQLite

How to reproduce:
ON SQLite
Create database N:\SqLite\outStream.db

CREATE TABLE FromNum (id int NOT NULL, Num numeric(5, 5));
INSERT INTO FromNum (id, Num) VALUES (1, .0);

On SQL Server

CREATE TABLE [dbo].[ToNum](
[id] [int] NOT NULL,
[Num] [numeric](5, 5) NULL,
PRIMARY KEY CLUSTERED
([id] ASC) );

PowerShell script:

[string]ToTableName = "SERVER.Test.dbo.ToNum"
[string]FromFileName = 'N:\SqLite\outStream.db'

[string[]]ttname = ToTableName.Split(".")
[string]ServerName = ttname[0]
[string]dbName = ttname[1]
[string]schema = ttname[2]
[string]DestinationTable = ttname[3]

sqlString = "SELECT * FROM FromNum"
con = New-Object -TypeName System.Data.SQLite.SQLiteConnection -ArgumentList 
"Data Source=$FromFileName"
#$con = New-Object -TypeName System.Data.Odbc.OdbcConnection -ArgumentList 
"DSN=SqLite;Database=N:\SqLite\outStream.db;Direct=True" this is Devart ODBC

con.Open()

SourceSQLCommand = con.CreateCommand()
SourceSQLCommand.CommandText = sqlString

DestinationConnectionString = "Data Source=$ServerName;Initial 
Catalog=$dbName;integrated security=false"

try
{
reader = SourceSQLCommand.ExecuteReader()
bulkCopy = New-Object ("System.Data.SqlClient.SqlBulkCopy") 
DestinationConnectionString, 
([System.Data.SqlClient.SqlBulkCopyOptions]::TableLock -bor 
[System.Data.SqlClient.SqlBulkCopyOptions]::UseInternalTransaction)
bulkCopy.DestinationTableName = DestinationTable
bulkcopy.EnableStreaming = true;
bulkCopy.BatchSize = 5 #The number of rows in each batch sent 
to the server
bulkCopy.BulkCopyTimeout = 0 #the number of seconds before a 
time-out
bulkCopy.WriteToServer($reader) 
#copy all rows to the server
}
catch
{
ex = _.Exception
Write-Error ex.Message
}
finally
{
reader.Close()
con.Close()
}

Error Message:

Exception calling "WriteToServer" with "1" argument(s): "The given value of 
type SqlDecimal from the data source cannot be
converted to type decimal of the specified target column."

Dmitriy Burtsev


This message, and any of its attachments, is for the intended recipient(s) 
only, and it may contain information that is privileged, confidential, and/or 
proprietary and subject to important terms and conditions available at 
http://www.stifel.com/disclosures/emaildisclaimers/. If you are not the 
intended recipient, please delete this message and immediately notify the 
sender. No confidentiality, privilege, or property rights are waived or lost by 
any errors in transmission.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.104.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.104.0 (with SQLite 3.15.2) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

[Baugher, Melody]

Thanks, Jens. I'll keep an eye on that.

Take care,
Melody

-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Jens Alfke
Sent: Monday, December 12, 2016 12:32 PM
To: SQLite mailing list 
Subject: Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has 
opposite behavior


> On Dec 12, 2016, at 5:00 AM, Baugher, Melody  wrote:
> 
>  string passwordPragma = "PRAGMA key='" + password + "';";

Not quoting the password string leaves you open to SQL injection attack. This 
probably isn’t an issue in an internal development tool, but if there’s any 
code like this in the main program, it’s a serious vulnerability, so I thought 
I’d point it out.

—Jens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

[Jens Alfke]

> On Dec 12, 2016, at 5:00 AM, Baugher, Melody  wrote:
> 
>  string passwordPragma = "PRAGMA key='" + password + "';";

Not quoting the password string leaves you open to SQL injection attack. This 
probably isn’t an issue in an internal development tool, but if there’s any 
code like this in the main program, it’s a serious vulnerability, so I thought 
I’d point it out.

—Jens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

[Simon Slavin]

On 12 Dec 2016, at 1:00pm, Baugher, Melody  wrote:

> Starting with an encrypted database, if I run this code twice in a row with 
> applyPassword=false, the password is removed the first time but then applied 
> the second time.

Your program is weird and buggy.  There is one big test in the program:

>  if (applyPassword)

Before this test is done, the program carefully constructs a command in the 
variable "passwordPragma" but uses it only if "applyPassword" is /not/ true.  
It then immediately issues

> connection.ChangePassword("");

which would undo the change it just made.

It also has several things inside the test (create a connection, use 
"activatePragma") which are done whether the test is true or false.  They 
should be moved outside the test.

Now I’ve told you that the program is weird take a look through it, tidy up the 
logic, and write a better one.

[What’s really amusing here is that decades of programming experience let me 
read that program even though I have never used whatever programming language 
it’s written in or the API it uses.]

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

[Baugher, Melody]

My SQLite databases are encrypted at build time.

Small tools were developed to remove or apply the password to all 9 databases 
after build to facilitate the work of the database developers. The tools run 
the following bit of code against each database:

  string activatePragma = "PRAGMA activate_extensions='SEE Code';";
  string passwordPragma = "PRAGMA key='" + password + "';";
  SQLiteConnection connection = new SQLiteConnection("Data Source = " + 
databaseFile);
  connection.Open();
 if (applyPassword)
  {
using (SQLiteCommand pragmaCommand = new SQLiteCommand(connection))
{
  pragmaCommand.CommandText = activatePragma;
  pragmaCommand.ExecuteNonQuery();
}
connection.ChangePassword(password);
  }
  else
  {
using (SQLiteCommand pragmaCommand = new SQLiteCommand(connection))
{
  pragmaCommand.CommandText = activatePragma;
  pragmaCommand.ExecuteNonQuery();
  pragmaCommand.CommandText = passwordPragma;
  pragmaCommand.ExecuteNonQuery();
}
connection.ChangePassword("");
  }
  connection.Close();

Starting with an encrypted database, if I run this code twice in a row with 
applyPassword=false, the password is removed the first time but then applied 
the second time.

Similarly, starting with an unencrypted database, fi I run this code twice in a 
row with applyPassword=true, the password is applied the first time but then 
removed the second time.

I can kind of see where perhaps when running the removal the second time, the 
"PRAGMA key=" bit is actually now applying the password.

But I don't understand why executing ChangePassword twice in a row on an 
unencrypted database would remove the password the second time.
Take care,
Melody R Baugher
DCS Corporation
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.102.0

[Mark Benningfield]

In SQLiteFunction.cs :

internal static bool UnbindAllFunctions(...
...
else
{
//
// NOTE: Need to use a copy of the function dictionary in 
this method
//   because the dictionary is modified within the 
UnbindFunction

//   method, which is called inside the loop.
//
lFunctions = new DictionarySQLiteFunction>(

lFunctions);

foreach (KeyValuePairSQLiteFunction> pair

in lFunctions)
{
SQLiteFunctionAttribute pr = pair.Key;

if (pr == null)
continue;

SQLiteFunction f = pair.Value;

if ((f == null) ||
!UnbindFunction(sqlbase, pr, f, flags))
{
result = false;
}
}
}

===

based on the comments, I'm wondering if it shouldn't look like this:

internal static bool UnbindAllFunctions(...
...
else
{
//
// NOTE: Need to use a copy of the function dictionary in 
this method
//   because the dictionary is modified within the 
UnbindFunction

//   method, which is called inside the loop.
//
lFunctions = new DictionarySQLiteFunction>(

lFunctions);

foreach (KeyValuePairSQLiteFunction> pair

in lFunctions)
{
SQLiteFunctionAttribute pr = pair.Key;

if (pr == null)
continue;

SQLiteFunction f = pair.Value;

if ((f == null) ||
!sqlbase.UnbindFunction(pr, flags)) <<<===
{
result = false;
}
}
}

Mark Benningfield

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

[John Reynolds]

A follow-up on this (and a late thanks!):

I've used your answer to write some build instructions for Ubuntu and Raspbian 
at
http://blog.wezeku.com/2016/10/09/using-system-data-sqlite-under-linux-and-mono/

I've also modified the F# SQLProvider type provider so that it no longer always 
loads
Mono.Data.SQLite under Mono, but allows you to specify that System.Data.SQLite 
should be
loaded regardless of whether the platform is .NET or Mono:
http://fsprojects.github.io/SQLProvider/core/sqlite.html#SQLiteLibrary

/John

> There are various compile-options and extensions baked into the
> "SQLite.Interop.dll" that are not enabled and/or included by
> default with "sqlite3.dll".
>
> One that is somewhat important, is the "vtshim" extension.  It
> is required if you want to implement a virtual table in managed
> code.  It's also fairly tightly integrated into the resulting
> "SQLite.Interop.dll", by necessity.
>
> It is possible to compile the "SQLite.Interop.dll" for Linux,
> Mac OS X, and probably other POSIX compliant systems, using
> the following build script:
>
>   https://urn.to/r/7C
>
> --
> Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

[Joe Mistachkin]

John Reynolds wrote:
>
> My question is: what are the trade-offs of not using
> SQLite.Interop.dll? 
> 

There are various compile-options and extensions baked into the
"SQLite.Interop.dll" that are not enabled and/or included by
default with "sqlite3.dll".

One that is somewhat important, is the "vtshim" extension.  It
is required if you want to implement a virtual table in managed
code.  It's also fairly tightly integrated into the resulting
"SQLite.Interop.dll", by necessity.

It is possible to compile the "SQLite.Interop.dll" for Linux,
Mac OS X, and probably other POSIX compliant systems, using
the following build script:

https://urn.to/r/7C

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

[John Reynolds]

Hi,

(Sorry if this becomes a double post - I first tried posting from Nabble)

I've compiled System.Data.SQLite.dll with the
"/property:UseSqliteStandard=true" option, so that it will load
sqlite3.dll (or it's Linux equivalent) instead of SQLite.Interop.dll.

The advantage of this is that you can run the exact same code on Windows
and Mono+Linux without resorting to using the rarely updated
Mono.Data.SQLite package (about 1.5 years old right now, and with
unfixed bugs critical to my application).

My question is: what are the trade-offs of not using SQLite.Interop.dll?

/John
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.103.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.103.0 (with SQLite 3.14.2) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite and Entity framework 5

[berny]

Is there a way to work with System.Data.SQLite with Entity framework 5?
Latest version for .net framework 4.5 requires EF6, bit I need to work with
EF5.

Thanks!
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite

[Lloyd]

Through DBContext constructor I have associated the connection. As the
table is not existing in my database, it throws an exception. Does sqlite
support automatic creation of tables or do I have create the tables and
relationships first  and then insert the data using the framework?

On Fri, Aug 19, 2016 at 6:02 PM, Lloyd  wrote:

> Hi,
>
> I am trying to use SQLite with EntityFramework6 on a .Net application.
>
> I have referred the documentation, created the app.config file as
> specified in the documentation. When I created a sample C# file as in the
> documentation,it generates an empty database file.
>
> DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.
> SQLite");
> using (DbConnection cnn = fact.CreateConnection())
> {
>   cnn.ConnectionString = "Data Source=test.db3";
>   cnn.Open();
> }
>
> How can I associate a DBContext with this connection? Is it possible to
> create tables in my sqlite database based on my entity classes?
>
> I couldn't find any tutorial on using System.Data.SQLite with Entity
> Framework.
>
> Any hint/help/a link to tutorial is greatly appreciated
>
> Thanks,
>   Lloyd
>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite

[Lloyd]

Hi,

I am trying to use SQLite with EntityFramework6 on a .Net application.

I have referred the documentation, created the app.config file as specified
in the documentation. When I created a sample C# file as in the
documentation,it generates an empty database file.

DbProviderFactory fact =
DbProviderFactories.GetFactory("System.Data.SQLite");
using (DbConnection cnn = fact.CreateConnection())
{
  cnn.ConnectionString = "Data Source=test.db3";
  cnn.Open();
}

How can I associate a DBContext with this connection? Is it possible to
create tables in my sqlite database based on my entity classes?

I couldn't find any tutorial on using System.Data.SQLite with Entity
Framework.

Any hint/help/a link to tutorial is greatly appreciated

Thanks,
  Lloyd
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.102.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.102.0 (with SQLite 3.13.0) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [System.Data.SQLite] Nuget 3 support

[Joe Mistachkin]

Jann Roder wrote:
>
> Nuget 3 now seems to have much better support for native libraries.
>

I'd really like to use this for System.Data.SQLite.

I suspect this will require a great deal of investigation, refactoring,
and debugging.

It's too late in the release cycle for 1.0.102.0 for this.  I'll look
into it for 1.0.103.0.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [System.Data.SQLite] Nuget 3 support

[Jann Roder]

Hi,
I recently migrated two of our solutions to nuget 3. Nuget 3 now seems to have 
much better support for native libraries. Unfortunately it is incompatible with 
the way the SQLite package currently does things. I had to manually call the 
traget that copies the interop libraries in my .csproj files.

I was wondering what your plans are with regards to supporting nuget 3? From 
what I have seen it appears to be difficult to have a package that needs to 
install native libraries that works with nuget 2 AND 3. I believe in nuget 3 
none of the custom copy targets should be necessary anymore.

Jann






Winton Capital Management Limited (“Winton”) is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering materials and consult their own 
advisers with respect to investment decisions and inform themselves as to 
applicable legal requirements, exchange control regulations and taxes in the 
countries of their citizenship, residence or domicile. Past performance is not 
indicative of future results.

Winton takes reasonable steps to ensure the accuracy and integrity of its 
communications, including emails. However Winton accepts no liability for any 
materials transmitted. Emails are not secure and cannot be guaranteed to be 
error free. Winton handles personal information in accordance with its privacy 
notice.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

[Dan Kennedy]

On 05/24/2016 01:16 AM, Joe Mistachkin wrote:
> Jason Doherty wrote:
>> CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx,
>> miny, maxy);
>>
>> fails with
>>
>> SQLite error (1); no such table: main.sqlite_stat1
>>
> Could you run the SQL query "ANALYZE;" on the database and see if that
> clears
> the issue?

On the off chance that it doesn't completely clear the issue but does 
change the error message to one that makes more sense, can you post the 
new error here? Thanks.

Dan.

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

[Joe Mistachkin]

Jason Doherty wrote:
>
>CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx,
> miny, maxy);
> 
> fails with
> 
>SQLite error (1); no such table: main.sqlite_stat1
> 

Could you run the SQL query "ANALYZE;" on the database and see if that
clears
the issue?

--
Joe Mistachkin

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

[Jason Doherty]

Hi 

We?ve used SQLite rtree indexes successfully on iOS and Android for
creating spatial indexes in the past.  We can?t seem to make them work on
Windows. We are using the System.Data.SQLite ADO.NET library that was
downloaded using the NuGet package manager (version 1.0.101) per the
instructions, running in x86 mode in Visual Studio 2013.

   CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx,
miny, maxy);

fails with

   SQLite error (1); no such table: main.sqlite_stat1

This only fails on Windows.  We saw this message on iOS when we didn?t
compile with the -DSQLITE_ENABLE_RTREE=1 option, but there is no such
option for the ADO.NET provider. Is it not compiled for rtree on Windows?

Thanks for any help!
Jason

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

[Keith Medcalf]

> I am able to recreate the exception here.  The value of Int64.MaxValue is
> 9223372036854775807.  The UnixEpoch values are measured in seconds from
> the epoch 1970-01-01 00:00:00Z.  Adding 9223372036854775807 seconds to the
> UnixEpoch would result in a DateTime far beyond the allowed maximum value
> for DateTime in the .NET Framework, which is -12-31 23:59:59.999.

dotNet uses 0001-01-01 00:00:00.000 as the epoch and integer increment is 
hundredths of a microsecond since the epoch.  This makes the largest dotNet 
timevalue 31550644800 which is a bit more than a third of 
Int64.MaxValue.

The maximum seconds increment of the unix epoch is 253370851200 after which you 
will need 5 digits for the year, and the minimum value is -62135596800, the 
next second below which is 0001/12/31 23:59:59.00 BC.

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

[Jann Roder]

Makes sense,
Somehow I had in my head that int64 would still only get you to the year 5000 
or so.
I guess the question is if it should fail like that in this case. Capping it at 
DateTime.MaxValue does not seem ideal either.

Jann

-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe 
Mistachkin
Sent: 28 April 2016 19:54
To: 'SQLite mailing list' 
Subject: Re: [sqlite] [System.Data.SQLite] int overflow in date handling when 
unixepoch is used


Jann Roder wrote:
>
> I just tested the new version that should have the fix for this and
> now I get an ArgumentOutOfRangeException exception when I actually
> have a value of Int64.MaxValue in a date column. Stack trace:
>

I am able to recreate the exception here.  The value of Int64.MaxValue is 
9223372036854775807.  The UnixEpoch values are measured in seconds from the 
epoch 1970-01-01 00:00:00Z.  Adding 9223372036854775807 seconds to the 
UnixEpoch would result in a DateTime far beyond the allowed maximum value for 
DateTime in the .NET Framework, which is -12-31 23:59:59.999.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



Winton Capital Management Limited (?Winton?) is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering materials and consult their own 
advisers with respect to investment decisions and inform themselves as to 
applicable legal requirements, exchange control regulations and taxes in the 
countries of their citizenship, residence or domicile. Past performance is not 
indicative of future results.

Winton takes reasonable steps to ensure the accuracy and integrity of its 
communications, including emails. However Winton accepts no liability for any 
materials transmitted. Emails are not secure and cannot be guaranteed to be 
error free. Winton handles personal information in accordance with its privacy 
notice.<https://www.wintoncapital.com/en/regulatory-disclosures#privacypolicy>

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

[Joe Mistachkin]

Jann Roder wrote:
>
> I just tested the new version that should have the fix for this and now
> I get an ArgumentOutOfRangeException exception when I actually have a
> value of Int64.MaxValue in a date column. Stack trace:
> 

I am able to recreate the exception here.  The value of Int64.MaxValue is
9223372036854775807.  The UnixEpoch values are measured in seconds from
the epoch 1970-01-01 00:00:00Z.  Adding 9223372036854775807 seconds to the
UnixEpoch would result in a DateTime far beyond the allowed maximum value
for DateTime in the .NET Framework, which is -12-31 23:59:59.999.

--
Joe Mistachkin

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

[Jann Roder]

Hi Joe,
I just tested the new version that should have the fix for this and now I get 
an ArgumentOutOfRangeException exception when I actually have a value of 
Int64.MaxValue in a date column. Stack trace:

   at System.DateTime.Add(Double value, Int32 scale)
   at System.Data.SQLite.SQLiteConvert.UnixEpochToDateTime(Int64 seconds, 
DateTimeKind kind)
   at System.Data.SQLite.SQLite3.GetDateTime(SQLiteStatement stmt, Int32 index)
   at System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, 
SQLiteConnectionFlags flags, Int32 index, SQLiteType typ)
   at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
   at System.Data.SQLite.SQLiteDataReader.GetValues(Object[] values)
   at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable 
datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, 
Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader 
dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, 
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, 
IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

Jann

-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe 
Mistachkin
Sent: 02 March 2016 18:36
To: 'SQLite mailing list' 
Subject: Re: [sqlite] [System.Data.SQLite] int overflow in date handling when 
unixepoch is used


Jann Roder wrote:
>
> When I set the dateformat to unixepoch the maximum date I can get back
> from a query is 2038-01-19. This appears to be a problem in the
> wrapper as SQLite itself is using 64bit integers for dates.
>

Thanks for the clear and concise report.  This issue should now be fixed on 
trunk, here:

https://system.data.sqlite.org/index.html/info/d28375563e7f5774

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



Winton Capital Management Limited (?Winton?) is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering materials and consult their own 
advisers with respect to investment decisions and inform themselves as to 
applicable legal requirements, exchange control regulations and taxes in the 
countries of their citizenship, residence or domicile. Past performance is not 
indicative of future results.

Winton takes reasonable steps to ensure the accuracy and integrity of its 
communications, including emails. However Winton accepts no liability for any 
materials transmitted. Emails are not secure and cannot be guaranteed to be 
error free. Winton handles personal information in accordance with its privacy 
notice.<https://www.wintoncapital.com/en/regulatory-disclosures#privacypolicy>

[sqlite] System.Data.SQLite version 1.0.101.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.101.0 (with SQLite 3.12.2) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.100.0 released

[Simon Slavin]

>> On Apr 15, 2016, at 12:46, Tim Uy  wrote:
>> 
>> that is a lot of 1s and 0s.

> On 15 Apr 2016, at 10:34pm, Brad Stiles  wrote:
> 
> It's *all* 1s and 0s. 

Hate them.

Simon.

[sqlite] System.Data.SQLite version 1.0.100.0 released

[Brad Stiles]

It's *all* 1s and 0s. 

> On Apr 15, 2016, at 12:46, Tim Uy  wrote:
> 
> that is a lot of 1s and 0s.
> 
>> On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin  
>> wrote:
>> 
>> 
>> System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki
>> 
>> Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
>> encounter any problems with this release.
>> 
>> --
>> Joe Mistachkin
>> 
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.100.0 released

[Scott Robison]

I think it's an Elias omega code.

On Fri, Apr 15, 2016 at 11:46 AM, Tim Uy  wrote:

> that is a lot of 1s and 0s.
>
> On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin 
> wrote:
>
> >
> > System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki
> >
> > Please post on the SQLite mailing list (sqlite-users at sqlite.org) if
> you
> > encounter any problems with this release.
> >
> > --
> > Joe Mistachkin
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Scott Robison

[sqlite] System.Data.SQLite version 1.0.100.0 released

[Tim Uy]

that is a lot of 1s and 0s.

On Fri, Apr 15, 2016 at 10:42 AM, Joe Mistachkin  wrote:

>
> System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki
>
> Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
> encounter any problems with this release.
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] System.Data.SQLite version 1.0.100.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.100.0 (with SQLite 3.12.1) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] "System.Data.SQLite" Version 1.0 Supportability

[Harish Kumar Gudur (DATA GLOVE INCORPORATED DBA TR)]

Hi Team,
We are planning to migrate few Vendor based applications from Windows Server 
2003 to the latest server Operating System Windows Server 2012/2008. Before 
migration we would like to do the assessment of the application and check the 
supportability.
We are performing the assessment for:
Application Name: System.Data.SQLite
Version: 1.0
Vendor: System.Data.SQLite Team

Kindly provide us the Official documents/ Website links that confirm the 
Supportability of the application on the latest Server Operating Systems - 
Windows Server 2012 R2/2012/2008 R2/2008.
Incase documents/ Website links are currently unavailable then please help us 
gathering the information in the below table if they are supported or not.
Application Name

Application Version

Supportability

Windows Server 2012 R2

Windows Server 2012

Windows Server 2008 R2

Windows Server 2008

System.Data.SQLite

1.0

Supported/ Not Supported

Supported/ Not Supported

Supported/ Not Supported

Supported/ Not Supported

Upgrade Available, if any *



Supported

Supported

Supported

Supported


* - Lowest available version supported on all the 4 Operating System.
This information would help us assess the application and migrate accordingly 
to the latest Operating Systems.
Thanks for your help.
With Warm Regards,
Vendor Research Team
Trimax Americas

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

[Jann Roder]

Hi,
When I set the dateformat to unixepoch the maximum date I can get back from a 
query is 2038-01-19. This appears to be a problem in the wrapper as SQLite 
itself is using 64bit integers for dates.

You can reproduce the problem like this:

[Test]
public void ShouldDoSparseTimeSeriesTransform2()
{
ExecuteNonQuery("CREATE TABLE Test_RAW (Date DATETIME, Id INT, Value INT, 
PRIMARY KEY (Date, Id))");
ExecuteNonQuery("INSERT INTO Test_RAW VALUES(strftime('%s', '2038-01-20'), 
1, 1)");
var result = ExecuteQuery("SELECT * FROM Test_RAW");
// Set breakpoint here and inspect the result.
Assert.AreEqual(1, result.Rows.Count);
}


private void ExecuteNonQuery(string command)

{

using (var cmd = new SQLiteCommand(command, m_connection))

{

cmd.ExecuteNonQuery();

}

}



private DataTable ExecuteQuery(string query)

{

using (var cmd = new SQLiteCommand(query, m_connection))

{

using (var da = new SQLiteDataAdapter(cmd))

{

var dataTable = new DataTable();

da.Fill(dataTable);

return dataTable;

}

}

}


private SQLiteConnection m_connection;



internal static SQLiteConnection GetNewInMemoryConnection()

{

var builder = new SQLiteConnectionStringBuilder

{

DataSource = ":memory:",

DateTimeFormat = SQLiteDateFormats.UnixEpoch

};

return new SQLiteConnection(builder.ConnectionString);

}



[SetUp]

public void SetUp()

{

m_connection = GetNewInMemoryConnection();

m_connection.Open();

}



[TearDown]

public void TearDown()

{

m_connection.Close();

m_connection.Dispose();

}




Winton Capital Management Limited ("Winton") is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering materials and consult their own 
advisers with respect to investment decisions and inform themselves as to 
applicable legal requirements, exchange control regulations and taxes in the 
countries of their citizenship, residence or domicile. Past performance is not 
indicative of future results.

Winton takes reasonable steps to ensure the accuracy and integrity of its 
communications, including emails. However Winton accepts no liability for any 
materials transmitted. Emails are not secure and cannot be guaranteed to be 
error free. Winton handles personal information in accordance with our privacy 
notice.

[sqlite] [System.Data.SQLite] int overflow in date handling when unixepoch is used

[Joe Mistachkin]

Jann Roder wrote:
>
> When I set the dateformat to unixepoch the maximum date I can get back
> from a query is 2038-01-19. This appears to be a problem in the wrapper
> as SQLite itself is using 64bit integers for dates. 
>

Thanks for the clear and concise report.  This issue should now be fixed
on trunk, here:

https://system.data.sqlite.org/index.html/info/d28375563e7f5774

--
Joe Mistachkin

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

[Jann Roder]

Well, it doesn't really matter what the documentation says. Fact is that it is 
currently broken. I can easily patch this on my end using an IDataReader 
implementation that forwards all calls except the GetSchemaTable method. It 
would be sad though if a high quality library like SQLite contained a flaw like 
this.

-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe 
Mistachkin
Sent: 04 January 2016 15:43
To: SQLite mailing list 
Subject: Re: [sqlite] System.Data.SQLite: Incorrect implementation of 
SQLiteDataReader::GetSchemaTable()


The docs you quote from are specific to the "SqlClient" ADO.NET implementation, 
which is used to communicate only with MS SQL Server.  Other providers are 
apparently free to have completely different semantics.

Sent from my iPhone

> On Jan 4, 2016, at 1:25 AM, Jann Roder  wrote:
> 
> Looking at MSDN the docs are not that fuzzy:
> https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldata
> reader.getschematable(v=vs.110).aspx
> 
> for example:
> 
> AllowDBNull : Set if the consumer can set the column to a null value or if 
> the provider cannot determine whether the consumer can set the column to a 
> null value. Otherwise, not set. A column may contain null values, even if it 
> cannot be set to a null value.
> 
> IsKey: true: The column is one of a set of columns in the rowset that, taken 
> together, uniquely identify the row. The set of columns with IsKey set to 
> true must uniquely identify a row in the rowset. There is no requirement that 
> this set of columns is a minimal set of columns. This set of columns may be 
> generated from a base table primary key, a unique constraint or a unique 
> index.
> 
> Unfortunately this is written from the perspective of someone using the 
> dataset to insert data into the database, but still the current 
> implementation violates the above.
> 
> While I understand your concern about backward compatibility this is still 
> clearly a bug in my opinion. Loading data into a datatable form SQLite is 
> only garunateed to work if the query is of the form SELECT * FROM Table. In 
> all other cases it depends. I think there should at least be an option that 
> will make it work in all cases.
> 
> Jann
> 
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org 
> [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Joe 
> Mistachkin
> Sent: 31 December 2015 17:45
> To: 'SQLite mailing list' 
> Subject: Re: [sqlite] System.Data.SQLite: Incorrect implementation of 
> SQLiteDataReader::GetSchemaTable()
> 
> 
> Jann Roder wrote:
>> 
>> The implementation of GetSchemaTable() in SQLiteDataReader seems to 
>> be based on the properties of the columns used in the select.  
>> Obviously uniqueness, nullness and primary key properties do not 
>> transfer when only a subset of the columns is selected or combined 
>> with data from other tables.
> 
> The official MSDN docs are a bit fuzzy on these points:
> 
> 
> https://msdn.microsoft.com/en-us/library/system.data.idatareader.getsc
> hemata
> ble%28v=vs.110%29.aspx
> 
>> 
>> Unfortunately the .Net Datatable::Load() command uses the information 
>> returned by SQLiteDataReader::GetSchemaTable().  This means that the 
>> result of many queries cannot be loaded into a Datatable using the
>> Load() command because of non-nullable columns being null (due to a 
>> left join) or even wrong (the Datatable just drops "duplicate" rows 
>> when loading data). See the code below that illustrates the problem.
> 
> Yes, I've seen this behavior while tracking down several past issues.
> On a somewhat sunnier note, the built-in ADO.NET support classes seem 
> remarkably good at adapting to [some of] the of idiosyncrasies of the various 
> ADO.NET providers.  However, as you have seen, there are some inconsistencies.
> 
>> 
>> I'm not sure how other DB drivers solve this problem, but it seems to 
>> me the SQLite driver should stop trying to be clever and just always 
>> set the IsUnique and IsKey columns to false and also always allow 
>> null values.
> 
> Unfortunately, changing this method in such a fundamental way would not be 
> backwards compatible.  Also, in some cases, it can be quite difficult to 
> determine what the "correct" behavior should be.
> 
> --
> Joe Mistachkin
> 
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

[Joe Mistachkin]

Jann Roder wrote:
> 
> Well, it doesn't really matter what the documentation says. 
> 

Unfortunately, the ADO.NET documentation is the primary source on how to
implement compatible providers.  Are you aware of better sources?

> 
> I can easily patch this on my end using an IDataReader implementation
> that forwards all calls except the GetSchemaTable method.
> 

That seems like a reasonably good solution.

>
> It would be sad though if a high quality library like SQLite contained a
> flaw like this.
> 

To clarify: the issue here is with System.Data.SQLite, not SQLite itself.

--
Joe Mistachkin

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

[Jann Roder]

Looking at MSDN the docs are not that fuzzy:
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx

for example:

AllowDBNull : Set if the consumer can set the column to a null value or if the 
provider cannot determine whether the consumer can set the column to a null 
value. Otherwise, not set. A column may contain null values, even if it cannot 
be set to a null value.

IsKey: true: The column is one of a set of columns in the rowset that, taken 
together, uniquely identify the row. The set of columns with IsKey set to true 
must uniquely identify a row in the rowset. There is no requirement that this 
set of columns is a minimal set of columns. This set of columns may be 
generated from a base table primary key, a unique constraint or a unique index.

Unfortunately this is written from the perspective of someone using the dataset 
to insert data into the database, but still the current implementation violates 
the above.

While I understand your concern about backward compatibility this is still 
clearly a bug in my opinion. Loading data into a datatable form SQLite is only 
garunateed to work if the query is of the form SELECT * FROM Table. In all 
other cases it depends. I think there should at least be an option that will 
make it work in all cases.

Jann

-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe 
Mistachkin
Sent: 31 December 2015 17:45
To: 'SQLite mailing list' 
Subject: Re: [sqlite] System.Data.SQLite: Incorrect implementation of 
SQLiteDataReader::GetSchemaTable()


Jann Roder wrote:
>
> The implementation of GetSchemaTable() in SQLiteDataReader seems to be
> based on the properties of the columns used in the select.  Obviously
> uniqueness, nullness and primary key properties do not transfer when
> only a subset of the columns is selected or combined with data from
> other tables.
>

The official MSDN docs are a bit fuzzy on these points:


https://msdn.microsoft.com/en-us/library/system.data.idatareader.getschemata
ble%28v=vs.110%29.aspx

>
> Unfortunately the .Net Datatable::Load() command uses the information
> returned by SQLiteDataReader::GetSchemaTable().  This means that the
> result of many queries cannot be loaded into a Datatable using the
> Load() command because of non-nullable columns being null (due to a
> left join) or even wrong (the Datatable just drops "duplicate" rows
> when loading data). See the code below that illustrates the problem.
>

Yes, I've seen this behavior while tracking down several past issues.
On a somewhat sunnier note, the built-in ADO.NET support classes seem 
remarkably good at adapting to [some of] the of idiosyncrasies of the various 
ADO.NET providers.  However, as you have seen, there are some inconsistencies.

>
> I'm not sure how other DB drivers solve this problem, but it seems to
> me the SQLite driver should stop trying to be clever and just always
> set the IsUnique and IsKey columns to false and also always allow null
> values.
>

Unfortunately, changing this method in such a fundamental way would not be 
backwards compatible.  Also, in some cases, it can be quite difficult to 
determine what the "correct" behavior should be.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



Winton Capital Management Limited (?Winton?) is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering materials and consult their own 
advisers with respect to investment decisions and inform themselves as to 
applicable legal requirements, exchange control regulations and taxes in the 
countries of their citizenship, residence or domicile. Past performance is not 
indicative of future results.

Winton takes reasonable steps to ensure the accuracy and integrity of its 
communications, incl

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

[Joe Mistachkin]

The docs you quote from are specific to the "SqlClient" ADO.NET implementation, 
which is used to communicate only with MS SQL Server.  Other providers are 
apparently free to have completely different semantics.

Sent from my iPhone

> On Jan 4, 2016, at 1:25 AM, Jann Roder  wrote:
> 
> Looking at MSDN the docs are not that fuzzy:
> https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx
> 
> for example:
> 
> AllowDBNull : Set if the consumer can set the column to a null value or if 
> the provider cannot determine whether the consumer can set the column to a 
> null value. Otherwise, not set. A column may contain null values, even if it 
> cannot be set to a null value.
> 
> IsKey: true: The column is one of a set of columns in the rowset that, taken 
> together, uniquely identify the row. The set of columns with IsKey set to 
> true must uniquely identify a row in the rowset. There is no requirement that 
> this set of columns is a minimal set of columns. This set of columns may be 
> generated from a base table primary key, a unique constraint or a unique 
> index.
> 
> Unfortunately this is written from the perspective of someone using the 
> dataset to insert data into the database, but still the current 
> implementation violates the above.
> 
> While I understand your concern about backward compatibility this is still 
> clearly a bug in my opinion. Loading data into a datatable form SQLite is 
> only garunateed to work if the query is of the form SELECT * FROM Table. In 
> all other cases it depends. I think there should at least be an option that 
> will make it work in all cases.
> 
> Jann
> 
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org 
> [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Joe 
> Mistachkin
> Sent: 31 December 2015 17:45
> To: 'SQLite mailing list' 
> Subject: Re: [sqlite] System.Data.SQLite: Incorrect implementation of 
> SQLiteDataReader::GetSchemaTable()
> 
> 
> Jann Roder wrote:
>> 
>> The implementation of GetSchemaTable() in SQLiteDataReader seems to be
>> based on the properties of the columns used in the select.  Obviously
>> uniqueness, nullness and primary key properties do not transfer when
>> only a subset of the columns is selected or combined with data from
>> other tables.
> 
> The official MSDN docs are a bit fuzzy on these points:
> 
> 
> https://msdn.microsoft.com/en-us/library/system.data.idatareader.getschemata
> ble%28v=vs.110%29.aspx
> 
>> 
>> Unfortunately the .Net Datatable::Load() command uses the information
>> returned by SQLiteDataReader::GetSchemaTable().  This means that the
>> result of many queries cannot be loaded into a Datatable using the
>> Load() command because of non-nullable columns being null (due to a
>> left join) or even wrong (the Datatable just drops "duplicate" rows
>> when loading data). See the code below that illustrates the problem.
> 
> Yes, I've seen this behavior while tracking down several past issues.
> On a somewhat sunnier note, the built-in ADO.NET support classes seem 
> remarkably good at adapting to [some of] the of idiosyncrasies of the various 
> ADO.NET providers.  However, as you have seen, there are some inconsistencies.
> 
>> 
>> I'm not sure how other DB drivers solve this problem, but it seems to
>> me the SQLite driver should stop trying to be clever and just always
>> set the IsUnique and IsKey columns to false and also always allow null
>> values.
> 
> Unfortunately, changing this method in such a fundamental way would not be 
> backwards compatible.  Also, in some cases, it can be quite difficult to 
> determine what the "correct" behavior should be.
> 
> --
> Joe Mistachkin
> 
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 
> 
> 
> Winton Capital Management Limited (?Winton?) is a limited company registered 
> in England and Wales with its registered offices at 16 Old Bailey, London, 
> EC4M 7EG (Registered Company No. 3311531). Winton is authorised and regulated 
> by the Financial Conduct Authority in the United Kingdom, registered as an 
> investment adviser with the US Securities and Exchange Commission, registered 
> with the US Commodity Futures Trading Commission and a member of the National 
> Futures Association in the United States.
> 
> This communication, including any attachments, is confidential and may be 
> privileged. This email is for u

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

[Jann Roder]

Hi,
The implementation of GetSchemaTable() in SQLiteDataReader seems to be based on 
the properties of the columns used in the select. Obviously uniqueness, 
nullness and primary key properties do not transfer when only a subset of the 
columns is selected or combined with data from other tables. Unfortunately the 
.Net Datatable::Load() command uses the information returned by
SQLiteDataReader::GetSchemaTable(). This means that the result of many queries 
cannot be loaded into a Datatable using the Load() command because of 
non-nullable columns being null (due to a left join) or even wrong (the 
Datatable just drops "duplicate" rows when loading data). See the code below 
that illustrates the problem.

I'm not sure how other DB drivers solve this problem, but it seems to me the 
SQLite driver should stop trying to be clever and just always set the IsUnique 
and IsKey columns to false and also always allow null values.

Jann

using System.Data;
using System.Data.SQLite;
using NUnit.Framework;

namespace SQLiteDemo
{
[TestFixture]
public class Demo
{
private SQLiteConnection m_connection;

[SetUp]
public void CreateDatabase()
{
m_connection = new SQLiteConnection("Data Source=:memory:");
m_connection.Open();
using (var command = new SQLiteCommand())
{
command.CommandText =
@"CREATE TABLE P (
  Pid1 INT NOT NULL,
  Pid2 INT NOT NULL,
  Value TEXT NOT NULL,
  CONSTRAINT PK_P PRIMARY KEY (Pid1, Pid2)
  );
CREATE TABLE PM (
  Pid1 INT NOT NULL,
  Pid2 INT NOT NULL,
  Value TEXT NOT NULL,
  CONSTRAINT PK_PM PRIMARY KEY (Pid1, Pid2, Value)
  );";
command.Connection = m_connection;
command.ExecuteNonQuery();
}

using (var command = new SQLiteCommand())
{
command.CommandText =
@"INSERT INTO P VALUES(1, 1, 'A');
  INSERT INTO P VALUES(2, 1, 'A');
  INSERT INTO P VALUES(3, 1, 'B');
INSERT INTO PM VALUES(1, 10, 'A');
INSERT INTO PM VALUES(3, 1, 'A');";
command.Connection = m_connection;
command.ExecuteNonQuery();
}
}

[TearDown]
public void CleanDatabase()
{
m_connection.Close();
m_connection = null;
}

[Test]
public void Case1()
{
var dt = new DataTable();
using (var command = new SQLiteCommand(@"SELECT P.Pid1, PM.Pid2
  FROM P
  LEFT JOIN PM ON P.Value = 
PM.Value", m_connection))
{
using (var reader = command.ExecuteReader())
{
var schema = reader.GetSchemaTable();

dt.Load(reader);
}
}

Assert.That(dt.Rows.Count, Is.EqualTo(5));
}

[Test]
public void Case2()
{
var dt = new DataTable();
using (var command = new SQLiteCommand(@"SELECT P.Pid1,
 CASE WHEN PM.Pid2 IS NULL 
THEN P.Pid2 ELSE PM.Pid2 END
  FROM P
  LEFT JOIN PM ON P.Value = 
PM.Value", m_connection))
{
using (var reader = command.ExecuteReader())
{
var schema = reader.GetSchemaTable();

dt.Load(reader);
}
}

Assert.That(dt.Rows.Count, Is.EqualTo(5));
}
}
}



Winton Capital Management Limited (?Winton?) is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering m

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

[Joe Mistachkin]

Jann Roder wrote:
>
> The implementation of GetSchemaTable() in SQLiteDataReader seems to be
> based on the properties of the columns used in the select.  Obviously
> uniqueness, nullness and primary key properties do not transfer when
> only a subset of the columns is selected or combined with data from
> other tables. 
>

The official MSDN docs are a bit fuzzy on these points:


https://msdn.microsoft.com/en-us/library/system.data.idatareader.getschemata
ble%28v=vs.110%29.aspx

> 
> Unfortunately the .Net Datatable::Load() command uses the information
> returned by SQLiteDataReader::GetSchemaTable().  This means that the
> result of many queries cannot be loaded into a Datatable using the
> Load() command because of non-nullable columns being null (due to a
> left join) or even wrong (the Datatable just drops "duplicate" rows
> when loading data). See the code below that illustrates the problem.
> 

Yes, I've seen this behavior while tracking down several past issues.
On a somewhat sunnier note, the built-in ADO.NET support classes seem
remarkably good at adapting to [some of] the of idiosyncrasies of the
various ADO.NET providers.  However, as you have seen, there are some
inconsistencies.

> 
> I'm not sure how other DB drivers solve this problem, but it seems to
> me the SQLite driver should stop trying to be clever and just always
> set the IsUnique and IsKey columns to false and also always allow null
> values.
> 

Unfortunately, changing this method in such a fundamental way would not
be backwards compatible.  Also, in some cases, it can be quite difficult
to determine what the "correct" behavior should be.

--
Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.99.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.99.0 (with SQLite 3.9.2) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] System.Data.SQLite How to activate Progress event?

[Roland Ziegler]

Hi all, I am using System.Data.SQLite, currently 1.0.98.1, with 
EntityFramework 6.1.3.

I want to make use of the SQLiteConnection.Progress event but can't get 
it to fire. I've set SQLiteConnection.ProgressOps to 1, 2 or 10, to no 
avail.

I have also tried the other SQLiteConnection events. StateChange, 
Update, Authorize, Commit and Disposed all worked as anticipated, Trace 
did not. Could that be related?

I obtain the current SQLiteConnection from EF's DbContext instance, set 
ProgressOps to non-zero and subscribe the Progress event. After that I 
run my queries or insert new data, commit the whole thing via 
DbContext.SaveChanges() and dispose of the context. All works fine, but 
SQLite just won't give progress feedback.

Are there any tricks to get Progress working?

Thanks
Roland

[sqlite] System.Data.SQLite How to activate Progress event?

[Joe Mistachkin]

Roland Ziegler wrote:
>
> I want to make use of the SQLiteConnection.Progress event but can't get 
> it to fire. I've set SQLiteConnection.ProgressOps to 1, 2 or 10, to no 
> avail.
>

As long as the event is set and the number of ops is greater than zero, it
should work.  Perhaps the Entity Framework is using more than one
connection?

The Progress event is per-connection and will only fire for progress events
related to its associated connection.

--
Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.98.0 released

[Steffen Mangold]

>
> System.Data.SQLite version 1.0.98.0 (with SQLite 3.8.11.1) is now available 
> on the System.Data.SQLite website:
>
Great news, thanks Joe!!

Regards Steffen

[sqlite] System.Data.SQLite version 1.0.98.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.98.0 (with SQLite 3.8.11.1) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] System.Data.SQLite 1.0.98.0 release

[Steffen Mangold]

Hi,

is there any target date when the preRelease branch gets over to a actual 
release?

Is a really hard show stopper for our development at the moment. We checked 
everything for compatibility before merge your current trunk to Visual Studio 
2015 and we forget about the SQLite design tool. :(

Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite 1.0.98.0 release

[Joe Mistachkin]

If everything goes as planned, it should be out later today (US Pacific Time).

Sent from my iPhone

> On Aug 19, 2015, at 4:37 AM, Steffen Mangold  powerdoo.com> wrote:
> 
> Hi,
> 
> is there any target date when the preRelease branch gets over to a actual 
> release?
> 
> Is a really hard show stopper for our development at the moment. We checked 
> everything for compatibility before merge your current trunk to Visual Studio 
> 2015 and we forget about the SQLite design tool. :(
> 
> Regards
> Steffen Mangold
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 

[sqlite] System.Data.SQLite preRelease branch

[Steffen Mangold]

Steffen Mangold wrote:
>
> Until final release I want to download the preRelease [e670692d90] 
> created for 18 days.
>

Joe Mistachkin wrote:
>
> Normally, the "preRelease" branches are just a staging area for changes 
> needed during the release process.
>
> If packages are available for a pre-release build, 
> there will be a "Pre-Release Download" link to the far left on the web site 
> navigation panel.
>
> Anyhow, the 1.0.98.0 release should be out sometime this week.
>

Thanks for make it clear. I hope for a fast release. :) Can't wait to take up 
programming again, with Visual Studio 2015.

--
Steffen Mangold

[sqlite] System.Data.SQLite preRelease branch

[Steffen Mangold]

Hi,

on the "News" site I see the update with support of Visual Studio 2015 is 
scheduled for some day in near future.
Until final release I want to download the preRelease [e670692d90] created for 
18 days.

When I try to download the "sqlite-netFx46-setup-bundle-x86-2015-1.0.98.0.exe" 
from 
https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki I 
get an error "Not Found, Not logged in".

How can I download the preRelease?

Best Regards

Steffen Mangold

[sqlite] System.Data.SQLite preRelease branch

[Joe Mistachkin]

Steffen Mangold wrote:
>
> Until final release I want to download the preRelease [e670692d90]
> created for 18 days.
>

Normally, the "preRelease" branches are just a staging area for changes
needed
during the release process.

If packages are available for a pre-release build, there will be a
"Pre-Release
Download" link to the far left on the web site navigation panel.

Anyhow, the 1.0.98.0 release should be out sometime this week.

--
Joe Mistachkin

[sqlite] System.Data.SQLite encryption

[Marco Bambini]

Anyone know which encryption algorithm is used in System.Data.SQLite?
Seems like it doesn?t use the standard SEE sqlite extension.

Thanks a lot.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs

[sqlite] System.Data.SQLite encryption

[Kevin Benson]

On Thu, Aug 6, 2015 at 4:16 AM, Marco Bambini  wrote:

> Anyone know which encryption algorithm is used in System.Data.SQLite?
> Seems like it doesn?t use the standard SEE sqlite extension.
>

https://www.mail-archive.com/sqlite-users at sqlite.org/msg87770.html

--
   --
  --
 --???--
K e V i N

[sqlite] System.Data.SQLite 1.0.97 on Win10

[Simon Slavin]

On 24 Jul 2015, at 9:05am, Jan Leimbach  wrote:

> I created a simple test statement like UPDATE tablename SET field = '123'
> WHERE field = '321'
> It returns always "Not an error" and does not update the table.

It's like your Mum told you to finish empty all bins but they were already 
empty.  Then she asks you if you did it and you say "Yes".  You did what she 
asked you.

The command will change data in all rows where this is true:

WHERE field = '321'

If there is one row where field = '321', it will change one row and report "Not 
an error".

If there are six rows where field = '321', it will change six rows and report 
"Not an error".

If there are no rows where field = '321', it will change no rows and report 
"Not an error".  Because it did its job.  There just wasn't anything to do.

So if it apparently doesn't do anything try executing this command

SELECT * FROM  tablename WHERE field = '321'

and see if there was anything to do.

Simon.

[sqlite] System.Data.SQLite 1.0.97 on Win10

[Jan Leimbach]

Hi everyone,

I try to update a table in my sqlite database and get "Not an error" result
from the SQLite engine. The same query works on win7. I know that win10 is
not final released yet, but I have no clue wants going wrong here.

I created a simple test statement like UPDATE tablename SET field = '123'
WHERE field = '321'
It returns always "Not an error" and does not update the table.

The simple code is like this:


SQLiteConnection connection = new SQLiteConnection();
connection.ConnectionString = "Data Source=" + sourceDb;
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = "UPDATE daten SET einrichtungs_kz =
'WL10022093' WHERE einrichtungs_kz LIKE '%20II%'";
command.ExecuteNonQuery();
connection.Close();

Can someone give me a hint?
Thanks!
Jan

[sqlite] System.Data.SQLite version 1.0.97.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.97.0 (with SQLite 3.8.10.2) 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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

[Mike Nicolino]

Yes, this branch does resolve the issue, thanks much!

This branch looks to be from the current mainline; I'll apply the fix locally 
to the 1.0.96.0 released version until the next release of System.Data.SQLite.

Thanks,
MikeN


-Original Message-
From: sqlite-users-bounces 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 wrote:
>
> The issue is isolated to ThreadAbortException since you can't catch it 
> and prevent it from being re-thrown.  I did find a 'fix' for a similar 
> issue in SystemData.SQLite back on 10/11/2012:
>

Thanks for the excellent analysis of the issue.  I believe you are completely 
correct.

The previous "fix" was for sqlite3_prepare(), to prevent any leakage of native 
handles prior to their ownership being "transferred" into an official critical 
handle object.

I've now implemented the necessary changes on a branch, pending more testing,
here:

https://system.data.sqlite.org/index.html/timeline?r=stepNoThreadAbort

Could you test these changes in your environment and let us know if they clear 
the issue?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[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 among other 
things to prevent a malicious user from sucking up web resources by spawning 
repeated long running requests).  The effect is IIS will abort threads that 
exceed the time threshold.  I'm seeing the GC finalizer get stuck trying to 
finalize an object in SQLite.Interop, blocking on a critical section (which 
eventually leads to memory exhaustion).  After a lot of digging, I believe the 
situation is as follows:


-  Request for a long running query via SQLite starts

-  SQLite 'step' is called, drops into unmanaged code, enters a 
critical section, then calls back to managed code for virtual table processing

-  IIS aborts the thread causing a ThreadAbortException in managed code 
(Virtual table processing)

-  Stack starts unrolling due to the ThreadAbortException, which 
prevents the unmanaged code from releasing the critical section

-  Finalizer gets stuck trying to acquire the critical section when the 
underlying System.Data.SQLite object(s) are getting finalized.

The issue is isolated to ThreadAbortException since you can't catch it and 
prevent it from being re-thrown.  I did find a 'fix' for a similar issue in 
SystemData.SQLite back on 10/11/2012:


https://system.data.sqlite.org/index.html/fdiff?v1=3994ed2958c14a11&v2=d05529e749a4f10b&sbs=1

I don't think the 'step' code is protected in the manner of the above fix 
(likely unneeded at the time, since virtual tables were not supported and there 
wasn't a case of 'step' dropping into unmanaged code and then back to managed 
code).

Questions:

-  Have I evaluated this issue correctly or is there potentially 
something wrong with my integration?

-  Presuming this is a bug, does anyone have a workaround suggestion?  
I'm somewhat hesitant to change the 'step' source in System.Data.SQLite to use 
the same approach as the 10/11/2012 fix, worrying about other potential side 
effects.

Thanks,
MikeN

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

[Joe Mistachkin]

Mike Nicolino wrote:
>
> The issue is isolated to ThreadAbortException since you can't catch it and
> prevent it from being re-thrown.  I did find a 'fix' for a similar issue
> in SystemData.SQLite back on 10/11/2012:
>

Thanks for the excellent analysis of the issue.  I believe you are
completely
correct.

The previous "fix" was for sqlite3_prepare(), to prevent any leakage of
native
handles prior to their ownership being "transferred" into an official
critical
handle object.

I've now implemented the necessary changes on a branch, pending more
testing,
here:

https://system.data.sqlite.org/index.html/timeline?r=stepNoThreadAbort

Could you test these changes in your environment and let us know if they
clear
the issue?

--
Joe Mistachkin

[sqlite] System.Data.SQLite, Need alternate way to get field length

[Drago, William @ CSG - NARDA-MITEQ]

Thanks for the reply, Clemens. The problem is now solved.


--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch
> Sent: Saturday, May 02, 2015 3:11 PM
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] System.Data.SQLite, Need alternate way to get
> field length
>
> William Drago wrote:
> > I am trying to determine the number of bytes in a blob. According to
> the help file under SQLiteDataReader.GetBytes Method in the Remarks
> section:
> >
> > "To determine the number of bytes in the column, pass a null value
> for the buffer. The total length will be returned."
> >
> > I'm working in VEE and VEE doesn't have a null keyword, so I tried
> System.DBNull.Value and I get an error (signatures don't match).
>
> If VEE (whatever that is) does not allow you to specify something that
> ends up as a null reference, the you cannot use this mechanism.
>
> > So, are there any other ways to get the number of bytes in a blob?
>
> SELECT length(MyLittleBlob) FROM ...
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] System.Data.SQLite, Need alternate way to get field length

[Clemens Ladisch]

William Drago wrote:
> I am trying to determine the number of bytes in a blob. According to the help 
> file under SQLiteDataReader.GetBytes Method in the Remarks section:
>
> "To determine the number of bytes in the column, pass a null value for the 
> buffer. The total length will be returned."
>
> I'm working in VEE and VEE doesn't have a null keyword, so I tried 
> System.DBNull.Value and I get an error (signatures don't match).

If VEE (whatever that is) does not allow you to specify something that
ends up as a null reference, the you cannot use this mechanism.

> So, are there any other ways to get the number of bytes in a blob?

SELECT length(MyLittleBlob) FROM ...


Regards,
Clemens

[sqlite] System.Data.SQLite, Need alternate way to get field length

[William Drago]

All,

I am trying to determine the number of bytes in a blob. 
According to the help file under SQLiteDataReader.GetBytes 
Method in the Remarks section:

"To determine the number of bytes in the column, pass a null 
value for the buffer. The total length will be returned."

I'm working in VEE and VEE doesn't have a null keyword, so I 
tried System.DBNull.Value and I get an error (signatures 
don't match).

I've tried a few other things, but VEE rejects everything 
that isn't a byte array or pointer to a byte array. I don't 
know if I can blame VEE. The method signature says byte[], 
so VEE is expecting to see a byte array or pointer to a byte 
array.

So, are there any other ways to get the number of bytes in a 
blob?

Thanks,
-Bill

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with a sqlite database file

[Jingfei Hu]

Hi all,
First I need your instructions about how to reply a daily digest email
because if I reply it directly, it seems the email carries a lot of topics
which doesn't belong to me and also it would bother others. And it's not
very easy for me to locate my topic if there are many and reply it
accordingly. BTW, I don't receive an independent reply for the topic of
myself. Only digest email is received. Is it because I choose to? Anyway I
only leave the message I want here and comment in line. Thanks.

--

Message: 4
Date: Sun, 19 Apr 2015 17:22:06 -0700
From: "Joe Mistachkin" 
To: "'General Discussion of SQLite Database'"

Subject: Re: [sqlite] System.Data.Sqlite with EF6 and VS2013 not
working with asqlite database file
Message-ID: <16CD11762DDC441E9DAFF33904AE7DC7 at LACHRYMOSE>
Content-Type: text/plain;   charset="us-ascii"


Jingfei Hu wrote:
> 
> I have a VS2010 project from one of my friends. The project contains a
> sqlite3 database file containing some tables and some views. According to
my
> friend, the database file is working properly with Visual Studio 2010 at
> that time. Also I can see the edmx file and generated code files from the
> VS2010 project. And I also find out it still uses provider
> System.Data.Sqlite instead of System.Data.Sqlite.EF6.
> 

What version of System.Data.SQLite is he using?  Recent versions should
default
to the System.Data.SQLite.EF6 provider.
Jingfei: The version information has been lost because my friend is not an
IT guy. And the project, you know, has been through a lot transitions. Apart
from that, which version does it start from that the Sytem.Data.SQLite use
System.Data.SQLite.EF6 provider as the default? I download a
sqlite-netFx40-setup-bundle-x86-2010-1.0.82.0 from another website because
this system.data.sqlite.org doesn't maintain the old version. And that
version still uses System.Data.SQLite as the default. 
> 
> And when I open the project with Visual studio 2013 and compile it, it has
a
> failure saying 'the provider System.Data.Sqlite has not been registered in
> app.config or machine.config'. To fix this, first I complete the following
> installations
> 

That error message makes sense.  The System.Data.SQLite.EF6 provider should
be
used when EF6 support is wanted.

> 
> Then open the edmx file with Xml editor and manually change the
> 'System.Data.Sqlite' to 'System.Data.Sqlite.EF6' and then compile it, the
> error message changes to be like 'Object not reference an instance'. After
> that I try another way, delete the existed edmx file (starting from
> scratch). When I use 'New ADO.Net Entity Model' wizard of VS2013 to create
a
> model in a new console project, everything appears fine, but actually not.
> One of the view I need heavily is not auto-generated with the below
warning
> message
> 

Using an EDMX generated with one version of Visual Studio with a different
version seems unlikely to work, at least from my personal experience.

> 
> warning 6013: The table/view 'main.xxx does not have a primary key defined
> and no valid primary key could be inferred. This table/view has been
> excluded. To use the entity, you will need to review your schema, add the
> correct keys, and uncomment it.
> 

If the table actually does have a primary key defined, maybe the EDMX from
the
other version of Visual Studio is incompatible?

Jingfei: No, the view doesn't have a primary key defined. I recheck the
schema using sqlite console tool and it doesn't have.  However, in Visual
Studio 2010, it can infer a primary key for the view from the database file.
So I wonder whether it's the version of VS or the version of
System.Data.Sqlite that causes this difference.

--
Joe Mistachkin

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with asqlite database file

[Joe Mistachkin]

Jingfei Hu wrote:
> 
> I have a VS2010 project from one of my friends. The project contains a
> sqlite3 database file containing some tables and some views. According to
my
> friend, the database file is working properly with Visual Studio 2010 at
> that time. Also I can see the edmx file and generated code files from the
> VS2010 project. And I also find out it still uses provider
> System.Data.Sqlite instead of System.Data.Sqlite.EF6.
> 

What version of System.Data.SQLite is he using?  Recent versions should
default
to the System.Data.SQLite.EF6 provider.

> 
> And when I open the project with Visual studio 2013 and compile it, it has
a
> failure saying 'the provider System.Data.Sqlite has not been registered in
> app.config or machine.config'. To fix this, first I complete the following
> installations
> 

That error message makes sense.  The System.Data.SQLite.EF6 provider should
be
used when EF6 support is wanted.

> 
> Then open the edmx file with Xml editor and manually change the
> 'System.Data.Sqlite' to 'System.Data.Sqlite.EF6' and then compile it, the
> error message changes to be like 'Object not reference an instance'. After
> that I try another way, delete the existed edmx file (starting from
> scratch). When I use 'New ADO.Net Entity Model' wizard of VS2013 to create
a
> model in a new console project, everything appears fine, but actually not.
> One of the view I need heavily is not auto-generated with the below
warning
> message
> 

Using an EDMX generated with one version of Visual Studio with a different
version seems unlikely to work, at least from my personal experience.

> 
> warning 6013: The table/view 'main.xxx does not have a primary key defined
> and no valid primary key could be inferred. This table/view has been
> excluded. To use the entity, you will need to review your schema, add the
> correct keys, and uncomment it.
> 

If the table actually does have a primary key defined, maybe the EDMX from
the
other version of Visual Studio is incompatible?

--
Joe Mistachkin

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with a sqlite database file

[Jingfei Hu]

Hi team,

My dev box is:

1.   Windows 8.1, 64 bit

2.   Visual Studio 2013 with update 4



I've got a problem like this:

I have a VS2010 project from one of my friends. The project contains a
sqlite3 database file containing some tables and some views. According to my
friend, the database file is working properly with Visual Studio 2010 at
that time. Also I can see the edmx file and generated code files from the
VS2010 project. And I also find out it still uses provider
System.Data.Sqlite instead of System.Data.Sqlite.EF6. And when I open the
project with Visual studio 2013 and compile it, it has a failure saying 'the
provider System.Data.Sqlite has not been registered in app.config or
machine.config'. To fix this, first I complete the following installations

1.   sqlite-netFx451-setup-bundle-x86-2013-1.0.96.0.exe is installed
along with the Entity framework 6 tools for vs2012
 &2013

2.   Nuget package System.Data.Sqlite is installed to the latest version
1.0.96.0 and entity framework version is 6.1.2

Then open the edmx file with Xml editor and manually change the
'System.Data.Sqlite' to 'System.Data.Sqlite.EF6' and then compile it, the
error message changes to be like 'Object not reference an instance'. After
that I try another way, delete the existed edmx file (starting from
scratch). When I use 'New ADO.Net Entity Model' wizard of VS2013 to create a
model in a new console project, everything appears fine, but actually not.
One of the view I need heavily is not auto-generated with the below warning
message



warning 6013: The table/view 'main.xxx does not have a primary key defined
and no valid primary key could be inferred. This table/view has been
excluded. To use the entity, you will need to review your schema, add the
correct keys, and uncomment it.



I am sort of blocking now. Any ideas about what's going on here and how to
fix that.



Best Wishes,

Jingfei

[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

Hello,

thank you very much!
The zip does the trick!

The speed of spellfix is simply mindblowing!

Cheers
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Hick 
Gunter
Gesendet: Donnerstag, 12. M?rz 2015 19:17
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net

The zip should contain 4 files

shell.c
sqlite3.c
sqlite3.h
sqlite3ext.h

sqlite-amalgamation-3080803.zip

-Urspr?ngliche Nachricht-
Von: sonypsx [mailto:sonypsx at gmx.net]
Gesendet: Donnerstag, 12. M?rz 2015 18:56
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net

Hello,

may i ask again ...
Can somebody help to successfully compile spellfix.c for windows?
Errors see below!

Cheers
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von sonypsx
Gesendet: Mittwoch, 04. M?rz 2015 19:54
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net

Hello Joe,

ok i'll tried:

gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c

and got this error:

c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\  -shared -o spellfix.dll 
c:\Sqlite\ext \misc\spellfix.c In file included from
c:\Sqlite\ext\misc\spellfix.c:17:0:
c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or 
direct ory  #include "sqlite3.h"
 ^
compilation terminated.

c:\MinGW\bin>

If I look into sqlite3ext.h i see the reference to the sqlite3.h file which 
does not exist in the whole sqlite source (zip) which I downloaded from
http://www.sqlite.org/src/info/e693e11d1b926597


Can you help me please?

Best regards
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe 
Mistachkin
Gesendet: Montag, 02. M?rz 2015 22:37
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net


sonypsx wrote:
>
> could some please post a sample how to use the spellfix module with 
> System.Data.SQLite under VB.net?
>

The first step would be to compile the spellfix extension as a loadable module, 
as documented here:

https://www.sqlite.org/loadext.html

Next, you can load it using the SQLiteConnection.LoadExtension method.

Finally, you should be able to follow along with the normal spellfix docs,
here:

https://www.sqlite.org/spellfix1.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
 Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: hick at scigames.at

This communication (including any attachments) is intended for the use of the 
intended recipient(s) only and may contain information that is confidential, 
privileged or legally protected. Any unauthorized use or dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please immediately notify the sender by return e-mail message and 
delete all copies of the original communication. Thank you for your cooperation.


___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite and spellfix under VB.net

[Keith Medcalf]

Make sure that you have all the necessary .h files in the same directory as the 
spellfix.c source code (the #include's use " " rather than < >, which means 
look in the current directory, not the include path).

Use the following command line in the directory containing source (.c) and 
header (.h) files:

gcc -mdll -s spellfix.c -o spellfix.dll

Notes:  -mthreads is not necessary.  static lib-gcc is not necessary.  This 
will generate only dependancies on KERNEL32 and the MSVCRT.DLL subsystem 
runtime.  If you want to use a specific (common) runtime, then you need to link 
that runtime.

The long form might be required for some modules:

gcc -mdll -mthreads -s -DSQLITE_API=__declspec(dllexport) -Wl,-Bstatic 
 -o  -static-libgcc

plus any special platform runtimes you want to use in preference to the 
subsystem runtime (such as msvcrt90 etc).

---
Theory is when you know everything but nothing works.  Practice is when 
everything works but no one knows why.  Sometimes theory and practice are 
combined:  nothing works and no one knows why.


>-Original Message-
>From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
>bounces at mailinglists.sqlite.org] On Behalf Of sonypsx
>Sent: Thursday, 12 March, 2015 11:56
>To: 'General Discussion of SQLite Database'
>Subject: Re: [sqlite] System.Data.SQLite and spellfix under VB.net
>
>Hello,
>
>may i ask again ...
>Can somebody help to successfully compile spellfix.c for windows?
>Errors see below!
>
>Cheers
>sonypsx
>
>-Urspr?ngliche Nachricht-
>Von: sqlite-users-bounces at mailinglists.sqlite.org
>[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von
>sonypsx
>Gesendet: Mittwoch, 04. M?rz 2015 19:54
>An: 'General Discussion of SQLite Database'
>Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net
>
>Hello Joe,
>
>ok i'll tried:
>
>gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c
>
>and got this error:
>
>c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\  -shared -o spellfix.dll
>c:\Sqlite\ext \misc\spellfix.c In file included from
>c:\Sqlite\ext\misc\spellfix.c:17:0:
>c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or
>direct ory  #include "sqlite3.h"
> ^
>compilation terminated.
>
>c:\MinGW\bin>
>
>If I look into sqlite3ext.h i see the reference to the sqlite3.h file
>which
>does not exist in the whole sqlite source (zip) which I downloaded from
>http://www.sqlite.org/src/info/e693e11d1b926597
>
>
>Can you help me please?
>
>Best regards
>sonypsx
>
>-Urspr?ngliche Nachricht-
>Von: sqlite-users-bounces at mailinglists.sqlite.org
>[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe
>Mistachkin
>Gesendet: Montag, 02. M?rz 2015 22:37
>An: 'General Discussion of SQLite Database'
>Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net
>
>
>sonypsx wrote:
>>
>> could some please post a sample how to use the spellfix module with
>> System.Data.SQLite under VB.net?
>>
>
>The first step would be to compile the spellfix extension as a loadable
>module, as documented here:
>
>   https://www.sqlite.org/loadext.html
>
>Next, you can load it using the SQLiteConnection.LoadExtension method.
>
>Finally, you should be able to follow along with the normal spellfix
>docs,
>here:
>
>   https://www.sqlite.org/spellfix1.html
>
>--
>Joe Mistachkin
>
>___
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>___
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>___
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

Hello,

may i ask again ...
Can somebody help to successfully compile spellfix.c for windows?
Errors see below!

Cheers
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von sonypsx
Gesendet: Mittwoch, 04. M?rz 2015 19:54
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net

Hello Joe,

ok i'll tried:

gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c

and got this error:

c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\  -shared -o spellfix.dll
c:\Sqlite\ext \misc\spellfix.c In file included from
c:\Sqlite\ext\misc\spellfix.c:17:0:
c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or
direct ory  #include "sqlite3.h"
 ^
compilation terminated.

c:\MinGW\bin>

If I look into sqlite3ext.h i see the reference to the sqlite3.h file which
does not exist in the whole sqlite source (zip) which I downloaded from
http://www.sqlite.org/src/info/e693e11d1b926597


Can you help me please?

Best regards
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe
Mistachkin
Gesendet: Montag, 02. M?rz 2015 22:37
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net


sonypsx wrote:
>
> could some please post a sample how to use the spellfix module with 
> System.Data.SQLite under VB.net?
> 

The first step would be to compile the spellfix extension as a loadable
module, as documented here:

https://www.sqlite.org/loadext.html

Next, you can load it using the SQLiteConnection.LoadExtension method.

Finally, you should be able to follow along with the normal spellfix docs,
here:

https://www.sqlite.org/spellfix1.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite and spellfix under VB.net

[Hick Gunter]

The zip should contain 4 files

shell.c
sqlite3.c
sqlite3.h
sqlite3ext.h

sqlite-amalgamation-3080803.zip

-Urspr?ngliche Nachricht-
Von: sonypsx [mailto:sonypsx at gmx.net]
Gesendet: Donnerstag, 12. M?rz 2015 18:56
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net

Hello,

may i ask again ...
Can somebody help to successfully compile spellfix.c for windows?
Errors see below!

Cheers
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von sonypsx
Gesendet: Mittwoch, 04. M?rz 2015 19:54
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net

Hello Joe,

ok i'll tried:

gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c

and got this error:

c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\  -shared -o spellfix.dll 
c:\Sqlite\ext \misc\spellfix.c In file included from
c:\Sqlite\ext\misc\spellfix.c:17:0:
c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or 
direct ory  #include "sqlite3.h"
 ^
compilation terminated.

c:\MinGW\bin>

If I look into sqlite3ext.h i see the reference to the sqlite3.h file which 
does not exist in the whole sqlite source (zip) which I downloaded from
http://www.sqlite.org/src/info/e693e11d1b926597


Can you help me please?

Best regards
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe 
Mistachkin
Gesendet: Montag, 02. M?rz 2015 22:37
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net


sonypsx wrote:
>
> could some please post a sample how to use the spellfix module with
> System.Data.SQLite under VB.net?
>

The first step would be to compile the spellfix extension as a loadable module, 
as documented here:

https://www.sqlite.org/loadext.html

Next, you can load it using the SQLiteConnection.LoadExtension method.

Finally, you should be able to follow along with the normal spellfix docs,
here:

https://www.sqlite.org/spellfix1.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
 Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: hick at scigames.at

This communication (including any attachments) is intended for the use of the 
intended recipient(s) only and may contain information that is confidential, 
privileged or legally protected. Any unauthorized use or dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please immediately notify the sender by return e-mail message and 
delete all copies of the original communication. Thank you for your cooperation.

[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

Hello Joe,

ok i'll tried:

gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c

and got this error:

c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\  -shared -o spellfix.dll
c:\Sqlite\ext
\misc\spellfix.c
In file included from c:\Sqlite\ext\misc\spellfix.c:17:0:
c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or
direct
ory
 #include "sqlite3.h"
 ^
compilation terminated.

c:\MinGW\bin>

If I look into sqlite3ext.h i see the reference to the sqlite3.h file which
does not exist in the whole sqlite source (zip) which I downloaded from
http://www.sqlite.org/src/info/e693e11d1b926597


Can you help me please?

Best regards
sonypsx

-Urspr?ngliche Nachricht-
Von: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe
Mistachkin
Gesendet: Montag, 02. M?rz 2015 22:37
An: 'General Discussion of SQLite Database'
Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net


sonypsx wrote:
>
> could some please post a sample how to use the spellfix module with 
> System.Data.SQLite under VB.net?
> 

The first step would be to compile the spellfix extension as a loadable
module, as documented here:

https://www.sqlite.org/loadext.html

Next, you can load it using the SQLiteConnection.LoadExtension method.

Finally, you should be able to follow along with the normal spellfix docs,
here:

https://www.sqlite.org/spellfix1.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.96.0 released

[Joe Mistachkin]

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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

Hello,



May I post this question again - since I did not got any reply.



could some please post a sample how to use the spellfix module with
System.Data.SQLite under VB.net?

If i try to create the required table as documented here:



  http://www.sqlite.org/spellfix1.html



I end up with an error: 

"SQL logic error or missing database no such module: spellfix1"



I'm already working fine with the FullText Extensions:

  http://www.sqlite.org/fts3.html

So I'm curious how to do spellfix e.g. Levenshtein in SQLite.



Thanks in advance

sonypsx

[sqlite] System.Data.SQLite and spellfix under VB.net

[Joe Mistachkin]

sonypsx wrote:
>
> could some please post a sample how to use the spellfix module with
> System.Data.SQLite under VB.net?
> 

The first step would be to compile the spellfix extension as a loadable
module, as documented here:

https://www.sqlite.org/loadext.html

Next, you can load it using the SQLiteConnection.LoadExtension method.

Finally, you should be able to follow along with the normal spellfix
docs, here:

https://www.sqlite.org/spellfix1.html

--
Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.95.0 released

[Joe Mistachkin]

System.Data.SQLite version 1.0.95.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.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

Hello,

could some please post a sample how to use the spellfix module with
System.Data.SQLite under VB.net?
If i try to create the required table as documented here:

http://www.sqlite.org/spellfix1.html

I end up with an error:  "SQL logic error or missing database no such
module: spellfix1"

I'm already working fine with the FullText Extensions:
http://www.sqlite.org/fts3.html
So I'm curious how to do spellfix e.g. Levenshtein in SQLite.

Thanks in advance
sonypsx

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

[Duncan Hall]

OK. Embarassing as it is, I'm going to have to 'fess up here.
When I attempted to implement a stopwatch which wasn't available, I
discovered that the app was targetting .Net 2. When I rebuilt it targetting
3.5 it worked.

Unfortunately the stopwatch tells me that it takes longer than I would like
(1.5s against 100ms on the desktop), but that is another story.

Thanks for your help and apologies for the overlooking the obvious

Duncan



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Re-System-Data-SQLite-for-Pocket-PC-RTREE-tp80344p80473.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

[Joe Mistachkin]

Duncan Hall wrote:
>
> I'm not using the Spatialite extension for the query, only the indexes
> created by it on the desktop which I think is a pretty standard SQLite
> RTree. At least it works that way on the desktop.
> 

So, on the target device, only the System.Data.SQLite binaries are being
used?

Could you please try to enable native debugging and capture the call stack
when the issue occurs?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

[Duncan Hall]

> Thanks.  I've run the schema and query here with the desktop version of
> SpatiaLite and it does not crash.  I suspect the underlying issue may be
> an alignment fault (or stack overflow) due to bad interaction between the
> ARM processor architecture and the SpatiaLite extension.

I'm not using the Spatialite extension for the query, only the indexes
created by it on the desktop which I think is a pretty standard SQLite
RTree. At least it works that way on the desktop.
Maybe I should attempt to create the database from scratch using geometry
bounding boxes for the index, but I can't see how this would be different.
Spatialite databases are really just complex SQLite databases


> Out of curiousity, do you know where to find the loadable module binaries
> for Windows CE (for SpatiaLite)?

That would be nice.
I have been trying to do something like this for years, but lacked the
necessary C skills to compile for Mobile. I think it has been done, but not
for recent versions that I am aware of.
My current projects for Android and IOS ran up against licensing issues for
the Spatialite dependent libraries in IOS so I started using the RTree to
run the query, then decode the Spatialite geometry BLOB afterwards. It seems
to run fine for my purposes without too much performance hit, so I revisited
the Windows Mobile 5/6 platform as we have quite a few still running and
they are still being used and sold  in the mobile GIS world despite
Microsoft's abandonment.
I was delighted to find that you are still supporting it.

Duncan




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Re-System-Data-SQLite-for-Pocket-PC-RTREE-tp80344p80423.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

[Joe Mistachkin]

Duncan Hall wrote:
>
> The db was created by Spatialite and has a fairly lengthy schema. I'm not
> sure if I should leave anything out so I'll attach a text file.
> 

Thanks.  I've run the schema and query here with the desktop version of
SpatiaLite and it does not crash.  I suspect the underlying issue may be
an alignment fault (or stack overflow) due to bad interaction between the
ARM processor architecture and the SpatiaLite extension.

Out of curiousity, do you know where to find the loadable module binaries
for Windows CE (for SpatiaLite)?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users