All articles

Postgresql Security with Builtin Roles and functions.

Introduction As PostgreSQL continues to gain traction in enterprise-grade applications, I am increasingly tasked and asked about implementing robust security policies. And, as most current DBA positions are multi-systems nowadays, I wanted to make a quick summary on roles and(…)

PostgreSQL: Maybe we should give ZFS a chance (1) – baseline

Recently I’ve switched my PostgreSQL playground from Linux to FreeBSD. Not because I don’t like Linux anymore, just because I like trying out other operating systems and see what works the same and what is different.

Documentum – Impact of Java 17 and JAVA_TOOL_OPTIONS

If you are familiar with Java, you probably know that starting with JDK 9, you may need to add some “–add-exports” or “–add-opens” parameters to the JAVA_TOOL_OPTIONS. This is the Strong Encapsulation, which started with JDK(…)

PostgreSQL: Partitioning an existing table (almost) online using table inheritance

The PostgreSQL mailing list archives are a wonderful place to get new ideas just by reading through random posts. This time I found an interesting idea on how to partition an existing(…)

Exploring FlyonUI with Vue.js: A Fresh and Evolving Library

As someone who has relied on Vuetify for most of my Vue.js projects, I’m always on the lookout for new libraries that can streamline development and keep designs modern. Recently, a new UI library called FlyonUI was released, and I(…)

PostgreSQL: Delaying authentication to debug a process

While investigating a customer issue (details here) one of the replies suggested to use pre_auth_delay to add a delay before a session is authenticated. Even if this was not useful for the actual issue, this(…)

Vue – Creating an Awesome Parallax Effect with Swiper

Adding a parallax effect to your website brings a smooth, professional feel, making it more interactive and visually appealing. With Swiper for Vue, you can easily implement parallax effects for a slideshow. In this guide, we’ll create a parallax effect(…)

Mastering SSIS with Excel – Resolving the ‘Microsoft.ACE.OLEDB.16.0 Provider is Not Registered’ Error

1        Introduction Dear Readers, Recently, I encountered the ‘Microsoft.ACE.OLEDB.16.0 Provider is Not Registered’ error while working on a data extraction task using SSIS. In this article, I’ll share how to fix this issue and also guide you through: Migrating SSIS(…)

PostgreSQL Conference Europe 2024 – Last day

As I reflect on my last day at PGConf.EU 2024 in the beautiful city of Athens, I am filled with a profound sense of gratitude and excitement. The conference was a melting pot of innovation, knowledge sharing, and community spirit,(…)

2024.pgconf.eu – Bigger than ever, the family is growing fast

The PostgreSQL community is growing every year and the same happens for pgconf.eu, which happened in Athens, Greece, this year. Attending this event is one of the best opportunities to get in touch with the people behind PostgreSQL. This year(…)