Issue Details (XML | Word | Printable)

Key: CORE-3497
Type: New Feature New Feature
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Sérgio
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Datatypes

Created: 27/May/11 11:00 AM   Updated: 29/May/11 02:21 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Environment: All


 Description  « Hide
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.




 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.