<story><title>Why SQLite Uses Bytecode</title><url>https://sqlite.org/draft/whybytecode.html</url></story><parent_chain></parent_chain><comment><author>wolf550e</author><text>The page is the result of this exchange on Twitter:&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;twitter.com&amp;#x2F;gorilla0513&amp;#x2F;status&amp;#x2F;1784756577465200740&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;twitter.com&amp;#x2F;gorilla0513&amp;#x2F;status&amp;#x2F;1784756577465200740&lt;/a&gt;&lt;p&gt;I was surprised to receive a reply from you, the author. Thank you :)
Since I&amp;#x27;m a novice with both compilers and databases, could you tell me what the advantages and disadvantages are of using a VM with SQLite?&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;twitter.com&amp;#x2F;DRichardHipp&amp;#x2F;status&amp;#x2F;1784783482788413491&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;twitter.com&amp;#x2F;DRichardHipp&amp;#x2F;status&amp;#x2F;1784783482788413491&lt;/a&gt;&lt;p&gt;It is difficult to summarize the advantages and disadvantages of byte-code versus AST for SQL in a tweet.  I need to write a new page on this topic for the SQLite documentation.  Please remind me if something does not appear in about a week.</text></comment>
<story><title>Why SQLite Uses Bytecode</title><url>https://sqlite.org/draft/whybytecode.html</url></story><parent_chain></parent_chain><comment><author>userbinator</author><text>&lt;i&gt;The problem of rendering a tree-of-objects as a table is sufficiently difficult that nobody does it, as far as I know. Hence, no tree-of-objects database engine provides the level of detail in their &amp;quot;EXPLAIN&amp;quot; output that SQLite provides.&lt;/i&gt;&lt;p&gt;I believe Microsoft SQL Server uses an object tree internally, and yet its query plan output is a table:&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;learn.microsoft.com&amp;#x2F;en-us&amp;#x2F;sql&amp;#x2F;t-sql&amp;#x2F;statements&amp;#x2F;set-showplan-all-transact-sql&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;learn.microsoft.com&amp;#x2F;en-us&amp;#x2F;sql&amp;#x2F;t-sql&amp;#x2F;statements&amp;#x2F;set-s...&lt;/a&gt;</text></comment>