This is a postgres client that does auto-completion and syntax highlighting. The pgcli is written using python prompt toolkit. Its feature include Auto-completion, Syntax highlighting, Multi line support, Pagination etc.

pgcli - Postgres CLI with autocompletion and syntax highlighting

Compose Transporter helps with database transformations from one store to another. It can also sync from one to another or several stores.Transporter allows the user to configure a number of data adaptors as sources or sinks. These can be databases, files or other resources. Data is read from the sources, converted into a message format, and then send down to the sink where the message is converted into a writable format for its destination. The user can also create data transformations in JavaScript which can sit between the source and sink and manipulate or filter the message flow.

Transporter - Sync data between persistence engines, like ETL only not stodgy

pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards.


pgModeler - PostgreSQL Database Modeler

Diesel is the most productive way to interact with databases in Rust because of its safe and composable abstractions over queries. Diesel offers a high level query builder and lets you think about your problems in Rust, not SQL. Its focus on zero-cost abstractions allows Diesel to run your query and load your data even faster than C. Unlike Active Record and other ORMs, Diesel is designed to be abstracted over. Diesel enables you to write reusable code and think in terms of your problem domain and not SQL.

Diesel - A safe, extensible ORM and Query Builder for Rust

PgBouncer is  a lightweight connection pooler for PostgreSQL. It supports Session pooling, Transaction pooling, Statement pooling. It is not tied to one backend server. The destination databases can reside on different hosts. It has low memory requirements (2 kB per connection by default). This is because PgBouncer does not need to see full packets at once. 

PgBouncer - Lightweight connection pooler for PostgreSQL

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

pgAdmin - Administration and development platform for PostgreSQL

Coolify is an open-source, hassle-free, self-hostable
Heroku & Netlify alternative. You can deploy Static Sites, any Node.js based applications, PHP, Rust applications hassle-free with automatic reverse proxy and SSL certs. You can create your own instance of MongoDB, MySQL, PostgreSQL, CouchDB, RedisDB,  WordPress, Plausible Analytics, NocoDB, MinIO or VSCode Server. 

Coolify - An open-source, hassle-free, self-hostable Heroku & Netlify alternative

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL. 
<BR><BR>
SQLx supports compile-time checked queries. It does not, however, do this by providing a Rust API or DSL (domain-specific language) for building queries. Instead, it provides macros that take regular SQL as an input and ensure that it is valid for your database. The way this works is that SQLx connects to your development DB at compile time to have the database itself verify (and return some info on) your SQL queries.

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL. 

SQLx - The Rust SQL Toolkit

<div class="mt-2 h4">Alf.io is a free and open source event attendance management system, developed for event organizers who care about privacy, security and fair pricing policy for their customers. It features an ecosystem of tools to cover the lifecycle of an event from ticket distribution, to event management, to reporting.</div>
<div class="mt-2 h4">&nbsp;</div>
<div class="mt-2 h4">The GUI is currently available in Italian, English, Spanish, German, Dutch, French, Turkish, Romanian and Portuguese. It supports <a href="https://stripe.com/" target="_blank" rel="noopener">Stripe</a> and <a href="https://mollie.com" target="_blank" rel="noopener">Mollie</a> as gateways for payments done by credit card.</div>

Alf.io is a free and open source event attendance management system, developed for event organizers who care about privacy, security and fair pricing policy for their customers.

Alf.io - The open source ticket reservation system

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

usql - universal command-line interface for SQL databases

Npgsql is a .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.For any additional information, please visit the Npgsql website at http://www.npgsql.org.

Npgsql -.NET data provider for PostgreSQL.

aiopg is a library for accessing a PostgreSQL database from the asyncio (PEP-3156/tulip) framework. It wraps asynchronous features of the Psycopg database driver.

aiopg - Library for accessing a PostgreSQL database from the asyncio

Cube.js is an open-source analytical API platform. It is primarily used to build internal business intelligence tools or add customer-facing analytics to existing applications. Cube.js was designed to work with serverless data warehouses and query engines like Google BigQuery and AWS Athena. A multi-stage querying approach makes it suitable for handling trillions of data points. Most modern RDBMS work with Cube.js as well and can be further tuned for performance.

Cube.js — Open-Source Analytical API Platform

Apache ShardingSphere is an open-source ecosystem consisted of a set of distributed database solutions, including 3 independent products, JDBC, Proxy & Sidecar (Planning). They all provide functions of data scale-out, distributed transaction and distributed governance, applicable in a variety of situations such as Java isomorphism, heterogeneous language and cloud-native.
<BR><BR>
Features: <BR>
<ul>
<li>Database sharding &amp; Table sharding</li>
<li>Replica query</li>
<li>Sharding strategy customization</li>
<li>Centre-less Distributed primary key</li>
<li>Distributed Governance</li>
<li>Data migration &amp; Scale-out</li>
<li>Observability(Tracing/Metrics) Supported</li>
<li>Data Encryption&amp;Decryption</li>
<li>Shadow Table for Performance Testing</li>
<li>Unified Transaction API</li>
</ul>

Apache ShardingSphere is an open-source ecosystem consisted of a set of distributed database solutions, including 3 independent products, JDBC, Proxy & Sidecar (Planning). They all provide functions of data scale-out, distributed transaction and distributed governance, applicable in a variety of situations such as Java isomorphism, heterogeneous language and cloud-native.

Apache ShardingSphere - Distributed Database Ecosphere 

pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. pg_cron can run multiple jobs in parallel, but it runs at most one instance of a job at a time. If a second run is supposed to start before the first one finishes, then the second run is queued and started as soon as the first run completes.

pg_cron - Run periodic jobs in PostgreSQL

Discover open source projects across all platforms

Projects