HNHacker News
TopNewBestAskShowJobs

Spixel_

36 karma · joined February 8, 2017

submissionscomments
Spixel_··on Cartographers of North Korea (2019)
I love how the data is laid out. It's easy to read and shows real care. I expected to lose my current nav when I clicked on an individual response, so I was pleasantly surprised when I didn't.
Spixel_··on AI is slowing down
The studies you are talking about are probably outdated, it's difficult to deny the actual productivity boost of coding agents.

I'm not talking about the quantity of code produced, but about actual user needs that are now resolved that would not have been before.

The main productivity gain will not come from existing software engineer, but from people that couldn't code at all before but are now able to do things by themselves. We are still very early.

Spixel_··on Elixir v1.20: Now a gradually typed language
Some do, but the DX was bad last time I tried, I did not find a way to use it with my setup.
Spixel_··on Elixir v1.20: Now a gradually typed language
I meant that it doesn't get much love from the community, it's pretty clear it's not used much, that's why things like `dbg` gets added to the language.
Spixel_··on Elixir v1.20: Now a gradually typed language
Almost nobody uses it though, which is too bad, especially since multi-head functions sometimes make it difficult to follow the execution path.

I'd like to do step by step but I cannot plug the debugger to VScode from inside a docker container.

Spixel_··on Anatomy of the .claude/ folder
T'es perdu, chaton ?
Spixel_··on Atlassian to cut roughly 1,600 jobs in pivot to AI
Notion is nice
Spixel_··on Firefox 148 Launches with AI Kill Switch Feature and More Enhancements
They all seem like great features.
Spixel_··on I tried building my startup entirely on European infrastructure
I agree with them, the French translation is way too casual/aggressive compared to the English text.

I wouldn't trust this website.

It comes across as influencer speech targeted to edgy young people with a touch of "how do you do, fellow kids?".

Pretty sure a modern LLM would yield a better one.

Spixel_··on Show HN: SQL-tap – Real-time SQL traffic viewer for PostgreSQL and MySQL
Maybe consider renaming this since pgTAP [0] exists and has nothing to do with this.

[0]: https://pgtap.org/

Spixel_··on SQL needed structure
You are right, but note that the default isolation level is "Read committed" in postgres.
Spixel_··on SQL needed structure
Read committed (which is the default), doesn't guarantee that. See "Nonrepeatable Read" and "Phantom Read" which are both possible in your documentation page.
Spixel_··on SQL needed structure
I don't get the transaction bit. At least with postgres, a transaction doesn't guarantee that all statements in it see the data at the same point in time (actually, it's not even guaranteed for subqueries).

Also, often, the transactional database servers is more difficult to scale than application servers so from a technical standpoint, it makes sense to do this glue work in app code.

Spixel_··on Next.js 14
We migrated to Remix a few months ago, never going back.
Spixel_··on Next.js 14
That would be Remix: https://remix.run

See: https://www.epicweb.dev/why-i-wont-use-nextjs

Spixel_··on Absolute truths I unlearned as junior developer (2019)
Comments aren't bad per se, but they should explain Why vs. How.
Spixel_··on Crabs evolved at least five times from separate groups of crustaceans (2021)
You should play Obra Dinn.
Spixel_··on Python Coding Style Compliance on Stack Overflow
> Given how much programming now consists of "copy, paste, and modify," enforcing style conventions on Stack Overflow might do more to improve general coding standards than anything else we could try.

I'm guessing most of developers use a formatter like black [0] nowadays so that will have less and less impact.

[0]: https://github.com/psf/black