Category: Database

Multi-client capability with PostgreSQL

In an application with several clients, it must be ensured that the data of one client is not displayed for others or can be changed by the actions of others. This article describes a solution for PostgreSQL databases.

Multilanguage database applications using Oracle APEX

Hello Everyone! If you are a DBA/PLSQL guru but are not familiar with traditional web development, then Oracle APEX is one of the best option. In this context, if you are trying to build a multilanguage application with Oracle APEX then this article should give an overview and understanding of how the translation mechanism that is built-in to Oracle APEX works, and how you should handle it. It is based on Oracle Application Express 18.1 version.

Naming conventions in Oracle databases

Naming conventions are an important part of coding conventions. Naming conventions are the rules for how “things” are named. In the case of a database, the “things” being named are schema objects such as tables, sequences, indexes, views, triggers as well as constraints. In a database it is essential to choose names with particular care.