Chronological list of all blog posts

Posts by month & year

  • Modern applications frequently need to access external services from within the database. In distributed architectures, those services are often exposed through REST APIs. Oracle APEX offers several declarative and programmatic ways to consume REST services, but a system administrator must first permit the necessary outbound network connectivity. NOTE: APEX behaves ever so slightly differently in…

  • On-premises edition. See below for a great article by Jeff Smith covering the other scenario where your database resides in Oracle Cloud. Secret management is a crucial part of your IT security strategy. Careless handling of secrets can leak these, and create security risks that are entirely avoidable. Hard-coding secrets, even for lab environments, is…

  • Recently, while browsing my feed on LinkedIn I came across a post dealing with PostgreSQL transactional DDL. Although I couldn’t find an exact documentation reference in the PostgreSQL docs (the closest I found is a reference to the transaction model in general) it is safe to say that you can wrap DDL statements into a…