HNHacker News
TopNewBestAskShowJobs

l5870uoo9y

1,200 karma · joined May 18, 2017

submissionscomments
l5870uoo9y··on SQL Tips and Tricks
And I take it CTEs are implicitly being discouraged.
l5870uoo9y··on Positive effects of creatine supplementation on memory in healthy individuals
> Creatine supplementation enhanced measures of memory performance in healthy individuals, especially in older adults (66–76 years).

Of course, it remains unknown if natural dietary improvements could have a similar effect without the need to use a chemical supplement where the long-term effects aren't well studied.

l5870uoo9y··on Cloudflare's new marketplace lets websites charge AI bots for scraping
How often are the bots indexing it?
l5870uoo9y··on iPhone 16 is much easier to repair
The problem with EU regulation is basically that it regulates foreign companies and products without creating domestic products.
l5870uoo9y··on Omega-3 intake counteracts symptoms of anxiety and depression in mice
Another important aspect regarding supplements; so few are tested for how well they are absorbed by human digestion.
l5870uoo9y··on What 10k Hours of Coding Taught Me: Don't Ship Fast
When I program something new and challenging, whether I want to or not, I follow Kent Beck's pattern[0]: “Make it work, make it right, make it fast.”. It seems unavoidable.

[0]: https://en.wikipedia.org/wiki/Kent_Beck

l5870uoo9y··on Ask HN: Is it wrong not wanting career progression beyond senior?
I remember working as a student at a narrow magazine in Copenhagen when I started developing. Many of the old journalists there deliberately choose to continue writing articles and in depth stories as opposed to becoming editor or manager. They loved their craft and it fulfilled their aspirations. I find it admirable to follow your passion.

Additionally, you can continuously learn new skills independent of formal role.

l5870uoo9y··on Show HN: Selectable – mobile-friendly Postgres client
The omnipresence of Postgres is impressive.
l5870uoo9y··on Tortured by regrets? A new study details how best to overcome them
The best advice I've read about avoiding regrets was in “A Guide to the Good Life: The Ancient Art of Stoic Joy” by William B. Irvine. William B. Irvine has an entire chapter dedicated to it titled; Fatalism. The basic approach of the Stoics was that the past (and present) should be viewed fatalistically; fate would have it so, and therefore there is no rational (again a key word for the Stoics) reason to regret this or that. Have you spent years coming to one realization or another? Lived too long in one place? Worked too long in the same workplace? It was fated to take so long. The same goes for the present; enjoy it because you can't change it. The future, on the other hand, you must influence to the extent you can.

William B. Irvine starts chapter six with:

> “ONE WAY TO PRESERVE our tranquility, the Stoics thought, is to take a fatalistic attitude toward the things that happen to us. According to Seneca, we should offer ourselves to fate, inasmuch as “it is a great consolation that it is together with the universe we are swept along.”

l5870uoo9y··on US health system ranks last compared with peer nations – report
The UK performs better (third place) than, for example, Germany (second last place). The UK's healthcare system is often heavily criticized as being on the brink of collapse - any explanation for this?
l5870uoo9y··on OpenAI Threatening to Ban Users for Asking Strawberry About Its Reasoning
Can I risk loosing access if any of my users write CoT-leaking prompts on the AI-powered services that I run?
l5870uoo9y··on Learn Git Branching
I have these Git shortcuts stored in my .zshrc file:

# https://stackoverflow.com/questions/4298960/git-add-a-git-co...

git config --global alias.ac '!git add -A && git commit'

git config --global alias.acm '!git add -A && git commit -m'

git config --global alias.ll '!git log --graph --full-history --all --color --pretty=format:"%x1b[31m%h%x09%x1b[32m%d%x1b[0m%x20%s"'

git config --global alias.gst '!git status'

git config --global alias.gca '!git commit -a --amend'

git config --global alias.gp '!git push origin HEAD'

git config --global alias.bd '!git branch -d'

git config --global alias.bdd '!git branch -D'

git config --global alias.mc '!git diff --name-only --diff-filter=U'

git config --global alias.co '!git checkout'

git config --global alias.po '!git push origin'

git config --global alias.cp '!git add -A && git commit -m "Content" && git push'

Out of those, I only – but often – use `git acm` and `git co` and `git po`.

Edit: formatting (oh dear).

l5870uoo9y··on Ask HN: Must-Read Books for Startups?
I recently read Deep Work by Cal Newport and while it isn't specifically about startups it does offer a crucial insights into doing work that is valuable (potentially also monetary valuable). Startups can be run in 1000s different ways, in particular solo-startups, but common for them is that they solve a difficult problem, and that requires deep work.
l5870uoo9y··on How a scientist is pushing to supersize research into ultra-processed foods
Roughly speaking, if you remove Nova class 4 you are back at mid-century eating habits and I doubt anybody would dare to claim that they weren't much healthier than today with 2/3 of US population being overweight. "Unhealthy" groceries still existed, but the quantities consumed were much smaller.
l5870uoo9y··on How a scientist is pushing to supersize research into ultra-processed foods
It is interesting to think of just how massive a shift the food industry, supermarkets and consumers would have to undertake to cut out high-processed foods (supermarkets would have to empty majority of their shelves).

