Skip to content
HomeVideosBooksBlogs
AllTop postsTopics
Podcasts
HistoryListsWatch laterLiked videosFollowing

The videos, books, blogs and podcasts Hacker News keeps recommending, all in one place.

VideosBooksBlogsPodcastsAboutPrivacySettings

Data from Hacker News, HackerTube, HackerBooks, HackerBlogs and Open Library. Credits · Not affiliated with Y Combinator.

HomeVideosBooksBlogsPodcasts
Ctrl K
    W

    Wesley Aptekar-Cassels

    blog.wesleyac.com · Personal blog · on HN since 2017

    Wesley Aptekar-Cassels writes about software engineering, SQLite, NixOS, running his own servers, and compensation transparency.

    Visit blogHN submissions
    DatabasesDevOps & Cloud
    What HN says

    HN commenters cite "Consider SQLite" as convincing them to use it in production, and link his post on how he runs servers.

    Stats for nerds
    50HN people shared it
    61linked in comments
    4Kstory points
    Jul 2026last shared
    2021people per year2026

    Top posts on HN

    1. 1
      The Curse of NixOS
      5 people · 585 points · first shared 2022 · 353 comments on HN
    2. 2
      Web3 is centralized
      2 people · 453 points · first shared 2022 · 482 comments on HN
    3. 3
      Things I Believe About Software Engineering
      2 people · 422 points · first shared 2020 · 225 comments on HN
    4. 4
      Timezone Bullshit
      2 people · 402 points · first shared 2021 · 319 comments on HN
    5. 5
      Consider SQLite
      12 people · 380 points · first shared 2021 · 266 comments on HN
    6. 6
      Elliptic Curve Cryptography for Beginners
      1 person · 328 points · first shared 2017 · 30 comments on HN
    7. 7
      The two questions I ask every interviewer
      2 people · 309 points · first shared 2017 · 303 comments on HN
    8. 8
      How many users block Google analytics? (2017)
      1 person · 265 points · first shared 2020 · 234 comments on HN
    9. 9
      SNES Development Part 1: Getting Started
      1 person · 265 points · first shared 2022 · 47 comments on HN
    10. 10
      Languages I want to write
      2 people · 190 points · first shared 2019 · 139 comments on HN

    What HN people wrote when they linked it

    • DyslexicAtheistJan 2022

      > I believe the idea of Web3/Crypto is that it's decentralized

      Web3 is Centralized: https://blog.wesleyac.com/posts/web3-centralized - discussed here a few days ago: https://news.ycombinator.com/item?id=29766497

      Even if it were decentralized, the moment a technology appears to be decentralized, we do everything in our power to add a centralized (management) layer on top (e.g. github). That layer is what the masses will flock to and eat the lunch of the original technology.

      If you have a technology that is already centralized which you try to decentralize it will be nothing more than a niche existence (that might not be a bad thing. See centralized Twitter vs decentralized Mastodon as an example of this)

      "Distribute", is more practical than "Decentralize" because it lets you articulate the players and don't have to worry about sybils.

      The funniest thing right now is the noisy people into NFT "art" who get their work stolen and are appealing to authority in meatspace.

    • AlexITCAug 2023

      Hi hn,

      Since I shared the AudioCraft cool project with my family, they were keen to try it but there does not seem to be any live version from it, I decided to host my own for a while and detailed my steps in this guide.

      There is a live MusicGen demo app for hn users to try, I don't know how long it will last online because the server doesn't seem to be capable of handling many concurrent requests: https://audiocraft.wiringbits.net/

      In a preview hn discussion about AudioCraft I saw a few people that weren't sure how to execute it, this guide can hopefully help the community (https://news.ycombinator.com/item?id=36972347).

      The way to deploy this version is the old-school way, similar to a previous hn discussion (https://blog.wesleyac.com/posts/how-i-run-my-servers) that generated some interest.

      Overall, this piece of technology is pretty interesting and fun, I hope the guide helps.

      Thanks.

    • mdp2021Apr 2022

      I do not quite understand the premises:

      > Given the complexity

      Which complexity? It is the simplest possible widespread, reliable and effective solution. Which makes it a primary choice.

      > it seems like there are use cases or needs here that I'm not seeing

      On the contrary, the use cases for the traditional Relational DB engines are defined: when you need a concurrency manager better than filesystem access. (Or maybe some unimplemented SQL function; or special features.) Otherwise, SQLite would be the natural primary candidate, given the above.

      Edit:

      I concur about https://blog.wesleyac.com/posts/consider-sqlite being a close to essential read if one has the poster's doubt.

      To its "So, what's the catch?" section, I would add: SQLite does not implement the whole of SQL (things that come to mind on the spot are variables; the possibility of recursion was implemented only recently, etc).

    • somishereFeb 2024

      Not an expert, however (lol) - even if the recommendations here are solid - this doesn't feel like a particularly well-reasoned comparison.

      IMHO maintaining a large number of files on disk (be it 16m or 1.5b) should be a non-starter (not to mention that zipping them to slightly reduce the count removes one of the benefits of having them in the first place). A database makes sense - as does SOC between generation and distribution if it brings benefit - but immediately writing off SQLite because of write performance[1]? Similarly the arguments against pmtiles feel outdated and ignorant of the developing nature of the protocol (appreciate it's a 2yo post!).

      OSM deciding on a format here has potential to significantly shape things to come. Hopefully Paul has progressed his thinking a bit since this was written.

      [1] https://blog.wesleyac.com/posts/consider-sqlite

    • rgoulterMar 2023

      c.f. Nix survey results from last year, which indicates many of the respondents use NixOS as their daily Linux distribution. (e.g. number of responses for just "uses gnome" and "uses plasma" are about half of the number of responses for "use NixOS daily").
      https://discourse.nixos.org/t/2022-nix-survey-results/18983

      Many of those who do use NixOS as a desktop Linux are enthusiastically happy about it.

      Indeed, this user described the combination of nice features & rough edges as "cursed". (It's so good you won't want to use anything else, but it's too rough to recommend generally).
      https://blog.wesleyac.com/posts/the-curse-of-nixos

    • javajoshJul 2023

      I think this is a good question and NOT monitoring services is something I need to fix. Consider https://blog.wesleyac.com/posts/how-i-run-my-servers. His unit files do not mention any monitoring. There are a variety of sysadmin things I'm bad at. For example, I do not know off the top of my head where to look for cron job failures or the IP addresses of malicious ssh login attempts, to take two examples. This concerns me because normally I'm very curious, and even a bit of a completist, but when it comes to sysadmin tasks I tend to "hope for the best".

    Related

    Farid Zakariafzakaria.com30 people

    Nix Derivation Madness

    Farid Zakaria
    Personal · last shared 2026
    Manish Goregaokarmanishearth.github.io97 people

    Picking Apart the Crashing iOS String

    Manish Goregaokar
    Personal · last shared 2026
    Chris McDonoughchrismcdonough.substack.com21 people

    The Shameful Defenestration of Tim

    Chris McDonough
    Personal · last shared 2026
    Graham Christensengrahamc.com57 people

    Erase your darlings: immutable infrastructure for mutable systems

    Graham Christensen
    Personal · last shared 2026
    Mattias Geniarma.ttias.be93 people

    Remote Kernel Code Execution Via HTTP Request In IIS On Windows

    Mattias Geniar
    Personal · last shared 2026
    Aphyraphyr.com551 people

    Hexing the technical interview (2017)

    Aphyr
    Personal · last shared 2026
    Turso Blogturso.tech102 people

    Working on databases from prison

    Turso Blog
    Company · last shared 2026
    Xe Iasoxeiaso.net198 people

    We all dodged a bullet

    Xe Iaso
    Personal · last shared 2026