For SQLite we need to know:
1) If there is a limit on number of records that can be written to in the SQLite database table.
2) Is there a limit on number of columns allowed?
3) Is it possible and advisable to add a column on the fly after the SQLite database table has been in place and has data in it?
– What options do we have if the answer is No.
4) Is it possible to setup ODBC connection to the SQLite table for ease of running queries? We have certain ODBC tables we currently use in eGate that has over million records.
Thank in advance for your responses.