How to Set Up Prisma with NeonDB for Your AI-Powered SaaS
Learn to integrate Prisma ORM with NeonDB for efficient database management in AI-powered SaaS applications. Covers model definition, schema migration, and API creation for seamless data handling.
Don't Make These 10 SQL Mistakes
Avoid common SQL pitfalls: optimize queries, prevent injections, design efficient tables, handle NULL values, use transactions, and understand joins for better database performance.
Creating an Autonomous AI App with AutoRAG and PhiData
Learn to build an AutoRAG system with PhiData, enhancing AI's decision-making for relevant responses. Covers setup, knowledge base creation, querying, and UI development for improved AI interaction.
Querying RDS PostgreSQL from AWS Lambda in Java
Connect AWS Lambda to RDS PostgreSQL using Java: Learn to build serverless functions, query databases, and return results efficiently in this hands-on tutorial.
Geospatial Validations Using FastAPI and PostGIS
Explore geospatial data integration in web apps using PostGIS and FastAPI. Learn fundamentals, leverage PostgreSQL extension, and implement custom validations for efficient backend development.
Auditing Your Data and Answering the Question - Is It the End of the Day Yet?
Explore Nielsen's data auditing system design, from tracking to analysis, using Kafka, Avro, Spark, and more. Learn about metadata design, table optimization, and alert-based monitoring for robust data management.
Exploring the New World - Remote Exploitation of SQLite and Curl
Discover new methods for finding vulnerabilities in SQLite and Curl through fuzzing and manual auditing, including insights on "Magellan" and "Dias" vulnerabilities.
How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of
Explore how modern SQL databases use advanced optimization techniques to outperform hand-written algorithms, making SQL the ideal language for complex data retrieval and business logic.
Amazing Features from PostgreSQL
Discover PostgreSQL's powerful features to simplify complex database problems, explore useful SQL tricks, and learn about various PostgreSQL distributions for on-premises and cloud deployments.
Industry-Leading Availability and Performance for MySQL Workloads on Cloud SQL
Optimize MySQL workloads with Cloud SQL's enhanced availability, performance, and management capabilities for enterprise-grade applications.
JOOQ - Joy of SQL
Explore advanced SQL techniques with JOOQ for efficient database interactions. Learn to write powerful, type-safe queries and unlock the full potential of your database.
A Postgres Compatible DB on Kubernetes - YugabyteDB
Install and explore YugabyteDB, an open-source distributed SQL database compatible with PostgreSQL, on Kubernetes. Learn about data sharding, replication, and geo-distribution for high availability and low latency.
Dungeons, Dragons, and Graph Databases
Explore graph databases through a D&D lens. Learn how to model complex relationships, write efficient queries, and optimize your dungeon crawl using this powerful database technology.
Removing Complexity from Integration Tests Using Testcontainers
Simplify integration testing for microservices using Testcontainers. Learn to create isolated, Docker-based environments for databases and services, enhancing test reliability and ease of implementation.
Anatomy of a Distributed SQL Database - YugabyteDB
Explore YugabyteDB's architecture, combining PostgreSQL features with distributed technologies for horizontal scaling and cloud-native performance. Learn about consensus protocols, sharding, and modern storage techniques.
Doctolib Needs a Bigger Database - Ok, But Which One?
Explore Doctolib's journey to scale their massive PostgreSQL database, evaluating solutions like Spanner, Yugabyte, and Citus to support business growth and handle millions of medical appointment bookings.
Aggregating Data in Django Using Database Views
Aprenda a agregar datos en Django usando vistas de base de datos con django-pgviews-redux. Simplifique consultas complejas, mejore el rendimiento y aproveche las características de los modelos de Django.
Streaming CDC Data from PostgreSQL to Snowflake - Challenges and Solutions
Uncover streaming ETL secrets: Postgres to Snowflake data ingestion, change data capture, dynamic tables, and Snowpipe streaming. Learn solutions for lower latency, cost savings, and enhanced scalability.
Let's Build Event Store in One Hour
Learn to build an event store using a relational database, exploring Event Sourcing concepts like storing events, state retrieval, and read models. Gain practical insights into DDD and CQRS implementation.
Practical Domain-Driven Design with EF Core
Learn to apply Domain-Driven Design principles with EF Core, focusing on tactical patterns and crafting cohesive domain models for both new and existing projects without compromising your design.
Where's My Stuff? Exploring Data Storage Options in Azure
Explore Azure data storage options, including relational, NoSQL, and Azure Storage. Learn pros, cons, and tradeoffs while converting a real app to leverage cloud storage patterns.