Hacker News: jiaaro

New comment by jiaaro in "Has AI tells"

jiaaro — Wed, 14 Oct 2026 17:48:09 +0000

I don't see the source code, where did you find that?

[Edit] Or are you implying that readers should direct an LLM at the entire article and expect an equivalent tool to be produced

New comment by jiaaro in "Avoiding duplicate objects in Django querysets"

jiaaro — Wed, 28 Jan 2026 00:08:56 +0000

Exists is a useful tool that you should certainly know how to use. Whether or not it's faster than distinct depends on the rest of the query. I've optimized queries where distinct is faster than exists. It's been some time, but I think it boils down to the relative sizes of the tables and how many of the exists queries actually find something (and how often they find more than one something).

Also, some databases (like clickhouse) allow for `any` joins which avoid producing duplicate rows. For example:

    select author.*
    from author
    inner any join book on (
        book.author_id = author.id 
        and book.title like 'Book%'
    )

Neon PostgreSQL Tutorial

jiaaro — Mon, 08 Sep 2025 18:23:23 +0000

Article URL: https://neon.com/postgresql/tutorial

Comments URL: https://news.ycombinator.com/item?id=45171899

Points: 1

# Comments: 0

New comment by jiaaro in "Show HN: Shelgon: A Framework for Building Interactive REPL Shells in Rust"

jiaaro — Thu, 06 Mar 2025 22:32:58 +0000

Cool project! But, I wonder how long can a project like this use a Pokemon as their namesake and mascot before you hear from nintendo's lawyers?

New comment by jiaaro in "Kafka at the low end: how bad can it get?"

jiaaro — Wed, 19 Feb 2025 20:54:27 +0000

Random and round robin partitioning are the configurations being discussed.

The main point of the article is that low message volumes mean you can get unlucky and end up with idle workers when there is still work to be done

New comment by jiaaro in "Oracle's Jump to Nashville Surprises Austin"

jiaaro — Thu, 25 Apr 2024 19:43:33 +0000

The linked article says, in reference to Oracle relocating its HQ to Austin:

> Oracle, which was founded in Santa Clara, Calif., in 1977, later had its headquarters in Redwood City. The software giant, at the time of its move to Texas, said that relocation was to allow a more flexible approach to its workforce

> The company had neither asked for nor received economic incentives from Austin to relocate, said city officials. Nashville pledged $175 million in incentives and the state of Tennessee $65 million to help build the Oracle campus in 2021

Franz: Native Kafka Client for macOS, Windows and Linux

jiaaro — Wed, 03 Apr 2024 15:06:28 +0000

Article URL: https://franz.defn.io/

Comments URL: https://news.ycombinator.com/item?id=39918452

Points: 3

# Comments: 0

New comment by jiaaro in "Senior Boeing employee on why he won't fly a MAX: Just Get me Off This Plane"

jiaaro — Tue, 27 Feb 2024 05:29:27 +0000

The main difference is that you wouldn’t instead drive the whole way instead once you find out the risk. But people do drive the same places they fly

New comment by jiaaro in "Show HN: Sqlbind a Python library to compose raw SQL"

jiaaro — Mon, 26 Feb 2024 19:15:14 +0000

`str(queryset.query)` does not give you executable SQL. Query parameters are not escaped or encoded in that representation of the query. That escaping/interpolation of query parameters is performed by mogrify. I agree the name is odd, and I don't know why they use it other than "transmogrify" being an obscure word for "magically transform".

debug_toolbar and silk are both tools that show you what queries were executed by your running application. They're both good tools, but neither quite solves the problem of giving you the executable SQL for a specific queryset (e.g., in a repl).

New comment by jiaaro in "Show HN: Sqlbind a Python library to compose raw SQL"

jiaaro — Mon, 26 Feb 2024 18:18:55 +0000

If you use postgres, psycopg provides `cursor.mogrify(query, params)` which returns the actual query that will be executed . For example:

    cursor.mogrify(*queryset.query.sql_with_params())

Alternatively, you can set the log level of the `django.db.backends` logger to DEBUG to see all executed queries

New comment by jiaaro in "Range Energy's electric trailer can improve semi-truck mpg by 36%"

jiaaro — Mon, 27 Nov 2023 22:03:36 +0000

On the other hand, these things see a lot more annual miles than consumer vehicles so the payback period should be shorter. I agree though, that probably it would require some kind of government involvement to get broad adoption.

Also, I imagine it's easier to find extra space for batteries in the the trailer than the tractor.

Regenerative breaking seems like a more important improvement though.

New comment by jiaaro in "Microsoft fixes the Excel feature that was wrecking scientific data"

jiaaro — Mon, 23 Oct 2023 14:15:41 +0000

I think the suggestion is that a spreadsheet is the not the right tool for the job.

There is very likely value in dedicated genetics-specific software, even in the form of an excel add-on.

[edit] Here's one, and it's free: https://biology-assets.anu.edu.au/GenAlEx/Welcome.html - so maybe this change from microsoft was necessary

New comment by jiaaro in "How to get transactions between almost any data stores"

jiaaro — Wed, 30 Aug 2023 19:17:40 +0000

Based on the paper Dang linked, it appears that epoxy is involved in all queries to all data stores it coordinates

New comment by jiaaro in "How to get transactions between almost any data stores"

jiaaro — Wed, 30 Aug 2023 19:15:45 +0000

Does Epoxy use postgres' own transaction ids across datastores? If not, does it implement its own "transaction id horizon" like postgres has so that you can assume all transactions before a certain counter are committed?

New comment by jiaaro in "3M is paying $5.5B to resolve 300k lawsuits over defective combat earplugs"

jiaaro — Mon, 28 Aug 2023 23:37:19 +0000

I’m not an industry expert either, but ear plugs don’t block sound taking other paths to the ear drum like bone conduction. The mix knob on this limiter can’t be turned to 100%

New comment by jiaaro in "Kafka is dead, long live Kafka"

jiaaro — Mon, 07 Aug 2023 16:34:08 +0000

The blog post mentions that partitions are too low-level an abstraction to program against. Does that mean WarpStream doesn't use partitions?

Do you provide any ordering guarantees like Kafka does at the partition level?

New comment by jiaaro in "Understanding database indexes in PostgreSQL"

jiaaro — Thu, 18 May 2023 04:46:10 +0000

And this is even true for some more exotic indexes where you might not expect it like exclusion constraints with gist. It’s much more expensive to maintain with a range as the first column and a highly selective id for the second column than the other way around (you want the highly selective column first)

New comment by jiaaro in "Freedom Clock"

jiaaro — Sat, 25 Mar 2023 22:00:38 +0000

As an American I can confirm that, not only do we say “4th of July,” both phrasings are in common use for any date of the year.

March 5th is more commonly heard in USA than 5th of March, but nobody would look at you funny either way.

New comment by jiaaro in "A page with no code"

jiaaro — Sun, 22 Jan 2023 03:11:20 +0000

One could argue that for some content, how to style it is just a suggestion anyway. Ie you could think of “our style guide for text content can be found at this address” as metadata for semantic HTML documents

New comment by jiaaro in "Manage like an engineer"

jiaaro — Thu, 12 Jan 2023 21:48:56 +0000

Yeah - It does seem like the author is trying to apply too many lessons learned from managing computers and software to managing people.