py-mysql-type-plugin vs sql-template-tag

py-mysql-type-plugin

Mypy plugin to type sql (by antialize)

Suggest topics

Source Code

Suggest alternative

Edit details

sql-template-tag

ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite` (by blakeembrey)

Pg Postgresql MySQL SQL sql-query sql-query-builder template-tags

Source Code

Suggest alternative

Edit details

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

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

featured

py-mysql-type-plugin		sql-template-tag
	Project
2	Mentions	3
0	Stars	314
-	Growth	-
5.4	Activity	6.3
26 days ago	Latest Commit	15 days ago
Python	Language	TypeScript
-	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.

py-mysql-type-plugin

Posts with mentions or reviews of py-mysql-type-plugin. 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
21 projects | news.ycombinator.com | 14 Aug 2023

It's fine advice - if you can type check your queries. My colleague wrote a mypy plugin for parsing SQL statements and doing type checking against a database schema file, which helps to identify typos and type errors early: https://github.com/antialize/py-mysql-type-plugin
Parsing SQL
7 projects | news.ycombinator.com | 22 Aug 2022

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
21 projects | news.ycombinator.com | 14 Aug 2023

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?
1 project | /r/node | 10 Apr 2022

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
6 projects | news.ycombinator.com | 9 Feb 2021

What are some alternatives?

When comparing py-mysql-type-plugin and sql-template-tag you can also consider the following projects:

pugsql - A HugSQL-inspired database library for Python

Dapper.SimpleCRUD - Who wants to write basic read/insert/update/delete statements? SimpleCRUD provides simple CRUD helpers for Dapper.

powderkeg - Live-coding the cluster!

yesql - A Clojure library for using SQL.

vscode-sqltools - Database management for VSCode

mini_sql - a minimal, fast, safe sql executor

jOOQ - jOOQ is the best way to write SQL in Java

squiller - Generate boilerplate from annotated SQL queries

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.

typed-sql

Atlas.Orm - A data mapper implementation for your persistence model in PHP.