[sqlite] Consuming Visual studio extension SDKs in a remote build

2015-02-23 Thread Saurav Sarkar
Hi All, I am new to .NET and developing an universal Windows application. I am using Visual Studio extension for SQLite for WinRT and Windows Phone. http://www.sqlite.org/2015/sqlite-wp81-winrt-3080801.vsix http://www.sqlite.org/2015/sqlite-winrt81-3080801.vsix I can perfectly install

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

2015-02-23 Thread Richard Hipp
On 2/23/15, Evans, Randall wrote: > Can the incremental BLOB functions (sqlite_blob_open(), sqlite_blob_read(), > etc) access BLOB column data defined in a SQLite virtual table? If it > matters, I am only interested in read-only access at this time. no. > > If the answer is yes, is there any

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

2015-02-23 Thread Evans, Randall
Can the incremental BLOB functions (sqlite_blob_open(), sqlite_blob_read(), etc) access BLOB column data defined in a SQLite virtual table? If it matters, I am only interested in read-only access at this time. If the answer is yes, is there any facility in virtual table support for xColumn or

[sqlite] Backup API and WAL

2015-02-23 Thread R.Smith
On 2015-02-23 04:54 AM, Donald Shepherd wrote: > On Mon Feb 23 2015 at 1:41:31 PM Simon Slavin wrote: > >> On 22 Feb 2015, at 11:15pm, Donald Shepherd >> wrote: >> >>> If I use the backup API to create a copy of an SQLite database that uses >>> Write-Ahead Logging, will the resulting copy

[sqlite] sqlite vfs and wal mode

2015-02-23 Thread Dan Kennedy
On 02/23/2015 12:42 PM, J Decker wrote: > I see; the first part... > > " result of the pragma or the error message if the pragma fails" I missed > the or part... or rather missed the part before the or. > > On Sun, Feb 22, 2015 at 8:13 PM, J Decker wrote: > >> So now that I have the added

[sqlite] Consuming Visual studio extension SDKs in a remote build

2015-02-23 Thread Joe Mistachkin
Saurav Sarkar wrote: > > Does the build machines need to have the same version of SQLite SDKs > installed manually in order to resolve the dependency ? > I'm not exactly sure how versioning works for the VSIX mechanism; however, I think they use exact matching on the version number. > > There

[sqlite] Database connection from within Visual Studio 2010

2015-02-23 Thread Joe Mistachkin
Tom Demler wrote: > > connect to an SQLite database using Visual Studio 2010 Premium. I've > downloaded and run sqlite-netFx40-setup-x64-2010-1.0.94.0.exe. > Only the bundled x86 packages have design-time support. Please download and install:

[sqlite] unreached code in sqlite3.c?

2015-02-23 Thread Nico Williams
On Thu, Feb 12, 2015 at 8:58 AM, Doug Currie wrote: > Well, if TERM_VNULL is 0, then the code is truly unreachable, so I wouldn't > call it a compiler bug. Agreed. But since this usage is so common, the compiler ought to have a switch to turn off warnings for this particular sort of case, which

[sqlite] Database connection from within Visual Studio 2010

2015-02-23 Thread Tom Demler
I'm trying to add the capability to do development of applications that connect to an SQLite database using Visual Studio 2010 Premium. I've downloaded and run sqlite-netFx40-setup-x64-2010-1.0.94.0.exe. I selected a custom install and made sure that all options were selected. I believe that all

[sqlite] Backup API and WAL

2015-02-23 Thread Igor Tandetnik
On 2/22/2015 6:15 PM, Donald Shepherd wrote: > If I use the backup API to create a copy of an SQLite database that uses > Write-Ahead Logging, will the resulting copy reflect the contents of both > the base database file and the -wal file? The data that a particular sqlite3_backup_step sees is

[sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-23 Thread Mersahin
I have the same problem on these conditions --> .net 2013 +updates you said. --> EF 6.1.2 --> 1.0.95.0 also --> .net 2015 CTP --> EF 6.1.2 --> 1.0.95.0 both of them return exception such as "Unable to determine the provider name for provider factory of type

[sqlite] Backup API and WAL

2015-02-23 Thread Donald Shepherd
On Mon Feb 23 2015 at 1:41:31 PM Simon Slavin wrote: > > On 22 Feb 2015, at 11:15pm, Donald Shepherd > wrote: > > > If I use the backup API to create a copy of an SQLite database that uses > > Write-Ahead Logging, will the resulting copy reflect the contents of both > > the base database file

[sqlite] Backup API and WAL

2015-02-23 Thread Simon Slavin
On 22 Feb 2015, at 11:15pm, Donald Shepherd wrote: > If I use the backup API to create a copy of an SQLite database that uses > Write-Ahead Logging, will the resulting copy reflect the contents of both > the base database file and the -wal file? Until a transaction is COMMITted, it's not part