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.
From the web
Tatum — blockchain API & RPC infrastructure
https://tatum.io/
Tatum makes blockchain development simple. It’s the go-to blockchain development platform with a unified framework for building Web3 apps using any of the 100+ protocols.
Show more
https://tatum.io/about
Tatum is a blockchain development platform that provides fast, reliable RPC gateways to 100+ networks. Tatum RPC endpoints feature failovers, geo and load balancing, and data caching for ultimate efficiency and reliability.
Tatum Developer Documentation
https://docs.tatum.io/
Whatever you're building, it's easiest to start and scale your app with Tatum . You get a unified abstraction layer to access all blockchains. Explore our documentation and examples. Access 130+ blockchain networks. Utilize JSON-RPC for connection to over 100 blockchain nodes, streamlining your blockchain interaction. Indexed Block Data.
Welcome to Tatum
https://docs.tatum.io/docs/getting-started
Ready to build fantastic blockchain applications? Tatum 's REST API and SDK are here to make your life easier when building blockchain applications! No complicated setups, we've got you covered. 💡 Why Tatum ? Fast development: Start building blockchain applications in no time.
Trending Now
How to Use Terraform with AWS: Complete Guide
Learn how to use Terraform with AWS step by step. Master provider setup, state management, security, and production-grade deployments. Start building today.
How to Build an AI Agent with LangChain: Step-by-Step Guide
Learn how to build an AI agent with LangChain in this step-by-step tutorial. Set up tools, integrate LLMs, and create autonomous agents with memory.
How to Monitor Kubernetes with Grafana and Prometheus
Learn how to monitor Kubernetes with Grafana and Prometheus using the kube-prometheus-stack. Step-by-step guide to deploy, connect, and visualize cluster metrics.
Starlink Launch in Japan: Direct Smartphone Communication via Satellite
SpaceX and KDDI launched satellite communication for smartphones in Japan. Learn how Starlink Direct-to-Cell works, who can access it, and what hidden geopolitical goals this project pursues.
MongoDB vs PostgreSQL When to Use Each: Key Differences
MongoDB vs PostgreSQL when to use each: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
How to Choose a Database for Your System: Expert Guide
Learn how to choose a database for your system with this evidence-based framework. Compare SQL, NoSQL, graph, and time-series databases to make the right decision.
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.
How Does Retrieval Augmented Generation Work? RAG Guide
Learn how does retrieval augmented generation work: RAG reduces AI hallucinations, grounds responses in real data, and transforms LLMs into trustworthy systems. Start now.
How to Implement JWT Authentication: Step-by-Step Guide
Learn how to implement JWT authentication securely in your web API. This complete guide covers token issuance, validation, best practices, and production security.
What Are Data Structures and Why They Matter | Basics
Learn what are data structures and why they are important for efficient software. Discover types, real-world impact, and how they shape modern computing.