pg-extra vs sqliterally

pg-extra

🐘 some helpful extensions for node-postgres (by danneu)

Postgres Node

DISCONTINUED

Suggest alternative

Edit details

sqliterally

Lightweight SQL query builder (by terkelg)

SQL Postgresql Postgres Parameterized template-literals Query Query Builder Node node-pg MySQL

Source Code

Suggest alternative

Edit details

SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App

With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

surveyjs.io

featured

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

pg-extra		sqliterally
	Project
1	Mentions	1
11	Stars	260
-	Growth	-
0.0	Activity	0.0
about 2 years ago	Latest Commit	about 2 years ago
JavaScript	Language	JavaScript
-	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pg-extra

Posts with mentions or reviews of pg-extra. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-03-10.

Slonik: A PostgreSQL client with strict types, detailed logging, and assertions
8 projects | news.ycombinator.com | 10 Mar 2021

The template tag solution is cute but really dangerous if you can accidentally leave off the `SQL` tag and the query still works.
Here's a solution that goes the long route of wrapping node-postgres' classes to ensure that you can never accidentally pass a basic string into query(): https://github.com/danneu/pg-extra/blob/be0e1a9fd513296e9bed...

sqliterally

Posts with mentions or reviews of sqliterally. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-07-03.

Stuck On Node database management. Should I use a different ORM? Should I use raw SQL?
9 projects | /r/node | 3 Jul 2021

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

What are some alternatives?

When comparing pg-extra and sqliterally you can also consider the following projects:

pgtyped - pgTyped - Typesafe SQL in TypeScript

visulate-ora2pg - Docker image and single page web application for Ora2Pg

slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

typeorm-model-generator - Generates models for TypeORM from existing database.

PostgreSQL - PostgreSQL client for node.js.

gsSQL - Use real SQL SELECT syntax to filter your Google Sheets data using a simple custom function.

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.

node-sql-template-strings - ES6 tagged template strings for prepared SQL statements 📋

lucid - AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more

ship-hold - data access framework for Postgresql on nodejs