Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

ginal Message- > From: sqlite-users On Behalf > Of Joe Mistachkin > Sent: Saturday, January 18, 2020 6:29 PM > To: 'SQLite mailing list' > Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll > > > Keith Bertram wrote: >> >>

Re: [sqlite] Possible caching issue between connections with specific inserts

Alexey Podogov wrote: > > Also, the issue can't be reproduced if: > - Cache size is set to 0; or > - Journal mode is WAL; or > - Password for database is too short (please see examples in the > demo code). > Thanks for the report. I'm looking into it no

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram wrote: > > Do you have an estimated time for this release? > If everything goes as planned, right around the third week of February. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

I’ll raise the default limit for the next release of System.Data.SQLite. Sent from my iPhone > On Jan 16, 2020, at 2:01 PM, Keith Bertram wrote: > > Yes I recognize that this would be a problem. I plan on having no more than > 20-25 attachments. > > If I understand correctly, the only way

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

Lite on .NET Core for all supported platforms. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

Which encryption extension are you using? Sent from my iPhone > On Jan 2, 2020, at 5:48 PM, Mike King wrote: > > Hi, > > This is my third attempt to send the following message to the list and each > time it gets rejected as suspected administrivia! (not sure what that is - > I guess it's a

Re: [sqlite] System.Data.SQLite.Core and Core-Linux version Mismatch [nuget]

There doesn’t appear to be a NuGet package named “System.Data.SQLite.Core-Linux” that I can see. I don’t fully understand what the issue is here; however, in general, all versions must match up. Also, the System.Data.SQLite.Core package should contain a native binary usable on Linux x64.

Re: [sqlite] Entity Framework Core support

ng effort and a lot more like a rewriting effort. That does not necessarily mean it won't get done (at some point); however, that will certainly impact it's relative priority on the roadmap. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] Deployment question

ework" setting for the project(s) on the "Application" tab within their project properties. For the set of DLLs from the new download, you'll want to make sure they are all set to .NET Framework 4.6. -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Entity Framework Core support

Given that Entity Framework 6.3.0 was released quite recently (with .NET Core support), it seems that it should be around for a while longer. Currently, there are no specific plans to support Entity Framework Core in System.Data.SQLite. -- Joe Mistachkin

Re: [sqlite] Deployment question

ds/1.0.112.0/sqlite-netFx46-static-bin ary-app-2015-1.0.112.0.zip -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Deployment question

System.data.sqlite. > When you say "installed", do you mean to say that you obtained the files from one of the "Setup" packages on the download page? -- 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.112.0 released

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

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

Yes, the NuGet packages are included in the release. Sent from my iPhone > On Oct 24, 2019, at 9:13 AM, Keith Bertram wrote: > > Ok. Thanks. Does it get immediately placed under nuget? > > Keith > > -Original Message- > From: sqlite-users On Behalf &g

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

Within the next week or so. Sent from my iPhone > On Oct 24, 2019, at 8:37 AM, Keith Bertram wrote: > > Ok. Thanks. Do you have an estimated release date? > > Keith > > -Original Message- > From: sqlite-users On Behalf > Of Joe Mistachkin > Sent: We

Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

but I don't see a matching way to do this within System.Data.SQLite.dll. > Thanks for pointing this out. I'll make sure that some way to accomplish this ends up in the 1.0.112.0 release, which is due out shortly. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] System.Data.SQLite.EF6 feature request: Timespan support

I’ll look into adding this type mapping to System.Data.SQLite. Sent from my iPhone > On Aug 19, 2019, at 7:19 PM, Barry wrote: > > A project I work on runs mainly on SQL Server, but there are times we want > to be able to create the same data model in SQLite for portability. > > We mostly

Re: [sqlite] System.Data.SQLite.dll.config in final build

vior before. Are you manually customizing the MSBuild files for the project? > > It has a note in it: do not copy this file to any of the build output > directories > Generally, it's not supposed to be in those directories. Is it causing any issues when loading the native SQLite int

Re: [sqlite] using System.Data.SQLite on Linux / ".Net Core 2"

Yes. Currently, there are binaries that support Windows, Linux, and MacOS in the “System.Data.SQLite.Core” NuGet package: https://www.nuget.org/packages/System.Data.SQLite.Core Sent from my iPhone > On Jul 21, 2019, at 1:27 PM, Larry Brasfield > wrote: > > Is there a build of

Re: [sqlite] Exception in SQLite.dll (1.0.111.0)

