Search Results for "pg"
Sort By:
Showing 27 open source projects for "pg"
View related business solutions-
Try Google Cloud Risk-Free With $300 in CreditUse your credit across every product. Compute, storage, AI, analytics. When it runs out, 20+ products stay free. You only pay when you choose to.
-
Gemini 3 and 200+ AI Models on One PlatformBuild generative AI apps with Vertex AI. Switch between models without switching platforms.
-
1
pg-osc
Easy CLI tool for making zero downtime schema changes
pg-osc (Online Schema Change) is a CLI tool for making non-blocking schema changes to large PostgreSQL tables. It creates a shadow table, copies data incrementally, and swaps tables with minimal downtime. Ideal for high-traffic applications, pg-osc lets teams modify database structures safely in production environments. -
2
pg-mem
An in memory postgres DB instance for your unit tests
pg-mem is an in-memory PostgreSQL emulator for Node.js and TypeScript that allows you to simulate a Postgres database without a real server. It’s perfect for unit testing and development scenarios where spinning up a full database would be too heavy. pg-mem supports many Postgres features and is compatible with various ORMs like TypeORM and Sequelize. -
3
pg_cron
Run periodic jobs in PostgreSQL
pg_cron is a PostgreSQL extension that allows SQL jobs to be scheduled using cron syntax. It runs inside the database server and lets users automate routine tasks like VACUUM, backups, and custom SQL scripts. Jobs are managed via SQL commands and can run on the same schedule format as standard UNIX cron, making it powerful and easy to use for database administrators and developers alike. -
4
node-pg-migrate
Node.js database migration management for Postgresql
...Started by Theo Ephraim, now maintained by Salsita Software. Installing this module adds a runnable file into your node_modules/.bin directory. If installed globally (with the -g option), you can run node-pg-migrate and if not, you can run ./node_modules/.bin/node-pg-migrate. Add "migrate": "node-pg-migrate" to scripts section of package.json so you are able to quickly run commands. Run npm run migrate create my first migration. It will create file xxx_my-first-migration.js in migrations folder. Now you should put your DB connection string to DATABASE_URL environment variable and run npm run migrate up. ... -
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
5
pg_probackup
Backup and recovery manager for PostgreSQL
pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments. -
6
pg_squeeze
A PostgreSQL extension for automatic bloat cleanup
pg_squeeze is a PostgreSQL extension that reclaims space in bloated tables without blocking read or write access. It provides a non-intrusive alternative to VACUUM FULL by creating a new compacted copy of the table in the background. It’s particularly useful for maintaining performance in large, heavily updated databases. -
7
pg_timetable
pg_timetable: Advanced scheduling for PostgreSQL
pg_timetable is a flexible job scheduler for PostgreSQL that allows scheduling of SQL or shell tasks directly within the database. It supports complex workflows, error handling, and dependency management, making it a powerful alternative to cron or external schedulers for database-related jobs. -
8
pg_mooncake
Real-time analytics on Postgres tables
pg_mooncake is a PostgreSQL extension that brings observability and performance insights to your database by exposing low-level metrics and analytics. It provides developers with enhanced visibility into query execution, memory usage, and system behavior. Ideal for fine-tuning Postgres performance, pg_mooncake is designed for those who need actionable insights without external tools. -
9
pg_partman
Partition management extension for PostgreSQL
pg_partman is a PostgreSQL extension for managing time-based and serial-based table partitioning. It automates the creation, maintenance, and retention of partitions, making it easier to manage large datasets with better performance and query efficiency. Designed for both native and trigger-based partitioning, pg_partman is ideal for applications handling time-series or log data. -
Application Monitoring That Won't Slow Your App DownFull APM with errors, performance, logs, and uptime monitoring. 99.999% uptime SLA on the platform itself.
-
10
pg_flo
Stream, transform, and route PostgreSQL data in real-time
The easiest way to move and transform data between PostgreSQL databases. -
11
pg_analytics
DuckDB-powered analytics for Postgres
pg_analytics (formerly named pg_lakehouse) puts DuckDB inside Postgres. With pg_analytics installed, Postgres can query foreign object stores like AWS S3 and table formats like Iceberg or Delta Lake. Queries are pushed down to DuckDB, a high-performance analytical query engine. By transforming Postgres into a performant search and analytics engine, ParadeDB frees your team from the pain of scaling and syncing Elasticsearch. -
12
pg_easy_replicate
Easily setup logical replication and switchover to new database
pg_easy_replicate is a simple tool for replicating PostgreSQL data from one database to another using logical replication. It abstracts away the complexity of publication/subscription setup and enables selective table replication. Ideal for developers or data engineers who want quick replication without deep Postgres expertise. -
13
pg_auto_failover
Postgres extension and service for automated failover
pg_auto_failover is a PostgreSQL extension and management tool for automated high availability. It handles health checks, failover, and monitoring without requiring third-party tools or complex configuration. Designed by the Citus Data team at Microsoft, it's ideal for developers and ops teams wanting reliable HA with minimal effort. -
14
PostgreSQL client and ORM for Golang
Golang ORM with focus on PostgreSQL features and performance
Basic types, integers, floats, string, bool, time.Time, net.IP, net.IPNet. All struct fields are nullable by default and zero values (empty string, 0, zero time, empty map or slice, nil ptr) are marshalled as SQL NULL. pg:",notnull" is used to add SQL NOT NULL constraint and pg:",use_zero" to allow Go zero values. sql.NullBool, sql.NullString, sql.NullInt64, sql.NullFloat64 and pg.NullTime. Structs, maps and arrays are marshalled as JSON by default. PostgreSQL multidimensional Arrays using array tag and Array wrapper. Hstore using hstore tag and Hstore wrapper. go-pg supports 2 last Go versions and requires support for Go modules. ... -
15
pg_scd
It is a trigger based solution for SCD in PostgreSQL
In general it is a data versioning/historisation solution based on triggers. Slowly changing dimensions are only the prominent specimen of dimensional modelling but relational modelling can take advantage from it too. Its aim is to extract as much information from the information schema/catalogue of the data base to keep configuration as simple and robust as possible. -
16
HHDB SQL Admin
HHDB SQL Admin is a graphical PostgreSQL client written in Java.
1. Developed by pure java 2. Customrized for PostgreSQL 3. Support multi-language 4. Use pg JDBC driver for connection 5. Use swing components for GUI 6. Test with Jdk1.7 and 1.8 on windows and CentOS 6,7 -
17
pg-listen
PostgreSQL LISTEN & NOTIFY for node.js that finally works
pg-listen is a Node.js library that simplifies listening to PostgreSQL notifications via the LISTEN/NOTIFY mechanism. It enables real-time event handling by subscribing to PostgreSQL channels and reacting to database changes. pg-listen is ideal for applications needing real-time updates or inter-process communication. -
18
pg_pathman
Partitioning tool for PostgreSQL
pg_pathman is a PostgreSQL extension that provides high-performance partitioning support, developed by PostgresPro. It improves query planning and execution speed for partitioned tables by introducing advanced partition pruning and runtime optimization strategies. It’s ideal for large datasets that require fine-tuned partition control. -
19
pg_flame
A flamegraph generator for Postgres EXPLAIN ANALYZE output
A flamegraph generator for Postgres EXPLAIN ANALYZE output. The pg_flame program reads a JSON query plan from standard input and writes the flamegraph HTML to standard output. Therefore you can pipe and direct input and output however you desire. Flamegraphs were invented by Brendan Gregg to visualize CPU consumption per code-path of profiled software. They are useful visualization tools in many types of performance investigations. Flamegraphs have been used to visualize Oracle database... -
20
node-orm2
Object Relational Mapping
Supported: 4.0 + If using Nodejs >= 14 & Postgres, you must use pg driver >= 8.1. v7 doesn't work correctly (tests time out). Tests are run on Travis CI If you want you can run tests locally. Create Models, sync, drop, bulk create, get, find, remove, count, aggregated functions. Create Model associations, find, check, create and remove. Define custom validations (several builtin validations, check instance properties before saving - see enforce for details). -
21
pg_rman
PostgreSQL Recovery Manager
pg_rman is an online backup and restore tool for PostgreSQL. The goal of the pg_rman project is providing a method for online backup and PITR as easy as pg_dump. Also, it maintains a backup catalog per database cluster. Users can maintain old backups including archive logs with one command. ******************************* 2015.07.03 Now, we are moving to GitHub. http://github.com/ossc-db/pg_rman ******************************* ---------- pg_rman は PostgreSQL... -
22
This PHP class implements a wrapper to access MySQL and PostgreSQL databases. It can be easily extended to support other database systems.
-
23
-
24
Trigger function to change every '' in input to NULL in output for PostgreSQL 8.x it behaves much like oracle then
-
25
The PHP Pg frontend project is yet an another frontend for the PostgresSQL database but it fully works and several cool features.
