Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

2020-02-14 Thread Simon Slavin
On 14 Feb 2020, at 2:59pm, Andy KU7T wrote: > Do you suggest me keeping storing TEXT (and declaring the column as TEXT > instead of GUID) or storing and declaring BLOB (and remove HEX)? TEXT. Makes sorting and searching easier. ___ sqlite-users

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

2020-02-14 Thread Andy KU7T
Thanks for the response. Do you suggest me keeping storing TEXT (and declaring the column as TEXT instead of GUID) or storing and declaring BLOB (and remove HEX)? I think both cases would work, but for performance, does it matter? AS long as my index is binary collated, it probably does not,

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

2020-02-14 Thread Radovan Antloga
In SQLite type guid does not exist. Look at this documentation: https://www.sqlite.org/datatype3.html Affinity for guid would be BLOB but in trigger you store TEXT. I do not use .NET but I think you should use different parameter type. I would use TEXT type. Regards R.A. On 14.02.2020 15:09,

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

2020-02-14 Thread radovan5
In SQLite type guid does not exist. Look at this documentation: https://www.sqlite.org/datatype3.html Affinity for guid would be BLOB but in trigger you store TEXT. I do not use .NET but I think you should use different parameter type. I would use TEXT type. Regards R.A. On 14.02.2020 15:09,

[sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

2020-02-14 Thread Andy KU7T
Hi, I am having trouble searching for a Guid. I think some conversion is missing. I wonder if someone can point me to the error… Column: [ID] GUID(16) Index: CREATE UNIQUE INDEX [ID_INDEX] ON [DXLOG]([ID] COLLATE [BINARY] ASC); Trigger: CREATE TRIGGER [AUTOGENERATE_ID] AFTER INSERT ON [DXLOG]

Re: [sqlite] WITHOUT ROWID tables

2020-02-14 Thread Richard Hipp
On 2/14/20, Wayne Collins wrote: > My first posting so I hope I get the etiquette correct. > > 1st question How can I determine from a C-program if a table was > generated with the "WITHOUT ROWID" option? I have an application where > it is important to know if a table has a rowid or not. To

[sqlite] Prevent receiving "ok" when using the .dump and .output commands

2020-02-14 Thread Iulian Onofrei
How can I prevent receiving the "ok" added here:  https://www.sqlite.org/src/info/b3692c406f7ba625  when I'm using `sqlite -cmd "PRAGMA key " database.sqlite .output`? iulianOnofrei ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] WITHOUT ROWID tables

2020-02-14 Thread Wayne Collins
My first posting so I hope I get the etiquette correct. 1st question How can I determine from a C-program if a table was generated with the "WITHOUT ROWID" option? I have an application where it is important to know if a table has a rowid or not. 2nd Question After a database is defined and

[sqlite] Test

2020-02-14 Thread Iulian Onofrei
test iulianOnofrei ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] multithreaded app with in-memory database and transactions

2020-02-14 Thread Wim Hoekman
On 13-Feb-20 23:38, Keith Medcalf wrote: Correct. "memory" databases can only be shared between connections in the same process, and then only by the sharedcache method. In effect, a "memory" database is nothing more than a cache, and sharing it between connections means sharing the cache.