Database function dictionary

Liquibase Development
1

I’m thinking about creation of database-function dictionary.

It should contain structured registry of native functions of all database families.
It should have many-to-one architecture.

Main aim of this functionality is to translate native functions of one database-type to native functions of another database-type, if it possible.

for example:
function that returns current date-time value in Oracle database will called as:

    CURRENT_TIMESTAMP()
in other database it will called by another way or even it may not exist.

My solution is to equip liquibase with universal entity for every such function and reg it in one catalog.
If our database have a synonym of function - liquibase should use implementation of it and do replace it by this synonym.

After that this registry will be filled by developers, when they will mess with some new functions.
If i need implementation of function - then exactly me should add and configure it.

After this refactoring it will possible to find and replace all locally-used functions by using one universal interface.

What’s your thinking about it?

2

I think that sounds like a good idea.  We definitely want the ability to use standardized function names like we do with CURRENT_TIMESTAMP.  If you can, try to stick to the ANSI SQL names of functions.

Nathan

3

 

  Well, I think that is really a good idea. Having a database function dictionary that contains structured registry of native functions of all database families is awesome. Thank you for sharing that information and idea.