[sqlite] The type of the key field 'xxx' is expected to be 'System.Int64', but the value provided is actually of type 'System.Int32'

Hi team, My bad that in fact the error The type of the key field 'xxx' is expected to be 'System.Int64', but the value provided is actually of type 'System.Int32' happens both under Debug and Release mode. The error is gone after upgrading to 1.0.96.0 version. Thanks, -J From: Jingfei Hu

[sqlite] What software is deployed more than SQLite?

I run a simple search on a Windows XP (virtual) machine of mine and found the following programs using SQLite: * Adobe Reader * Adobe Acrobat Professional * Avira Antivir (almost 400 million use it based on their official website) * Apple Application Support On 05/03/2015 11:32

[sqlite] REGEXP pcre DLL for Windows

Hello, can somebody me please and provide a working almost recent precompiled windows dll version of "pcre" which is capable to load within sqlite3? I did try hard, found some precompiled ones at http://www.airesoft.co.uk/pcre. But they cannot be loaded within sqlite3. I did the try with

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

On 4 May 2015, at 18:52, Scott Doctor wrote: > The day I can open source my rent, groceries, car repairs, is when everything > else can be free. Rent and groceries... yeah, good luck there. ;) But car repairs might actually come along at some point (decade or two?) if the 3D printing scene

[sqlite] SQLite4 on old 32-bit Linux

Hello, I try to run sqlite4 on pretty old 32-bit Linux box, but without success. SQLite4 version [90c09b0451], 2014-09-19 18:48:23 $ sqlite4 a.db SQLite version 4.0.0 2014-09-19 18:48:23 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table b (c

[sqlite] SQLite queries

Hello, This is Amit Golhani from Larsen & Toubro India, currently I am evaluating features of SQLite to meet our product requirements, which are mainly as follows: -database should recover automatically without human intervention in case of abrupt power failure/ crash/ termination of program

[sqlite] Integrating sqlite with Core Data and iCloud

There are a lot of people who go on this journey, and I don't recommend it. If you want to take advantage of iCloud, it's best to use Core Data directly, perhaps with an API shim of your own making that makes it easier and more suitable to your needs. On Apr 25, 2015, at 12:41 PM, Jeff M

[sqlite] SELECT performance vs PRIMARY KEY/UNIQUE constraints

Nicolas there are other people who also receive this mail. if you have code that will help someone else. Please post the information Mr Hipp requested. Jay On Tue, Apr 28, 2015 at 5:08 PM, Nicolas Boullis wrote: > Hi, > > On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard Hipp wrote: > > > >

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

That will be the day I can hit print on my computer and a Roast Beef Sandwich, with lettuce, tomato, onion, cheddar, and a smear of mustard on Marble Rye comes out my printer, all while driving my flying car (it is 2015, where is my flying car?) Scott Doctor scott at