<< Click to Display Table of Contents >> Navigation:  Supported database systems > SQLite > Updating SQLite SQLite

We ship SQLite 3.42 because it was the final version that used the the same software based rounding methods used by PostgreSQL and Sybase SQL Anywhere. So, for example, if you switch from SQLite to PostgreSQL and use exactly the same data the results from any rounding operations performed by the database will be identical. This is important if you use Dispatch for Invoicing.

 

You are free to update SQLite to the very latest version. The latest version of SQLite can be downloaded here:

 

https://sqlite.org/download.html

 

The file you are looking for is the DLL for Windows x86 (32-bit). You will be downloading a ZIP file (e.g. https://sqlite.org/2025/sqlite-dll-win-x86-3500400.zip) that contains the sqlite3.dll file. That file must be unzipped and sqlite3.dll must be copied to the following folder:

 

C:\Program Files (x86)\CanScale\Dispatch3.2\System