sql-template-tag
ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite` (by blakeembrey)
iodio
Pure Functional Monadic Lazy Query Builder based on Knex,js powered by Fluture (by FbN)
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
| sql-template-tag | iodio | |
|---|---|---|
| 3 | 1 | |
| 319 | 10 | |
| - | - | |
| 6.3 | 5.0 | |
| about 1 month ago | over 3 years ago | |
| TypeScript | JavaScript | |
| MIT 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.
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.
sql-template-tag
Posts with mentions or reviews of sql-template-tag.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-08-14.
-
Python: Just Write SQL
You can avoid this entirely with JavaScript's tagged template literals. Here is an example library: https://github.com/blakeembrey/sql-template-tag
-
Knex Raw SQL String SQL Highlighting VS Code and best practices to avoid SQL Injection Attack?
If you prefer SQL and you use postgres you can check out slonik. If you want to keep using knex you can use https://github.com/blakeembrey/sql-template-tag. They will add placeholders for all the values and expose helper for query building via strings (e.g. a special join). At the same time they are typesafe.
- Objection to ORM Hatred
iodio
Posts with mentions or reviews of iodio.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-02-09.
-
Objection to ORM Hatred
Considered it, but I think that there are advantage in programmatically construct the query (see for example knex modify). Directly write down SQL or use template with sql make it harder. The only problem with knex is that it mutate at every operation instead of returning a new instance. I'm experimenting in wrapping it in a lazy monad that return a Fluture (https://github.com/FbN/iodio)
What are some alternatives?
When comparing sql-template-tag and iodio you can also consider the following projects:
Dapper.SimpleCRUD - Who wants to write basic read/insert/update/delete statements? SimpleCRUD provides simple CRUD helpers for Dapper.
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.
yesql - A Clojure library for using SQL.
vscode-sqltools - Database management for VSCode
knex-to-dbml - Generate DBML from a knex.js connection
jOOQ - jOOQ is the best way to write SQL in Java
Atlas.Orm - A data mapper implementation for your persistence model in PHP.
powderkeg - Live-coding the cluster!
mini_sql - a minimal, fast, safe sql executor
sql-template-tag vs Dapper.SimpleCRUD
iodio vs TypeORM
sql-template-tag vs yesql
iodio vs Dapper.SimpleCRUD
sql-template-tag vs vscode-sqltools
iodio vs knex-to-dbml
sql-template-tag vs jOOQ
iodio vs Atlas.Orm
sql-template-tag vs TypeORM
sql-template-tag vs Atlas.Orm
sql-template-tag vs powderkeg
sql-template-tag vs mini_sql