SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Postgresql Open-Source Projects
-
supabase
The open source Firebase alternative. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
Project mention: What Is security.txt and How Can It Help Improve Website Security? | dev.to | 2024-12-08The SECURITY.md in the supabase/supabase repository is a symbolic link to apps/docs/public/.well-known/security.txt
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
Project mention: Netdata: 20% discount on all annual plans Promo code BF20241Y | news.ycombinator.com | 2024-12-04
-
Project mention: Show HN: Visual DB – Web front end for your database | news.ycombinator.com | 2024-09-10
-
Gogs: An easy-to-setup self-hosted Git service.
-
Project mention: 8 Open-Source Tools to grow your app and reach new markets! 🔥 | dev.to | 2024-10-11
Star the Discourse repository ⭐
-
This is the third and the final article of the series. It's written based on the results of checking DBeaver version 24 with the help of the PVS-Studio static analyzer. The tool detected a few suspicious code fragments that caught our development team's attention and prompted us to cover them in several articles. If you haven't read the previous ones, you can find them here:
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Prisma - a modern Object-Relational Mapping (ORM) tool for simplifying database interactions. Having heard much about it, I am excited to incorporate it into future projects.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
Hope you enjoy the release. If you want to get into the nitty-gritty, check out our release notes in GitHub. To see what other features we have in the works, see our product roadmap.
-
quivr
Opiniated RAG for integrating GenAI in your apps 🧠 Focus on your product rather than the RAG. Easy integration in existing products with customisation! Any LLM: GPT4, Groq, Llama. Any Vectorstore: PGVector, Faiss. Any Files. Anyway you want.
-
With the advent of people moving away from serverless and pushing more towards self-hosted solutions around VPS from provided like Hetzner and using deployment tools like Coolify , I’ve been wanting to have a cool monitoring app which not only monitor uptime but also disk space, CPU pressure, memory pressure, networking and more and throw alerts when something looks outside of the allowable thresholds.
-
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.
// src/main/database/dataSource.ts import path from "node:path"; import "reflect-metadata"; import { DataSource } from "typeorm"; import { UserEntity } from "./entities/user/user.entity"; import { PostEntity } from "./entities/post/post.entity"; const isElectron = !!process.versions.electron; # simple trick to see if the data source is called from the Electron app or CLI (for migrations scripts) const isProduction = process.env.NODE_ENV === "production"; let databasePath: string; if (isElectron) { // eslint-disable-next-line @typescript-eslint/no-require-imports const { app } = require("electron"); databasePath = path.join( app.getPath("userData"), app.isPackaged ? "app-name.sqlite" : "app-name.dev.sqlite" ); } else { // use hardcoded path for running migrations in development (macOS) databasePath = path.join( "/Users/user/Library/Application Support/app-name/", isProduction ? "app-name.sqlite" : "app-name.dev.sqlite" ); } // https://typeorm.io/data-source-options#better-sqlite3-data-source-options const dataSource = new DataSource({ type: "better-sqlite3", database: databasePath, entities: [UserEntity, PostEntity], migrations: [ path.join(__dirname, isElectron ? "database" : "", "/migrations/*.{js,ts}"), ], synchronize: false, # important logging: true # use this for debugging }); export const entityManager = dataSource.createEntityManager(); export default dataSource;
-
Project mention: Show HN: I made a double-entry based personal finance app | news.ycombinator.com | 2024-11-28
I'm still holding out for something that can monitor my bank account and automatically register transactions instead of me having to manually enter them. https://maybe.co/ is working on a solution for American banks.
I understand that Europeans already have protocols in place for this sort of thing. Why must the EU always get the nice things?
-
Project mention: Using Clerk SSO to access Google Calendar and other service data | dev.to | 2024-12-11
BookMate is an open-source, publicly accessible, lightweight clone of popular booking services like cal.com or Calendly.
-
plane
🔥 🔥 🔥 Open Source JIRA, Linear, Monday, and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.
Project mention: Huly – Open-Source All-in-One Project Management Platform | news.ycombinator.com | 2024-10-13We’ve been using Plane CE and are really happy with it. For those who need a serious project management tool, I’d definitely recommend giving it a try. Huly looks interesting-might explore it in the future. I did try self-hosting, but the experience wasn’t great.
https://github.com/makeplane/plane
-
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.
3. Sequelize
-
Directus
The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, auth & more.
Project mention: Ask HN: Anybody used Retool for production, user-facing app? | news.ycombinator.com | 2024-11-18I would also recommend looking at Directus (https://directus.io).
We evaluated PayloadCMS to drive the backend of a mobile app and eventually settled on Directus because it supported heterogeneous collections which was something we had to have.
Directus also has a template for a multi-tenant app which sounds like something you might need.
-
full-stack-fastapi-template
Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.
Flask Tutorial: https://palletsprojects.com/p/flask/ FastAPI Tutorial: https://github.com/tiangolo/full-stack-fastapi-template Django REST Framework Tutorial: https://www.django-rest-framework.org/tutorial/quickstart/ Nginx Configuration Guide: https://docs.nginx.com/nginx/admin-guide/web-server/web-server/ Confluent Kafka Python Client: https://docs.confluent.io/platform/current/clients/api-docs/confluent-kafka-python.html Remember: This is a high-level overview. Each step involves further research and configuration based on your specific requirements.
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Project mention: The 50 best open-source alternatives to popular SaaS software | dev.to | 2024-07-10GitHub: Redash GitHub Repository
-
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: Show HN: Pages CMS 1.0.0 – open-source CMS for static sites (Next.js, Astro) | news.ycombinator.com | 2024-12-06 -
Star on GitHub ⭐ - Twenty
-
PostgREST
-
🌐 Composed Image Retrieval 📎 Intro to Multimodal LLama 3.2 🛠️ Multi Agent Concierge 💻 RAG with Langchain Granite, Milvus 🫶 Download content ✅ Transformer Replacement? 🤖 vLLM for runing models 🌐 Amphion 📝 Autogluon 🚙 Notebook LLama like Google's Notebook LLM 🫶 Monocle2ai for tracing GenAI app code LFA&D Project 🤖 Bee Agent Framework ✅ LLama RFP Response ▶️ GenAI Script 👽 Simular AI Agent S 🦾 DrawDB with AI ✨ Ollama with LLama 3.2 Vision!!!! Preview 🚕 Powerful RAG Checker 📊 SQL Generator 💻 Role of LLMs 🐍 Document Extraction 🕶️ Open Source Vector DB Reddit 🍔 The Practical Guide to Self Hosting LLM 🦾 Stagehand Controller 🕶️ Understanding HNSWLIB 🐍 Best practices in RAG 💻 Enigma Agent 📝 Langchain, Ollama, Phi3 for Function Calling 🔋 Compass Judger 📝 Princeton NLP SimPO 🍔 Princeton NLP ProLong 🔋 Princeton NLP HELMET 🧐 Ollama Cheatsheet 🚕 Princeton NLP CopyCat 📊 Princeton NLP Shp 🕶️ Can LLM Solve Hard Github Issues 📝 Enabling Large Language Models to Generate Text with Citations 🔋 Princeton NLP CharXiv 📊 Awesome AI Agents List 🦾 Nomic’s Matryoshka text embedding model
-
Plausible Analytics
Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.
Project mention: Show HN: Vince – A self hosted alternative to Google Analytics | news.ycombinator.com | 2024-11-28 -
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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).
Postgresql discussion
Postgresql related posts
-
Using Clerk SSO to access Google Calendar and other service data
-
Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
-
Amazon Aurora DSQL
-
Postgres for Everything (E/Postgres)
-
Optimizing a Rust GPU matmul kernel
-
Litdb – type safe SQL for JavaScript/TS
-
Show HN: Outerbase Studio – Open-Source Database GUI
-
A note from our sponsor - SaaSHub
www.saashub.com | 12 Dec 2024
Index
What are some of the best open-source Postgresql projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | supabase | 74,884 |
| 2 | Netdata | 72,392 |
| 3 | nocodb | 50,113 |
| 4 | Gogs | 45,177 |
| 5 | Discourse | 42,504 |
| 6 | dbeaver | 40,809 |
| 7 | Prisma | 40,001 |
| 8 | Metabase | 39,006 |
| 9 | quivr | 36,862 |
| 10 | coolify | 35,302 |
| 11 | TypeORM | 34,542 |
| 12 | maybe | 34,266 |
| 13 | cal.com | 32,774 |
| 14 | plane | 31,162 |
| 15 | Sequelize | 29,635 |
| 16 | Directus | 28,355 |
| 17 | full-stack-fastapi-template | 28,306 |
| 18 | Redash | 26,525 |
| 19 | drizzle-orm | 24,901 |
| 20 | Twenty | 24,036 |
| 21 | postgrest | 23,532 |
| 22 | drawdb | 22,880 |
| 23 | Plausible Analytics | 20,755 |
Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai