<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Ved Gupta</title>
    <description>The latest articles on DEV Community by Ved Gupta (@innovatorved).</description>
    <link>https://dev.to/innovatorved</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F835437%2Fffa2a70e-2bd7-4734-ae82-44414b1b7d24.jpeg</url>
      <title>DEV Community: Ved Gupta</title>
      <link>https://dev.to/innovatorved</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/innovatorved"/>
    <language>en</language>
    <item>
      <title>SQL in Depth: Interactive WASM SQLite 3 Workbench &amp; Database Internals from First Principles</title>
      <dc:creator>Ved Gupta</dc:creator>
      <pubDate>Thu, 19 Nov 2026 18:34:22 +0000</pubDate>
      <link>https://dev.to/innovatorved/sql-in-depth-interactive-wasm-sqlite-3-workbench-database-internals-from-first-principles-2hdl</link>
      <guid>https://dev.to/innovatorved/sql-in-depth-interactive-wasm-sqlite-3-workbench-database-internals-from-first-principles-2hdl</guid>
      <description>&lt;p&gt;Most SQL tutorials stop at syntax (&lt;code&gt;JOIN&lt;/code&gt;, &lt;code&gt;GROUP BY&lt;/code&gt;, window functions) and leave you guessing when a real production query suddenly slows down.&lt;/p&gt;

&lt;p&gt;Understanding &lt;em&gt;why&lt;/em&gt; a query is slow means understanding how the database engine actually parses, plans, indexes, and executes it. Passive reading about B-Trees, query plans, and transaction isolation only gets you so far—it clicks much faster when you can run queries and watch the internals step by step.&lt;/p&gt;

&lt;p&gt;That's why I built &lt;strong&gt;SQL in Depth&lt;/strong&gt;, a free, open-source interactive textbook covering SQL and database internals from first principles. Everything runs right in the browser with no accounts, no paywalls, and no local DB setup.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Try it live:&lt;/strong&gt; &lt;a href="https://sql-in-depth.vedgupta.in" rel="noopener noreferrer"&gt;sql-in-depth.vedgupta.in&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Source code on GitHub:&lt;/strong&gt; &lt;a href="https://github.com/innovatorved/sql-in-depth" rel="noopener noreferrer"&gt;github.com/innovatorved/sql-in-depth&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What's Inside
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Interactive WASM SQLite 3 Workbench&lt;/strong&gt; — write and run real SQLite 3 queries directly in the browser alongside each lesson.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Table-Level Relational Visualizer&lt;/strong&gt; — watch how joins, filters, groupings, and transformations operate on actual rows step by step.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;180 Structured Units&lt;/strong&gt; — from relational algebra and core SQL semantics to indexing, query optimization, storage internals, and transactions.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;36 Interactive Simulators&lt;/strong&gt; — experiment hands-on with database internals and see how design trade-offs behave.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Feedback &amp;amp; Contributions
&lt;/h2&gt;

&lt;p&gt;If you're preparing for backend interviews, sharpening your SQL fundamentals, or curious about how relational engines work under the hood, give it a spin!&lt;/p&gt;

&lt;p&gt;If you find it useful, a star on GitHub helps others discover it—and issues, PRs, or ideas for new simulators are always welcome in the comments or on GitHub.&lt;/p&gt;

</description>
      <category>sql</category>
      <category>database</category>
      <category>sqlite</category>
      <category>opensource</category>
    </item>
    <item>
      <title>I Built 3 Free, Open-Source Interactive Textbooks for System Design, SQL, and DSA</title>
      <dc:creator>Ved Gupta</dc:creator>
      <pubDate>Thu, 19 Nov 2026 18:05:50 +0000</pubDate>
      <link>https://dev.to/innovatorved/i-built-3-free-open-source-interactive-textbooks-for-system-design-sql-and-dsa-bn7</link>
      <guid>https://dev.to/innovatorved/i-built-3-free-open-source-interactive-textbooks-for-system-design-sql-and-dsa-bn7</guid>
      <description>&lt;p&gt;Passive reading has always been my least effective way to learn core computer science. Reading about how B-Trees split, how Raft elects a leader, or how a hash table handles collisions makes sense on paper—until you actually have to trace the state transitions yourself.&lt;/p&gt;

