RedisJSON - a JSON data type for Redis
RedisJSON is a Redis module that implements ECMA-404 The JSON Data Interchange Standard as a native data type. It allows storing, updating and fetching JSON values from Redis keys (documents).
Primary features:
- Full support of the JSON standard
- JSONPath -like syntax for selecting elements inside documents
- Documents are stored as binary data in a tree structure, allowing fast access to sub-elements
- Typed atomic operations for all JSON values types
RediSearch - Redis Secondary Index & Query Engine
RediSearch is a source available Secondary Index, Query Engine and Full-Text Search over Redis, developed by Redis .
Redisearch implements a secondary index on top of Redis, but unlike other Redis indexing libraries, it does not use internal data structures such as sorted sets.
This also enables more advanced features, such as multi-field queries, aggregation, and full text search capabilites. These capabilities include exact phrase matching and numeric filtering for text queries, something that is neither possible or efficient with traditional Redis indexing approaches.
Prisma is a next-generation ORM that consists of these tools:
- Prisma Client: Auto-generated and type-safe query builder for Node.js & TypeScript
- Prisma Migrate: Declarative data modeling & migration system
- Prisma Studio: GUI to view and edit data in your database
Prisma Client can be used in any Node.js or TypeScript backend application (including serverless applications and microservices). This can be a REST API, a GraphQL API a gRPC API, or anything else that needs a database.
Postgres Explain Visualizer is designed to make EXPLAIN output easier to grok. It creates a graphical representation of the plan. You can see it in action at https://tatiyants.com/pev
The Internals of PostgreSQL, with :
- Chapter 1. Database Cluster, Databases and Tables
- Chapter 2. Process and Memory Architecture
- Chapter 3. Query Processing
- Chapter 4. Foreign Data Wrappers (FDW) and Parallel Query
- Chapter 5. Concurrency Control
- Chapter 6. VACUUM Processing
- Chapter 7. Heap Only Tuple (HOT) and Index-Only Scans
- Chapter 8. Buffer Manager
- Chapter 9. Write Ahead Logging (WAL)
- Chapter 10. Base Backup and Point-In-Time Recovery (PITR)
- Chapter 11. Streaming Replication
A scalable, distributed, collaborative, document-graph database, for the realtime web