1. Request for a specific queries' HTML comes into DB
2. Check if contained in Cache
   2.1. YES: Return output -- END
   2.2. NO: CreateAndSave

CreateAndSave

• Creates the HTML for given Query
• Saves created HTML in Cache
• Adds Trigger for Query to all the Tables that Query depends on. If there are any.
  • Trigger meaning that when you INSERT / UPDATE into the Table it regenerates the HTML (preferably after inserting lol)
  • The queries to these triggers shall be stored in a table

Use the builtin XML-Functions (https://www.postgresql.org/docs/current/functions-xml.html) and see if there's a speed improvement.

• First with serializing JSON-HTML
• Creating direct HTML Table

User is able to provide Base Template. Then there would be functions that could generate Tables, Charts, text idk.

The generated stuff would then be placed into the template.

Implementation of Template

• format(formatstr text [, formatarg "any" [, ...] ])
• regexp_replace ( string text, pattern text, replacement text [, flags text ] ) → text
• replace ( string text, from text, to text ) → text