Fraud Blocker

Lessons Learned From Building an Oracle to PostgreSQL Migrator

Many people who want to be free of license costs, high support costs, and technical restrictions on the Oracle side have taken up the popular sport of…

Continue Reading

TRANSACTIONS WITH HOLD CURSORS AND POSTGRESQL 

Cursors and transactions serve as the basic building blocks for creating database applications. This article describes how cursors and transactions in…

Continue Reading

POSTGRESQL GAPS IN SEQUENCES

Most database tables have a primary key that is a made-up number, and that number is usually made by a sequence. In a previous article, I went into so…

Continue Reading

How to correctly use JSON in PostgreSQL

One of PostgreSQL’s most cherished features is the extensive JSON support. It is widely used by many people, especially by those who have more experie…

Continue Reading

WSL2 FOR WINDOWS: INSTALL AND POSTGRESSQL SETUP 

This article describes how to set up PostgreSQL on WSL2 for Windows, make the required configuration changes to PostgreSQL, and connect to the databas…

Continue Reading

🎉 Thank you for subscribing!

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