EDB Postgres Advanced Server (EPAS) has introduced a highly anticipated feature called EDB SPL Check in its 16th version. This extension is a boon for developers working with Stored Procedure Language (SPL) in the EDB Postgres Advanced Server. Here’s a quick dive into what EDB SPL Check offers and how it can transform your database management and development experience.
What is EDB SPL Check?
EDB SPL Check is a feature that helps detect errors in EDB stored procedures that might be overlooked by the standard CREATE PROCEDURE/FUNCTION command. The feature can be enabled using the following command: CREATE EXTENSION spl_check;
EDB SPL Check can operate in either active or passive mode. In active mode, it runs checks with API functions like spl_check_function, while in passive mode, functions are checked upon execution.
Why is SPL Check Important?
Click here to keep reading the full article on my personal blog.
Relevant Blogs
EDB celebrates National Intern Day on Thursday, July 25th
Intern Day is an important opportunity for us at EDB to celebrate and acknowledge our talented interns. At EDB, we are committed to fostering the next generation of technologists who...Yet Another JSON parser for PostgreSQL
How we ended up with two JSON parsers in PostgreSQLAutovacuum Tuning Basics
A few weeks ago I covered the basics of tuning checkpoints, and in that post I also mentioned autovacuum as the second common source of performance issues (based on what...More Blogs
Basics of Tuning Checkpoints
On systems doing non-trivial number of writes, tuning checkpoints is crucial for getting good performance. Yet checkpoints are one of the areas where we often identify confusion and configuration issues...
EDB's Jonathan Battiato and Danish Khan Join Data on Kubernetes Community as Ambassadors
Postgres deployments on Kubernetes have the power to accelerate application development and modernization for next-generation workloads. At EDB, we’ve long championed this synergy, driving innovation and supporting open-source initiatives that...