Re: [sqlite] [dotnet core] Could not load file or assembly

On Aug 23, 2018, at 4:01 AM, 小旭未来 wrote: > > Hello,I installed "System.Data.SQLite.Core (1.0.109.1)" in my project, but > when I using "System.Data.SQLite", it throw an exception. > FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, > Version=1.0.109.0,

[sqlite] [dotnet core] Could not load file or assembly

Hello,I installed "System.Data.SQLite.Core (1.0.109.1)" in my project, but when I using "System.Data.SQLite", it throw an exception. FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.109.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'. I installed

Re: [sqlite] Unsigned

> On Aug 23, 2018, at 4:22 AM, Wout Mertens wrote: > > I don't understand, can you not just use blobs as primary keys? You can. And while the usual bignum encodings won't sort correctly with the default blob collation, you can get around that with clever encoding. For example, for unsigned

Re: [sqlite] Unsigned

I don't understand, can you not just use blobs as primary keys? $ sqlite3 SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t(id blob primary key);