Medium7h agoHow to Model Relationships in NoSQL Databases
This piece details the considerations for modeling relationships after transitioning from SQL to NoSQL databases.
Medium7h ago
Medium4h agoVector Embeddings vs. Traditional Databases: What’s the Difference?
The article explains the differences between vector embeddings and traditional databases in terms of matching and retrieving data.
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT
This piece addresses a database error that occurs when installing a plugin related to AUTO_INCREMENT settings.
Medium7h agoThe Database Migration Took 400ms in Staging and Locked Production for 11 Minutes
The article discusses a database migration issue that caused significant downtime in production due to a simple SQL query.
Medium6h agoPostgreSQL EXPLAIN ANALYZE: How to Find Why Your Query Is Actually Slow
The article explains how to analyze query performance in PostgreSQL using the EXPLAIN ANALYZE command.
Medium7h agoYour REST API Is Returning Too Much Data. The Database Is Paying for Every Field.
This article critiques a REST API for returning excessive data, highlighting cost implications for database fields.
Medium6h agoWe Added Redis to Make the System Faster. Then the Cache Became the Architecture.
Caching reduced database traffic and improved latency.
# Subqueries & CTEs: Two Ways to Query Inside a Query
The piece discusses the use of subqueries and Common Table Expressions (CTEs) in SQL for querying data.
The Database Playground: Everything You Can Plug In and Tune in PostgreSQL and MySQL (Including AI Workloads)
This article provides insights on tuning PostgreSQL and MySQL for various workloads.
Medium10h ago@Cacheable Looks Done in Five Minutes. Redis Will Argue in Production
The article discusses how @Cacheable from Spring Boot can be effectively utilized in production environments with Redis.
PostgreSQL vs MySQL: 7 syntax differences that break migrations
It outlines significant syntax differences that can disrupt the migration from MySQL to PostgreSQL.
Medium13h agoWhat Actually Goes Wrong Without Transactions — And How Databases Fix It
The article outlines the importance of transactions in databases and how they prevent data integrity issues.
Medium9h ago#Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes
The article discusses benchmarking different types of indexes for data-intensive applications using Django and PostgreSQL.
Medium3h agoUnlearning SQL: Practical Data Modeling with Amazon DynamoDB
The article provides an overview of practical data modeling techniques using Amazon DynamoDB in a cloud environment.
The NOT IN trap: why your SQL query returns zero rows
This article explains common issues that can lead to empty results in SQL queries.
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N
The article reviews the differences between ROW_NUMBER, RANK, and DENSE_RANK in SQL queries.
How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit
The article provides a method for recovering deleted SQL Server rows without enabling certain features.
Building an ETL Pipeline with Python, Docker, and PostgreSQL (And Debugging the Real Errors)
This article provides insights into building an ETL pipeline with Python, Docker, and PostgreSQL, along with debugging tips.
Slaying the N+1 Query Dragon: A Jedi’s Guide to Database Optimization
The article offers advice on optimizing database queries to improve performance.
AI Is Changing How We Write Code, but Database Design Remains Untouched: Here’s Why
The piece addresses how AI's transformation of coding practices has not yet affected database design.
Multi-Tenant Database Architecture: Row-Level Security (RLS) & PostgreSQL Isolation
The article explains the implementation of row-level security in multi-tenant database architectures using PostgreSQL.
Why You Probably Don’t Need a Dedicated Vector Database (Postgres pgvector Is Enough)
The piece argues that using PostgreSQL's pgvector can negate the need for a dedicated vector database.
Predictability Belongs In Every Database Decision
The article emphasizes the importance of predictability in database performance evaluation rather than just peak speed.
PostgreSQL vs DynamoDB for Idempotency: Both Stopped Duplicates — Only One Made Recovery Obvious
The article compares the performance of PostgreSQL and DynamoDB in ensuring idempotency for data writes.
r/programming2d agoPostgres AT TIME ZONE 'UTC' does NOT do what you think it does
The article explores the nuances of the PostgreSQL database's time zone handling.
r/programming4d agoConstructing Anomalous Elliptic Curves
The article presents a technical discussion on constructing anomalous elliptic curves.
You've reached the end of this feed
Your internet, curated by AI
Describe what you care about in plain English. MyFeed scans thousands of sources and delivers only what matters to you.
Popular feeds
AI tools & productsStartup fundingReact & Next.jsSpace explorationCybersecurity