HackerTrans
TopNewTrendsCommentsPastAskShowJobs

islandert

no profile record

Submissions

Ask HN: How did you accidentally build a database?

2 points·by islandert·3 lata temu·1 comments

comments

islandert
·2 lata temu·discuss
Would the JVM ecosystem almost be a working example of this? Since there are a variety of languages with editor integration that all compile down to the same byte code, it feels pretty close to what you’re describing.
islandert
·2 lata temu·discuss
I made a CLI tool called kilojoule that is similar to jq. I addition to the normal suite of JSON manipulations, it also has support for a couple of other file formats and can call other shell commands.

https://github.com/stevenlandis/kilojoule

I’ve found it to be a pleasant multi tool for interacting with the shell when I need something a little more than bash.

It took a couple of weekends and evenings to get working but was a really fun way to learn about parsers, interpreters and Rust.
islandert
·2 lata temu·discuss
TikTok?
islandert
·2 lata temu·discuss
If you don't have access to COPY if the postgres instance is managed, I've had a lot of luck with encoding a batch of rows as a JSON string, sending the string as a single query parameter, and using `json_to_recordset` to turn the JSON back into a list of rows in the db.

I haven't compared how this performs compared to using a low-level sql library but it outperforms everything else I've tried in sqlalchemy.
islandert
·2 lata temu·discuss
I love that writing LLM-friendly docs is just... writing good docs. There's a ton of overlap between accessibility work and preparing things to be used by LLMs.

I wonder if an unintended side effect of this AI hype cycle is a huge investment in more accessible applications.
islandert
·2 lata temu·discuss
There’s a straightforward way to reach this testing state for optimization problems. Write 2 implementations of the code, one that is simple/slow and one that is optimized. Generate random inputs and assert outputs match correctly.

I’ve used this for leetcode-style problems and have never failed on correctness.

It is liberating to code in systems that test like this for the exact reasons mentioned in the article.
islandert
·2 lata temu·discuss
Not high level but a RTO policy seems like an easy way to downsize without having to fire people now that interest rates are higher.
islandert
·3 lata temu·discuss
I'm finishing up reading Cadillac Desert, a book describing the history of dam building and irrigation project in the US. It goes deep into all aspects of irrigation projects from environmental to economic to political.

Very cool to hear that this dam is getting torn down just 30 years after the book was published.