Database Optimization
Showing 36 of 40 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 PostgreSQL extension that enables creation and testing of hypothetical indexes without actually building them.
A Ruby gem that automatically eager loads ActiveRecord associations to prevent N+1 queries without manual configuration.
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.
A Rails gem for managing tags using PostgreSQL array columns with efficient querying and tag cloud strategies.
An ActiveRecord module for Ruby on Rails that skips specific columns by default and loads them on-demand.
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.