ta.SQLite on more than one thread? Further, are you making sure that all objects that belong to a connection opened on a given thread X are not references on any other threads at the same time (including SQLiteCommand, SQLiteDataReader, et al)? -- Joe Mistachkin ___

[sqlite] System.Data.SQLite version 1.0.111.0 released

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

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

LL build.bat ReleaseManagedOnly -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

et of MSBuild properties and then customize the source code for "SQLite.Interop.dll", e.g. in the "interp.c" source code file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Best way to set default PRAGMA's in System.Data.SQLite

is what it says: > In order to do this, you'll want to execute the PRAGMA statements against the connections that you open prior to running other SQL. The flags for the connection (primarily) control the behavior of System.Data.SQLite and they (generally) have no relation to PRAGMA statements.

Re: [sqlite] Odd exception when creating a connection object

able to compile a build of System.Data.SQLite locally? On trunk, I've added the ability to disable the SQLiteLog subsystem using a new environment variable ('No_SQLiteLog'). Are you able to test the effects of this enhancement in your environment? --

Re: [sqlite] Odd exception when creating a connection object

ative API while the connections are being created? Any details you could provide in order to reproduce this could be useful. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/m

[sqlite] System.Data.SQLite version 1.0.110.0 released

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] Final preparations for the release of System.Data.SQLite v1.0.110.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, February 22nd. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Support for System.Data.SQLite: Different API type for int/integer columns

