Open-source projects categorized as Postgresql | Edit details

Top 23 Postgresql Open-Source Projects

  • GitHub repo Metabase

    The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

    Project mention: Open source contributions for a Data Engineer? | reddit.com/r/dataengineering | 2021-04-16

    If you want to work more on the visualization side maybe Metabase, Superset and Streamlit.

  • GitHub repo Sequelize

    An easy-to-use multi SQL dialect ORM tool for Node.js

    Project mention: Deferring Side-Effects in Node.js until the End of a Transaction | dev.to | 2021-05-17

    At Grouparoo, we use Actionhero as our Node.js API server and Sequelize for our Object Relational Mapping (ORM) tool - making it easy to work with complex records from our database. Within our Actions and Tasks, we often want to treat the whole execution as a single database transaction - either all the modifications to the database will succeed or fail as a unit. This is really helpful when a single activity may create or modify many database rows.

  • GitHub repo TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: Iniciando con typeOrm para Nodejs | dev.to | 2021-05-16
  • GitHub repo Redash

    Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

    Project mention: Show HN: Django SQL Dashboard | news.ycombinator.com | 2021-05-10

    This is cool!

    I've had a lot of success with http://redash.io, which is a similar (though much more complex) project. SQL backend +visualizations can be really powerful and surprisingly flexible for building dashboards that aren't quite ad-hoc, but don't deserve their own standalone app and you just need to tie some input fields into SQL parameters.

  • GitHub repo postgrest

    REST API for any Postgres database

    Project mention: Going full-stack with Flutter and Supabase - Part 1: Authentication | dev.to | 2021-05-14

    It's all open source: Supabase is built on top of other popular open-source packages, such as PostgREST for accessing your database directly from the client, and GoTrue for user authentication. All that, along with a nice admin interface so you can manage everything. If you wanted, you could host and manage these services on your own. If PostgREST does not fit your use case, you could host a server that will communicate with your Postgres database directly. And if you ever decide that Supabase is not for you, you could always migrate all your data somewhere else. At the end of the day, it's all in a Postgres database.

  • GitHub repo Knex

    A query builder for PostgreSQL, MySQL and SQLite3, designed to be flexible, portable, and fun to use.

    Project mention: Prisma ORM: how to use the great database mapping package | reddit.com/r/programming | 2021-05-14

    This isn't possible yet and something we'd like to offer at some point. Similar to what knex does: http://knexjs.org/#Builder-whereRaw. I've relayed this to our product team who will create an issue for this.

  • GitHub repo shardingsphere

    Distributed Database Ecosphere

    Project mention: Weekly Developer Roundup #23 - Sun Nov 22 2020 | dev.to | 2020-11-21

    apache/shardingsphere (Java): Distributed database middleware

  • GitHub repo supabase

    The open source Firebase alternative. Follow to stay updated about our public Beta.

    Project mention: Should we go serverless? | reddit.com/r/FlutterDev | 2021-05-15

    With https://supabase.io at least you have the option to go self-hosted if there’s a problem so there’s significantly less risk.

  • GitHub repo Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server & SQLite

    Project mention: Prisma ORM: how to use the great database mapping package | reddit.com/r/programming | 2021-05-14

    I hope this was helpful, and I am happy to answer any questions. Feel free to tag me here or in our github discussions, where I am more active.

  • GitHub repo mybatis-plus

    An powerful enhanced toolkit of MyBatis for simplify development

    Project mention: The Apache Attic | news.ycombinator.com | 2021-04-09
  • GitHub repo TimescaleDB

    An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

    Project mention: TimescaleDB Raises $40M | news.ycombinator.com | 2021-05-05

    Fair point about adaptive chunking. You sound like a long-term user!

    There is always a trade-off between getting features to users quickly to experiment and incrementally improve, versus doing it always very conservatively.

    When we launched adaptive chunking (introduced in 0.11, deprecated in 1.2), we explicitly marked it as beta and default off, to hopefully reflect that. [1]

    The approach we are now taking with Timescale Analytics [2] is to have an explicit distinction between experimental features (which will be part of a distinct"experimental" schema in the database, and must be expressly turned on with appropriate warnings) and stable features. Hopefully this can help find a good balance between stability and velocity, but feedback welcome!

    [1] https://github.com/timescale/timescaledb/releases/tag/0.11.0

    [2] https://github.com/timescale/timescale-analytics/tree/main/e...

  • GitHub repo Directus

    Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.

    Project mention: Why use Next.js + Strapi? | dev.to | 2021-05-06

    Directus is one of the CMS that presents, a proposal very similar to Strapi, but its stack is made in PHP, and has bug reports critical by users.

  • GitHub repo cube.js

    📊 Cube.js — Open-Source Analytical API Platform

    Project mention: Introducing Cube Store: High concurrency and sub-second latency for any database | reddit.com/r/Database | 2021-04-30

    That's witty! IMO, there's nothing wrong with JavaScript, however, in the Cube.js codebase, we have more Rust and TypeScript than anything else :–)

  • GitHub repo postgraphile

    Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!

    Project mention: v4.12.0-alpha.0 | reddit.com/r/PostGraphile | 2021-02-15
  • GitHub repo pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: Commandline Database Clients with Autocompletion and Syntax Highlighting | news.ycombinator.com | 2021-02-18

    In what way did it blow up? You must have hit a bug, using .pg_service should work. Would you care to open an issue on https://github.com/dbcli/pgcli/issues or just dump the error message here so we can investigate?

  • GitHub repo PostgreSQL

    PostgreSQL client for node.js.

    Project mention: Node.js Lambda service and DB connection pool (help needed) | reddit.com/r/aws | 2021-05-16

    I am currently using the https://github.com/brianc/node-postgres, module in my code.

  • GitHub repo dogehouse

    Taking voice conversations to the moon 🚀

    Project mention: yep, it sure is | reddit.com/r/linuxmemes | 2021-05-14

    https://github.com/benawad/dogehouse Let’s try making a good federated ID service for it

  • GitHub repo Plausible Analytics

    Simple, open-source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.

    Project mention: How to self host a Privacy respecting analytics solution? | dev.to | 2021-05-18

    Plausible Analytics

  • GitHub repo awesome-postgres

    A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

  • GitHub repo pgweb

    Cross-platform client for PostgreSQL databases

  • GitHub repo diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: My second impression of Rust and why I think it's the best general-purpose language! | reddit.com/r/rust | 2021-05-09

    I'm not building web-apps yet, currently i'm doing a terminal UI app. You can check the cargo.toml for deps. I'm planning to build a Rust blueprint for JHipster quite soon so I'll be able to directly compare productivity with Spring boot. And yes there is no equivalent of SB in Rust but I don't think you need that in Rust, there are great web frameworks like Actix or Rocket which provides most of what you need from SB and since you dont have to do OOP in Rust you actually dont need many Hibernate like features IMO, but you have http://diesel.rs/ to cover that.

  • GitHub repo usql

    Universal command-line interface for SQL databases

    Project mention: Usql 0.9.1 – Now with Autocomplete | news.ycombinator.com | 2021-05-09

    There's a new version of usql - the universal command-line client for SQL databases.

    After I started contributing to it a while ago, I went through all comments in older posts about it here on hackernews. I think the most requested feature was autocomplete. So I went ahead and implemented it. I surprised myself, how useful it ended up being. This includes completing filenames and even command names which I use on a regular basis and know very well.

    Another thing we managed to figure out are static builds for Linux. If you previously had issues with starting usql, seeing errors about libicu, you might want to give this latest version a try.

    There's also a basic implementation of the `\copy` command. Combined with the `csvq` driver, it allows loading CSV or JSON files to any supported database. But it doesn't do _any_ type mapping, so you might have to add some casting in the source query.

    Other new features include pager support, output to a file or a pipe, `\crosstab` command, and many more.

    If that got your attention, give it a spin. Full release notes are available at https://github.com/xo/usql/releases. As always, all feedback and contributions are welcome.

  • GitHub repo azuredatastudio

    Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. (by microsoft)

    Project mention: Drawbridge: What SQL Server on Linux is built on | news.ycombinator.com | 2021-01-13

    Cool! How do I enable MySQL support?

    This issue led me to believe it's not implemented yet: https://github.com/Microsoft/azuredatastudio/issues/4904

    And search for MySQL or MariaDB on extensions marketplace nets zero results.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-05-18.


What are some of the best open-source Postgresql projects? This list will help you:

Project Stars
1 Metabase 24,780
2 Sequelize 24,268
3 TypeORM 24,154
4 Redash 18,712
5 postgrest 17,003
6 Knex 14,130
7 shardingsphere 13,819
8 supabase 12,586
9 Prisma 11,233
10 mybatis-plus 10,989
11 TimescaleDB 10,978
12 Directus 10,880
13 cube.js 10,357
14 postgraphile 10,247
15 pgcli 9,562
16 PostgreSQL 9,561
17 dogehouse 8,578
18 Plausible Analytics 7,655
19 awesome-postgres 6,998
20 pgweb 6,856
21 diesel 6,819
22 usql 6,451
23 azuredatastudio 6,339