PostgreSQL Table Translation Framework v2.0.1

Tested with PostgreSQL v13.1 and v11.3

Only minor issues:

• Better support for NULLs in TT_PadConcat() (#248)
• Added an order parameter to TT_GetIndexTestVal() (#248)
• Fixed an issue with TT_SubstringText() making some translation very slow (#250)
• Fixed a minor issue in TT_PrettyDuration() for durations like 111.2973 and 59.9
• Display MEAN TIME PER ROW in TT_ShowProgress() only when currentRowNb > 1
• Added default error codes for some helper functions
• Minor changes to the main Readme
• Added citing instructions
• Added a license file (GNU)

PostgreSQL Table Translation Framework v2.0.0

Major version number increase from 1.0.0 to 2.0.0 because some helper functions were dropped and hence translation tables written using these functions would have to be modified.

Tested with PostgreSQL v13.1 and v11.3

Main changes:

• Queries prepared by TT_Prepare() now convert all explicit MatchTable(), LookupText(), LookupInt() and LookupDouble() helper functions found in translation tables to LEFT JOINs (#242, #243).

  Implicit calls to those functions (embedded in existing helper functions) continue to work as inline subqueries and are not converted to LEFT JOINs. They should be slower than their converted equivalent.

  All Table Translation Framework helper functions that used to call those functions have been removed. They are:

  • TT_LookupTextMatchList()
  • TT_MatchTableSubstring()
  • TT_LookupTextSubstring()
  • TT_AlphaNumericLookupTextMatchList()
  • TT_AlphaNumericMatchTable()
  • TT_IsLessThanLookupDouble()
  • TT_MinIndexMatchTable()
  • TT_GetIndexMatchTable()
  • TT_MinIndexLookupText()
  • TT_MaxIndexLookupText()
  • TT_GetIndexLookupText()

  Those helper functions will no longer work in existing translation tables and have to be replaced with their explicit lookup helper functions equivalent so that the translation engine can recognize them and convert them to LEFT JOINs:

  Ex. 1. replace getIndexMatchTable() with matchTable(getIndexText())

  Ex. 2. replace isLessThanLookupDouble() with isLessThan(x, lookupText())

  You can have a look at the query prepared by TT_Prepare() in the message tab of the pgAdmin query tool.

• Fixes to or new helper functions (#241)

• General documentation review (#226)

• Others bug fixes (#220, #244)

PostgreSQL Table Translation Framework v1.0.0

Main changes in this release are:

Fixes to or new helper functions (#231, #229, #228, #227, #225, #224, #223, #222, #221, #219, #218, #217, #216, #215, #214)
Report translation progress in the message pane (#232)
Others (#230)

PostgreSQL Table Translation Framework v1.1.0

Tested with PostgreSQL 13.1

Main changes:

• New TT_Translate() function should make every translation much faster (#168)
• Fixes to or new helper functions (#234)

Others bug fixes (#237)

PostgreSQL Table Translation Framework 0.0.6-beta

Main changes in this release are:

• Updates to helper functions
• Modification to log files to avoid locks. Allows multiple translations to run in parallel. #207

Complete list of updates for this release:
#196, #197, #198, #200, #201, #202, #204, #206, #207, #208, #209, #211, #212, #213

PostgreSQL Table Translation Framework 0.0.5-beta

Update to helper function notNull(). This is required for translation tables to work correctly in CASFRI v5.0.4-beta

Complete list of issues resolved for this release:

#195

PostgreSQL Table Translation Framework 0.0.4-beta

Major updates for this release are:

• Engine can be installed as PostgreSQL extension
• New helper functions
• Better handling of NULL values
• Application of default error codes for helper functions
• No longer need to quote numbers in translation tables

Complete list of issues resolved for this release:
#75, #142, #146, #154, #155, #156, #157, #158, #159, #161, #163, #164, #165, #166, #169, #171, #173, #178, #179, #181, #182, #183, #184, #185, #187, #188, #189, #190, #193, #194

PostgreSQL Table Translation Framework 0.0.3-beta

Major updates for this release are:

• Implementation of string list syntax
• Improved error handling
• Renaming of some helper functions
• Separated GIS helper functions into their own install, test and uninstall files

Complete list of issues resolved for this release:

#16, #29, #48, #51, #57, #59, #72, #76, #82, #83, #84, #86, #87, #89, #91, #93, #94, #95, #96, #97, #98, #99, #101, #102, #103, #104, #105, #106, #107, #108, #111, #113, #114, #115, #116, #117, #118, #119, #120, #121, #122, #123, #124, #126, #127, #128, #129, #130, #131, #132, #134, #135, #137, #139, #141, #143, #144, #145, #151, #153

PostgreSQL Table Translation Framework 0.0.2-beta

The major update for this release is that the translator now only accepts text arguments as inputs. The translator then casts input arguments to the correct type inside the helper functions (#17). This simplifies the validation of helper functions in the catalog and greatly reduces the number of signatures needed for helper functions. Additional features include more validation of translation tables, and additions of more helper functions.

Full list of issues resolved in this release:
#8, #12, #15, #17, #20, #23, #28, #29, #31, #36, #37, #41, #44, #45, #47, #49, #52, #53, #54, #56, #58, #60, #61, #62, #63, #64, #65, #66, #67, #68, #69, #70, #71, #74, #77, #78, #79, #80, #81, #88, #90, #92

PostgreSQL Table Translation Framework 0.0.1-beta

Prototype table translation framework for PostgreSQL implementing core engine and helper functions.