HNHacker News
TopNewBestAskShowJobs

Jarwain

1,379 karma · joined August 10, 2015

[ my public key: https://keybase.io/jarwain; my proof: https://keybase.io/jarwain/sigs/AV0SQmJodiY9H26NcODWIHkTImQOF4ThsfpgMpjcalk ]
submissionscomments
Jarwain··on Using an $8 smart outlet to avoid brainrot
I find it has a lot to do with activation energy, or how much friction there is.

If something is too easy, it happens. If something is too hard/annoying to do relative to the reward, it doesn't.

When I lived in Boston, I was able to get myself to go to Tae Kwon Do classes because it was literally on my commute. When I'd work from home, I'd end up missing the class. When covid hit, same.

When I lived in Palo Alto, I rarely went to the city (and usually only when I could crash at a friend's place for the weekend) because the process of biking to caltrain, take caltrain, bike to wherever I wanna go, then reverse on my way home or catch an Uber, kinda ends up being an annoying or expensive process.

When I moved to SF, I went and partied what was probably more frequently than was healthy. Moving to Oakland brought the rate back down again, but to a level that felt a little too isolating. Getting a car seems to hit a sweet spot; driving isn't too bad, and I have a lot more options. Buuut being responsible for a car curbs the worse behaviors.

Jarwain··on Timescale Is Now TigerData
Hey I mean I'm not super likely to use both tiger data and tiger graph, but using both tailscale and timescale has resulted in some awkward mixups
Jarwain··on The principles of database design, or, the Truth is out there
That's a good reason! I think with UUIDv7, because it's sequential it's indexes are faster than UUIDv4. Still larger than bigints though. I'd like to do a benchmark at some point
Jarwain··on DuckLake is an integrated data lake and catalog format
Too late to edit buuut

There's a standard! (for time intervals, and I could see it working here)[0]

> Section 3.2.6 of ISO 8601-1:2019 notes that "A solidus may be replaced by a double hyphen ["--"] by mutual agreement of the communicating partners",

So forget what I said; why exacerbate the standards problem?[1]

[0]https://en.wikipedia.org/wiki/ISO_8601#Time_intervals [1]https://xkcd.com/927/

Jarwain··on Human coders are still better than LLMs
I find it very much depends on the LLM you're using. Gemini feels more likely to push back than claude 3.7 is. Haven't tried claude 4 yet
Jarwain··on DuckLake is an integrated data lake and catalog format
I'm not super sure about it being in the filename, if only because my understanding is that some of the lakes use it for partitioning and other metadata (metameta-data?).

Imo range is probably the most useful statistic in a folder/file name anyways for partitioning purposes. My vote would be for `^` as the range separator to minimize risk of collision and confusion. i.e. `timestamp=2025-03-27T00:00:00-0800^2025-03-30-0700` or `hour=0^12`,`hour=12^24`. `^` is valid across all systems, and I'd be very surprised if it was commonly used as a property/column name. Only collision I can think of is that its start-of-line in regex

Jarwain··on DuckLake is an integrated data lake and catalog format
That's fair! I guess I see it as trading technical complexity with the human complexity of getting everyone on board with an update to the standard, and getting that standard implemented across the board. It's a lot easier to get my coworkers to just use duckdb as a reader/writer with ducklake than to change the system.

Frankly, I'm not entirely sure what the process of proposing that change to the hive file scheme would even look like

Jarwain··on DuckLake is an integrated data lake and catalog format
Maybe I'm misunderstanding something about how ducklake works, but isn't that the purpose of the 'catalog database'? To store the metadata about all the files to optimize the query?

In theory, going off of the schema diagram they have, all your files are listed in `data_file`, the timestamp range for that file would be in `file_column_stats`, and that information could be used to decide what files to _actually_ read based on your query.

Whether duckdb's query engine takes advantage of this is a different story, but even if it doesn't Yet it should be possible to do so Eventually.

Jarwain··on Show HN: SweepIQ – A simple AI tool to help you learn more, faster
First counterexample that comes to mind, you're traveling to a country for one reason or another, and it'd be helpful to learn or know more of the language. The faster you learn, the more helpful it'll be.

Another example, your friend's band's guitarist got sick and you've got a week to learn a full set's worth of music

Generally I find some urgency to be a nice motivator

Jarwain··on OpenAI to buy AI startup from Jony Ive
I mean no, but it could also be plausible deniability?
Jarwain··on The principles of database design, or, the Truth is out there
Why have a bigint numerical ID at all?
Jarwain··on Ditching Obsidian and building my own
oooh I love that. That also hits my qualms with notion too!

I think I'm sold. Thank you for answering all of my questions so thoroughly.

Jarwain··on The principles of database design, or, the Truth is out there
Sorry I'm a bit confused.

I'm in agreement that a natural key shouldn't be used as the primary key for a record.

I was responding to a comment about having a hidden "database ID" (which I interpreted as being a serial key?) and a public "Uuid", and questioning the utility of that hidden database ID versus having a public UUIDv7 as the sole primary key, followed by questioning whether the utility of obscuring that primary UUIDv7 is worth the complexity of having to manage multiple artificial keys.

I agree that security through obscurity is a valuable layer in a multi-layered security position.

I guess I just don't think obscuring a Uuid primary key is worth the added complexity in most systems.

I see it like adding a second front door to your house with a separate set of keys. Sure it'd be more secure, but it's an added pain and doesn't help if you don't have a sturdy doorframe, or smash-resistant windows.

Jarwain··on Ditching Obsidian and building my own
Oh that all sounds super neat!

My current workflow is to drop almost everything into my daily notes, whether time-based, time independent, or reference. The non-time-based notes I'll #tag and logseq will create a new page for the tag or add the block to that page's references.

That way I have both my thoughts on a #topic, and when I thought about it. If I go back and look at the topic and notice a bunch of notes about it spread across time I know that it's a more consistent interest of mine, and can consolidate that info into the body of the topic page, and might start adding further thoughts there directly.

Generally my goal is to get a distraction out of my head ASAP in a way that I feel like I'll be able to find it again later or it'll otherwise be useful, so that I can keep focusing on whatever I'm currently trying to do. Sometimes that'll mean I have notes on two or three different topics on the same daily page that's easy for me to hop between and add to, but it also stays relatively organized.

The other thing I like are "unreferenced blocks" where if I don't think to tag a stray thought I have about, say, RAG, it'll still show up on my #rag page.

Jarwain··on Ditching Obsidian and building my own
Book is exactly what I was thinking of!

I think my only other question is around my preferred "Daily Journal" workflow and unreferenced tags

On one hand I feel some surprise that you're noting a distinction between metadata/tags for collections of notes vs collections of blocks. On the other hand, it's a bit of a peeve of mine that there's a distinction between "pages" and "blocks" in logseq when it comes to linking & referencing.

Jarwain··on The principles of database design, or, the Truth is out there
I thought we were talking about UUIDv7, which is random enough to make this not a problem right?
Jarwain··on The principles of database design, or, the Truth is out there
So you've got a database ID, either serial or uuid? And you encrypt it when you send it to the user, maybe encrypted against their JWT or something to maintain stateless sessions?

And I guess if the user references specific resources by ID you'd have to translate back? Assuming the session has been maintained correctly,which I guess is a plus for stateful sessions. And it doesn't really matter if you get a collision on the encrypted output.

I spent enough time in the nibling comment talking about my doubts about that advice not to publicly share the identifying key. But I'll add one more point; it feels like a bunch of added complexity for marginal benefit.

Jarwain··on The principles of database design, or, the Truth is out there
Idk that reeks of security through obscurity to me. Your authorization/permission scheme has got to be fubar'd if you're relying on obscuring IDs to prevent someone from accessing a resource they shouldn't.

I'm sure I'm missing something obvious, but I'm not sure what other threat vectors there are, assuming it's in conjunction with other layers of security like a solid authorization/access control scheme.

I guess I'm not the biggest fan for a few reasons. I'd rather try and design a system such that it's secure even in the case of database leak/compromise or some other form of high transparency. I don't want to encourage a culture of getting used to obscurity and potentially depending on it instead of making sure that transparency can't be abused.

Also, it just feels wasteful. If you have two distinct IDs for a given resource, what are you building your foreign keys against? If you build it against the hidden one, and want to query the foreign table based on user input, you've gotta either do a join or do a query to Get the hidden key just to do another query. It just feels wasteful.

EDIT: apparently RFC 4122 even says not to assume UUIDs are hard to guess and shouldn't be used for security capabilities. So if it shouldn't be depended on for security, why add all this complexity to keep it secure?

Jarwain··on The principles of database design, or, the Truth is out there
Why have both a database ID and UUIDv7, versus just a UUIDv7?
Jarwain··on Ditching Obsidian and building my own
Trillium looks great! I'm curious if it has an outliner mode or something similar? I currently use logseq and the two features I love are how each bullet/block is its own thing that can be cross-referenced and embedded in other blocks and pages, and that my workflow is essentially to have daily journal pages I dump everything into and tag and references/crossreferences are automatically handled and linked to build out a network of things.

I've noticed that trillium has hierarchical notes; is there a view to look at an item higher on the tree and have it also have the contents of all its children?

Jarwain··on Ditching Obsidian and building my own
As does tailscale!
Jarwain··on Coding without a laptop: Two weeks with AR glasses and Linux on Android
Ive been thinking the same thing! Except with Code-server or some other way to get vscode's remote over ssh
Jarwain··on You do not need NixOS on the desktop
Just wait until LLM's and mcp matures; why tap tap tap your phone when you could just talk to Jarvis
Jarwain··on Show HN: Self-Funded Game with Homemade Engine – Play Online, Steam Coming
Not necessarily? It just started autoplaying on mobile
Jarwain··on BuyMeACoffee silently dropped support for many countries (2024)
Unfortunately, for most people, all coins get rolled up into "crypto" and "nfts" which share reputation.

As for Jarwain-Immibis Bond Token, well that depends on how one assesses trust, which in the most cynical sense comes down to the repercussions involved in breaking the bond.

Jarwain··on BuyMeACoffee silently dropped support for many countries (2024)
I've always found it ironic how crypto basically make it not necessary to trust, but nobody trusts it.
Jarwain··on BuyMeACoffee silently dropped support for many countries (2024)
Another way to see it is that physical $100 has $300 of value.

But eventually, Alice wants her money back, the bank cashes in the bond, the government repays the cash.

So part of that value is the value of trust as a function of time. Trust in the bank, trust in the government, trust that they'll pay back their debts on a defined schedule. Plus interest.

Jarwain··on The unreasonable effectiveness of an LLM agent loop with tool use
Aider's benchmarks show 4.1 (and 4o) work better in its architect mode, for planning the changes, and o3 for making the actual edits
Jarwain··on Internet Roadtrip: Vote to steer
Also the vote timer is shorter if there's only one option!
Jarwain··on Internet Roadtrip: Vote to steer
I've found it to not work consistently. When I first started it showed the whole thing, but after playing for a while and some refreshes it only shows the path that this browser has seen. So if I switch apps for a while with it running in the bg, then come back, it skips straight from where we were when I last played to where we are now
← PreviousPage 3 of 26Next →