slowpokefs
safeql
Our great sponsors
| slowpokefs | safeql | |
|---|---|---|
| 1 | 8 | |
| 13 | 1,220 | |
| - | 2.3% | |
| 0.0 | 7.2 | |
| over 9 years ago | 3 months ago | |
| C | TypeScript | |
| GNU General Public License v3.0 only | MIT License |
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.
slowpokefs
-
Crazy fast build times (Or when 10 seconds starts to make you nervous)
One thing I saw was someone logging all system calls their software generated and comparing that between runs. They'd been bitten by some minor library upgrade that had changed directory scanning which caused huge multiples of normal latency which on an SDD wasn't noticeable but on an HDD went from trivial to insane.
That was handy because it didn't actually involve testing on a slow device but mostly showed what we needed to know.
There are tools like https://github.com/schoentoon/slowpokefs which try to make your fast storage act like a HDD which could be better for black-box testing.
safeql
-
compile-time SQL validations and type generation in TypeScript & Node
Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?
-
Using mysql2 package alongside Prisma for optimizing query performance with large tables
Anyways, an alternative if you're interested in using raw sql for max efficiency is an interesting project called SafeQLwhich treats inline queries as something to be linted. The only issue with that is if you develop on Windows, it doesn't work unless you're using WSL.
-
Best ORM library?
If you want to just write raw/valid SQL safely - SafeQL is great, one major issue though is that it doesn't work on Windows (you can hack it with WSL).
-
What backend should i use for sveltekit projects?
SafeQL I think could replace a lot of ORM code, the only issue is it doesn't support Windows if you need that.
-
You may not need an SQL query builder or ORM
If there was a tool that plugs into your linter (ESLint) and helps you find and fix these issues, would you use it? Luckily, I just wrote one - SafeQL.
-
Please Don't (Manually) Parameterize Your SQL Queries
Last week, I wrote a post about a plugin (that lints your SQL queries) called SafeQL. While doing so, I wrote this line:
-
Write SQL Queries With Confidence (TypeScript + Postgres)
Be sure to follow this issue if you're interested - https://github.com/ts-safeql/safeql/issues/14
SafeQL is currently in its very early stages, but we can make it better with the community's help! If you have any ideas/improvements/bugs to share, be sure to file an issue in our GitHub repository.
What are some alternatives?
LocalStack - 💻 A fully functional local AWS cloud stack. Develop and test your cloud & Serverless apps offline
node-sql-template-strings - ES6 tagged template strings for prepared SQL statements 📋
safeql - Composable / async / functional / type-safe / parallel-pipelined queries and relations without SQL injection or N+1s.
icecream - Distributed compiler with a central scheduler to share build load
ctl - My variant of the C Template Library
todo-with-svelte - A basic demo example for integrating between Appwrite & Svelte🧡
compiler-benchmark - Benchmarks compilation speeds of different combinations of languages and compilers.
eslint-plugin-functional - ESLint rules to disable mutation and promote fp in JavaScript and TypeScript.
typescript-eslint - :sparkles: Monorepo for all the tooling which enables ESLint to support TypeScript
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
knip - ✂️ Find unused files, dependencies and exports in your JavaScript and TypeScript projects. Knip it before you ship it!