https://sudonull.com/cursor-trigram-indexes-for-fast-regex-search
Learn how Cursor sped up regex search in the IDE via local trigram indexes and sparse n-grams. Details on implementation for monorepo. Dive into optimization for middle/senior dev.
Search Articles — Sudonull
Search Results
In this project
https://sudonull.com/clickhouse-skipping-indexes-bloom-set-minmax
How ClickHouse skipping indexes speed up queries on columns outside ORDER BY. Breakdown of minmax, set, bloom_filter, ngrambf_v1, tokenbf_v1 with examples from gaming and EXPLAIN.
https://sudonull.com/postgresql-query-optimization-and-understanding-index-operations
Figure out why PostgreSQL ignores indexes. Detailed analysis of EXPLAIN ANALYZE, selectivity, correlation, and advanced index types to improve database performance.
https://sudonull.com/django-optimization-from-30s-to-142ms
Monolith Refactoring Breakdown: eliminating N+1, indexes, DDD. Metrics: CPU -60%, queries from 2800 to 3. Instructions for middle/senior dev.
https://sudonull.com/triangulation-of-ai-search-claude-chatgpt-gemini
Learn the Deep Research workflow through three neural networks with different search engines. Comparison of indexes, prices, research levels. Save hours on fact-checking — read the guide.
From other projects
https://ymaho.com/the-graph-vs-chainlink-key-differences-in-web3-data
The Graph indexes on-chain data; Chainlink brings off-chain data to smart contracts. Learn how they work and why they're complementary, not competitors.
Trending Now
Nvidia capitalization $5.4 trillion: surpassed Europe
Nvidia reached $5.4 trillion capitalization, outpacing the 10 largest companies in Europe. Analysis of growth reasons, overheating risks, and forecasts for the AI chip market. Read the review.
Kubernetes Architecture Explained with Examples | Guide
Kubernetes architecture explained with examples: understand control plane, worker nodes, Pods, and deployment flow. Learn how clusters work with practical use cases.
What Are the Ethical Concerns in Artificial Intelligence?
Learn what are the ethical concerns in artificial intelligence, from bias to job loss. Backed by research, this guide offers a practical framework for evaluation.
How to Write a SQL Query: Tutorial with Examples
Learn how to write a SQL query with practical examples. Master SELECT, WHERE, JOIN, GROUP BY, and best practices for readable, efficient SQL. Start now.
Top 10 Breakthrough Technologies 2026 from WEF: Full Analysis
Analysis of trends, hidden risks, and geopolitical implications of Top 10 Emerging Technologies 2026. Who benefits from new developments and who loses. Read the analytics.
Docker Container Networking Explained: A Practical Guide
Docker container networking explained in depth: learn bridge vs host networks, DNS, port publishing, and how to build secure, scalable multi-container apps.
Breakthrough in Quantum Error Correction: Google and Quantinuum
Google and Quantinuum have reached the threshold of scalable quantum error correction. Learn how this changes the future of quantum computing and who benefits from the breakthrough.
What Is a Vector Database? Beginner's Guide to AI Search
What is a vector database? Learn how vector databases power AI search, RAG, and recommendations. Discover key concepts and when to use them. Start here.
Fine Tuning vs Retrieval Augmented Generation: A Guide
Compare fine tuning vs retrieval augmented generation for LLMs. Learn which approach suits your AI project based on accuracy, cost, and data freshness.
How to Become a Self-Taught Programmer and Get a Job
Learn how to become a self-taught programmer and get a job in 2026 with this practical roadmap. Master fundamentals, build a portfolio, and land your first developer role.