Identifying Slow Queries and Fixing Them in PostgreSQL
Optimize PostgreSQL performance by identifying and fixing slow queries through configuration, monitoring, and query analysis techniques.
Row Level Security Explained - Performance and Application in PostgreSQL
Explore PostgreSQL's Row-Level Security: functionality, use cases, and implementation. Learn about leakproof functions and performance optimization techniques.
Advanced Int-Bigint Conversions in PostgreSQL - Preventing Integer Overflow
Explore advanced techniques for handling integer overflow in databases, including prevention strategies and solutions for pending int overflow issues.
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.
aC the World! As-Code for Anything - PowerShell Summit 2022
Explore "as-Code" concepts for PowerShell, learning to leverage existing tools and apply core principles to solve real-world problems using JSON, YAML, and more.
Service Denied! Understanding How Regex DoS Attacks Work - Lecture
Explore regex DoS attacks in Rails, understand their mechanics, and learn defensive strategies to protect your application from malicious input.
Call Me Back, Postgres - Using Triggers and Notifications in Rails
Explore Postgres triggers as an alternative to Active Record callbacks, leveraging listen and notify features for seamless data syncing in Rails applications.
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.
Code Generation from API Swagger YAML Schema to PowerShell Module - 4 Easy Steps
Generate PowerShell modules from API Swagger YAML schemas in four simple steps, enhancing automation and streamlining development processes.
The Very Hungry Transaction - Avoiding Dangerous Patterns in Database Transactions
Explore database transaction pitfalls and best practices to safeguard data integrity and application performance in Rails applications.
This or That? Similar Methods and Classes in Ruby and Rails
Explore similar patterns, classes, and methods in Ruby and Rails to make informed coding decisions and optimize your development process.
Data Warehouses are Gilded Cages - What Comes Next
Explore DuckDB's potential to revolutionize data analytics, shifting from centralized warehouses to powerful local processing. Learn how this approach can enhance efficiency and user control in data management.
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.
How to Build a Streaming Database in Three Challenging Steps
Explore the foundational choices and trade-offs in building a streaming database with Frank McSherry, Chief Scientist at Materialize. Learn manageable approaches to this complex task.
Cubing and Metrics in SQL - Extending Apache Calcite for Advanced Analytics
Explore Apache Calcite's SQL extensions for metrics, measures, and analytic expressions. Learn to define data models, use them in queries, and perform cross-dimensional calculations for advanced analytics.
Building an Open Data Service Layer with Arrow, DuckDB and Semantic Layer
Explore FlexQuery, an open-source solution revolutionizing data services with Arrow, DuckDB, and semantic layers. Learn to create high-performance, scalable analytics environments using Python and cutting-edge technologies.
Building a Unified Feature Platform with DuckDB and Arrow
Explore ML feature platform development using DuckDB and Arrow. Learn scaling strategies, DuckDB extension implementation, DeltaLake interoperability, and performance comparison with Spark.
Flappybird Game and Real-Time Data Pipeline Workshop - Tinybird
Build a real-time data pipeline for Flappybird's leaderboard. Capture in-game events, stream data, and create REST APIs while enhancing SQL skills in this hands-on workshop.
Building a GraphQL API - Beyond the Basics
Explore advanced GraphQL API development in Drupal, covering schema design, operations implementation, and modular API construction for enhanced usability and functionality.
Great New Features of Drupal Gutenberg Editor and Proper Snacks for Developers
Explore new Drupal Gutenberg features: patterns, theme control, visual enhancements, and dynamic blocks. Learn best practices for custom blocks and structured content retrieval.
Blending the Gap: Mixing MATLAB with Julia
Explore seamless integration of MATLAB and Julia, enabling transparent function calls and data structure access between the two languages without complex syntax or APIs.