drizzle-orm
Pusher
drizzle-orm | Pusher | |
---|---|---|
48 | 13 | |
20,638 | 662 | |
4.5% | -0.2% | |
9.6 | 0.0 | |
4 days ago | 11 months ago | |
TypeScript | Ruby | |
Apache License 2.0 | 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.
drizzle-orm
-
A Software Engineer's Tips and Tricks #1: Drizzle
Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL β you know Drizzle.
-
Get started with Drizzle ORM and Xata's Postgres service
Drizzle ORM is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.
-
Shape Typing in Python
> being able to have a completely typesafe ORM such as Drizzle (https://orm.drizzle.team/) feels like a Rubicon moment, and touching anything else feels like a significant step backwards.
Alright, but there's nothing stopping you from having a completely typesafe ORM in python, is there?
Sure, there's isn't really one that everyone uses yet, but the python community tends to be a bit more cautious and slower to adopt big changes like that.
-
Don't use your ORM entities for everything β embrace the SQL
Drizzle [1] comes pretty close the last time I checked.
[1]: https://orm.drizzle.team
-
I Deployed My Own Cute Lilβ Private Internet (a.k.a. VPC)
Each appβs front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwikβs official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).
-
Exploring Astro DB
It's just SQL so you can take it out at any moment and move to any other DB provider. The package for working with Astro DB, @astrojs/db, includes Drizzle ORM so migration to a different provider should be relatively painless
- ORMs are nice but they are the wrong abstraction
- Drizzle TypeScript ORM
-
Basic analytics with Vercel Postgres, Drizzle & Astro
Since Vercel's analytics pricing is a bit too expensive for my use case (where I hit the limit of 2,500 requests per month), and I didn't like using Google Analytics (not a big fan of Google), I decided to build my own analytics dashboard. Databases was something I didn't work with much before directly, so I decided to use an ORM, Drizzle, which is quite lightweight and easy to use.
-
Edge Functions: Node and native NPM compatibility
do yourself a favor and ditch Prisma. It's a bloody mess of a project and codebase. I recommend https://github.com/drizzle-team/drizzle-orm to anyone that'll listen.
Pusher
-
The top real-time notification services for building in-app notifications
Pusher Channels is a real-time notifications service that empowers developers to swiftly integrate real-time functionality, like live notifications and chat, into web and mobile apps using WebSockets. Pusher is known for reliability and scalability and is used by Buffer, GitHub, and Datadog.
-
Database Review: Top Five Missing Features from Database APIs
Pusher
-
How do you do WebSocket connections when you're doing SSR?
Typically, you don't do websockets. There are some great products out there that give you the same capabilities. I recently started working with Pusher for my Remix applications and am loving it!
-
Is a Multiplayer Game Possible with NextJS + Vercel?
According to Vercel's website SocketIO is NOT supported, however Pusher Channels is recommended in it's place. Not sure what it is, but it supposedly is supported by vercel and potentially can help.
-
7 Useful JavaScript Libraries To Build a Real-Time Web App
Pusher is a hosted service that makes it super-easy to add real-time data and functionality to web and mobile applications. It sits as a real-time layer between your servers and your clients. Pusher maintains persistent connections to the clients β over WebSocket if possible and falling back to HTTP-based connectivity β so that as soon as your servers have new data that they want to push to the clients they can do, instantly via Pusher.
-
Need help implementing google maps
Then watchPosition from @react-native-community/geolocation is definitely the way to go. Here's a link to the example in their repo. This will constantly update the position state variable, which you can then send to a realtime service which other users are subscribed to and consuming. (Depending on your implementation, could be a websocket or some pub/sub service... I've worked with Pusher Channels before for something similar.)
-
Best way to add chatting into my web app?
An easy way to start with is to use external Pusher channels service It requires 0 devops and everything works very well, for free at least at the beginning. However, like any external service, it can't scale without paying. "Pay as you grow".
-
Tools for real-time stock app
I see that NextJS now recommends a pub/sub approach Vercel Support Your client will need to subscribe to the events from a 3rd party service like Pusher Channels and the Pub should be handled by a serverless function
-
Centrifugo β scalable real-time messaging server. Handles WebSocket, EventSource, GRPC, HTTP-streaming and SockJS connections, manages channel subscriptions. Provides API to publish messages into channels. Integrates well with any stack.
Centrifugo is very similar to pusher.com Channels product (https://pusher.com/channels) β but self-hosted. Also β somewhat similar to socket.io - but not a library, so can work with any backend. Centrifugo is pretty unique in terms of available features sum β so can't say that there is a direct analogue I've heard about - sth from one product, sth from another, sth unique. And of course there are alternatives which can do what Centrifugo can't since the market of real-time servers is quite big.
- What is the best 3rd party chat service for web PHP integration?
What are some alternatives?
kysely - A type-safe typescript SQL query builder
laravel-websockets - Websockets for Laravel. Done right.
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Socket.io - Realtime application framework (Node.JS server)
MikroORM - TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
Centrifugo - Scalable real-time messaging server in a language-agnostic way. Self-hosted alternative to Pubnub, Pusher, Ably. Set up once and forever.
knex-tree - Query hierarchical data structures in sql with knex
twilio-ruby - A Ruby gem for communicating with the Twilio API and generating TwiML
MongoDB - The MongoDB Database
Restforce - A Ruby client for the Salesforce REST API.
hono - Web Framework built on Web Standards
Xeroizer - Xero accounting system API library.