plgo - easily create postgresql extensions in golang

  •        18

plgo is an tool for easily creating PostgreSQL extensions with stored procedures and triggers in golang. It creates wrapper code, PostgreSQL extension files and builds your package.



Related Projects

pg_partman - Partition management extension for PostgreSQL

  •    PLpgSQL

pg_partman is an extension to create and manage both time-based and serial-based table partition sets. Native partitioning in PostgreSQL 10 is supported as of pg_partman v3.0.1. Note that all the features of trigger-based partitioning are not yet supported in native, but performance in both reads & writes is significantly better. Child table creation is all managed by the extension itself. For non-native, trigger function maintenance is also handled. For non-native partitioning, tables with existing data can have their data partitioned in easily managed smaller batches. For native partitioning, the creation of a new partitioned set is required and data will have to be migrated over separately.

pgMail - PostgreSQL Email Stored Funct.

  •    Perl

pgMail is a small TCL based script that you can store within any PostgreSQL database. Once it is stored there, you can create any number of specialized procedures to send email from directly within PostgreSQL like emailing a customer when product ships. FYI! This project has moved to GITHUB! You can see the repository here: WE HAVE MOVED!!! Please visit the project page (linked below) for all new and relevant information, including requests for help!

PostgreSQL - Powerful, Open Source Object-Relational Database System

  •    C

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language.

PGObserver - A battle-tested, flexible & comprehensive monitoring solution for your PostgreSQL databases

  •    Python

PGObserver is a battle-tested monitoring solution for your PostgreSQL databases. It covers almost all the metrics provided by the database engine's internal statistics collector, and works out of the box with all PostgreSQL versions (beginning with 9.0) as well as AWS RDS. You don’t have to install any non-standard, server-side database extensions to take advantage of its core functionality, nor do you need to register any privileged users.For some metrics you must install data-gathering wrapper functions — also known as stored procedures — on the server being monitored. This will enable you to circumvent the superuser requirements.

HeidiSQL - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi

  •    Pascal

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases, PostgreSQL and MariaDB. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data, either to SQL file, clipboard or to other servers. Read about features or see some screenshots. Look at the online help page for learning how to use HeidiSQL.

upsert - Upsert on MySQL, PostgreSQL, and SQLite3

  •    Ruby

Make it easy to upsert on traditional RDBMS like MySQL, PostgreSQL, and SQLite3—hey look NoSQL!. Transparently creates (and re-uses) stored procedures/functions when necessary. You pass it a bare-metal connection to the database like Mysql2::Client (from mysql2 gem on MRI) or Java::OrgPostgresqlJdbc4::Jdbc4Connection (from jdbc-postgres on Jruby).

Job Scheduler for PostgreSQL

  •    C++

pgjobs is a mechanism for scheduling and executing stored procedures under PostgreSQL database server.

logidze - Database changes log for Rails

  •    Ruby

Logidze provides tools for logging DB records changes. Just like audited and paper_trail do (but faster). Logidze allows you to create a DB-level log (using triggers) and gives you an API to browse this log. The log is stored with the record itself in JSONB column. No additional tables required. Currently, only PostgreSQL 9.5+ is supported (for PostgreSQL 9.4 try jsonbx extension).

Java Stored Procedure system


The software runs java stored procedures in open source database servers. PostgreSQL is supported, SAP DB support is comming.

Citus - Scalable PostgreSQL for multi-tenant and real-time workloads

  •    C

Citus is a distributed database that scales across commodity servers using transparent sharding and replication. Citus extends the underlying database rather than forking it, giving developers and enterprises the power and familiarity of a relational database. As an extension, Citus supports new PostgreSQL releases, and allows you to benefit from new features while maintaining compatibility with existing PostgreSQL tools.

hypopg - Hypothetical Indexes for PostgreSQL

  •    C

HypoPG is a PostgreSQL extension adding support for hypothetical indexes. An hypothetical, or virtual, index is an index that doesn't really exists, and thus doesn't cost CPU, disk or any resource to create. They're useful to know if specific indexes can increase performance for problematic queries, since you can know if PostgreSQL will use these indexes or not without having to spend resources to create them. For more information on this extension usage, you can see this blog post.

Timescaledb - An open-source time-series database optimized for fast ingest and complex queries

  •    PLpgSQL

TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension and released under the Apache 2 open-source license.

pglogical - Logical Replication extension for PostgreSQL 9

  •    C

The pglogical extension provides logical streaming replication for PostgreSQL, using a publish/subscribe model. It is based on technology developed as part of the BDR project ( To use pglogical the provider and subscriber must be running PostgreSQL 9.4 or newer.

zson - ZSON is a PostgreSQL extension for transparent JSONB compression

  •    C

ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS. Memory is saved as well. See docs/ Everything depends on your data and workload, though. Don't believe any benchmarks, re-check everything on your data, configuration, hardware, workload and PostgreSQL version.

agensgraph - AgensGraph, a transactional graph database based on PostgreSQL

  •    C

AgensGraph is a new generation multi-model graph database for the modern complex data environment. AgensGraph is a multi-model database, which supports the relational and graph data model at the same time that enables developers to integrate the legacy relational data model and the flexible graph data model in one database. AgensGraph supports ANSI-SQL and openCypher ( SQL queries and Cypher queries can be integrated into a single query in AgensGraph. AgensGraph is based on the powerful PostgreSQL RDBMS, and is very robust, fully-featured and ready for enterprise use. AgensGraph is optimized for handling complex connected graph data and provides plenty of powerful database features essential to the enterprise database environment including ACID transactions, multi-version concurrency control, stored procedure, triggers, constraints, sophisticated monitoring and a flexible data model (JSON). Moreover, AgensGraph leverages the rich eco-systems of PostgreSQL and can be extended with many outstanding external modules, like PostGIS.

audit-trigger - Simple, easily customised trigger-based auditing for PostgreSQL (Postgres)

  •    PLpgSQL

A simple, customisable table audit system for PostgreSQL implemented using triggers.

postgresql-metrics - Tool that extracts and provides metrics on your PostgreSQL database

  •    Python

Service to extract and provide metrics on your PostgreSQL database.This tool is a CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. CLI is runnable in long running process mode, which will periodically send the gathered metrics forward.

gawk libraries for XML, PostgreSQL,...

  •    Awk

Dynamically loaded extension libraries for GNU AWK

pg_query - Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser

  •    Ruby

This Ruby extension uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parsetree. In addition the extension allows you to normalize queries (replacing constant values with ?) and parse these normalized queries into a parsetree again.


  •    ASPNET

DataLG is a Data Access Layer (DAL) generator. Create stored procedures, views, and tables on the database side, then use DataLG to create an assembly (and its source) to interact with them. Works with: Ms Sql Server, Sqlite 3, Mysql 4-5, and PostgreSQL.