Easy SQL object management with express
an npm package for getting started with express sql and mvc
A short description of my package is ejs-express-sql
Athena-Express makes it easier to execute SQL queries on Amazon Athena by consolidating & astracting several methods in the AWS SDK
Utilities for SQL instrumentations
Athena-Express-Plus is a Node.js library for simplified SQL query execution in Amazon Athena, supporting the latest AWS SDK v3 architecture. It provides seamless integration with Athena, enabling clean JSON result retrieval, parameterized queries, and pag
PGlite is a WASM Postgres build packaged into a TypeScript client library that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It is only 3.7mb gzipped.
Format whitespace in a SQL query to make it more readable
🛡️ Faster SQL escape and format for JavaScript (Node.js, Bun, and Deno).
A simple and lightweight library for highlighting SQL queries written in pure JavaScript
simple node sql parser
A JavaScript library for connecting securely to your Cloud SQL instances
SQL language support for the CodeMirror code editor
Simple SQL escape and format for MySQL
A TDS driver, for connecting to MS SQLServer databases.
Fast, unopinionated, minimalist web framework
Microsoft SQL Server client for Node.js.
Basic IP rate-limiting middleware for Express. Use to limit repeated requests to public APIs and/or endpoints such as password reset.
Formats SQL queries. Part of SQLTools
An opinionated sql formatter plugin for Prettier
Fastest full featured PostgreSQL client for Node.js
Zero-dependency Web Application Firewall middleware for Node.js / Express — SQL injection, XSS, path traversal, command injection, rate limiting, and more.
Postgres everywhere - your data, in sync, wherever you need it.
TypeScript definitions for express
A expression builder for SQL expressions with Postgresql support
Extends ActiveRecord migrations to allow an SQL expression for the default value of a column
This project implements an abstract SQL compiler for Alf expressions
Small DSL to create ActiveRecord (>= 3.1) attribute predicates without writing SQL.
Simple helper for generating portable SQL expressions.
Speedup your ActiveRecord by storing and updating the results of SQL or Ruby expressions into record attributes
You probably want another gem: arel. Use that to generate SQL using Ruby. This gem only generates SELECT and WITH (ie CTE) statements/expressions.
UserQuery generates SQL WHERE clauses from a simple user query expression. Can integrate with ActiveRecord or be used stand-alone.
From http://edgeguides.rubyonrails.org/active_record_migrations.html#types-of-schema-dumps: There is however a trade-off: db/schema.rb cannot express database specific items such as triggers, stored procedures or check constraints. While in a migration you can execute custom SQL statements, the schema dumper cannot reconstitute those statements from the database. If you are using features like this, then you should set the schema format to :sql. No longer is this the case. You can now use the default schema format (:ruby) and still preserve your check constraints.
Expressive, chainable DSL for SQL window functions (ROW_NUMBER, RANK, LAG, LEAD, SUM, etc.) that integrates naturally with ActiveRecord query methods.
This is a custom gem that extends ActiveRecord to enable the expression of SQL `INSERT INTO ... SELECT ...` queries in a more convenient way. It allows you to copy data from one table to another based on specified conditions using a simple and expressive syntax.
Verifica is Ruby's most scalable authorization solution, ready to handle sophisticated authorization rules. Verifica is framework and database agnostic and designed around Access Control Lists. ACL powers a straightforward and unified authorization flow for any user and resource, regardless of how tricky the authorization rules are. Verifica aims to solve the issue when authorization rules become too complex to be expressed in a single SQL query. And at the same time the database is too big to execute these rules in the application code.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.