safeql
Appwrite
safeql | Appwrite | |
---|---|---|
8 | 581 | |
1,232 | 41,134 | |
1.0% | 1.4% | |
5.6 | 10.0 | |
1 day ago | 4 days ago | |
TypeScript | TypeScript | |
MIT License | BSD 3-clause "New" or "Revised" 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.
Appwrite
-
How I use Appwrite Databases with Pinia to build my own habit tracker
If you haven't tried Appwrite, make sure you give it a spin. It's a open source backend that packs authentication, databases, storage, serverless functions, and all kinds of utilities in a neat API. Appwrite can be self-hosted, or you can use Appwrite Cloud starting with a generous free plan.
-
Exploring Appwrite: A Comprehensive Guide
What is Appwrite? Appwrite is an open-source backend server that abstracts the complexity of backend development, allowing developers to focus on building their applications. It provides a wide range of services including databases, storage, functions, and authentication, all designed to work seamlessly together. This integration simplifies the development process, reducing the need for extensive configuration and integration work.
-
11 Planetscale alternatives with free tiers
Appwrite is an open source BaaS platform that provides services like serverless functions, serverless databases, user authentication, and messaging. Since its release, it has quickly become a popular choice for building websites and applications.
-
Biometric authentication with Passkeys
Appwrite for user management, databases, and serverless functions
- Appwrite
-
100+ FREE Resources Every Web Developer Must Try
Appwrite: Open-source backend server for web and mobile developers.
-
The 2024 Web Hosting Report
Today, this ecosystem is going strong with new providers like Hasura, AppWrite and Supabase powering millions of projects. There are a few reasons people choose this style of hosting, especially if they are more comfortable with frontend development. BaaS lets them set up a database in a secure way, expose some business logic on top of the data, and connect via a dev-friendly SDK from their app or website code to save data easily. These modern tools build a blend of managed database with curated plugins such as authentication, great admin dashboards, and function as a service type capability - all in one package, and often offered as a integrated hosted service.
-
Why would you use Backend as a Service (BaaS)?
View on GitHub
-
2024 Web Development Wish List
Joins - see Future of Queries - MariaDB supports json joins, so definitely possible!
-
Show HN: Mutable.ai – Turn your codebase into a Wiki
Wow, looks nice! I almost felt like I could understand Bitcoins code xD
Could you do Appwrite? https://github.com/appwrite/appwrite
I'm not affiliated to them, just wanted to get started hacking it.
What are some alternatives?
node-sql-template-strings - ES6 tagged template strings for prepared SQL statements 📋
supabase - The open source Firebase alternative.
slowpokefs - Fuse driver to simulate slow disk IO for testing purposes
Strapi - 🚀 Strapi is the leading open-source headless CMS. It’s 100% JavaScript/TypeScript, fully customizable and developer-first.
icecream - Distributed compiler with a central scheduler to share build load
pocketbase - Open Source realtime backend in 1 file
eslint-plugin-functional - ESLint rules to disable mutation and promote fp in JavaScript and TypeScript.
nhost - The Open Source Firebase Alternative with GraphQL.
todo-with-svelte - A basic demo example for integrating between Appwrite & Svelte🧡
Directus - The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
typescript-eslint - :sparkles: Monorepo for all the tooling which enables ESLint to support TypeScript
parse-server - Parse Server for Node.js / Express