Database Optimization
Showing 34 of 34 projects
A Perl script that analyzes MySQL, MariaDB, and Percona Server configurations to provide performance and stability recommendations.
A comprehensive collection of PostgreSQL, Greenplum, and AI-related technical articles, tutorials, and learning resources.
A Ruby gem that detects N+1 queries, unused eager loading, and missing counter caches to improve application performance.
A collection of utilities, scripts, and views for managing, optimizing, and automating Amazon Redshift data warehouse operations.
A Rails gem providing advanced, flexible counter caches that update on value changes and support multi-level relations.
An automatic indexer for Postgres that analyzes query patterns and suggests optimal indexes to improve database performance.
A blob-level read-through caching solution for ActiveRecord that adds fetch methods to cache model objects and associations using Memcached.
A Laravel package for generating RFC 4122-compliant UUIDs with optimized performance and seamless Eloquent integration.
A Redis query analyzer that parses MONITOR output to provide statistics on key patterns, command frequency, and timing metrics.
A MySQL 5.5 fork maintained by Twitter with performance optimizations for NUMA, SSDs, and production monitoring.
A Ruby gem that automatically eager loads ActiveRecord associations to prevent N+1 queries without manual configuration.
A PostgreSQL extension that enables creation and testing of hypothetical indexes without actually building them.
A Ruby gem that scans Rails models to suggest missing database indexes and generates SQL migration scripts.
A collection of advanced command-line tools for MySQL database administration, maintenance, and optimization.
A command-line tool for easy PostgreSQL table partitioning with zero downtime and minimal app changes.
An Eloquent trait for Laravel that adds query caching with a simple remember() method.
A Ruby gem providing a generic lazy batching mechanism to avoid N+1 database queries and HTTP requests.
An ActiveRecord extension for efficiently inserting large datasets via single SQL statements in Ruby on Rails.
A PostgreSQL extension that automatically removes table bloat and optionally sorts tuples by an index, using background workers and logical decoding.
A PostgreSQL extension that compresses JSONB data using a shared dictionary of frequent strings, saving disk space and memory.
A high-performance Java library for compressing arrays of integers, optimized for databases and information retrieval.
Efficiently find next/previous ActiveRecord records using keyset pagination in a single query.
Official Python library for generating short, unique, URL-safe IDs from numbers.
A Java library providing geohash encoding, decoding, and bounding box utilities for efficient location-based queries.
A write-through and read-through caching library for ActiveRecord 4-6, inspired by Cache Money and cache_fu.
A Redis-based oplog implementation for Meteor that replaces MongoDB's oplog to enable scalable reactive applications.
A Prisma middleware for caching database queries in Redis with in-memory fallback and cache invalidation.
A Heroku buildpack that installs and runs PgBouncer in a dyno alongside your app for PostgreSQL connection pooling.
An embedded persistent key-value store optimized for blockchain applications, designed for efficient Patricia-Merkle trie storage.
Store up to 64 boolean flags in a single integer column with ActiveRecord using bit arrays.
A Ruby gem providing ActiveRecord batch methods for plucking columns, reducing SQL queries and memory usage by up to 50%.
A Magento 2 module that provides commands to analyze and clean up unused, missing, and duplicated catalog media files.
A high-performance, cryptographically secure UUID/GUID generator for Go, optimized for databases and up to 10x faster than google/uuid.
Separates read and write operations across multiple Ecto repositories for database replication setups.
Related Tags
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.