Table Indexes Give tables Indexes if they will help with SELECT queries, e.g. Group Transactions SQLite is capable of carrying out many thousands of actions on a database per second, but not very many individually triggered transactions. You can work round this by grouping transactions such as INSERT or UPDATE to get a massive speed […]

You’ll need to update the .Net Version your project is uses or you’lll get a compile error such as: ‘SQLite’: is not a member of ‘System::Data’ See here

Get the latest set of files from system.data.sqlite.org. Binary packages are intended to be used for development and deployment of their applications onto customer machines.  Ensure you select the correct version for the .NET Framework version and Windows 32/64bit version your applicaiton targets.  Select the version without 'mixed-mode assembly' bundle. (Setup packages are intended for developer machines if […]

https://www.sqlite.org SQLite doesn't require any installation on the client machine.  It depends on the Visual C++ runtime, but you don't need to install it on the client machine. The system.data.sqlite download page contains several "static" packages that already contain the runtime. SQLite isn't a full SQL database, it uses a small set of datatypes and doesn't have […]