Fraud Blocker

PostgreSQL Streaming Replication Setup

    Streaming replication and logical replication are the two types of replication that PostgreSQL currently supports. This is the page you have been look…

    Continue Reading

    Upgrade Postgres with Ubuntu 20.04.02

    The previous time, PostgreSQL was installed on top of PostGIS. Today, I’ll add to this article by explaining how to upgrade PostGIS on Ubuntu. Postgis…

    Continue Reading

    Oracle EMPTY_BLOB function

      Oracle/PLSQL EMPTY_BLOB function can be used to initialize empty LOB columns in INSERT or UPDATE operators or it can be used to initialize LOB variabl…

      Continue Reading

      What in SQL is an INNER JOIN? Furthermore, what is an outside member?

      In IT, a join is a term that is frequently used and mentioned but infrequently fully understood. What distinguishes inner joins from outer joins, semi…

      Continue Reading

      Oracle MONTHS_BETWEEN function.

      Oracle/PLSQL MONTHS_BETWEEN function returns the number of months between date1 and date2….

      Continue Reading

      🎉 Thank you for subscribing!

      You're now on the list for database FinOps strategies and performance insights.