Porting SQLite to platform with no 64-bit integer support
For a project I am working on, we'd like to use SQLite as an embedded
The compiler we use for the platform (based on Analog Devices' Blackfin
processor) does however not support 64-bit integers, which are used by
We have thought of three solutions (or workarounds) for this problem:
1. Compile in C++ mode and define a 64-bit integer class. This may have
problems with dereferencing pointers to such numbers.
2. Redefine i64 as a 32-bit integer and hope they are not really needed
(as long as the database file is < 2GByte).
3. Use the GNU compiler for Blackfin. However, we use a lot of software
that is optimised (#pragmas) for Analog Devices' own compiler, so that
would have to be re-done.