pgtyped
amplication
Our great sponsors
pgtyped | amplication | |
---|---|---|
34 | 148 | |
2,762 | 13,240 | |
- | 1.3% | |
8.7 | 10.0 | |
3 days ago | 1 day ago | |
TypeScript | TypeScript | |
MIT License | GNU General Public License v3.0 or later |
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.
pgtyped
-
Type-Safe Printf() in TypeScript
There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql
There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped
To me the second approach seems much more pragmatic because you donβt need to run a SQL parser in a fairly potato interpreter on every build
-
ORMs are nice but they are the wrong abstraction
ORMs suck, but raw SQL embedded in your code sucks too.
This might be good time to plug my TypeScript non-ORM: https://jawj.github.io/zapatos/.
I should say I also like what I've seen of https://kysely.dev/ and https://pgtyped.dev/.
-
An effective way to build a heavy CRUD Rest API?
Thank you for suggestions they helped me finding what I was looking for. I will either pick kysely or https://pgtyped.dev/, but first I will do some tests. Thanks!
-
PostgresJs: The Fastest full featured PostgreSQL client for Node.js and Deno
Perhaps not as featured as OPβs but Iβve found https://pgtyped.dev/ useful. Queries are written as SQL files, and pgtyped creates typed functions you call with query parameters.
-
compile-time SQL validations and type generation in TypeScript & Node
Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?
-
Deno 1.33: Deno 2 is coming
There's pgtyped, which I believe does almost the same as sqlc
-
Kysely: TypeScript SQL Query Builder
For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?
You might also want to consider pgTyped (https://github.com/adelsz/pgtyped). It's supposed to make SQL and TS work together. I haven't gotten around to using it yet but I hear good things.
-
This package is so underrated.
I would highly recommend trying out pgTyped if you want typesafe queries with postgres. It's fantastic!
amplication
-
Creating a Restaurant Finder Application Using ReactJS and Amplication
Go to https://amplication.com.
-
Extending GitOps: Effortless continuous integration and deployment on Kubernetes
The application used in this demonstration was generated through Amplication, which allows you to generate production-ready backend services - reliably, securely, and consistently.
-
Auth0 and Amplication: Simplifying Authentication in Your Applications
Setting up Auth0 authentication in your Amplication application is easy. You can use the Auth0 plugin to add the required dependencies and configuration files to your application. The steps are as follows:
-
Top 6 ORMs for Modern Node.js App Development
In addition, Prisma is supported by microservice code generation tools like Amplication. Prisma plugs directly into the code generated by Amplication. By doing so, you can utilize Prisma as an ORM layer for your databases and generate microservice code with ease in just a few clicks.
-
Celebrating Hacktoberfest 2023 with Amplication
We've prepped dozens of issues spanning various domains like bug fixes, UI/UX improvements, documentation enhancements, and more.
-
βοΈ Full Stack Amazon Clone with Next.js, Typescript, Tailwind CSS, Zustand, Next UI, Recharts and Amplication π
Amplication, is a powerful open-source backend development tool engineered to streamline and accelerate web application creation. It offers a user-friendly interface and a comprehensive feature set, making it a valuable resource for developers and organizations aiming to swiftly develop robust, scalable applications while conserving time and resources.
β Give Amplication a Star! β
-
Distributed Tracing and OpenTelemetry Guide
In this example, I will create 3 Node.js services (shipping, notification, and courier) using Amplication, add traces to all services, and show how to analyze trace data using Jaeger.
-
Understanding and Preventing Memory Leaks in Node.js
Amplication lets you auto-generate Node.js code for your microservices, enabling you to build high-quality apps with high-quality code that take extra precautions for the issues discussed above to ensure that your app will not cause any memory leaks (well, at least not in the boilerplate code we generate. The rest... is up to you π).
-
How to Effectively Use Caching to Improve Microservices Performance
If you're eager to explore microservices architecture and seeking an excellent entry point, consider Amplication. Amplication is an open-source, user-friendly backend generation platform that simplifies the process of crafting resilient and scalable microservices applications 20x faster. With a large and growing library of plugins, you have the freedom to use exactly the tools and technologies you need for each of your microservices.
What are some alternatives?
Strapi - π Strapi is the leading open-source headless CMS. Itβs 100% JavaScript/TypeScript, fully customizable and developer-first.
Appwrite - Build like a team of hundreds_
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
kysely - A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely]
nestjs-localization - Nestjs localization provides a convenient way to retrieve strings in various languages, allowing you to easily support multiple languages within your application.
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.
prisma-dbml-generator - Prisma DBML Generator
nest-keycloak-connect - keycloak-nodejs-connect module for Nest
ledokku - Beautiful web UI for all things Dokku
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
typesafe-query-builder - Generate SQL queries leveraging type inference and Postgres Json functions
nestjs - A collection of badass modules and utilities to help you level up your NestJS applications π