Category Blogs

PostgreSQL: Generating Generic Auditing Trigger

PostgreSQL, as one of the best open source object-relational DBMS, is quite popular today. However, it doesn’t provide built-in auditing function, which is required by most production systems.

Let’s see how we generate generic auditing function for a table in PostgreSQL schema. Then we should be able to generate auditing function for the entire schema easily.

Let’s assume we have a table name as input parameter, and we have a pre-built auditing table, which contain all fields from source table, in line 5 below, plus all other auditing fields:

Read More

Introducing Xonomy – An Advanced Open Source XML Editor

There are quite a few XML Editors on the market, but it’s really hard to find out one which is nicely implemented and can be used as an integration part of web-based application until we found Xonomy.

Xonomy is written in JavaScript by Michal Boleslav MÄ›chura. It can be embedded in any web pages. It offers a series advanced features, such as syntax highlight, left-click menu, context-based customizable menu items, editable attribute value from picklist, etc. User may even use drag-n-drop to adjust the position of tree node. With all these features, it’s well-equipped as an advanced web-based editor with pre-defined constraints for tree structure, attribute, and attribute values.

In order to use Xonomy in a html page, three components are needed:

  • Xonomy library, including xonomy...
Read More

Adobe AEM Technology Stack in Brief

In 2008, I worked on a Web Content Management (WCM) project for Accenture BPO. The client of Accenture spent 1.5 M on purchasing the license and package of the WCM system called Day Communique / CQ. The core team of Day Software contributed to Apache Jackrabbit – an open source content repository, then created the commercial CQ, which includes a content hierarchical repository CRX, an IDE CRX DE and the browser-based authoring and deployment interface. The unique tight bundle of content repository, IDE and smooth web-based deployment environment gains quite a bit clients quickly, especially for those who have deep pocket. In 2009, Day released CQ 5. In 2010, Day CQ 5 was acquired by Adobe and renamed to Adobe AEM (Adobe Experience Manager).

It has been ten years! Now Adobe AEM released ver...

Read More