String lengths in the SQL backend

Marcus Wolschon Marcus at wolschon.biz
Thu Nov 13 02:18:49 EST 2008


Well, my 2ct here:

I am using the account-code to store item-numbers/item-barcodes (assets)
or account-numbers (bank-accounts). Item-numbers can get quite long
(think the serial-number identifying a laptop) but 32 characters should be okay,
as long as it's not 32 byte (think Unicode).

How far has the sql-schema matured and what databases are supported atm?
After a few years the SQL-file does get a bit slow to load.

Marcus


More information about the gnucash-user mailing list