Readit News logoReadit News
harterrt commented on SQL style guide by Simon Holywell   sqlstyle.guide/... · Posted by u/thunderbong
SPBS · 9 months ago
> Spaces should be used to line up the code so that the root keywords all end on the same character boundary.

  SELECT file_hash
    FROM file_system
   WHERE file_name = '.vimrc';
This style is annoying and I wish it gained less traction. It looks neat but it puts so much burden on the query writer, especially when you modify the query and all of the sudden you need to indent multiple lines just to make them all align. You know what's neat and still easy to modify/diff? Just indent a new line for each row.

    SELECT
        file_hash
    FROM
        file_system
    WHERE
        file_name = '.vimrc';

harterrt · 9 months ago
Agreed. Fwiw, Mozilla’s style guide prohibits rivers like this.

https://docs.telemetry.mozilla.org/concepts/sql_style

harterrt commented on SQL style guide by Simon Holywell   sqlstyle.guide/... · Posted by u/thunderbong
cwbriscoe · 9 months ago
I am definitely not a fan of that style. Wastes too much vertical space without much benefit.
harterrt · 9 months ago
What would you change?
harterrt commented on SQL style guide by Simon Holywell   sqlstyle.guide/... · Posted by u/thunderbong
yen223 · 9 months ago
Thanks for sharing this!

It looks so much cleaner in my eyes.

Plus it uses constant-sized indents, which means less futzing about with spaces and all that.

Also means you can comment out the first select item, something you can't do with the article's approach.

harterrt · 9 months ago
Yes! I can’t see the point of enforcing fussing with indents to get a river.
harterrt commented on SQL style guide by Simon Holywell   sqlstyle.guide/... · Posted by u/thunderbong
harterrt · 9 months ago
For comparison, here’s Mozilla’s SQL style guide: https://docs.telemetry.mozilla.org/concepts/sql_style
harterrt commented on Ask HN: Could you share your personal blog here?    · Posted by u/revskill
harterrt · 2 years ago
blog.harterrt.com

Mostly data science - been slow lately, but I’m working on a couple pieces again.

harterrt commented on Humans aren’t mentally ready for an AI-saturated ‘post-truth world’   wired.com/story/generativ... · Posted by u/pseudolus
rcktmrtn · 2 years ago
More than interfaces. To quote McLuhan: "Man becomes, as it were, the sex organs of the machine world, as the bee of the plant world, enabling it to fecundate and to evolve ever new forms. The machine world reciprocates man's love by expediting his wishes and desires, namely, in providing him with wealth."

The AI thing has been jarring but it's nothing new. All part of the same process.

harterrt · 2 years ago
Thanks for sharing. I want to hear more from him. Do you have a recommended book by McLuhan to start with?
harterrt commented on ChatGPT vs. Bard: A Realistic Comparison   blog.theapricot.io/posts/... · Posted by u/brianpk
OkGoDoIt · 2 years ago
Two spaces is less tokens, might actually be a good thing overall to limit token usage so you can fit more code in the context window. It’s easy enough to have your IDE convert it to your preferred format after generation. But I am a diehard fan of tabs over spaces, so I guess I’m used to converting incorrectly formatted code anyway ;-)
harterrt · 2 years ago
First time I've seen a good argument for tabs over spaces. Richard Hendricks would be proud
harterrt commented on Launch HN: Electric Air (YC W23) – Heat pump sold directly to homeowners    · Posted by u/cmui
gumptionary · 2 years ago
Love what you're trying to do. I recently moved most of the way off oil-based hydronic baseboard heating in my 1800's New England farmhouse through installing 3 ductless mini-splits with Mitsubishi Hyper Heat condensors. Just to help with your user research, my biggest decision points:

1. Cold weather operation. I get you're saying the units are good down to -15f, but there's nothing like the fact that I can talk to plenty of other people who have good experiences with Hyperheat at -15f to ensure that they'll actually work. Given I'm using these primarily for heat (the AC is a bonus), if they didn't heat well and efficiently at 0f then it was all pointless. 2. Repairability. Again, given I'm trying to use these as my primary heat, I need to know I'll have someone who will service the unit who can be here in a matter of hours. This is why I went away from the DIY route. Most installers around here (semi-rural New England) are super brand aligned and won't service the stuff they don't install.

Would be happy to help with user research if you're looking for folks to talk to.

harterrt · 2 years ago
+1 to servicability. It's hard to get someone who knows how to clean my minisplits. This looks really cool, but I'd need to be confident that I could maintain my units myself.
harterrt commented on Notes against note-taking systems   sashachapin.substack.com/... · Posted by u/Tomte
hyperrail · 3 years ago
I'm having some trouble understanding what note-taking systems the author is attacking. There are some hints:

> Getting lost in your knowledge management system is a fantastic way to avoid creating things.

> All of the above applies to reading books about note-taking, taking courses about note-taking, and watching videos about note-taking.

> I am waiting for any evidence that our most provocative thinkers and writers are those who rely on elaborate, systematic note-taking systems. I am seeing evidence that people taught knowledge management for its own sake produce unexciting work.

It sounds like Mr. Chapin is referring to formalized techniques or processes for format and organization of notes. But he doesn't give any examples, and I'm not familiar with the ones he hints at - I've never watched any YouTube videos on note taking or read any books on organizing your thoughts.

When I was in college, I took detailed notes in paper notebooks, and still do so occasionally when I'm sitting in a lecture. Otherwise, I send narrative emails to myself, write more business-style notes in Microsoft OneNote, or doodle in a small memo pad. It's clear to me that this is not what he means by a "note-taking system," but what is?

harterrt · 3 years ago
Probably he’s referring to zettelkasten systems.

u/harterrt

KarmaCake day301December 20, 2010
About
Principal Data Scientist, Mozilla

http://blog.harterrt.com/pages/about.html#about

View Original