Top 23 Postgresql Open-Source Projects
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.
An easy-to-use multi SQL dialect ORM tool for Node.jsProject 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.
Scout APM - Leading-edge performance monitoring starting at $39/month. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
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.
REST API for any Postgres databaseProject 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.
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.
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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.
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server & SQLiteProject 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.
An powerful enhanced toolkit of MyBatis for simplify developmentProject mention: The Apache Attic | news.ycombinator.com | 2021-04-09
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. 
The approach we are now taking with Timescale Analytics  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!
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.
📊 Cube.js — Open-Source Analytical API PlatformProject mention: Introducing Cube Store: High concurrency and sub-second latency for any database | reddit.com/r/Database | 2021-04-30
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
Postgres CLI with autocompletion and syntax highlightingProject 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?
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.
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
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
A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
Cross-platform client for PostgreSQL databases
A safe, extensible ORM and Query Builder for RustProject 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.
Universal command-line interface for SQL databasesProject 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.
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.
What are some of the best open-source Postgresql projects? This list will help you: