Blog

UUID v7 overcomes the limitations of v4 by including an 48 bit epoch timestamp along side random data. Here we discuss how you can enable UUID v7 on PostgreSQL and use it on a Ruby on Rails project.

Use ASDF to manage multiple versions of PostgreSQL in the same machine without the need for virtual machines.

Fix Library not loaded: /usr/local/lib/libpq.5.4.dylib error after you upgrade your Homebrew packages.

Enums are a useful and commonly used data type in Ruby applications. Rails 7 introduces support to create native PG enum data types. This post discusses the creation and use of native enums with PostgreSQL, advantes & disadvantages.

Want to delete all records from a PostgreSQL table? You have two options, the commands DELETE and the TRUNCATE will both help. But whats is more efficient?