safeql
postgres_lsp
| safeql | postgres_lsp | |
|---|---|---|
| 8 | 6 | |
| 1,224 | 3,132 | |
| 1.0% | 0.6% | |
| 5.6 | 9.2 | |
| 8 days ago | 23 days ago | |
| TypeScript | Rust | |
| 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.
postgres_lsp
-
We built our customer data warehouse all on Postgres
Thank you for turning me on top Cornucopia, it looks awesome. I've used the very similar aiosql in Python, but I hadn't realized there was a Rust analog.
To tell the truth I've been waiting for postgres_lsp to mature before trying it out, but based on this example [1] I think it does support multiple queries.
Since it uses a parser extracted from Postgres, the nonstandard syntax would probably trip it up, but there's probably a way to fix that.
[1] https://github.com/supabase/postgres_lsp/blob/main/example/f...
-
compile-time SQL validations and type generation in TypeScript & Node
Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?
-
Supabase Local Dev: migrations, branching, and observability
While code editors have great support for most programming languages, SQL support is underwhelming. We want to make Postgres as simple as Python. Our recently announced Postgres Language Server takes us a step in that direction - eventually it will provide first-class support for Postgres in your favorite code editor including Linting, Syntax Highlighting, Migrations Parsing, SQL Auto-complete, and Intellisense.
-
Hugging Face is now supported in Supabase
Postgres Language Server
- Show HN: Postgres Language Server
What are some alternatives?
node-sql-template-strings - ES6 tagged template strings for prepared SQL statements 📋
pspg - Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
slowpokefs - Fuse driver to simulate slow disk IO for testing purposes
edge-runtime - A server based on Deno runtime, capable of running JavaScript, TypeScript, and WASM services.
icecream - Distributed compiler with a central scheduler to share build load
vecs - Postgres/pgvector Python Client
eslint-plugin-functional - ESLint rules to disable mutation and promote fp in JavaScript and TypeScript.
basejump - Teams, personal accounts, permissions and billing for your Supabase app
todo-with-svelte - A basic demo example for integrating between Appwrite & Svelte🧡
declarative-schemas
typescript-eslint - :sparkles: Monorepo for all the tooling which enables ESLint to support TypeScript
supabase-test-helpers - Test helpers for pgTAP and Supabase