Postgresql vs. MongoDB
PostgreSQL vs. MongoDB is the one of the most wondered comparisons in the database world. Let me compare them in a concise way.
PostgreSQL vs. MongoDB: A Concise Comparison
PostgreSQL and Mong...
The N+1 query problem in Laravel and how to solve it
The N+1 query problem in Laravel (and other ORMs) occurs when an application makes inefficient database queries, leading to performance issues. This problem typically arises in scenarios where a query...
Efficient Percentile Ranking in PostgreSQL
When analyzing data, percentiles help us understand the relative ranking of records within a dataset. In PostgreSQL, we can compute percentiles efficiently using the PERCENT_RANK() OVER window functio...
Improving the documentation user experience
At SurrealDB, weโre constantly iterating to enhance our product and provide the best possible experience for our users. Recently, we've gathered feedback through our channels and made updates we bel...
Why CRUD Doesnโt Work for ETL (And What to Do Instead)
Traditional CRUD operations donโt scale well in ETL workflows. Handling data row by row creates unnecessary overhead, slowing down performance. This article explores how to transition from CRUD-base...
Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming ๐ฎ
TL;DR: AI gaming company Latitude replaced Amazon Aurora with TimescaleDB for their interactive storytelling platform, cutting storage costs by $12K monthly while improving query performance.
--> ...
Trust But Verify: Evaluating Security When Choosing Data Infrastructure Tools
Cover Image: How data is stored on a server, as envisioned by Hackers (1995) Dir. Iain Softley ยฉMetro-Goldwyn-Mayer, Inc.
A data leader's guide to maintaining security when working with thi...
Installing MongoDB Using Docker: A Complete Guide
Docker provides an excellent way to run MongoDB without installing it directly on your system. This approach offers better isolation, easier version management, and simpler setup. In this guide, I'll ...
The filesystem - a quick & dirty way to store temp data in your API
I have an API service for a Google Sheets add-on that I built, and I wanted
to temporarily store some request metadata that I started collecting in the client.
How the add-on works. The API generates ...