How Optimizing Database Queries Can Cut Cloud Egress Costs and Boost Speed

·1 views

Cloud providers charge for data transferred out of databases over the public internet, a cost known as egress, which can grow quickly as applications scale. Platforms like PlanetScale and Postgres include limited egress allowances — 100GB and 10GB respectively — with metered charges beyond those thresholds. The two main causes of excessive egress are fetching too many columns and running unbounded queries without row limits. Developers can reduce data transfer by selecting only required columns, adding LIMIT clauses, and using Postgres functions like jsonb_agg() to extract specific fields from JSONB data. These query optimizations deliver a dual benefit: lower infrastructure costs and faster application performance.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

How Procshot Keeps Screenshot Step Numbers Intact Across Browser Sessions

Procshot is a Chrome extension that automatically generates numbered, step-by-step guides from browser screenshots. A key technical challenge arose because Chrome's Manifest V3 service workers shut down after roughly 30 seconds of inactivity, causing in-memory sequence counters to reset mid-guide. Developer fixed this by storing the sequence number in chrome.storage.session, which persists across service worker restarts for the duration of a browser session. To handle guide resets intelligently, Procshot combines a configurable 30-minute inactivity timer with an explicit 'New Guide' button, assigning each guide session a unique ID via crypto.randomUUID(). Step-number badges cannot be drawn directly in the service worker since the Canvas API is unavailable there, requiring an offscreen document workaround instead.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

MongoDB Offers ACID, Vector Search, and Time-Series Without Extra Installs

MongoDB is often adopted initially as a flexible JSON store, but developers frequently discover it supports far more than document storage, including ACID transactions, full-text search, time-series data, geospatial queries, and horizontal sharding. Its aggregation pipeline enables complex analytical queries in a readable, top-to-bottom format, reducing the need for convoluted subqueries or CTEs. As AI became a business priority for many organizations, MongoDB's built-in vector search allowed teams to build retrieval-augmented generation apps without adding a separate database. The platform's integration with Voyage AI further addresses common RAG pitfalls such as stale embeddings, poor context ranking, and high token costs through automated embeddings, rerankers, and semantic caching. The broader takeaway is that MongoDB's native feature set can replace multiple specialized databases, lowering architectural complexity over time.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Third-Party API Offers TikTok Public Profile Data Without Official Approval

A third-party service called TikTok Data Pro, listed on RapidAPI, provides developers access to public TikTok profile data without requiring TikTok's official API approval. The tool returns structured data including follower counts, engagement metrics, video statistics, and profile details via a single REST endpoint. TikTok's official API is restricted to approved partners and involves a lengthy review process, leaving most developers without a viable option for basic public data. TikTok Data Pro supports code integration in cURL, JavaScript, and Python, and offers a free tier of 500 API calls with no credit card required. The service was highlighted in a developer guide originally published on scrapiq.in and shared via DEV Community.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

MiniMax Model Praised for Handling Ambiguity and Long-Context Reasoning

MiniMax is an AI model positioned in the upper-mid tier of available models, noted for solid benchmark numbers, low response latency, and reliable context handling. A key strength highlighted is its tendency to seek clarification when faced with ambiguous or underspecified questions, rather than confidently producing potentially incorrect answers. The model also maintains coherence across long conversations without the performance degradation observed in comparable models at similar context lengths. Response speed is described as consistent, favoring sustained workloads over peak burst throughput. The model is recommended as a first-class option for developers building AI agents that require multi-step reasoning, code generation, and tool orchestration.

0 comments Read more at DEV Community