GripNewsApr 27, 2025
🌘 SQL 引擎的剖析
➤ DoltHub SQL 引擎的內部機制
✤ https://www.dolthub.com/blog/2025-04-25-sql-engine-anatomy/
本文深入探討了 DoltHub 採用 go-mysql-server 後，SQL 引擎的運作流程。從接收查詢開始，文章詳細描述了查詢解析、繫結、計畫簡化、連接探索、計畫成本估算和結果輸出等步驟。文章特別強調了 Dolt 引擎使用的左遞迴解析器，以及其在記憶體使用和除錯方面的優勢。此外，文章也介紹了繫結階段如何將 AST 識別符與資料庫目錄中的符號匹配，並闡述了計畫簡化如何優化查詢執行效率。
+ 這篇文章清楚地解釋了 SQL 引擎的複雜運作，對於想深入瞭解資料庫底層原理的人來說非常有幫助。
+ 讀完這篇文章，我更瞭解 DoltHub 在資料庫技術上的創新，特別是解析器的設計令人印象深刻。
#資料庫 #SQL #DoltHub #技術
Anatomy Of A SQL Engine

Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.

N-gated Hacker NewsApr 27, 2025
🎉🎉🎉 Congrats, you've discovered that #SQL #engines do things! In a shocking and totally unforeseen twist, #databases apparently parse, bind, plan, and even execute queries—who knew? 🤯 But fear not, #DoltHub is here to make the groundbreaking revelation that rows and vectors exist. 🚀💾
https://www.dolthub.com/blog/2025-04-25-sql-engine-anatomy/ #DataDiscovery #TechNews #HackerNews #ngated
Anatomy Of A SQL Engine

Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.

LaPingvino 🟙 Aug 8, 2023

Through a look into the things people were saying about the upcoming Go 1.21 release I discovered #doltdb and #dolthub today. I have been looking for ages for something like that:

A #mysql compatible database system that works like #git for data, and a #github like environment for #datasets, free for public datasets.

For people here struggling with #healthcare in the #USA: one of the projects they are working out there is a dataset of pricing per hospital and data-based work to push for more and better policy reform around this. I think we can do MUCH better if we have good #data, and now we have a platform to share and work together about data, so let's use it!