nowfound

Dev tools · June 6, 2025

Book to help you build a PostgreSQL-like database server from scratch

I just finished writing my book that guides you through building your own SQL database server from scratch. The software engineering books I've enjoyed the most are the ones that let you learn through writing code and experimentation, which is why I wanted to create a practical book. More details and a preview at https://technicaldeft.com/build-a-database-server In summary: + Learn how parse and type check SQL + Execute complex queries that use JOIN and GROUP BY + Challenge yourself with suggested extensions + Comparisons with real databases including PostgreSQL, MySQL, SQLite…

Book to help you build a PostgreSQL-like database server from scratch launched on June 6, 2025 with 5 votes and more than 75% of that year's launches. The site was still online in September 2026, 1 year on.

What it does

A step-by-step guide to building your own database server. Learn about SQL and improve your programming skills.

Build a Database Server A step-by-step guide to building your own database server. Learn about SQL and improve your programming skills. Create an interpreter that can parse, type check and run SQL queries. Start with running simple queries and build up to more complex ones. SELECT 1; SELECT order_no, SUM (items.price) AS total, COUNT (order_no) FROM orders INNER JOIN items ON orders.id = items.order_id WHERE dispatched GROUP BY order_no ORDER BY total DESC ; def run_select load_table apply_joins filter_rows apply_grouping apply_projections order_rows apply_offset apply_limit build_result end Learn SQL (the fun way) Learning by creating your own database server will help you gain a deeper…from technicaldeft.com

In the maker’s words, at launch

I just finished writing my book that guides you through building your own SQL database server from scratch. The software engineering books I've enjoyed the most are the ones that let you learn through writing code and experimentation, which is why I wanted to create a practical book. More details and a preview at…

Does a similar job

all alternatives →
  • Learn by rebuilding Redis, Git, a database from scratchJul 2026 · shipthatcode.com · ▲200

    Learn programming by building real systems from scratch. Redis, Git, a database, a compiler — every lesson is choose, write, run.

  • PN
    PostgresML, now with analytics and project management2022 · postgresml.org · ▲444

    We've been hard at work for a few weeks and thought it's time for another update. In case you missed our first post, PostgresML is an end-to-end machine learning solution, running alongside your favorite database. This time we have more of a suite offering: project management, visibility into the datasets and the deployment pipeline decision making. Let us know what you think! Demo link is on the page, and also here: https://demo.postgresml.org

  • Open Source PostgreSQL Studio2021 · supabase.com · ▲407

    Powerful PostgreSQL tool is now open source for self-hosting

  • SQL playground2021 · uibakery.io · ▲156

    Free private sample PostgreSQL databases

  • Building a database engine2025 · ▲9

    A book that shows how to build a database storage engine

  • Nabubit2024 · ▲203

    Your database design copilot

More dev tools this month

the category →
  • Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.

    Dev tools · 1d ago · github.com

  • /dev/null▲492

    a social network for devs

    Dev tools · 4d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 29d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 24d ago · openbot.run

  • Talanoa▲346

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 22d ago · talanoa.email

Source: Show HN post ↗ · launch text quoted in part

Launched alongside, June 2025

the whole month →
  • IM

    Hey HN! Pilots everywhere are required to keep a logbook of all their flying hours, aircraft, airports, and so on. Since I track everything digitally (some people still just use paper logbooks!), I put together some data visualizations and a few 3D globes to show my flying history. This globe is probably my favourite so far: https://jameshard.ing/pilot/globes/all If you’ve got ideas for other graphs or ways to show this kind of data, I’d love to hear them!

    Life & fun · 2025 · jameshard.ing

  • Stunning presentations with AI. No design skills required.

    AI · 2025 · chroniclehq.com

  • Build native mobile apps for iOS and Android without code.

    Dev tools · 2025 · bble.io

  • Twenty▲989

    Build your Enterprise CRM with an AI-friendly SDK

    Dev tools · 2025 · twenty.com

  • All your connections, across all your socials.

    AI · 2025 · pally.com

  • I was the main contributor to workout.lol, an open-source fitness app to easily build a workout routine. The project had traction (1.4k GitHub stars, 95 forks, ~20K visits/month), but was eventually sold due to video licensing hurdles. The new owner stopped maintaining it, and the repo went abandoned. Over the next 9 months, I sent 15 emails to try to save it : no replies. Feature requests & issues were ignored. The community was left with a "broken" tool let's say. I couldn't just let it die So I built the new version from scratch with the same open-source spirit, but a better…

    Dev tools · 2025 · github.com