SQLite data types are documented [http://www.sqlite.org/datatype3.html here], but what are the important implications and how does it affect the BDB integration?
There are no differences between the Berkeley DB SQL API and the SQLite API related to SQL data types. The code to handle data types in Berkeley DB is identical to the code in SQLite. The documentation says that SQLite uses a dynamic type system as opposed to a static type system, but that it’s backwards compatible. What might be the issues of this from an RDBMS user’s standpoint? First, take a minute to read the SQLite documentation on data types. SQL used to access statically typed databases will be compatible with Berkeley DB.
