Hacker News: wmanley

New comment by wmanley in "Do you even need a database?"

wmanley — Thu, 16 Apr 2026 14:14:43 +0000

SQLite in mmap mode (not the default) will use mmap for reading. It will still use write using `pwrite` so it can detect and recover from write failures.

See https://www.sqlite.org/mmap.html :

> The default mechanism by which SQLite accesses and updates database disk files is the xRead() and xWrite() methods of the sqlite3_io_methods VFS object. These methods are typically implemented as "read()" and "write()" system calls which cause the operating system to copy disk content between the kernel buffer cache and user space.

> Beginning with version 3.7.17 (2013-05-20), SQLite has the option of accessing disk content directly using memory-mapped I/O and the new xFetch() and xUnfetch() methods on sqlite3_io_methods.

The principal advantage to mmap in my mind is that the cache is shared among your SQLite connections.

New comment by wmanley in "Do you even need a database?"

wmanley — Wed, 15 Apr 2026 15:45:09 +0000

Business logic tests will rarely test what happens to your data if a machine loses power.

New comment by wmanley in "What does " 2>&1 " mean?"

wmanley — Fri, 27 Feb 2026 13:28:43 +0000

It's a shame that unix tools don't support file descriptors better. The ability to pass a file (or stream, or socket etc) directly into a process is so powerful, but few commands actually support being used this way and require filenames (or hostnames, etc) instead. Shell is so limited in this regard too.

It would be great to be able to open a socket in bash[^1] and pass it to another program to read/write from without having an extra socat process and pipes running (and the buffering, odd flush behaviour, etc.). It would be great if programs expected to receive input file arguments as open fds, rather than providing filenames and having the process open them itself. Sandboxing would be trivial, as would understanding the inputs and outputs of any program.

It's frustrating to me because the underlying unix system supports this so well, it's just the conventions of userspace that get in the way.

[^1]: I know about /dev/tcp, but it's very limited.

New comment by wmanley in "America vs. Singapore: You can't save your way out of economic shocks"

wmanley — Thu, 19 Feb 2026 23:56:10 +0000

US borders are awful. I guess you get away with it because the USA is so large that most people rarely leave, so rarely have to experience it.

New comment by wmanley in "The state of the kernel Rust experiment"

wmanley — Fri, 19 Dec 2025 13:16:58 +0000

I guess that means you're using the colloquial meaning of the word safety/unsafe rather than the rust definition. It's worth being explicit about that (or choosing a different word) in these discussions to prevent confusion.

For Rust safety (meaning no UB) most definitely is a property of the language. If a module does not contain unsafe and the modules it uses that do contain unsafe are implemented soundly then there is no UB.

In C UB is a part of the language.

New comment by wmanley in "The state of the kernel Rust experiment"

wmanley — Fri, 19 Dec 2025 11:23:44 +0000

> in C only specific language features are unsafe and not all code

Using rust's definition of unsafe which is roughly "can cause undefined behaviour" then it seems to me isolating use of these features isn't possible. What is C without:

* Dereferencing pointers * Array access * Incrementing signed integers

You can do all of the above without invoking UB, but you can't separate the features in C that can cause UB from the ones that can't.

New comment by wmanley in "100k TPS over a billion rows: the unreasonable effectiveness of SQLite"

wmanley — Tue, 02 Dec 2025 19:38:12 +0000

Use a connection per-thread instead. By sharing a connection across threads you’ll be limiting concurrency - and transactions won’t work as you’d expect. SQLite connections are not heavy.

Also: use WAL mode and enable mmap.

New comment by wmanley in "Migrating the main Zig repository from GitHub to Codeberg"

wmanley — Thu, 27 Nov 2025 07:41:26 +0000

Retries won’t work in that case. Would be better to have two endpoints: get the time in x seconds and wait until time passed. That way retrying the wait endpoint will work fine and if time hasn’t elapsed it can just curl itself with the same arguments.

New comment by wmanley in "Drawing Text Isn't Simple: Benchmarking Console vs. Graphical Rendering"

wmanley — Wed, 12 Nov 2025 11:03:22 +0000

No, actually the biggest difference is removing the `filter` property from the `.wave2` class which is used for rendering the background. With that removed the page is responsive even with the backdrop-filter - and it makes no visual difference AFAICS.

New comment by wmanley in "Drawing Text Isn't Simple: Benchmarking Console vs. Graphical Rendering"

wmanley — Wed, 12 Nov 2025 09:56:40 +0000

It's also perfectly responsive if you disable JavaScript. Maybe something related to the --positionX and --positionY CSS variables that are updated on every mouse move?

New comment by wmanley in "Laptops with Stickers"

wmanley — Wed, 12 Nov 2025 09:53:19 +0000

What stickers did you used to have? I'm always fascinated with how people change their mind.

New comment by wmanley in "Drawing Text Isn't Simple: Benchmarking Console vs. Graphical Rendering"

wmanley — Tue, 11 Nov 2025 17:13:54 +0000

Looks like it's caused by `backdrop-filter: blur(6px);` on `.menu-content`. After disabling that it's slow, but not that slow.

Edit: This is with Firefox 144 on Ubuntu 22.04

New comment by wmanley in "The future of Python web services looks GIL-free"

wmanley — Sat, 25 Oct 2025 22:50:51 +0000

Even with volatile it’s a load and then a store no? It may not be undefined behaviour, but I don’t think it will be atomic.

New comment by wmanley in "Keeping SSH sessions alive with systemd-inhibit"

wmanley — Thu, 18 Sep 2025 13:43:53 +0000

> SSH is a "legacy protocol" and its users are "uneducated troglodytes",

Who are you quoting here?

New comment by wmanley in "Just Use HTML"

wmanley — Tue, 16 Sep 2025 19:46:36 +0000

With jinja you’d use template inheritance and just update the base template for this:

https://jinja.palletsprojects.com/en/stable/templates/#templ...

New comment by wmanley in "Next.js is infuriating"

wmanley — Tue, 02 Sep 2025 15:17:38 +0000

And also:

> and so have 4 different libraries they rely on

HTMX has no dependencies. https://htmx.org/essays/vendoring/

> and actually the most up to date version of two libraries you rely on are not interoperable right now because they depend on different node versions

HTMX has no build step. https://htmx.org/essays/no-build-step/

New comment by wmanley in "Unexpected productivity boost of Rust"

wmanley — Thu, 28 Aug 2025 16:02:13 +0000

> Its always funny when i see these kinds of posts.

What's funny about it?

New comment by wmanley in "Object-oriented design patterns in C and kernel development"

wmanley — Wed, 27 Aug 2025 17:14:54 +0000

It’s not about ‘this’ being a global, it’s if you see ‘i++’ in code it’s not obvious if ‘i’ is a member or not without having to check context.

New comment by wmanley in "Will Smith's concert crowds are real, but AI is blurring the lines"

wmanley — Tue, 26 Aug 2025 14:21:44 +0000

People over 35 are the people with money. I can't imagine a bunch of 16 year olds paying £300 to go and see Oasis in the 90s, but those 16 year olds are now in their 40s and now have money and an opportunity to live their adolescent dream.

New comment by wmanley in "Prime Number Grid"

wmanley — Tue, 19 Aug 2025 10:11:46 +0000

Scaling is already supported - try Ctrl+Mouse Wheel or pinch to zoom on mobile. It also supports writing an image with the keyboard shortcut "Print Screen".