JavaScript Postgresql

Open-source JavaScript projects categorized as Postgresql | Edit details

Top 23 JavaScript Postgresql Projects

  • Sequelize

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

    Project mention: Getting started with Adonis, Vue & Inertia | dev.to | 2022-01-22

    Lucid is AdonisJS Built-In ORM. It's extremely powerful and works much like Laravel's Eloquent ORM. While Lucid is built in, you can optionally use Sequelize or Prisma with AdonisJS as well.

  • Knex

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

    Project mention: New to PostgreSQL - Best way to use it? | reddit.com/r/PostgreSQL | 2022-01-25

    a) How will you do your queries from node. There's two, actually three approaches. First, writing SQL directly in your code (which I think is the one you should take), and in this case you would use node-postgres. The great thing about this is that you can try out some query in DBeaver or in psql (the command line) or some other tool and when it's right, just copy to your node.js code. Or conversely, if a query in your program isn't right, you can debug it in psql / DBeaver with some test inputs. Anyway another approach would be to use an ORM, and for this one I think the most popular in node land is Prisma (but I may be wrong). And then there's a middle ground which is like just writing queries, but instead of using sql syntax, you write it with JS methods and get them converted to SQL using a query builder. A nice query builder would be knexjs, and actually it's the kind of thing I would use myself (but I don't program in node). (Prisma itself has a comparison on those 3 approaches (actually, the whole Prisma documentation is pretty good))

  • OPS

    OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.

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

    PostgreSQL client for node.js.

    Project mention: New to PostgreSQL - Best way to use it? | reddit.com/r/PostgreSQL | 2022-01-25

    a) How will you do your queries from node. There's two, actually three approaches. First, writing SQL directly in your code (which I think is the one you should take), and in this case you would use node-postgres. The great thing about this is that you can try out some query in DBeaver or in psql (the command line) or some other tool and when it's right, just copy to your node.js code. Or conversely, if a query in your program isn't right, you can debug it in psql / DBeaver with some test inputs. Anyway another approach would be to use an ORM, and for this one I think the most popular in node land is Prisma (but I may be wrong). And then there's a middle ground which is like just writing queries, but instead of using sql syntax, you write it with JS methods and get them converted to SQL using a query builder. A nice query builder would be knexjs, and actually it's the kind of thing I would use myself (but I don't program in node). (Prisma itself has a comparison on those 3 approaches (actually, the whole Prisma documentation is pretty good))

  • Bookshelf

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

    Project mention: Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn? | reddit.com/r/node | 2021-12-30

    I made the transition from LAMP to Node-based stacks 6 or 7 years ago and started out using BookshelfJS. Node is a different world though, one that lends itself to distributed services and server-less infrastructure, and it's changed how I interact with DBs.

  • falcon

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

    Project mention: best free sql query assistance tool | reddit.com/r/SQL | 2021-08-30

    Or maybe Falcon as a desktop tool.

  • react-firebase-starter

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

    Project mention: 12+ React Boilerplates & Starter Kits For Developers In 2021 | dev.to | 2021-05-11

    GitHub

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • pg-promise

    PostgreSQL interface for Node.js

    Project mention: Help seeding a database with PG | reddit.com/r/learnjavascript | 2021-08-17

    Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise

  • orm2

    Object Relational Mapping

  • postgres

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

    Project mention: How can I check if I am safe from SQL injection? | reddit.com/r/node | 2021-11-12
  • postbird

    Open source PostgreSQL GUI client for macOS, Linux and Windows

    Project mention: PostgreSQL 14 Released | news.ycombinator.com | 2021-09-30

    I've been trying out Beekeeper Studio [https://www.beekeeperstudio.io/] recently, and like that it supports both MySQL and PostgreSQL (and others I don't use). The interface takes a little bit to get used to, but it's been pretty powerful for me.

    Before that, or when I'm in a rush to just get something done as I adjust to Beekeeper, I use Postbird (an Electron app) [https://github.com/Paxa/postbird]

  • pg-boss

    Queueing jobs in Node.js using PostgreSQL like a boss

    Project mention: Postgres is a great pub/sub and job server | news.ycombinator.com | 2021-12-17

    If anyone is looking to use postgres as a job server with node.js clients, I can highly recommend the pg-boss library (https://github.com/timgit/pg-boss). Looks like it just added pub/sub too (yesterday), so I guess you could use it for that too.

  • Chartbrew

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

    Project mention: Ask HN: Tool for dashboards / alerting on operational health metrics? | news.ycombinator.com | 2021-12-19

    There's an indie-hacker I follow building this: https://chartbrew.com/

    From what I understand, it's more like an easier-to-use grafana, where you can build charts/graphs from different data sources.

  • 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

    Project mention: Some?ready?made.solution() for private users messaging ? (not for testing) | reddit.com/r/node | 2021-11-17
  • django-react-boilerplate

    DIY Django + React Boilerplate for starting your SaaS

  • PostGUI

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

    Project mention: Ask HN: Best (Low-/No-Code) Solution for Simple Web-Based Database Front Ends | news.ycombinator.com | 2021-04-01
  • mlcraft

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

    Project mention: Ыelf-hosted alternative to Looker | reddit.com/r/selfhosted | 2021-09-27
  • pure-orm

    A Node.js SQL toolkit for writing native SQL queries yielding pure business objects

    Project mention: Do you ever avoid submitting something on HN so devs don't ruin it? | news.ycombinator.com | 2021-12-08

    I would certainly hate for devs to hate on this top-secret pure orm project [0].

    [0] https://github.com/craigmichaelmartin/pure-orm

  • sqliterally

    Lightweight SQL query builder

    Project mention: Stuck On Node database management. Should I use a different ORM? Should I use raw SQL? | reddit.com/r/node | 2021-07-03

    You can use something like sqliterally to compose your SQL, and maybe make it a bit cleaner.

  • giraffeQL

    🦒 Developer tool to visualize relational databases and export schemas for GraphQL API's.

    Project mention: giraffeQL - Relational Database Visualiser and Schema Exporter for GraphQL APIs | reddit.com/r/coolgithubprojects | 2021-02-27
  • lcbo-api

    A crawler and API server for Liquor Control Board of Ontario retail data

    Project mention: LCBO.com adds the ability to download the store availability as an excel file (bottom of page) | reddit.com/r/torontocraftbeer | 2021-03-19
  • Kyrix

    Interactive details-on-demand data visualizations at scale

    Project mention: Implicit In-order Forests: Zooming a billion trace events at 60fps | news.ycombinator.com | 2021-04-30

    We built a general 2D zooming visualization system which supports data in PostgreSQL: https://github.com/tracyhenry/kyrix. Under the hood, it uses PostgreSQL quad tree index to fetch data on demand.

    We have also tested with Citus, which helped us scaled to billions of objects. Demo: https://youtu.be/ccES97ni_vI

  • pgcmd

    Non-interactive PostgreSQL query tool.

    Project mention: Ask HN: What are some tools / libraries you built yourself? | news.ycombinator.com | 2021-05-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-01-25.

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 25,575
2 Knex 15,244
3 nodeBB 12,403
4 PostgreSQL 10,145
5 Bookshelf 6,260
6 falcon 4,870
7 react-firebase-starter 4,374
8 pg-promise 3,071
9 orm2 3,065
10 postgres 2,215
11 postbird 1,216
12 pg-boss 728
13 Chartbrew 614
14 MiAOU 505
15 django-react-boilerplate 477
16 PostGUI 331
17 mlcraft 309
18 pure-orm 297
19 sqliterally 251
20 giraffeQL 149
21 lcbo-api 127
22 Kyrix 125
23 pgcmd 116
Find remote Postgresql jobs at our new job board 99remotejobs.com. There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
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.
scoutapm.com