Do It in SQL: pgbouncer_wrapper - Controlling pgbouncer with SQL Commands
Learn to control pgbouncer with SQL commands using pgbouncer_wrapper. Explore its capabilities, get inspired, and contribute to its improvement.
You Have 2 Seconds to Respond - Atob
Explore techniques for optimizing Rails application response times, focusing on rapid user interactions and performance enhancements.
Puny to Powerful PostgreSQL Rails Apps - Scaling Challenges and Solutions
Scale Rails apps on PostgreSQL: Learn safe migrations, query optimization, database maintenance, replication, and partitioning for improved performance.
PowerShell with SQL Statement Data Gathering - PowerShell Summit 2023
Explore SQL data gathering techniques in PowerShell to enhance your scripting capabilities and streamline database interactions.
Taylor's Guide to Big Rewrites - Lessons from a Successful Application Migration
Learn strategies for successful large-scale application rewrites, drawing insights from Taylorism and a real-world case study of migrating 2,500 customers' data over 18 months.
Beyond CRUD: PostgreSQL Techniques Your Rails App Is Missing
Explore advanced PostgreSQL techniques for Rails apps, including locking mechanisms and mutex, to enhance scalability and prevent production outages.
Migrating Shopify's Core Rails Monolith to Trilogy
Explore Shopify's migration from Mysql2 to Trilogy, covering MySQL protocols, Active Record adapters, and open source contributions. Learn about implementation challenges and production impact.
ActiveRecord::Encryption - Stop Hackers from Reading Your Data
Learn to encrypt data in Rails applications using ActiveRecord::Encryption. Explore implementation strategies, potential pitfalls, and real-world successes from GitHub's experience.
Using Postgres and OpenAI to Power Your AI Recommendation Engine - RailsConf 2024
Discover how to build and optimize an AI recommendation engine using Rails, Postgres, and OpenAI. Learn scaling techniques for handling unique AI data needs.
The Very Hungry Transaction - Avoiding Risky Database Patterns
Explore how database transactions grow into liabilities, uncover problematic patterns, and learn strategies to maintain data integrity and database health.
Scaling Uber's Metric System from Elasticsearch to Apache Pinot
Explore Uber's journey in scaling their metric system, transitioning from Elasticsearch to Apache Pinot for improved reliability and performance in real-time data processing.
CDC Stream Processing with Apache Flink
Explore Apache Flink's capabilities as a data integration hub, focusing on its SQL engine for changelog processing, CDC data handling, and materialized view maintenance. Learn about data source semantics and system integrations.
Ten Years of Building Open Source Standards: From Parquet to Arrow to OpenLineage
Explore the journey of building open-source data standards, from Apache Parquet to Arrow to OpenLineage. Gain insights into successful project ideation, growth, and ecosystem impact in data management.
Pushing Drupal Development Limits - 22 Million Products and 1 Million Daily Updates
Explore scaling Drupal Commerce to handle 22 million products and 1 million daily updates across multiple sites. Learn unique solutions for large-scale e-commerce development.
Performance Audits - The Top 8 Problems We Find and How to Fix Them
Discover the 8 most common performance issues in web development and learn effective strategies to resolve them for optimal site speed and user experience.
Performance Audits: The Top 8 Problems in Drupal and How to Fix Them
Discover top Drupal performance issues and their solutions. Learn quick wins and architectural improvements from leading experts to optimize your site's speed and efficiency.
Successful Migrations - A Strategic Framework for Planning and Estimating Drupal Migrations
Develop a strategic framework for planning and estimating Drupal migrations, ensuring successful transitions and optimal outcomes.
Migration for Mortals - Content Migration for Non-Technical Folks
Discover practical strategies for content migration, tailored for non-technical individuals. Learn efficient techniques to streamline the process and ensure successful data transfer.
Spring Data JPA: Persisting and Managing Java Objects in Relational Databases
Master Spring Data JPA to efficiently persist, read, and manage data between Java objects and relational databases. Learn standardized interfaces for seamless data operations.
Basics of SQL Queries and Query Optimization
Master SQL fundamentals and query optimization techniques for efficient database management and manipulation across various relational database management systems.
Introduction to Liquibase
Learn the basics of Liquibase, an open-source tool for managing database schema changes. Explore its usage, advantages, and how it tracks and applies updates across different database systems.