CREATE FUNCTION only checks syntax. plpgsql_check parses PL/pgSQL through the server's own compiler without executing, catching bad column refs, unreachable code, RETURN errors. https://www.valtersit.com/vault/compile-plpgsql-functions-with-plpgsqlcheck-before-deploy-f6fdc5/
Compile PL/pgSQL Functions with plpgsql_check Before Deploy
www.valtersit.com
November 3, 2026 at 4:10 AM
CREATE FUNCTION only checks syntax. plpgsql_check parses PL/pgSQL through the server's own compiler without executing, catching bad column refs, unreachable code, RETURN errors. https://www.valtersit.com/vault/compile-plpgsql-functions-with-plpgsqlcheck-before-deploy-f6fdc5/
October on GitRanks: morluto climbed 53341 places to #6. Mexico grew 121.6% to 16k developers, PLpgSQL grew 34.2% to 27.8k, and 3 developers entered the top 100. #github
November 1, 2026 at 12:00 PM
October on GitRanks: morluto climbed 53341 places to #6. Mexico grew 121.6% to 16k developers, PLpgSQL grew 34.2% to 27.8k, and 3 developers entered the top 100. #github
🐞 PostgreSQL Debugger: Debug #Postgres stored routines
For PostgreSQL, installing a debugger on Windows, macOS or Linux takes zero additional setup and no extensions.
📖 See how it works: cutt.ly/hym22O6Z
⚡ Get the AI-powered #dbForgeStudio for #PostgreSQL: cutt.ly/1ym22N0O
#PLpgSQL
For PostgreSQL, installing a debugger on Windows, macOS or Linux takes zero additional setup and no extensions.
📖 See how it works: cutt.ly/hym22O6Z
⚡ Get the AI-powered #dbForgeStudio for #PostgreSQL: cutt.ly/1ym22N0O
#PLpgSQL
October 19, 2026 at 6:47 AM
🐞 PostgreSQL Debugger: Debug #Postgres stored routines
For PostgreSQL, installing a debugger on Windows, macOS or Linux takes zero additional setup and no extensions.
📖 See how it works: cutt.ly/hym22O6Z
⚡ Get the AI-powered #dbForgeStudio for #PostgreSQL: cutt.ly/1ym22N0O
#PLpgSQL
For PostgreSQL, installing a debugger on Windows, macOS or Linux takes zero additional setup and no extensions.
📖 See how it works: cutt.ly/hym22O6Z
⚡ Get the AI-powered #dbForgeStudio for #PostgreSQL: cutt.ly/1ym22N0O
#PLpgSQL
SECURITY DEFINER lets a PL/pgSQL function run as its owner, not the caller. Essential for audit writes or restricted schemas. Always pin search_path to block https://www.valtersit.com/vault/deploy-a-plpgsql-function-with-security-definer-hardened-sea-426ee3/ #postgresql #plpgsql #security-definer
Deploy a PL/pgSQL Function with SECURITY DEFINER Hardened Search Path
www.valtersit.com
October 18, 2026 at 7:10 PM
SECURITY DEFINER lets a PL/pgSQL function run as its owner, not the caller. Essential for audit writes or restricted schemas. Always pin search_path to block https://www.valtersit.com/vault/deploy-a-plpgsql-function-with-security-definer-hardened-sea-426ee3/ #postgresql #plpgsql #security-definer
PostgreSQL exception handling: capture SQLSTATE, message, detail, hint and constraint name with GET STACKED DIAGNOSTICS for real audit trails. PL/pgSQL saves the day. https://www.valtersit.com/vault/exception-handling-with-get-stacked-diagnostics-for-auditing-657fd9/ #postgresql #plpgsql #exception
Exception Handling with GET STACKED DIAGNOSTICS for Auditing
www.valtersit.com
October 1, 2026 at 5:00 AM
PostgreSQL exception handling: capture SQLSTATE, message, detail, hint and constraint name with GET STACKED DIAGNOSTICS for real audit trails. PL/pgSQL saves the day. https://www.valtersit.com/vault/exception-handling-with-get-stacked-diagnostics-for-auditing-657fd9/ #postgresql #plpgsql #exception
Supabase Postgres Functions & Triggers: Developer Guide Master Postgres functions and triggers in Supabase. Build automated workflows, complex business logic, and database-level validation with PL/pgSQL. Topics: supabase, postgres, plpgsql https://www.iloveblogs.blog/guides/supa…
August 29, 2026 at 2:59 AM
Supabase Postgres Functions & Triggers: Developer Guide Master Postgres functions and triggers in Supabase. Build automated workflows, complex business logic, and database-level validation with PL/pgSQL. Topics: supabase, postgres, plpgsql https://www.iloveblogs.blog/guides/supa…
Quietly one of the better self-hosted document managements I've found.
Evergreen is a GPL-2.0, PLpgSQL document management. Highly-scalable software for libraries that helps library patrons find library m...
#opensource #selfhosted #documentmanagementintegratedlibrarysystemsils
Evergreen is a GPL-2.0, PLpgSQL document management. Highly-scalable software for libraries that helps library patrons find library m...
#opensource #selfhosted #documentmanagementintegratedlibrarysystemsils
August 20, 2026 at 12:35 AM
Quietly one of the better self-hosted document managements I've found.
Evergreen is a GPL-2.0, PLpgSQL document management. Highly-scalable software for libraries that helps library patrons find library m...
#opensource #selfhosted #documentmanagementintegratedlibrarysystemsils
Evergreen is a GPL-2.0, PLpgSQL document management. Highly-scalable software for libraries that helps library patrons find library m...
#opensource #selfhosted #documentmanagementintegratedlibrarysystemsils
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.
https://github.com/commandprompt/plx
https://github.com/commandprompt/plx
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.
PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql. - commandprompt/plx
github.com
August 16, 2026 at 5:08 AM
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.
https://github.com/commandprompt/plx
https://github.com/commandprompt/plx
github.com/commandprompt/plx
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScrip...
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScrip...
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.
github.com
August 15, 2026 at 10:35 PM
github.com/commandprompt/plx
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScrip...
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScrip...
RubyやPythonなどの書き方でPostgreSQLのストアド関数を書いてPL/pgSQLに変換できるツールっぽい
データベース周りの記述を書きやすくなりそうかな
yug1224 starred commandprompt/plx
https://github.com/commandprompt/plx
データベース周りの記述を書きやすくなりそうかな
yug1224 starred commandprompt/plx
https://github.com/commandprompt/plx
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.
github.com
August 15, 2026 at 10:23 PM
RubyやPythonなどの書き方でPostgreSQLのストアド関数を書いてPL/pgSQLに変換できるツールっぽい
データベース周りの記述を書きやすくなりそうかな
yug1224 starred commandprompt/plx
https://github.com/commandprompt/plx
データベース周りの記述を書きやすくなりそうかな
yug1224 starred commandprompt/plx
https://github.com/commandprompt/plx
Ruby, PHP, JavaScript, Python, COBOL, TypeScript, Goなどさまざまな言語風にストアドプロシージャを書けるPostgreSQL拡張。書いたのはPL/pgSQLにトランスパイルされる模様。各言語風だな。
GitHub - commandprompt/plx: PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql.
PostgreSQL extension: write stored functions in Ruby, PHP, JavaScript, or Python dialects that transpile to plpgsql. - commandprompt/plx
github.com
August 15, 2026 at 1:58 PM
Ruby, PHP, JavaScript, Python, COBOL, TypeScript, Goなどさまざまな言語風にストアドプロシージャを書けるPostgreSQL拡張。書いたのはPL/pgSQLにトランスパイルされる模様。各言語風だな。
pgFormatter, even if not perfect, is the most advanced SQL and PlPgsql code formatter and beautifier dedicated to PostgreSQL. www.postgresql.org/about/news/p...
pgFormatter v5.9 has been released
Dar Es Salam, Tanzania - December 21th, 2025 ## pgFormatter v5.9 pgFormatter, even if not perfect, is the most advanced …
www.postgresql.org
December 23, 2025 at 2:55 PM
pgFormatter, even if not perfect, is the most advanced SQL and PlPgsql code formatter and beautifier dedicated to PostgreSQL. www.postgresql.org/about/news/p...
Explore PLpgSQL’s trends on GitRanks via the link below. What’s behind this sudden downturn? #github
https://gitranks.com/language/PLpgSQL/global/1?t=pRulPEmj
https://gitranks.com/language/PLpgSQL/global/1?t=pRulPEmj
April 26, 2026 at 8:00 AM
Explore PLpgSQL’s trends on GitRanks via the link below. What’s behind this sudden downturn? #github
https://gitranks.com/language/PLpgSQL/global/1?t=pRulPEmj
https://gitranks.com/language/PLpgSQL/global/1?t=pRulPEmj
Is it slower to use plpgsql?
February 16, 2024 at 7:23 PM
Is it slower to use plpgsql?
If nothing else, having to write out PLpgSQL will be
November 21, 2024 at 6:17 AM
If nothing else, having to write out PLpgSQL will be
COMMIT, ROLLBACK, and Autocommit: PostgreSQL Transactions for SQL Server DBAs
SQL Server DBAs lean on the 'run to the SELECT, then COMMIT or ROLLBACK by hand' workflow. PostgreSQL's autocommit, abort-on-error, and plpgsql change the rules. Here is how to get the same safety and diagnostics in psql…
SQL Server DBAs lean on the 'run to the SELECT, then COMMIT or ROLLBACK by hand' workflow. PostgreSQL's autocommit, abort-on-error, and plpgsql change the rules. Here is how to get the same safety and diagnostics in psql…
COMMIT, ROLLBACK, and Autocommit: PostgreSQL Transactions for SQL Server DBAs
SQL Server DBAs lean on the 'run to the SELECT, then COMMIT or ROLLBACK by hand' workflow. PostgreSQL's autocommit, abort-on-error, and plpgsql change the rules. Here is how to get the same safety and diagnostics in psql and pgAdmin.
www.sqlserverscience.com
June 16, 2026 at 2:30 PM
Doing simple comparison of #postgresql procedural languages.
Return 42 is function returning hardcoded value 42.
Select row selects a single row from table having 10k rows.
plpgsql being faster than sql is surprising for the second case.
Return 42 is function returning hardcoded value 42.
Select row selects a single row from table having 10k rows.
plpgsql being faster than sql is surprising for the second case.
April 26, 2025 at 8:44 PM
Doing simple comparison of #postgresql procedural languages.
Return 42 is function returning hardcoded value 42.
Select row selects a single row from table having 10k rows.
plpgsql being faster than sql is surprising for the second case.
Return 42 is function returning hardcoded value 42.
Select row selects a single row from table having 10k rows.
plpgsql being faster than sql is surprising for the second case.
pgFormatter v5.10 has been released Antananarivo, Madagascar - May 9th, 2026 pgFormatter v5.10 pgFormatter, even if not perfect, is the most advanced SQL and PlPgsql code formatter and beautifier d...
Origin | Interest | Match
Origin | Interest | Match
pgFormatter v5.10 has been released
Antananarivo, Madagascar - May 9th, 2026 ## pgFormatter v5.10 pgFormatter, even if not perfect, is the most advanced SQL and …
www.postgresql.org
May 11, 2026 at 10:33 PM
pgFormatter v5.8 has been released Dar Es Salam, Tanzania - September 14th, 2025 pgFormatter v5.8 pgFormatter, even if not perfect, is the most advanced SQL and PlPgsql code formatter and beautifie...
Origin | Interest | Match
Origin | Interest | Match
pgFormatter v5.8 has been released
Dar Es Salam, Tanzania - September 14th, 2025 ## pgFormatter v5.8 pgFormatter, even if not perfect, is the most advanced …
www.postgresql.org
September 14, 2025 at 9:52 PM
Feed: "PostgreSQL news"
Published on Wednesday, May 20, 2026
Published on Wednesday, May 20, 2026
plpgsql_wrap v1.0 released
Toronto, Canada - May 19th, 2026 ## PostgreSQL plpgsql wrap utility `plpgsql_wrap` is a PostgreSQL extension used to obfuscate PLPGSQL …
www.postgresql.org
May 21, 2026 at 3:03 AM
Feed: "PostgreSQL news"
Published on Wednesday, May 20, 2026
Published on Wednesday, May 20, 2026
Is plpgsql the best language to write functions in #PostgreSQL? Obviously #SQL is the best, so let's just talk about "second best".
I think it is, but I am not necessarily correct.
What are your opinions?
I think it is, but I am not necessarily correct.
What are your opinions?
June 29, 2025 at 4:47 PM
Is plpgsql the best language to write functions in #PostgreSQL? Obviously #SQL is the best, so let's just talk about "second best".
I think it is, but I am not necessarily correct.
What are your opinions?
I think it is, but I am not necessarily correct.
What are your opinions?
Can we get a demo of nested plsql in a package to plpgsql in an extension please?
June 11, 2025 at 10:35 AM
Can we get a demo of nested plsql in a package to plpgsql in an extension please?