And then additional strides would have to be made to be convert restaurants (not to mention school cantinas) into actually healthy dining places. I don't think a single burger place would survive such an assessment.

l5870uoo9y··on How a scientist is pushing to supersize research into ultra-processed foods
You can use the Nova classification[0] which has 4 groupings. First 3 are nutritionally harmless, the fourth is highly processed.

[0]: https://en.wikipedia.org/wiki/Nova_classification

l5870uoo9y··on Does your startup need complex cloud infrastructure?
> Pieter has built numerous successful micro-SaaS businesses by running his applications on single server, avoiding cloud infrastructure complexity...

From what I understand he employees a dedicated system administrator to manage his fleet of VPS (updates, security and other issues that arise) for 1000s of USD per month.

l5870uoo9y··on Swimmable Cities
Although the outdoor swimming facilities are amazing, the swimming pools used for sports swimming are still few, small and generally overcrowded.
l5870uoo9y··on Why Haskell?
Pure functions are a crazy useful abstractions. Complex business logic? Extract it into a type-safe pure function. Still to "unsafe"? Testing pure functions are fast and simple. Unclear what a complex function does? Extract it into meaningful pure functions.
l5870uoo9y··on Show HN: Node.js ORM to query SQL database through an array-like API
How do you manage database migrations then? Are they in Git repository? Genuinely curious.
l5870uoo9y··on Show HN: Node.js ORM to query SQL database through an array-like API
What I find valuable is that many ORMs provide type support and manage migrations, not so much the day-to-day interaction with the database.
l5870uoo9y··on Americans' love affair with big cars is killing them
I agree they have a considerate and disciplined driving culture, but on the other hand parts of the autobahn are without any speed limitations which increase accidents ("Freie Fahrt für freie Bürger").
l5870uoo9y··on Founder Mode
> So he had to figure out a better way on his own, which he did partly by studying how Steve Jobs ran Apple.

What is the essence of Steve Jobs' management style?

l5870uoo9y··on OpenAI is good at unminifying code
It is also shockingly good at converting/extracting data to CSV or JSON, but not JSONL. Even the less capable model, `gpt-4o-mini`, can "reliably" parse database schemas in various formats into CSV with the structure:

```csv table_name,column_name,data_type table_name,column_name1,data_type table_name,column_name2,data_type ... ```

I have been running it in production for months[1] as a way to import and optimize database schemas for AI consumption. This performs much better than including the `schema.sql` file in the prompt.

[1]: https://www.sqlai.ai/app/datasources/add/database-schema/ai-...

l5870uoo9y··on Vanilla Prime: A simpler, more sustainable way of web development
Not to mention 16 other dev dependency packages.
l5870uoo9y··on Japan on edge of EUV lithography chip-making revolution
Regardless of the immediate ban on ASML, China has made a geopolitical and strategic decision to obtain advanced chip manufacturing capabilities be it in 5, 10 or 20 years. Would be timely if Western politicians showed same concern for national manufacturing capabilities instead of continuously relying on outsourcing.
l5870uoo9y··on StructuredRAG: JSON Response Formatting with Large Language Models
> It may additionally be promising to test Chain-of-Thought (CoT) prompting strategies. This entails adding a “rationale” key to the model’s output such that the additional reasoning improves the performance of the model. However, this will require the output to be a composite object with the additional "rationale" key and string-valued response. Our results suggest that this additional output structure may result in lower success rates. Similar in spirit to structured decoding methods, it may also be helpful to prefix the end of the prompt with “{“ or use the key, such as “{“paraphrased_questions”: [".

For most of my prompts I want CoT.

l5870uoo9y··on Stripe Built One of Silicon Valley's Best Engineering Teams (2013)
> One thing that's worked well for Stripe is bringing on people who didn’t have an immediately obvious role in the organization. If you can think of one thing this person can do, then there’s probably ten more you're not thinking of that he/she can do two months from now. Focusing on hiring to fill a role could make you more likely to sacrifice quality just to get someone with the right skill set.

Essentially DDR state hiring policies that ensured "work" for everyone. Was this part of the reason for the many tech layoffs the last few years?

l5870uoo9y··on Toasts are bad UX
In the examples shown, toasts are misused to display low-quality notifications, e.g. “x has been copied!”. Using toasts to display relevant error messages alleviates several problems:

- they work well in an otherwise cluttered user interface (error messages often break layouts)

- they allow the data layer to be substantially simplified, e.g. no need to store errors, error setters, error getters in Redux or similar

- they allow programmers to implement error handling toasts once and use everywhere

l5870uoo9y··on We survived 10k requests/second: Switching to signed asset URLs in an emergency
10k req/s would potentially crash the ruby proxy server halting the image serving.

Cloudflare is the way to go. I generally serve heavy files, e.g. videos, from a Cloudflare bucket to avoid expensive bills from primary host.

← PreviousPage 5 of 16Next →