Founder building products with AI. Writing about Cursor, startups, and turning long-postponed ideas into real apps.

When writing PL/pgSQL functions, the syntax highlighting stops working inside the function body if it is defined using the standard PostgreSQL syntax with AS ...

So, you’re working with Python and maybe feeling a bit swamped by all the tools out there. It’s a common thing, honestly. Python is great, but it’s got a lot going on. That’s where PyCharm comes in.

Researchers at Varonis discovered a vulnerability within Postgres language extension PL/Perl, allowing a user to set arbitrary environment variables in PostgreSQL session processes. The vulnerability ...

PostgreSQL functions, also known as stored procedures, are powerful tools that allow you to encapsulate complex logic within the database itself. They can be written in various languages supported by ...

Hungry, Humble, Honest, with Heart. The Opportunity Are you a highly experienced DBA with a passion for supporting enterprise data needs Do you have expertise in PostgreSQL or Oracle databases, along ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Soroosh Khodami discusses why we aren't ready ...

Here are only a few functions to demonstrate how easy it is to write PL/pgSQL functions. For more complex examples the programmer might look at the regression test for PL/pgSQL.