How often is the query plan optimal?

Comments (1)

alexisread · 1h ago

TBH this is a good case for Linq-style queries, over SQL-based ones. Linq style allows you to narrow the query deterministically vs Sql eg. Mytable1.select().where().join(mytable2)

This applies the filter before the join, compared with:

Select from mytable1 join mytable2 on... Where...

Which relies on the query plan to resolve the correct application of where, and hope it puts the where before the join.

This becomes more important in the cloud, where Iceberg tables cannot be benchmarked in the same way as single-cluster relational DBs.

Show HN: TokenDagger – A tokenizer faster than OpenAI's Tiktoken (github.com)

Show HN: New Ensō – first public beta (untested.sonnet.io)

Show HN: We're two coffee nerds who built an AI app to track beans and recipes (beanbook.app)

Show HN: Open-Source International Space Station Tracker ESP32/Arduino for $20 (github.com)

Show HN: A continuation of IRS Direct File that can be self-hosted (github.com)

Show HN: Timezone converter that tells you if your meeting time sucks (timezig.com)

Show HN: C.O.R.E – Opensource, user owned, shareable memory for Claude, Cursor (github.com)

Show HN: Private real-time dictation app for Mac (github.com)

Show HN: I built a daily sunlight tracker (lumehealth.io)

Show HN: Audiopipe – Pipeline for audio diarization, denoising and transcription (github.com)

Show HN: Attach Gateway – one-command OIDC/DID auth for local LLMs (github.com)

Show HN: ArcFont – Font Embedding Model (github.com)

Show HN: Octelium – FOSS Alternative to Teleport, Cloudflare, Tailscale, Ngrok (github.com)

Show HN: QuizKnit, an open source quiz creator (quizknit.com)

Show HN: MailMap – Turn emails into interactive stories on Google Maps (mailmap.site)

Show HN: I'm an airline pilot – I built interactive graphs/globes of my flights (jameshard.ing)

Show HN: Summle – A little maths Game (summle.net)

Show HN: Sharpe Ratio Calculation Tool (fundratios.com)

Show HN: Semantic-dictionary – A Python dictionary with semantic lookup (github.com)

Show HN: DotnetEbpf - Write Linux eBPF kernel applications in C# (github.com)

Show HN: Ravana, Multi AI Assistant Browser Desktop App (github.com)

Show HN: AGL a toy language that compiles to Go (github.com)

Show HN: My Cross-Platform MySQL Parser (abbychau.github.io)

Show HN: Vet – A tool for safely running remote shell scripts (getvet.sh)

Show HN: AI image alt text generation tool – Turn images into text with AI (imagerr.ai)

Show HN: A tool to benchmark LLM APIs (OpenAI, Claude, local/self-hosted) (llmapitest.com)

Show HN: Sink – Sync any directory with any device on your local network (github.com)

Show HN: A different kind of AI Video generation

Show HN: Flutter Course 3.0: A Browser IDE (hungrimind.com)

Show HN: Magnitude – Open-source AI browser automation framework (github.com)

Show HN: Do you know RGB? (maxwellito.github.io)

Show HN: Zenta – Mindfulness for Terminal Users (github.com)

Show HN: I built an AI dataset generator (github.com)

Show HN: SmartStepper – Multi-Step Form Library with Config-Based Flow (github.com)

Show HN: SVG Lined Tile Generator (adpreese.github.io)

Show HN: Layerfig Type-safe layered config for JavaScript/TS with any validator (layerfig.dev)

Show HN: Tablr – Supabase with AI Features (tablr.dev)

Show HN: Oasis – An open-source, 3D-printed smart terrarium (github.com)

Show HN: BloomPilot – AI-Powered Overlay for Bloomberg Terminal (prestigious-albatross-928.convex.app)

Show HN: Ciara – Securely deploy any application on any server (ciara-deploy.dev)

Show HN: Scream to Unlock – Blocks social media until you scream “I'm a loser”

Show HN: PILF, The ultimate solution to catastrophic oblivion on AI models (github.com)

Show HN: Ketcher Docker – Self-Hosting Advanced Chemical Structure Editor (github.com)

Show HN: Anti-Cluely – Detect virtual devices and cheating tools on exam systems (anti-cluely.com)

Show HN: EliteSaaS – Self-Contained SaaS Starter (Auth, Billing, Email, Launch) (elitesaas.dev)

Show HN: PRSS Site Creator – Create Blogs and Websites from Your Desktop (prss.co)

Show HN: Elelem, a tool-calling CLI for Ollama and DeepSeek in C (codeberg.org)

Show HN: Anagnorisis. A Vision for Better Information Management (medium.com)

Show HN: Visualizing method dependencies over classes in C# and TypeScript (github.com)

Show HN: Clai - Vendor agnostic Claude Code/Gemini CLI written in Go (github.com)

How often is the query plan optimal?

Comments (1)