SQLite Forum

Timeline
Login

38 forum posts by user mistachkin

2021-10-19
01:43 Reply: VS and NuGet and SQLite pkg version (artifact: 98b10a564b user: mistachkin)
In general, the latest release of System.Data.SQLite should be used.  There
should not be any backward incompatible changes between releases unless they
are specially marked in the release notes, e.g.:

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

If the latest release of System.Data.SQLite cannot be used, it should still
be possible to force a previous release to be used via the "package restore"
feature of NuGet:

[https://docs.microsoft.com/en-us/nuget/consume-packages/package-restore]
2021-10-14
20:50 Edit reply: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux (artifact: 12b7857bbb user: mistachkin)

Thanks for the report. This is now fixed on trunk, here:

https://system.data.sqlite.org/index.html/info/6cda6ab5ab4bcee5

18:15 Reply: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux (artifact: eeaefb84ec user: mistachkin)
Thanks for the report.  I believe I see the problem and I'm working on a fix.
2021-10-13
03:56 Edit reply: sqlite3_busy_handler missing (artifact: c8762970f0 user: mistachkin)
Are you able to manually dispose of the SQLiteDataReader and SQLiteCommand
objects associated with a connection?

If not, is there is some external code making use of those objects?

EDIT #1: Meanwhile, I'm going to add a managed event that exposes the busy
         handler.

EDIT #2: Please see [https://system.data.sqlite.org/index.html/info/2541fcec64c42a1d].
2021-10-11
01:12 Edit reply: sqlite3_busy_handler missing (artifact: 08a52f61fc user: mistachkin)
Are you able to manually dispose of the SQLiteDataReader and SQLiteCommand
objects associated with a connection?

If not, is there is some external code making use of those objects?

EDIT #1: Meanwhile, I'm going to add a managed event that exposes the busy
         handler.

EDIT #2: Please see [https://system.data.sqlite.org/index.html/info/2541fcec64c42a1d].
         I still need to add tests.
2021-10-09
21:30 Edit reply: sqlite3_busy_handler missing (artifact: 1f90a2a852 user: mistachkin)
Are you able to manually dispose of the SQLiteDataReader and SQLiteCommand
objects associated with a connection?

If not, is there is some external code making use of those objects?

EDIT: Meanwhile, I'm going to add a managed event that exposes the busy
      handler.
21:22 Reply: sqlite3_busy_handler missing (artifact: 89d1e60d3f user: mistachkin)

Are you able to manually dispose of the SQLiteDataReader and SQLiteCommand objects associated with a connection?

If not, is there is some external code making use of those objects?

2021-10-01
16:41 Reply: sqlite3_busy_handler missing (artifact: 1df5c0138c user: mistachkin)

I'm curious about your use case. Perhaps the managed assembly can provide for it?

Calling directly into the native interop assembly is unsupported.

2021-08-27
17:09 Reply: System.Data.SQLite with SSE (or other encryption) (artifact: e15ee9c3dc user: mistachkin)

Yes; however, there is no longer a need to recompile System.Data.SQLite.

2021-08-25
22:27 Post: System.Data.SQLite version 1.0.115.0 released (artifact: 7fdcf53101 user: mistachkin)

System.Data.SQLite version 1.0.115.0 (with SQLite 3.36.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 this forum if you encounter any problems with this release.

22:18 Reply: System.Data.SQLite with SSE (or other encryption) (artifact: 55245c0a60 user: mistachkin)

SEE is supported in the latest NuGet packages.

2021-08-24
16:28 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS (artifact: 3e59db3125 user: mistachkin)

Maybe try one of the pre-compiled binary packages instead of the NuGet package?

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

2021-08-17
00:51 Reply: System.Data.SQLite.dll & SQLite.Interop.dll digital sign (artifact: 5876720dbf user: mistachkin)

The digital signing was started as of the 1.0.114.0 release.

2021-08-11
16:11 Reply: Runtime error: Unable to load shared library 'SQLite.Interop.dll' or one of its dependencies (artifact: cba0942bfa user: mistachkin)

Maybe this is related to the recent MSBuild issue?

2021-08-06
03:57 Reply: sqlite-netFx46-setup-bundle-x86-2015-1.0.114.0 (artifact: 7dcf9d35d4 user: mistachkin)
I'm not sure I understand what you are trying to accomplish.  However, I can
tell you that the setup packages are no longer officially supported and have
been moved to their own download page:

https://system.data.sqlite.org/index.html/doc/trunk/www/downloads-unsup.wiki

Instead of using a setup package, perhaps one of the NuGet packages would be
better for your situation, please consider:

https://www.nuget.org/packages/System.Data.SQLite/

2021-07-28
04:28 Reply: .NET 5 and sqlite (artifact: c06eeacb69 user: mistachkin)

The System.Data.SQLite.Core NuGet package supports the .NET Standard 2.1, which should work with .NET 5:

https://www.nuget.org/packages/System.Data.SQLite.Core/
00:46 Reply: Need 1.0.110.0 x64 Download (artifact: 4ffaf1ef9a user: mistachkin)
2021-07-08
03:30 Reply: Linkage #defines are unused (artifact: 6463fbcf3b user: mistachkin)
These defines are all used by various build processes, some of which are
internal.
2021-07-01
18:33 Reply: SQLite.Interop.dll and NetStandard (artifact: 243f9db4b9 user: mistachkin)

Maybe this is related to the recent MSBuild issue?

18:32 Reply: Loading bundled extensions in dotnet on linux (artifact: ae6b531896 user: mistachkin)

Can you please try using the fully qualified file name for the "SQLite.Interop.dll" you wish to use?

2021-06-19
16:05 Reply: How to ReadUncommitted for c# .net framework 4.5 (artifact: 61a934a778 user: mistachkin)
System.Data.SQLite does not currently have support for shared cache mode;
therefore, using PRAGMA read_uncommitted will have no effect.
2021-06-11
16:13 Reply: SQLite.Interop.dll: Exception 0xc00000fd (artifact: 149dde15d0 user: mistachkin)
The root cause of this will be extremely difficult to pin down without more
details on the observed behavior, e.g. example code, example schema, stack
traces, etc.
2021-06-10
17:13 Reply: PreLoadSQLite_LibraryFileNameOnly (artifact: adec7ce9a1 user: mistachkin)
The PreLoadSQLite_LibraryFileNameOnly setting is not designed to be used in this
way.

I think in order to accomplish what you are wanting, the existing P/Invoke layer
would have to switch to dynamically created delegates, i.e. no DllImport and no
need for a constant SQLITE_DLL.  That would be a large change in behavior, which
would risk breaking backwards compatibility.
2021-06-09
18:20 Reply: The CopySQLiteInteropFiles target in the NuGet package no longer works in Visual Studio 16.10 (artifact: bedb26d776 user: mistachkin)
So far, I do not see a clean way to work around this issue in MSBuild.

Given how complex (and fragile) the NuGet packaging has been, I sincerely
hesitate to add more complexity here, as it would risk breaking (correct)
versions of MSBuild and/or Visual Studio.
17:06 Reply: SQLite SEE compatibility with existing CryptoAPI databases (artifact: 9d1f69ffe2 user: mistachkin)
I think the most reliable course of action would be to remove the legacy
encryption using an older version of System.Data.SQLite and then encrypt
using SEE.
2021-06-07
17:35 Reply: Lock contention in ForceLogPrepare (artifact: 9f6f1a498c user: mistachkin)

There is now an experimental change on trunk that attempts to address this issue, here:

https://system.data.sqlite.org/index.html/info/15055f1aacc28167

17:32 Reply: No interop libs with net48 and sqlite1.0.113 or higher (artifact: b20185b1f7 user: mistachkin)
Based on this log output, it appears the "CopySQLiteInteropFiles" MSBuild
property is ending up with a value of "false".  This will disable the copy
step in the associated target.

At a minimum, I would skip setting this value to "false" in your project
files and MSBuild targets files.
16:16 Reply: No interop libs with net48 and sqlite1.0.113 or higher (artifact: 2e12c32ead user: mistachkin)
It might be useful to examine the full MSBuild logs.  Can you build your project
with diagnostic logging enabled, e.g. something like:

   dotnet build the_project.csproj --verbosity diagnostic > "%TEMP\build.log"
15:11 Reply: No interop libs with net48 and sqlite1.0.113 or higher (artifact: b7e6b802d1 user: mistachkin)
Why is the following section present in your project file?

  <PropertyGroup>
    <ContentSQLiteInteropFiles>true</ContentSQLiteInteropFiles>
    <CopySQLiteInteropFiles>false</CopySQLiteInteropFiles>
    <CleanSQLiteInteropFiles>false</CleanSQLiteInteropFiles>
    <CollectSQLiteInteropFiles>false</CollectSQLiteInteropFiles>
  </PropertyGroup>

It should not be necessary.  Could you please try removing it?
2021-06-06
15:56 Reply: The CopySQLiteInteropFiles target in the NuGet package no longer works in Visual Studio 16.10 (artifact: af7912023c user: mistachkin)
This proposal seems a bit risky given the nesting of single quote characters.

Does MSBuild actually support this?

Perhaps a more complex MSBuild target is needed with a well-defined sequence
of assignments that do not require nesting of single quotes?
15:43 Reply: The CopySQLiteInteropFiles target in the NuGet package no longer works in Visual Studio 16.10 (artifact: d05633f452 user: mistachkin)
I will look into the feasibility of fixing this issue in a portable and
reliable way later this week.
2021-05-31
21:53 Reply: System.Data.SQLite version 1.0.114.0 released (artifact: 9273c8a923 user: mistachkin)
16:54 Reply: System.Data.SQLite version 1.0.114.0 released (artifact: d2c637bafb user: mistachkin)
The "Password" connection string property relied upon the legacy CryptoAPI
codec.  That code has been unmaintained since 2011, unsupported since 2017,
and completely non-functional since release 1.0.113.0 due to changes in the
underlying core library architecture.

If you need to continue using this feature, you'll need to continue using a
version prior to 1.0.113.0.
2021-05-28
23:03 Reply: System.Data.SQLite version 1.0.114.0 released (artifact: d108466c39 user: mistachkin)

Are you using the "Password" connection string property?

2021-05-25
21:20 Post: System.Data.SQLite version 1.0.114.0 released (artifact: 86fb2f3877 user: mistachkin)

System.Data.SQLite version 1.0.114.0 (with SQLite 3.35.5) 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 this forum if you encounter any problems with this release.

2021-01-14
04:50 Reply: SQLite .NET: CommandBuilder performs really bad on tables with a lot of indexes (artifact: 242b0609cd user: mistachkin)
Thanks for the report.

I've looked at the command builder class and didn't notice anything obvious
that explains the times you are seeing; however, I would like to note that
it relies heavily upon the DbCommandBuilder class provided by .NET itself.

That being said, I'm open to suggestions on how to make it faster as long
as we can retain backwards compatibility.
2020-06-01
16:08 Post: System.Data.SQLite version 1.0.113.0 released (artifact: 672e2351e6 user: mistachkin)

System.Data.SQLite version 1.0.113.0 (with SQLite 3.32.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 this forum if you encounter any problems with this release.

2020-05-25
21:40 Reply: Date/time formatting (artifact: 5dbefa1dd5 user: mistachkin)

I'm not sure if this statement applies to the Win32 API itself or to the MSVCRT function used to interact with it, e.g. localtime().