pgweb - Web-based PostgreSQL database browser written in Go

•    Go

---

Pgweb is a web-based database browser for PostgreSQL, written in Go. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.

postgresql pgweb cross-platform postgresql-client postgresql-gui postgresql-admin postgresql-management postgres

fullstack-apollo-react-express-boilerplate-project - 💥A sophisticated Apollo in React and Express boilerplate project

•    Javascript

---

A full-fledged Apollo Server 2 with Apollo Client 2 starter project with React, Express and PostgreSQL. Since this boilerplate project is using PostgreSQL, you have to install it for your machine and get a database up and running. You find everything for the set up over here: Setup PostgreSQL with Sequelize in Express Tutorial. After you have created a database and a database user, you can fill out the environment variables in the server/.env file.

react reactjs react-apollo react-apollo-graphql apollographql apollo-client apollo-server apollo-server-express authentication authorization boilerplate fullstack

usql - universal command-line interface for SQL databases

•    Go

---

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.

sql postgresql mysql sqlite3 command-line microsoft-sql-server oracle-database cli

SQL Relay - Database Connection Pool library with API available in all programming languages

•    C++

---

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, and all major databases. It has APIs for C, C++, ODBC, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, Java, TCL and Erlang, drop-in replacement libraries for MySQL and PostgreSQL clients.

connection-pool database-connection-pool database-proxy mysql-proxy database-migration

MaxScale - An intelligent database proxy

•    C++

---

The MariaDB Corporation MaxScale is an intelligent proxy that allows forwarding of database statements to one or more database servers using complex rules, a semantic understanding of the database statements and the roles of the various servers within the backend cluster of databases. It extends the high availability, scalability, and security of MariaDB Server while at the same time simplifying application development by decoupling it from underlying database infrastructure.

database-proxy mysql-proxy mariadb-proxy scalable distributed database-firewall

phpMyFAQ - phpMyFAQ - Open Source FAQ system for PHP and MySQL, PostgreSQL and other databases

•    PHP

---

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 5.6+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and an Image Manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup-system, a dynamic sitemap, related FAQs, tagging, RSS feeds, built-in spam protection systems, OpenLDAP and Microsoft Active Directory support, and an easy to use installation script. phpMyFAQ is only supported on PHP 5.6.0 and up, you need a database as well. Supported databases are MySQL, Percona Server, PostgreSQL, Microsoft SQL Server, SQLite3 and MariaDB. If you want to use Elasticsearch as main search engine, you need Elasticsearch 2.x as well. Check our detailed requirements on phpmyfaq.de for more information.

faq phpmyfaq mysql database postgresql sqlite mssql elasticsearch docker docker-compose

pgAdmin - Administration and development platform for PostgreSQL

•    C

---

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.

postgresql-admin database-admin database-tools postgresql-tools postgresql-management postgresql-gui

asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.

•    Python

---

asyncpg is a database interface library designed specifically for PostgreSQL and Python/asyncio. asyncpg is an efficient, clean implementation of PostgreSQL server binary protocol for use with Python's asyncio framework. You can read more about asyncpg in an introductory blog post. asyncpg requires Python 3.5 or later and is supported for PostgreSQL versions 9.2 to 10.

postgresql python-3 asyncio async-python async-programming high-performance database-driver

php-crud-api - Single file PHP script that adds a REST API to a SQL database

•    PHP

---

Single file PHP 7 script that adds a REST API to a MySQL 5.6 InnoDB database. PostgreSQL 9.1 and MS SQL Server 2012 are fully supported. NB: This is the TreeQL reference implementation in PHP.

api-server restful mysql geospatial postgresql php-api postgis crud rest-api openapi swagger automatic-api database multi-database sql-database ubuntu-linux geojson sqlserver

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.

Algernon - Pure Go web server with built-in Lua, Markdown, HyperApp and Pongo2 support

•    Go

---

Web server with built-in support for HTTP/2, Lua, Markdown, Pongo2, HyperApp, Amber, Sass(SCSS), GCSS, JSX, BoltDB, Redis, PostgreSQL, MariaDB/MySQL, rate limiting, graceful shutdown, plugins, users and permissions. Uses no external libraries, only pure Go.

http2 scss pongo2 amber application-server redis boltdb mariadb postgresql gcss web-server

Pgpool - Middleware between PostgreSQL Client and Server

•    C

---

pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It supports connection pooling, Using the replication function enables creating a realtime backup on 2 or more physical disks, so that the service can continue without stopping servers in case of a disk failure, Load balance the queries, It can execute queries in parallel to multiple servers.

connection-pool postgresql-tools database-library middleware backup

Ora2Pg - Tool used to migrate an Oracle database to a PostgreSQL compatible schema

•    Perl

---

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

database-tools database-migration oracle-to-postgresql postgresql-tools

Npgsql -.NET data provider for PostgreSQL.

•    CSharp

---

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 database postgresql postgres c-sharp sql postgresql-client postgresql-driver postgresql-library

puppetlabs-postgresql - Puppet module for managing PostgreSQL

•    Ruby

---

The postgresql module allows you to manage PostgreSQL databases with Puppet.PostgreSQL is a high-performance, free, open-source relational database server. The postgresql module allows you to manage packages, services, databases, users, and common security settings in PostgreSQL.

JavaScript SQL (JSSQL)

•    Javascript

---

A database engine entirely in JavaScript (AJAX)

postgrest - REST API for any Postgres database

•    Haskell

---

PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch. Download the binary (latest release) for your platform.

haskell database rest postgresql server postgrest automatic-api

postgrest - REST API for any Postgres database

•    Haskell

---

PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch. Download the binary (latest release) for your platform.

haskell database rest postgresql server postgrest automatic-api

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 (http://www.opencypher.org). 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.

graph-database multi-model-database postgresql enterprise nosql graphdb

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.

database citus multi-tenant postgresql scale sharding sql distributed-database postgres