4-bit integer, mostly for reasons of backward compatibility. In order to customize the mappings, the flag UseConnectionTypes should be used when opening the connection -AND- the AddTypeMapping method is used to override a built-in mapping of the same name (e.g. "

Re: [sqlite] Problem using System.data.SQLite

dress deployment these issues in a portable (and supported) way. It appears that I may need to figure out a way to automatically update the JSON file associated with the application, but that does not seem like the most elegant solution. -- Joe Mistachkin ___

Re: [sqlite] Next release

Roger Schlueter wrote: > > What about System.Data.SQLite? > I would estimate that the next System.Data.SQLite release, which will include SQLite 3.25, will be released within two to three weeks after SQLite 3.25 itself is released, barring an unforeseen complications. -- Joe M

[sqlite] System.Data.SQLite version 1.0.109.0 released

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

Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

olved; however, in the past, these types of issues have been caused > > by a mismatch between how the .NET Framework and SQLite treat typing > > of column values and/or a mismatch between the data type used in the > > query and the one actually stored in the database file. >

Re: [sqlite] Exception at changing a row in .NET FW 4.7.1

e one actually stored in the database file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Different behavior of .NET client 1.0.108.0SQLiteDataAdapter / DataReader on literal int values in select list.

;1 > Since no rows are returend, there is no type information available based on the value of the returned data (as there is no data). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

Re: [sqlite] Need a document/link or suggestion

to "sqlite3" (for Windows) or "libsqlite3" (for other operating systems). This should allow the Mono and/or .NET to find it. I assume it will need to be located in the same directory as the managed "SQLite-net-pcl" assemblies. -- Joe Mistachkin ___

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

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

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.109.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to next Monday, June 4th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

[sqlite] System.Data.SQLite version 1.0.108.0 released

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

Re: [sqlite] not able to save log to sqlite

the connection string must use "Data Source", with a space between the words. I'm not sure if the space is be preserved in your config file. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.108.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this Wednesday, February 28th. Thanks. -- Joe Mistachkin ___ sqlite-users ma

Re: [sqlite] Using Sqlite nuget package in a .Net test assembly

Greg Pagendam-Turner wrote: > > Using Sqlite nugget package version 3.13 > Are you using the full (desktop) .NET Framework? If so, the NuGet package you probably want is probably "System.Data.SQLite". -- Joe Mistachkin ___ sqlite

Re: [sqlite] invalid date time

requested value into the declared type (which I assume is DateTime in this case). -- 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

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

Re: [sqlite] SQLite 3.22.0: Precompiled Windows 64-bit DLL is 32-bit?

Stanley Jacob wrote: > > With 3.22.0, this produces "ImportError: DLL load failed: %1 is not a > valid Win32 application." > With 3.21.0, there is no error. > Thanks for the report. It should be the x64 version now. -- Joe Mistachkin _

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.107.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, January 26th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Compilation failure for sqlite3_analyzer

link the "compat\tcl" directory within the source tree to the "C:\Tcl" directory (via an NTFS junction): CD /D C:\path\to\sqlite\compat MKLINK /J tcl C:\Tcl -- Joe Mistachkin __

Re: [sqlite] An issue with System.Data.SQLite

Aleksey Lulchenko wrote: > > Please, give me the clues what is going wrong, if you can. I think it > is a typical bug in many situations. > Could you please show us the schema of the table (or tables) involved? -- Joe Mistachkin ___

Re: [sqlite] Cross-compiling fails.

er NMAKE macros like USE_NATIVE_LIBPATHS, NCRTLIBPATH, and NSDKLIBPATH. For example, nmake /f Makefile.msc sqlite3.exe XCOMPILE=1 USE_NATIVE_LIBPATHS=1 Alternatively, you can build the amalgamation source code file "sqlite3.c" without cross-compiling and then cross-compile it.

Re: [sqlite] Need SQLite datafiles to be locked on OS level(Windows)

Simon Slavin wrote: > > I'm hoping that Joe Mistachkin, or someone else who understands > that library sees this, just to check that it works the way > you're expecting it to. > Judging from the description so far, I think that both SQLite and System.Data.SQLite are wo

Re: [sqlite] Need SQLite datafiles to be locked on OS level(Windows)

inal poster may wish to increase the default retry values using the SQLITE_FCNTL_WIN32_AV_RETRY file control with the sqlite3_file_control() function, see: https://www.sqlite.org/c3ref/c_fcntl_begin_atomic_write.html -- Joe Mistachkin @ https://urn.

[sqlite] System.Data.SQLite version 1.0.106.0 released

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

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

s 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/

Re: [sqlite] TR: Database base disk is malformed issue

got a Database base disk is malformed issue. We > can repair the base via an sql dump of the base. The issue itself is never > exactly the same : we can have a duplicate  TRIGGER or TABLE or sometimes > INSERT INTO with non valide data. > Are you able to share the full schema for the d

[sqlite] System.Data.SQLite version 1.0.105.2 released

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

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

Another note: The GUID column will need to be marked as UNIQUE or PRIMARY KEY in the CREATE TABLE statement in order for the BLOB lookup to work properly. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

Sergio Capozzi wrote: > > It seems the KeyInfo calculation is doing something wrong. > Is there a workaround or is a known bug? > Version 1.0.105.1 > Thanks for the report. This should now be fixed on trunk. -- Joe Mistachkin @ https://urn.

Re: [sqlite] Memory Issue - GLOBs and Windows Active Mapped File

Have you tried using the command "PRAGMA mmap_size=0;" on the connection? https://www.sqlite.org/pragma.html#pragma_mmap_size -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.

[sqlite] System.Data.SQLite version 1.0.105.1 released

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

Re: [sqlite] Bug causing MSVC to fail to compile Session Extension from the amalgamation

this and fails the > compilation. > Thanks for the report. This should now be fixed on trunk. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

[sqlite] System.Data.SQLite version 1.0.105.0 released

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

Re: [sqlite] Selecting from view with System.Data.SQLite throws

What is the declared data type for the column? Also, what are the raw values for the first row? You may want to use the SQLite command line tool to query the database for them. Sent from my iPhone https://urn.to/r/mistachkin > On Apr 8, 2017, at 12:55 PM, Joseph L. Casale

Re: [sqlite] Visual Studio 2015 Express C# LoadExtension() not working?

I can think of one possibility offhand: The application is running as 32-bit and the extension DLL is 64-bit (or vice-versa). Sent from my iPhone https://urn.to/r/mistachkin > On Mar 17, 2017, at 5:02 PM, Phil Pollock wrote: > > I can't get the LoadExtension()

Re: [sqlite] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

a fairly reasonable value. Alternatively, it can be overridden at compile-time. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listin

Re: [sqlite] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

ACHE_SIZE and/or SQLITE_DEFAULT_PAGE_SIZE defines. -- 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] Bug? Incorrect use of SQLITE_DEFAULT_CACHE_SIZE

_SIZE. > What values are you using for the SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_PAGE_SIZE defines? -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

on: "Specified cast is not valid." > Changing the type of iKeyID to "long" should make it work, e.g.: long iKeyID = (long)sqliteCmd.ExecuteScalar(); Alternatively, you should also be able to use the LastInsertRowId property of the SQLiteConnection object, e.g.:

Re: [sqlite] SQLite3 Pros / Cons

3.dll" by the P/Invoke integration). -- 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] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

ter", "SQLiteCommand", "SQLiteConnection", "SQLiteDataReader", etc. -- 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] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

