safeql
node-starter-kit
safeql | node-starter-kit | |
---|---|---|
8 | 13 | |
1,224 | 155 | |
1.0% | 5.2% | |
5.6 | 1.8 | |
7 days ago | almost 3 years ago | |
TypeScript | TypeScript | |
MIT License | 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.
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.
node-starter-kit
- Good Examples of Testing in an Open Source Repo?
- Ask HN: Who wants to be hired? (June 2021)
-
Preparing a project, and a tehnologies stack
Here is link number 1 - Previous text "API"
-
How do you deploy your NodeJS APIs?
I'm deploying by either manually by running yarn deploy script or firing it via GitHub Actions when a PR is created, updated, or merged to the main branch.
- Node or serverless for my app?
-
Minimal Node.js boilerplate with Prettier and ESlint
Example: github.com/kriasoft/node-starter-kit
-
Any Laravel Eloquent like ORM for node.js?
Nope. Just plain GraphQL.js + Knex.js (example), often typed manually since it's not where most of the time spend on when building an API server (though it can be automated via a scaffolding script if there are too many db tables). Generating TypeScript definitions off the actual db schema using knex-types (example).
-
What is new with node.js world?
Examples: - https://github.com/kriasoft/node-starter-kit - basic Node.js API starter kit - https://github.com/kriasoft/graphql-starter - monorepo template with GraphQL, React, Relay
-
Ask HN: Who wants to be hired? (May 2021)
I can help you developing a (GraphQL API) server for your web and/or mobile app as well as CI/CD workflows, optimized for serverless infrastructure in Google Cloud Platform. The initial version (first iteration) will be ready and live in under three days! Code examples:
https://github.com/kriasoft/node-starter-kit
-
NodeJs Best practices
You may want to browse through https://github.com/kriasoft/node-starter-kit to pick up some common patterns (e.g. transactional emails, OAuth 2.0 authentication, user sessions, views, db migrations, etc.).
What are some alternatives?
node-sql-template-strings - ES6 tagged template strings for prepared SQL statements 📋
nestjs-bff - A full-stack TypeScript solution, and starter project. Includes an API, CLI, and example client webapp. Features include production grade logging, authorization, authentication, MongoDB migrations, and end-to-end testing.
slowpokefs - Fuse driver to simulate slow disk IO for testing purposes
express-typescript-boilerplate - A delightful way to building a RESTful API with NodeJs & TypeScript by @w3tecch
icecream - Distributed compiler with a central scheduler to share build load
cloudbeaver - Cloud Database Manager
eslint-plugin-functional - ESLint rules to disable mutation and promote fp in JavaScript and TypeScript.
react-native-typescript-boilerplate - React Native Typescript starter kit / template (Redux Thunk + React Native Navigation v7)
todo-with-svelte - A basic demo example for integrating between Appwrite & Svelte🧡
starter-reactjs-nestjs-mysql - Starter React.js NestJS MySQL with continuous integration and AWS deployment
typescript-eslint - :sparkles: Monorepo for all the tooling which enables ESLint to support TypeScript
tinyws - 🚡 tiny WebSocket middleware for Node.js