[sqlite] : Vacuum and WiCe (Windows Embbeded Compact 7)

2015-08-05 Thread afriendandmore
Hello, I am developing an application for Windows Compact Embedded 7 using .net 3.5 and sqlite. Is there a possibility to run vacuum, mean to compact the database und WinCe from a C# Program? Thank you very much.

[sqlite] SQLite Entity Framework Provider

2015-08-05 Thread Erik Ejlskov Jensen
Joe, There are a number of interfaces that you need to implement in order to support migrations. You can look at the SQL Server and the SQL Server Compact providers in the EF source. Feel free to contact me directly. Ideally, the source code for System.data.sqlite should be hosted on github

[sqlite] Bug in sqlite3_trace/trigger/delete

2015-08-05 Thread sqlite-mail
Hello again ! I forgot also to mention that sqlite do not check for duplicates table constraint declarations see the extended example bellow: - PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE aa(id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE ab(id INTEGER PRIMARY KEY,

[sqlite] SQLite Amalgamation in a GIT repo

2015-08-05 Thread Andy Rahn
I found that there aren't any up-to-date GIT copies of just the amalgamation on github. So, I wrote up some simple steps whereby anyone could make their own. On a project that uses GIT and either git subtree or git submodules, this is a very handy way to keep SQLite up-to-date. http://blog.paddle

[sqlite] Compile Warning from Universal Windows App using Visual Studio 2015

2015-08-05 Thread Weidong Shen
I am already using the latest version (Version 3.8.11.1) which was updated on 2015-07-31. Thanks! From: Joe Mistachkin To: Weidong Shen ; General Discussion of SQLite Database Sent: Tuesday, August 4, 2015 10:40 PM Subject: Re: [sqlite] Compile Warning from Universal Windows App using

[sqlite] Bug in sqlite3_trace/trigger/delete

2015-08-05 Thread sqlite-mail
>Hello ! > > There is also another small bug in sqlite3 parsing of table > constraints the documentation say that "CREATE TABLE" will accept one > or more table constraints separated by comma but the parser do not > catch the absence of a comma, it still seem to works as expected but > if we t

[sqlite] Compile Warning from Universal Windows App using Visual Studio 2015

2015-08-05 Thread Weidong Shen
Hi, I created a test UWP project using Visual Studio 2015/Windows 10 and added a reference to "SQLite.UAP.2015, Version=3.8.11.1". When compiling the project, I get the following warning message: warning MSB3781: The SDK "SQLite.UAP.2015, Version=3.8.11.1" depends on the following SDK(s) "Micro