---
title: "Discussion on \"Build your own SQLite, Part 1: Listing tables\" | Hashnode"
description: "Discussion on \"Build your own SQLite, Part 1: Listing tables\". As developers, we use databases all the time. But how do they work?\nIn this series, we'll try to answer that question by building our own\nSQLite-compatible database from scratch.\nSource code examples will be provided in Rust, but you are encouraged t..."
url: "https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Build your own SQLite, Part 1: Listing tables](https://blog.sylver.dev/build-your-own-sqlite-part-1-listing-tables?utm_source=hashnode&utm_medium=feed)

As developers, we use databases all the time. But how do they work? In this series, we'll try to answer that question by building our own SQLite-compatible database from scratch. Source code examples will be provided in Rust, but you are encouraged t...

Jul 22, 2024 · 13 min read · blog.sylver.dev  
Updated Oct 31, 2025  
Read the article

-   [#rust](https://hashnode.com/tag/rust)
-   [#sqlite](https://hashnode.com/tag/sqlite)
-   [#from-scratch](https://hashnode.com/tag/from-scratch)
-   [#project](https://hashnode.com/tag/project)
-   [#database](https://hashnode.com/tag/database)

## Written by

[Geoffrey Copin](https://hashnode.com/@Sylver)

@Sylver

  
[View profile](https://hashnode.com/@Sylver)

## Responses 3

Markdown supported · ⌘↵ to post

[Tahoma Toelkes](https://hashnode.com/@tensility)

[Feb 23, 2025](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/67ba6b24022c31125a853530)

s/followed by an sequence of/followed by a sequence of/

Cheers.

[Jeff Johnson](https://hashnode.com/@jeffsworld)

[Aug 18, 2024](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/66c15aa787ea70eb7d7fc803)

Great start, looking forward to the rest of the series!

[Geoffrey Copin](https://hashnode.com/@Sylver)

[Aug 18, 2024](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/66c15aa787ea70eb7d7fc803#reply-66c21920bd2b003a2bb75ee9)

Thanks a lot, Part 2 is in the works!

[Mikhail Kondratyev](https://hashnode.com/@mkondratyev85)

[Jul 24, 2024](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/66a117e796ed58e259741fb4)

This tutorial is a nice balance between in depth explanation of the subject and not too very complicated examples of the rust code. I'm eager to see the next post in this series

[Geoffrey Copin](https://hashnode.com/@Sylver)

[Jul 24, 2024](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/66a117e796ed58e259741fb4#reply-66a152799b494a5ad58d402c)

Thanks for your kind words!

[yunfan](https://hashnode.com/@yunfan)

[Jul 24, 2024](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/66a069d5f2c5c75e07798d61)

thanks, but can you showed how to parsing the sql commands and mapping it to execution?

[Geoffrey Copin](https://hashnode.com/@Sylver)

[Jul 24, 2024](https://hashnode.com/posts/build-your-own-sqlite-part-1-listing-tables/669ed0e6f022df6305c6593a/comment/66a069d5f2c5c75e07798d61#reply-66a09f5e59a9f349009dd8ed)

Absolutely! The next parts will focus on the implementation of « SELECT », including building a small parser for SQL commands.
