PostgreSQL
Redis
Our great sponsors
PostgreSQL | Redis | |
---|---|---|
404 | 14 | |
14,619 | 13,845 | |
3.1% | 7.0% | |
9.9 | 3.4 | |
5 days ago | 2 days ago | |
C | TypeScript | |
GNU General Public License v3.0 or later | 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.
PostgreSQL
-
Understanding SQL vs. NoSQL Databases: A Beginner's Guide
SQL (Structured Query Language) databases are relational databases. They organize data into tables with rows and columns, and they use SQL for querying and managing data. Examples include MySQL, PostgreSQL, and SQLite.
-
From zero to hero: using SQL databases in Node.js made easy
Node.js, MySQL and PostgreSQL servers installed on your machine
-
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).
-
How to dump and restore a Postgres DB with new table ownership
I've used MySQL for years. But recently, I found myself working PostgreSQL and simple things like dumping and restoring a database are different enough that I decided to document the process. It's straightforward enough once I knew how.
-
Test Driving a Rails API - Part One
A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:
-
Um júnior e um teste técnico: The battle.
PostgreSQL
-
How to choose the right type of database
PostgreSQL: Offers a robust feature set and strong compliance with SQL standards, making it suitable for a wide range of applications, from simple to complex, particularly where data integrity and extensibility are key.
-
NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB
FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.
-
Preventing SQL injection attacks in Node.js
To better understand how SQL injection works, let's quickly create a vulnerable app using Node.js, Express, and a PostgreSQL database. The application takes user input from a form, constructs a SQL query, and executes it against the database to fetch some data.
-
Full Stack Chat App with Socket.io
We'll use PostgreSQL, and first of all, you need to install PostgreSQL if you haven't installed it yet. https://www.postgresql.org/
Redis
- Is `ioredis` still actively maintained?
-
Crafting A Minimalist Portfolio Website with SvelteKit and Pico CSS
To make data retrieval efficient and minimize the need to request data from the API on every page load, I implemented a caching strategy using the ioredis package, which is a popular redis client for Node.js for interacting with a Redis database.
-
10 Powerful Node.js Libraries Every Developer Should Know About
5. ioredis
-
Unable to properly connect to Redis in Kubernetes
These are the objects I pass to ioredis to create my Redis instances (one for sessions and one as the main one):
-
Help implementing Heroku Data For Redis (+bull & throng) / `ioredis`
In order to try and mitigate the OOMs. I read the Background Jobs in Node.JS with Redis blog post and implemented Heroku Data For Redis with ioredis, BullMQ and Throng,
-
Message Queue in Redis, Part 2
Redis.Redis and Redis.Cluster at the end of the rule actually refer to the ioredis constructors, so to set them up, we must use the ioredis constructors.
-
MOVED error with Redis cluster
ioredis is a popular Node.js client, providing a robust support for Redis Cluster.
-
How to use Redis Cluster for caching
To connect to Redis from your application, you will need a library that can perform that for you (Otherwise you have to reinvent the wheel). While I've been using IORedis for a nodeJS application in this demo, if you have been using a different language, you will have to look for different connectors like Lettuce for Java or perhaps go-redis for Go.
-
Using Redis Pub/Sub with Node.js
The Redis client I'm going to use today is ioredis, because its API is intuitive, very robust and with good performance.
-
Redis configuration in nestjs
Just create your own wrapper service around one of the existing nodejs redis clients, I used the following client https://github.com/luin/ioredis
What are some alternatives?
psycopg2 - PostgreSQL database adapter for the Python programming language
Redis - Redis is an in-memory database that persists on disk. The data model is key-value, but many different kind of values are supported: Strings, Lists, Sets, Sorted Sets, Hashes, Streams, HyperLogLogs, Bitmaps.
ClickHouse - ClickHouse® is a free analytics DBMS for big data
node-redis - A high-performance Node.js Redis client. [Moved to: https://github.com/redis/node-redis]
phpMyAdmin - A web interface for MySQL and MariaDB
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Firebird - FB/Java plugin for Firebird
bull - Premium Queue package for handling distributed jobs and messages in NodeJS.
Adminer - Database management in a single PHP file
MongoDB - The Official MongoDB Node.js Driver
SQLAlchemy - The Database Toolkit for Python
uuid - Generate RFC-compliant UUIDs in JavaScript