Postgresql

Open-source projects categorized as Postgresql Edit details

Top 23 Postgresql Open-Source Projects

  • supabase

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

    Project mention: A cloud-base database(with APIs) to store data from a frontend app (Free to start/paid)? | reddit.com/r/Database | 2022-08-11

    Check out https://supabase.com

  • Discourse

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

    Project mention: Dear Auth0: Fuck you and fuck your new pricing model | reddit.com/r/webdev | 2022-08-01

    Is this to let 3rd party services (like https://www.discourse.org/) sign in via your users credentials?

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • Metabase

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

    Project mention: How limit CPU/Ram on a system service on nixos? | reddit.com/r/NixOS | 2022-08-11

    My metabase service is eating all the resources on my machine, and while found a solution I need a way to limit the usage of the resources.

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative - turns any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs.

    Project mention: What kind of open source self-hosted solution is needed in your industry? | reddit.com/r/selfhosted | 2022-08-13

    NocoDB

  • 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: Am I just a boomer, or does anyone else avoid frameworks as much as possible? | reddit.com/r/node | 2022-08-12
  • dbeaver

    Free universal database tool and SQL client

    Project mention: Top 5 MariaDB GUI tools in 2022 | dev.to | 2022-08-01

    DBeaver is a free and open source multiplatform tool for all people who work with databases. Apart from MariaDB, it supports MySQL, PostgreSQL, Oracle, MS Access, MongoDB, Redis, and many more databases. It is actively maintained, and users are invited to report bugs and suggest features on the DBeaver GitHub page.

  • Sequelize

    An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js | Postgres, MySQL, MariaDB, SQLite, MSSQL, Snowflake & DB2

    Project mention: A JavaScript monolith ready to scale | dev.to | 2022-08-13

    3- Add an ORM with the proper DB driver (I use Sequelize -mostly- or Mongoose but there are a tone out there, you can pick your favourite one).

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • Prisma

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

    Project mention: Prisma Vs Mongoose for Nestjs and MongoDB app | reddit.com/r/Nestjs_framework | 2022-08-13

    Prisma is really cool and intuitive to use but I wouldn't use until this bug is fixed

  • Redash

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

    Project mention: Is Redash dead? The red arrow indicates when Databricks acquired Redash | reddit.com/r/dataengineering | 2022-08-04
  • postgrest

    REST API for any Postgres database

    Project mention: A rest library | reddit.com/r/haskell | 2022-08-12

    Perhaps you'll find this project interesting https://github.com/PostgREST/postgrest

  • 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: What kind of open source self-hosted solution is needed in your industry? | reddit.com/r/selfhosted | 2022-08-13

    Directus

  • shardingsphere

    Ecosystem to transform any database into a distributed database system, and enhance it with sharding, elastic scaling, encryption features & more

    Project mention: DistSQL Applications: Building a Dynamic Distributed Database | dev.to | 2022-07-26

    GitHub Issues

  • Knex

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

    Project mention: Building REST Endpoints with Knex and PostgreSQL | dev.to | 2022-08-09

    By building a demo project, we’ve learned how to build REST endpoints with Knex and PostgreSQL. We started by introducing PostgreSQL and Knex and why you should use them, then we created a blog project for the demonstration. Now that you’ve gotten the knowledge you seek, how would you use a query builder in your next project? Consider learning more about Knex from their official website and take things even further!

  • cube.js

    📊 Cube — Headless Business Intelligence for Building Data Applications

    Project mention: Parsing logs from multiple data sources with Ahana and Cube | dev.to | 2022-06-08

    const measureNames = [ 'perc_10', 'perc_10_value', 'perc_20', 'perc_20_value', 'perc_30', 'perc_30_value', 'perc_40', 'perc_40_value', 'perc_50', 'perc_50_value', 'perc_60', 'perc_60_value', 'perc_70', 'perc_70_value', 'perc_80', 'perc_80_value', 'perc_90', 'perc_90_value', 'perc_100', 'perc_100_value', ]; const measures = Object.keys(measureNames).reduce((result, name) => { const sqlName = measureNames[name]; return { ...result, [sqlName]: { sql: () => sqlName, type: `max` } }; }, {}); cube('errorpercentiles', { sql: `with sagemaker as ( select model_name, variant_name, cast(json_extract(FROM_UTF8( from_base64(capturedata.endpointinput.data)), '$.correlation_id') as varchar) as correlation_id, cast(json_extract(FROM_UTF8( from_base64(capturedata.endpointoutput.data)), '$.prediction') as double) as prediction from s3.sagemaker_logs.logs ) , actual as ( select correlation_id, actual_value from postgresql.public.actual_values ) , logs as ( select model_name, variant_name as model_variant, sagemaker.correlation_id, prediction, actual_value as actual from sagemaker left outer join actual on sagemaker.correlation_id = actual.correlation_id ) , errors as ( select abs(prediction - actual) as abs_err, model_name, model_variant from logs ), percentiles as ( select approx_percentile(abs_err, 0.1) as perc_10, approx_percentile(abs_err, 0.2) as perc_20, approx_percentile(abs_err, 0.3) as perc_30, approx_percentile(abs_err, 0.4) as perc_40, approx_percentile(abs_err, 0.5) as perc_50, approx_percentile(abs_err, 0.6) as perc_60, approx_percentile(abs_err, 0.7) as perc_70, approx_percentile(abs_err, 0.8) as perc_80, approx_percentile(abs_err, 0.9) as perc_90, approx_percentile(abs_err, 1.0) as perc_100, model_name, model_variant from errors group by model_name, model_variant ) SELECT count(*) FILTER (WHERE e.abs_err <= perc_10) AS perc_10 , max(perc_10) as perc_10_value , count(*) FILTER (WHERE e.abs_err > perc_10 and e.abs_err <= perc_20) AS perc_20 , max(perc_20) as perc_20_value , count(*) FILTER (WHERE e.abs_err > perc_20 and e.abs_err <= perc_30) AS perc_30 , max(perc_30) as perc_30_value , count(*) FILTER (WHERE e.abs_err > perc_30 and e.abs_err <= perc_40) AS perc_40 , max(perc_40) as perc_40_value , count(*) FILTER (WHERE e.abs_err > perc_40 and e.abs_err <= perc_50) AS perc_50 , max(perc_50) as perc_50_value , count(*) FILTER (WHERE e.abs_err > perc_50 and e.abs_err <= perc_60) AS perc_60 , max(perc_60) as perc_60_value , count(*) FILTER (WHERE e.abs_err > perc_60 and e.abs_err <= perc_70) AS perc_70 , max(perc_70) as perc_70_value , count(*) FILTER (WHERE e.abs_err > perc_70 and e.abs_err <= perc_80) AS perc_80 , max(perc_80) as perc_80_value , count(*) FILTER (WHERE e.abs_err > perc_80 and e.abs_err <= perc_90) AS perc_90 , max(perc_90) as perc_90_value , count(*) FILTER (WHERE e.abs_err > perc_90 and e.abs_err <= perc_100) AS perc_100 , max(perc_100) as perc_100_value , p.model_name, p.model_variant FROM percentiles p, errors e group by p.model_name, p.model_variant`, preAggregations: { // Pre-Aggregations definitions go here // Learn more here: https://cube.dev/docs/caching/pre-aggregations/getting-started }, joins: { }, measures: measures, dimensions: { modelVariant: { sql: `model_variant`, type: 'string' }, modelName: { sql: `model_name`, type: 'string' }, } });

  • TimescaleDB

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

    Project mention: Advice on managing (mostly) timeseries data in an academic context | reddit.com/r/Database | 2022-08-04

    TimescaleDB

  • mybatis-plus

    An powerful enhanced toolkit of MyBatis for simplify development

  • nodeBB

    Node.js based forum software built for the modern web

    Project mention: NodeBB - Node.js based forum software built for the modern web | reddit.com/r/CKsTechNews | 2021-12-25
  • Plausible Analytics

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

    Project mention: Lots of companies are wrong about their GDPR compliance. | reddit.com/r/Entrepreneur | 2022-07-18

    Site: https://plausible.io

  • 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.11 | reddit.com/r/PostGraphile | 2022-05-25
  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    Project mention: New to MySQL, tips about client tools | reddit.com/r/mysql | 2022-08-12

    I personally use DBeaver at the moment but I recently learned about Beekeeper Studio and think it looks pretty slick: https://www.beekeeperstudio.io/

  • PostgreSQL

    PostgreSQL client for node.js.

    Project mention: Saving data to a postgres database from a json file | reddit.com/r/Nestjs_framework | 2022-08-12

    If no, use the file system to read the json file and use this package Postgres NPM to integrate your db and send the data with the json keys mapped to the column names of the tables

  • pgcli

    Postgres CLI with autocompletion and syntax highlighting

    Project mention: Postgres: ERROR: column d.adsrc does not exist | reddit.com/r/PostgreSQL | 2022-05-23

    Home: http://pgcli.com

  • full-stack-fastapi-postgresql

    Full stack, modern web application generator. Using FastAPI, PostgreSQL as database, Docker, automatic HTTPS and more.

    Project mention: migrating a LARGE flask api to kotlin+spring boot. any advice ? | reddit.com/r/Kotlin | 2022-07-16
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 2022-08-13.

Postgresql related posts

Index

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

Project Stars
1 supabase 36,355
2 Discourse 36,171
3 Metabase 29,395
4 nocodb 29,288
5 TypeORM 29,011
6 dbeaver 27,705
7 Sequelize 26,576
8 Prisma 24,690
9 Redash 21,538
10 postgrest 19,047
11 Directus 17,158
12 shardingsphere 17,005
13 Knex 16,229
14 cube.js 13,539
15 TimescaleDB 13,457
16 mybatis-plus 13,359
17 nodeBB 12,822
18 Plausible Analytics 12,034
19 postgraphile 11,463
20 beekeeper-studio 11,086
21 PostgreSQL 10,577
22 pgcli 10,561
23 full-stack-fastapi-postgresql 9,540
Find remote jobs at our new job board 99remotejobs.com. There are 3 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Clean code begins in your IDE with SonarLint
Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
www.sonarlint.org