JavaScript Postgresql

Open-source JavaScript projects categorized as Postgresql

Top 23 JavaScript Postgresql Projects

  • 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: Using a MySQL database to serve multiple guilds | reddit.com/r/Discord_Bots | 2023-01-21

    If you like the OOP paradigm and you don't know a lot of the SQL syntax i also suggest looking for an ORM, which abstracts query language the language you're using like https://sequelize.org/

  • Knex

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

    Project mention: Kysely: TypeScript SQL Query Builder | news.ycombinator.com | 2023-01-24

    How does HN receive SQL builders in general? I feel like most of us agree ORMs are typically a bad idea. I feel like that almost instantly leaves the need for "something" to take its place. In my experience, it's typically been a query builder like this.

    I've also tried:

    https://knexjs.org/

    https://www.npmjs.com/package/sql-template-strings ("out of date" since like 2016? https://www.npmjs.com/package/sql-template-tag might be better)

    Are query builders an anti pattern? People who are doing serious/logic heavy stuff with SQL, how do you avoid a query builder (if at all?)

  • 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!

  • nodeBB

    Node.js based forum software built for the modern web

    Project mention: The over-reliance on Discord is doing more harm than good. | reddit.com/r/truegaming | 2022-11-23

    If you want to make your own app out of custom code that you will actively develop new features for, I think your points are true. But if you just wanted a modern version of the old phpBB forums, there are plenty of almost-turnkey projects/templates you can use. Check out NodeBB for instance. Maybe the barrier for entry is higher in a way, given increased complexity, but you also get more and nicer features "for free". I think it's a wash.

  • PostgreSQL

    PostgreSQL client for node.js.

    Project mention: What is your development stack for 2023? | reddit.com/r/node | 2023-01-09

    node-postgres (raw sql, without ORM)

  • Bookshelf

    A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

    Project mention: Is there a 'batteries included' backend framework like Django, but written in JS? | reddit.com/r/learnjavascript | 2022-03-06

    If you're set on JS (using only one language on a team/project can be very nice) common choices for backend often involve using Express or hapi with some ORM (like Prisma or Bookshelf).

  • falcon

    Free, open-source SQL client for Windows and Mac 🦅 (by plotly)

    Project mention: Connect SQL Client to PostgreSQL in Docker Compose | reddit.com/r/docker | 2022-07-27

    As you can see, I have Postgres db running in my container, I also have a client I want to use to access this database (falcon-client), however, it cannot connect to the db, I'm assuming it's because my port at 5432 is not allowing access to the database (as suggested here)

  • react-firebase-starter

    Boilerplate (seed) project for creating web apps with React.js, GraphQL.js and Relay

    Project mention: Alternatives to Create React App | dev.to | 2022-10-13

    Let's look at React Starter Kit, which bills itself as an isomorphic web project boilerplate. Additionally, the React Starter Kit is described as, “very opinionated” on the webpage. This implies that it has already chosen our tech stack for us, which consists of Node.js, Express and GraphQL.

  • Sonar

    Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • postgres

    Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno (by porsager)

    Project mention: Well, shit. Objection.js has been sunset, which ORM/querybuilder did you move to? | reddit.com/r/node | 2022-12-03

    About a year ago I moved to raw SQL using Postgres.js. Honestly I thought it would be traumatic but it's been great so far.

  • franchise

    🍟 a notebook sql client. what you get when have a lot of sequels.

    Project mention: What is the best web-based PostgreSQL for Workshop | reddit.com/r/PostgreSQL | 2022-10-05

    Would https://franchise.cloud be any use?

  • pg-promise

    PostgreSQL interface for Node.js

    Project mention: Ask HN: Why are so many PHP projects moving to Node? | news.ycombinator.com | 2023-01-26

    I've always loved this project / product:

    https://github.com/outline/outline

    I think the guy who built it posts here. There's also pg-promise, a "Postgres interface for Node.js":

    https://github.com/vitaly-t/pg-promise

  • orm2

    Object Relational Mapping

  • postbird

    Open source PostgreSQL GUI client for macOS, Linux and Windows

  • thin-backend

    🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps

    Project mention: Ask HN: How would you refactor a big project in 2023? | news.ycombinator.com | 2023-01-13

    A tool like https://thin.dev/ might be good for you. You can port and serve functionality a little bit at a time into thin and use their managed postgres db and the schema editor to handle the new fields in the backend.

  • pg-boss

    Queueing jobs in Node.js using PostgreSQL like a boss

    Project mention: How/do you handle queue type workflows? | reddit.com/r/Supabase | 2023-02-05
  • Chartbrew

    Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊

    Project mention: Those making $500/month on side projects in 2023 – Show and tell | news.ycombinator.com | 2023-01-22

    I'm working part-time on my project https://chartbrew.com

    It's an open-source data visualization and reporting platform that I started in 2018, I abandoned in 2019, then resumed working on it more seriously in 2020.

    Currently, the platform is doing $1,138 in MRR from then managed hosting service and has made over $11k in revenue so far. It's been growing steadily in the last few months but going through a rough Dec-Jan period at the moment. You can see the open page at https://chartbrew.com/open

    Onwards and great job everyone at working to make side projects work for you!

  • django-react-boilerplate

    DIY Django + React Boilerplate for starting your SaaS

    Project mention: Registration in Django Rest Framework | reddit.com/r/django | 2022-11-08

    You cac check SaaSitive React and Django tutorial. It has lesson about registration and more. It is paid tutorial.

  • MiAOU

    A chat server with OAuth2 authentication, persistent and searchable history, video and audio, markdown formatting, private and public rooms, stars, votes, embedded games, and many other features

  • tasking-manager

    Tasking Manager - The tool to team up for mapping in OpenStreetMap

    Project mention: Humanitarian OpenStreetMap Team | news.ycombinator.com | 2023-02-07

    Help mapping (all in a browser) https://tasks.hotosm.org/explore?campaign=T%C3%BCrkiye%20Ear...

    The tech for the task manager is at https://github.com/hotosm/tasking-manager/issues

  • PostGUI

    A React web application to query and share any PostgreSQL database.

  • mlcraft

    Low-code metrics store, modern open-source alternative to Looker

  • rdb

    Javascript ORM

  • sqliterally

    Lightweight SQL query builder

  • Netflix-Clone

    Netflix like full-stack application with SPA client and backend implemented in service oriented architecture (by yuchiu)

    Project mention: Best Clone Projects On Github!! | reddit.com/r/github | 2023-01-26

    Netflix Clone - https://github.com/yuchiu/Netflix-Clone

  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

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 2023-02-07.

JavaScript Postgresql related posts

Index

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

Project Stars
1 Sequelize 27,388
2 Knex 17,078
3 nodeBB 13,170
4 PostgreSQL 10,957
5 Bookshelf 6,309
6 falcon 5,052
7 react-firebase-starter 4,450
8 postgres 4,367
9 franchise 3,942
10 pg-promise 3,276
11 orm2 3,076
12 postbird 1,360
13 thin-backend 1,105
14 pg-boss 1,068
15 Chartbrew 976
16 django-react-boilerplate 544
17 MiAOU 515
18 tasking-manager 419
19 PostGUI 370
20 mlcraft 363
21 rdb 291
22 sqliterally 256
23 Netflix-Clone 252
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
www.influxdata.com