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 database-management

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

•    Typescript

---

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.

heroku-alternative netlify-alternative cloud-platform paas platform-as-a-service mysql couchdb docker redis php vuejs mongodb analytics reactjs nextjs postgresql static svelte databases minio mysql-database self-hosted vscode-server

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

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 database-management

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 load-balancing query-routing replication

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

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

pg_timetable - Advanced scheduling for PostgreSQL

•    Go

---

pg_timetable is an advanced job scheduler for PostgreSQL, offering many advantages over traditional schedulers such as cron and others. It is completely database driven and provides a couple of advanced concepts.

sql cron docker-image scheduling postgresql interval chains postgres

sql_exporter - Database agnostic SQL exporter for Prometheus

•    Go

---

Database agnostic SQL exporter for Prometheus. SQL Exporter is a configuration driven exporter that exposes metrics gathered from DBMSs, for use by the Prometheus monitoring system. Out of the box, it provides support for MySQL, PostgreSQL, Microsoft SQL Server and Clickhouse, but any DBMS for which a Go driver is available may be monitored after rebuilding the binary with the DBMS driver included.

sql-exporter dbms sql-server mysql postgresql database prometheus database-tools

PolarDB - Share-nothing, Distributed database based on PostgreSQL

•    C

---

PolarDB for PostgreSQL (PolarDB for short) is an open-source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication.

database distributed-database rdbms postgresql

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

Apache ShardingSphere - Distributed Database Ecosphere

•    Java

---

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.

mysql sql database postgresql shard distributed-transactions distributed-database database-cluster shardingsphere distributed-sql-database

Prisma - Next-generation ORM for Node.js and TypeScript

•    Typescript

---

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

mysql postgres mongo sql-server orm database mongodb sqlite postgresql mariadb mssql sqlserver mongodb-orm prisma-client nodejs-orm rest-api database-migration

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