&lt;p&gt;Over the past few months, I built &lt;strong&gt;three free, open-source interactive textbooks&lt;/strong&gt; focused on first-principles learning, visual simulators, and hands-on experimentation. No paywalls, no accounts required, and everything runs directly in your browser.&lt;/p&gt;




&lt;h2&gt;
  
  
  1. System Design in Depth
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Live:&lt;/strong&gt; &lt;a href="https://system-design-in-depth.vedgupta.in" rel="noopener noreferrer"&gt;https://system-design-in-depth.vedgupta.in&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;GitHub:&lt;/strong&gt; &lt;a href="https://github.com/innovatorved/system-design-in-depth" rel="noopener noreferrer"&gt;https://github.com/innovatorved/system-design-in-depth&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;A structured, end-to-end system design curriculum designed to go beyond buzzwords and high-level diagrams.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What's inside:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;200 topics across 6 tracks&lt;/strong&gt; covering fundamentals, distributed systems, storage, caching, messaging, and real-world architectures&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;32 interactive simulators&lt;/strong&gt; to experiment with concepts like load balancing, rate limiting, replication, and consensus&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;15 from-scratch builds&lt;/strong&gt; to bridge theory and implementation&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;470 curated videos&lt;/strong&gt; and &lt;strong&gt;600 practice questions&lt;/strong&gt; to test your understanding&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  2. SQL in Depth
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Live:&lt;/strong&gt; &lt;a href="https://sql-in-depth.vedgupta.in" rel="noopener noreferrer"&gt;https://sql-in-depth.vedgupta.in&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;GitHub:&lt;/strong&gt; &lt;a href="https://github.com/innovatorved/sql-in-depth" rel="noopener noreferrer"&gt;https://github.com/innovatorved/sql-in-depth&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Most SQL tutorials stop at syntax (&lt;code&gt;JOIN&lt;/code&gt;, &lt;code&gt;GROUP BY&lt;/code&gt;, window functions) without explaining &lt;em&gt;why&lt;/em&gt; a query is slow or how the database engine actually executes it. SQL in Depth covers both SQL and database internals from first principles.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What's inside:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Interactive WASM SQLite 3 Workbench&lt;/strong&gt; right in the browser—no local database setup needed&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Table-Level Relational Visualizer&lt;/strong&gt; to see how joins, filters, and transformations operate on real rows&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;180 structured units&lt;/strong&gt; going from relational algebra to indexing, query planning, and transactions&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;36 interactive simulators&lt;/strong&gt; covering database internals&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  3. DSA in Depth
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Live:&lt;/strong&gt; &lt;a href="https://dsa-in-depth.vedgupta.in" rel="noopener noreferrer"&gt;https://dsa-in-depth.vedgupta.in&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;GitHub:&lt;/strong&gt; &lt;a href="https://github.com/innovatorved/dsa-in-depth" rel="noopener noreferrer"&gt;https://github.com/innovatorved/dsa-in-depth&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Instead of treating data structures and algorithms as isolated interview trivia, DSA in Depth is built as an interactive, hardware-grounded, primary-source textbook.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What's inside:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;69 visual simulators&lt;/strong&gt; for stepping through pointer manipulations, tree rotations, graph traversals, and memory layouts&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;22 zero-dependency coding labs&lt;/strong&gt; so you can implement and verify algorithms hands-on&lt;/li&gt;
&lt;li&gt;Grounded in how modern hardware (caches, memory hierarchy, branch prediction) affects real-world algorithm performance&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  Feedback &amp;amp; Contributions Welcome
&lt;/h2&gt;

&lt;p&gt;All three projects are completely free and open source. If you're studying for interviews, brushing up on fundamentals, or teaching CS concepts, I'd love for you to try them out.&lt;/p&gt;

&lt;p&gt;If you spot any bugs, have ideas for new simulators, or want to contribute improvements, feel free to open an issue or PR on GitHub—or drop your thoughts in the comments below!&lt;/p&gt;

</description>
      <category>systemdesign</category>
      <category>sql</category>
      <category>algorithms</category>
      <category>opensource</category>
    </item>
  </channel>
</rss>
