Postgresql

Top 23 Postgresql Open-Source Projects

  • Netdata

    Monitor your servers, containers, and applications, in high-resolution and in real-time.

    Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05

    netdata.cloud — Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!

  • supabase

    The open source Firebase alternative.

    Project mention: No more Mr. Open Source Guy | dev.to | 2024-02-21

    There are roughly 10 million downloads of my NuGet packages in total, all of whom are open source. This is 20 times more downloads than for instance SupaBase. SupaBase is evaluated at 1 billion dollars and have been given VC funding of more than 100 million dollars.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • Gogs

    Gogs is a painless self-hosted Git service

    Project mention: Forgejo forks its own path forward | news.ycombinator.com | 2024-02-16

    > Gitea but the other one

    Wouldn't that also be Gogs? https://gogs.io/

    I remember when that one was what a lot of people were looking into, before the Gitea fork happened. It's odd to see how this has happened yet again, but I guess is a good thing that it's even possible in the first place, if there are indeed differing values and goals?

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative

    Project mention: NocoDB: The Open Source Airtable Alternative | news.ycombinator.com | 2024-01-27
  • Discourse

    A platform for community discussion. Free, open, simple.

    Project mention: Introducing the new Godot Forum | /r/godot | 2023-12-08

    Discourse is also open source https://github.com/discourse/discourse

  • Prisma

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

    Project mention: Taming cross-service database transactions in NestJS with AsyncLocalStorage | dev.to | 2024-02-21

    There have been multiple feature requests to add native support for AsyncLocalStorage to Prisma, but they haven't been met with much enthusiasm from the maintainers. Some people solved it by extending and overriding the client (which is arguably prone to breaking with updates).

  • dbeaver

    Free universal database tool and SQL client

    Project mention: 👻Top 8 Free, Open Source SQL Clients🔥 | dev.to | 2023-09-04

    DBeaver is a veteran SQL client. In addition to basic visualization and management capabilities, it has a SQL editor, data and schema migration capabilities, monitor database connections, and more. It supports a full range of databases (both SQL and NoSQL). DBeaver is also hooked up with GPT-3, which converts your natural language to SQL.

  • LearnThisRepo.com

    Learn 300+ open source libraries for free using AI. LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI!

  • Metabase

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

    Project mention: My mental model of Clojure transducers | news.ycombinator.com | 2023-09-10

    It seems folks want a working example. Here's one in prod:

    Metabase is a BI tool, backend written mostly in Clojure. Like basically all BI tools they have this intermediate representation language thing so you write the same thing in "MBQL (metabase query language)" and it theoretically becomes same query in like, Postgres and Mongo and whatever. End user does not usually write MBQL, it's a service for the frontend querybuilding UI thing and lots of other frontend UI stuff mainly in usage.

    Whole processing from MBQL -> your SQL or whatever is done via a buncha big-ass transducers. Metabase is not materially faster than other BI tools (because all the other BI tools do something vaguely similar in their langs) but it's pretty comparable speed and the whole thing was materially written by like 5 peeps

    https://github.com/metabase/metabase/blob/master/src/metabas...

    (nb: I used to work for Metabase but currently do not. but open core is open core)

  • TypeORM

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

    Project mention: NodeJS Security Best Practices | dev.to | 2024-02-19

    If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.

  • Sequelize

    Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

    Project mention: NodeJS Security Best Practices | dev.to | 2024-02-19

    If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.

  • cal.com

    Scheduling infrastructure for absolutely everyone.

    Project mention: JSONCrack Codebase Analysis — Part 4.2.1.1 — JsonEditor — debouncedUpdateJson | dev.to | 2024-01-07

    The next codebase to analyse is cal.com. This repo is larger than jsoncrack. It is a monorepo with packages and lots of stuff going behind the scenes.

  • Directus

    The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

    Project mention: Open-Source Headless CMS in 2024 | dev.to | 2024-01-30

    Directus: The Shape-Shifting Maverick

  • Redash

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

    Project mention: Contribuir con proyectos Open Source | /r/devsarg | 2023-12-06
  • maybe

    The OS for your personal finances

    Project mention: Ask HN: What's the deal with the "open-source SaaS" trend these days? | news.ycombinator.com | 2024-01-25

    And doing so could end up making it accelerate, possibly making the unviable business eventually viable: https://github.com/maybe-finance/maybe

  • plane

    🔥 🔥 🔥 Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.

    Project mention: Projectmanagement | /r/selfhosted | 2023-12-08
  • postgrest

    REST API for any Postgres database

    Project mention: Ask HN: Popular open source tool originally written in Haskell? | news.ycombinator.com | 2024-02-10
  • shardingsphere

    Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.

    Project mention: Managing Data Residency - the demo | dev.to | 2023-05-25

    Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.

  • Knex

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

    Project mention: Create a Blog web app using Adonis.js 6 | dev.to | 2024-02-20

    AdonisJS core team has created/maintains Lucid. It is a SQL query builder, and an Active Record ORM built on top of Knex.

  • Plausible Analytics

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

    Project mention: Using Analytics on My Website | news.ycombinator.com | 2023-12-15

    If you already use Posthog, Web Analytics has been in Public Beta for quite some time.[1]

    If I remember correctly, CloudFlare Analytics does not need you to register your domain with them. I personally feel keeping domain registration coupled with your DNS provider is not a good idea.

    Plausible[2] has an Open Source self-hostable version but is not so updated in sync with their SaaS version.

    Umami[3] is another simple, clean one. And, of course, as many have suggested, Matomo is the other well-established one. If you want to avoid maintaining a hosting routine, a lot do the hosting out of the box these days. PikaPods[4] was good when I tried and played around for a while.

    1. https://posthog.com/docs/web-analytics

    2. https://github.com/plausible/analytics

    3. https://umami.is

    4. https://www.pikapods.com

  • drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

    Project mention: ORMs are nice but they are the wrong abstraction | news.ycombinator.com | 2024-02-01
  • cube.js

    📊 Cube — The Semantic Layer for Building Data Applications

    Project mention: Need to reduce costs - which service to use? | /r/dataengineering | 2023-12-05

    also check out cube.dev. they can do the semantic layer and cache it so you are not hitting Snowflake all the time.

  • APIJSON

    🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码,前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code.

  • TimescaleDB

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

    Project mention: TimescaleDB: An open-source time-series SQL database | news.ycombinator.com | 2024-02-06
  • WorkOS

    The modern API for authentication & user identity. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

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 2024-02-21.

Postgresql related posts

Index

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

Project Stars
1 Netdata 67,109
2 supabase 63,158
3 Gogs 43,815
4 nocodb 40,714
5 Discourse 39,762
6 Prisma 36,254
7 dbeaver 36,074
8 Metabase 35,819
9 TypeORM 32,952
10 Sequelize 28,888
11 cal.com 27,242
12 Directus 24,728
13 Redash 24,599
14 maybe 22,907
15 plane 22,703
16 postgrest 21,802
17 shardingsphere 19,244
18 Knex 18,506
19 Plausible Analytics 17,664
20 drizzle-orm 17,235
21 cube.js 16,908
22 APIJSON 16,378
23 TimescaleDB 16,149
The modern API for authentication & user identity.
The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
workos.com