Best practice

Best practice notes and information related to Xbase++
I Love Xbase++ (ILX)
The portal for Xbase++ developers worldwide
ISAM deleted record semantic and SQL
V2.0 ISAM deleted record semantic and SQL
Steffen F. Pirsig
4 min read
Views
514
Background One of the largest differences in how data is managed between SQL and ISAM is how deleted records are handled. In short: ISAM: does mark a record as deleted. This way it is out of scope. To really get rid of the record you need to do a time consuming PACK operation. SQL: does really...
Using large BLOBs with the PostgreSQL server
V2.0 Using large BLOBs with the PostgreSQL server
Andreas Herdt
3 min read
Views
471
Background The PostgreSQL columns of type TEXT and BYTEA allow the storage of large binary data (e.g. PDF documents or images) up to 1GB. If such column types are used in a table their data is accessed like any other data of the record when using the Xbase++ ISAM emulation. With each...
Top Bottom