//urn.to/r/sds_docs The primary classes you'll want to look into include SQLiteConnection, SQLiteCommand, SQLiteParameter, and SQLiteDataReader. -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailingli

[sqlite] System.Data.SQLite version 1.0.104.0 released

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

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.104.0 have begun...

If you have any issues with the current trunk code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Monday, December 12th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Parallel access to read only in memory database

_open*() C APIs? Further details on using URI file names may be found here: https://www.sqlite.org/uri.html -- Joe Mistachkin @ https://urn.to/r/mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.s

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

" 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 version 1.0.103.0 released

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

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.103.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Monday, August 29th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list s

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

re supported on a "best effort" basis, mostly because: 1. They were never fully completed. 2. The Visual Studio extensibility interfaces they use are very fragile and scarcely documented. 3. Debugging them is nefariously difficult. -- Joe Mistach

Re: [sqlite] Failed to install Microsoft Visual C++ Runtime

must (?) be (at least) one that is new (to Visual Studio 2015). -- 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.102.0 released

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

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

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.102.0 have begun...

Eric Sink wrote: > > The next time April 15th falls on a Friday is 2022, so I guess we have plenty > of time. > Actually, it did say Monday, June 20th before I sent it; however, my mail client is apparently acting up. -- Joe Mistachkin __

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.102.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, April 15th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list s

Re: [sqlite] Can't find PInvoke DLL 'SQLite.Interop.101.dll'.

Nigel Walton wrote: > > Can't find PInvoke DLL 'SQLite.Interop.101.dll'. > PID:01FD0185 TID:057E0022 testce.EXE > MissingMethodException > Can't find PInvoke DLL 'SQLite.Interop.101.dll'. > Do you have the appropriate MSVC runtime ("MSVCR110.DLL") i

Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum

must be set to "incremental" first, per: https://www.sqlite.org/pragma.html#pragma_incremental_vacuum -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite built as Multithread

e used with native SQLite libraries that need to work with System.Data.SQLite. -- 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.DLL] Cannot access sqlite database on remote computer

m (which was revised to fix other issues), opening a database on a UNC path requires that the initial backslashes in the file name be doubled, e.g.: mypc\db\Mydb.db -- Joe Mistachkin ___ sqlite-users mail

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

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

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

3:59:59.999. -- Joe Mistachkin

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

s. The file names used by the build scripts are set to those specific values for good reason. -- Joe Mistachkin

[sqlite] How to register System.Data.SQLite as a data source?

e. However, it would be required, with a value of "false", if you actually wanted to make changes to the system. -- Joe Mistachkin

[sqlite] How to register System.Data.SQLite as a data source?

ta source for what? The .NET Framework itself? Visual Studio? The tool used by the official setup packages for this purpose is here: http://urn.to/r/r -- Joe Mistachkin

[sqlite] Use System.Data.Sqlite in Mono on a ARM based Panel

tations, etc. To compile an interop DLL for Mono, please grab the source code, extract it, and then use the following script (or something like it): http://urn.to/r/kJ -- Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.101.0 released

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

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

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.100.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday, April 15th. Thanks. -- Joe Mistachkin

[sqlite] Sqlite and we7 local time issue

ocalTime" branch, here: https://www.sqlite.org/src/timeline?r=winCeLocalTime Please let us know if this clears the issues seen in your WinCE build environment. -- Joe Mistachkin

[sqlite] calling Skip() on IQueryable with LINQ is generating incorrect sql

ataContext class appears to be part of the LINQ-to-MSSQL feature. You probably want to use the ObjectContext class. -- Joe Mistachkin

[sqlite] calling Skip() on IQueryable with LINQ is generating incorrect sql

I get an error. > Maybe it's somehow using LINQ-to-MSSQL instead? What does the C# code look like that is actually performing the LINQ query? -- Joe Mistachkin

[sqlite] calling Skip() on IQueryable with LINQ is generating incorrect sql

inq (or EF6) assembly. In the past, I believe there was an issue where it would not emit the LIMIT clause; however, that was fixed long ago. Perhaps the project is picking up an outdated version of the managed assemblies for System.Data.SQLite somewhere? -- Joe Mistachkin

[sqlite] calling Skip() on IQueryable with LINQ is generating incorrect sql

Tim Stowell wrote: > > var queryable = table.Skip(20); // Incorrect SQL generated > Are you using the latest System.Data.SQLite? Do you have an example of the generated SQL? -- Joe Mistachkin

  1   2   3   4   5   6   7   >