You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
You can take a look to postgre DataTypes an you ll see a leack , i use firebird and i dont wanna change i like it but it have some probs or forgoten Improvements.
How can firebird be improved to be the best of the best.
Complex Datatype (Record/Struct on a field), Like PostGreSql. (Several child fields under a field.)
AutoInc DataType - Like Serial PostGre to avoid the use of Trigger -> it should trigger auto the generator.
XML Support - Extremely useful and and remove chils of a xml data.
Calc DataType - Calculate on the fly. is useful because it will be a static field on db - This is usefull for Visual IDE dev.
Aggregate Fields - Extremely usefull.
Boolean DataType - Supposet it will on fb version 3 , (It will be usefull to be a 0 -1 or F - T Char)
- TableField - Datatype - To store tables under a field
1 st Type - To be a table under a field. - Should be an external table but only acessible from this field.
2 nd Type - To be a Table under a field - But To store all Table under the field including structure of the table .
3 rd Type - To be a Static Table under a Blob (the table stucture is always the same)
On the 1st - the table definitions is stored on the table outside the field -should be usefull to this to Point to a table dinamicly - we may point in diferent rows to diferent Tables.
On 2 nd - the field is a blob to store all tabledata and structure (I do this with blobs load and save but the prob is this is not automaticly).
This means each row can have a diferente table ...
On the 3rd - the table definitions is only stored once on the field and the blob stored is only data match is fields header structure.
The text was updated successfully, but these errors were encountered:
Submitted by: Sérgio (sfxcc)
You can take a look to postgre DataTypes an you ll see a leack , i use firebird and i dont wanna change i like it but it have some probs or forgoten Improvements.
How can firebird be improved to be the best of the best.
Complex Datatype (Record/Struct on a field), Like PostGreSql. (Several child fields under a field.)
AutoInc DataType - Like Serial PostGre to avoid the use of Trigger -> it should trigger auto the generator.
XML Support - Extremely useful and and remove chils of a xml data.
Calc DataType - Calculate on the fly. is useful because it will be a static field on db - This is usefull for Visual IDE dev.
Aggregate Fields - Extremely usefull.
Boolean DataType - Supposet it will on fb version 3 , (It will be usefull to be a 0 -1 or F - T Char)
- Network Address Types - 8.9.1. inet - 8.9.2. cidr - 8.9.3. inet vs. cidr - 8.9.4. macaddr
- TableField - Datatype - To store tables under a field
1 st Type - To be a table under a field. - Should be an external table but only acessible from this field.
2 nd Type - To be a Table under a field - But To store all Table under the field including structure of the table .
3 rd Type - To be a Static Table under a Blob (the table stucture is always the same)
On the 1st - the table definitions is stored on the table outside the field -should be usefull to this to Point to a table dinamicly - we may point in diferent rows to diferent Tables.
On 2 nd - the field is a blob to store all tabledata and structure (I do this with blobs load and save but the prob is this is not automaticly).
This means each row can have a diferente table ...
On the 3rd - the table definitions is only stored once on the field and the blob stored is only data match is fields header structure.
The text was updated successfully, but these errors were encountered: