Database Drivers in Drupal: Modularization and Future Developments
Explore the rationale behind moving Drupal database drivers to separate modules and discuss future plans for enhancing database functionality and performance in Drupal.
JS-ON - Security-OFF - Abusing JSON-Based SQL Queries
Explore security risks in SQL databases with JSON features. Learn about potential vulnerabilities and hacking techniques for JSON-based queries in major database engines.
Driving the Future of PostgreSQL Adoption
Explore strategies for accelerating PostgreSQL adoption and shaping its future in the database landscape.
Run Postgres in a Docker Container - Easiest PostgreSQL Setup
Learn to run PostgreSQL in Docker, connect via pgAdmin and psql, integrate with Django, reset the database, and persist data using volumes for an efficient development setup.
Managing Cubase's MediaBay Databases for Advanced Users
Master Cubase's MediaBay database management with advanced techniques for organizing and optimizing your audio workflow using SQLite tools and practical database management strategies.
Create Local No-Code AI Agents with N8N and Ollama - A Step-by-Step Tutorial
Learn to build local AI agents using n8n and Ollama - create calculator, news search, and blog writer agents with PostgreSQL integration and no-code workflows in just 10 minutes.
High-Performance User-Space Protocol Stack: Balancing Performance and Generality
Discover how to build high-performance user-space protocol stacks using DPDK, achieving better performance while maintaining compatibility with applications like Redis and MySQL.
Database Schemas in the Wild - Learning from a Large Corpus of Relational Database Schemas
Explore the insights from GitSchemas, a vast collection of 150k+ database schemas extracted from SQL scripts, revealing patterns in real-world database design and constraints across 1M+ tables.
Atomic Honeypot - A MySQL Honeypot That Drops Shells
Discover how a weaponized MySQL honeypot server exploits vulnerabilities to counter-attack malicious clients, featuring innovative use of CVE-2023-21980 and CVE-2024-21096 for defensive security research.
Data Mesh for Instant Query - Why Trino on Data Mesh
Discover how modern data platforms are evolving from producer-centric to consumer-centric approaches, exploring Trino's role in data mesh architecture for efficient cross-platform data analysis and instant querying.
Indexed Streams - A Formal Intermediate Representation for Fused Contraction Programs
Explore a formal operational model for fused execution of contraction languages, covering sparse tensor and relational algebra. Learn about indexed streams and their compiler implementation.
Functional Programming in PostgreSQL - Lambda Days 2023
Explore functional pipelines in PostgreSQL using TimescaleDB toolkit, leveraging custom types and operators for powerful data analytics directly in SQL.
ElectricSQL - Local-first SQL with Elixir
Explore local-first development with ElectricSQL, a platform for reactive, realtime, multi-user sync using Postgres and SQLite, powered by Elixir's replication technology.
Multitenant Web Applications with Phoenix - ElixirConf EU 2023
Explore multitenancy implementation in Phoenix web applications using Ecto and PostgreSQL schemas for data encapsulation, with step-by-step examples and practical insights.
Go Concurrency Powering Gigabyte-Scale Real-World Data Pipeline
Explore Go concurrency techniques for building high-performance data pipelines, focusing on MongoDB to RDBMS migration and optimizing worker pools for gigabyte-scale data processing.
Billions of Records in MySQL: Lessons Learned
Explore strategies for managing billions of MySQL records, covering optimization, storage engines, schema design, and backup techniques for large-scale databases.
Scales and Guides: How to Visualize Anything
Visualize data effectively using scales and guides. Learn techniques for categorical, nominal, and ordinal data, plus explore parallel axis plots and scaling functions.
ChatGPT Experiment - Building with Unfamiliar Technology
Explore building a CRUD backend service using ChatGPT4, navigating unfamiliar technologies like TypeScript, Express, MySQL, and Docker for microservices development.
Pydantic Logfire - Uncomplicated Observability
Explore Logfire, a new observability platform from Pydantic's team. Learn how it simplifies app understanding and fixing through live demos and integrations with FastAPI, Postgres, and OpenAI.
Effortless Low-Code Data Testing for Enhanced Data Quality
Explore low-code solutions for efficient data testing, integrating methods into CI/CD frameworks and applying them to real-world scenarios to enhance data quality across various technologies.
Effortless Low-Code Data Testing for Enhanced Data Quality
Explore low-code solutions for efficient data testing. Learn to implement automated quality checks, integrate with CI/CD frameworks, and apply techniques across various data technologies for immediate organizational impact.