It is not really clear in sqlite.org what SQLite have as limits and size.
32 or 64 Bits ?
SQLite seems to be 32 Bits (whatever that means).
2. Size and limits
How many TABLE can I add in a SQLite Data Base ?
How many Columns in a Record can I add in a SQLite TABLE ?
I created one that have 81 Columns.
I suppose that the number of Records is far above that (and depends on the number of TABLEs; and data in the Records are affected by those).
I suppose that the more TABLE(s) and Columns, the more time the data takes to be read or/and write.
I also know that a Listbox have a finite number of Columns (64 or 256); and here comes my trouble in mind.
Usually, my mouth emit strange noises when I read in a book the variables limits (Integer for example), since that value does not change from IDE to another IDE / Language and you get that information in the language reference and in all books about that IDE:(
But @ sqlite.org, this was not explicitely given (and I had the Listbox max # of column [64 or 256, depends on Xojo version] in mind and that make troubles in my mind).
All: how do I limit to 64 or 256 columns a read in sqlite ?
(to avoid errors at Listbox display time ?)
I have a db with 62 columns nd displaying (data for) that amount of columns in a Listbox is not easy to read.
I use three windows to fullfil the DB (that is one Cardboard A4 page) and I have three other pages to work with (mainly CheckBox / RadioButtons).
Do you have experience of this kind of amount of Columns (or more) ?
Dave / DB Schema Reader providers:
How do you deal with a 50 TABLEs or 129 Columns in a TABLE in your Tadpole / Application software ?
(SQLite DB Graphic Design)