HNHacker News
TopNewBestAskShowJobs

jakswa

284 karma · joined August 19, 2012

https://jake.town
submissionscomments
jakswa··on Implementing "seen by" functionality with Postgres
I just wanted to say thanks for linking. I feel like I'm always on the search for new PG storage extensions, even if I'm not able to use them everywhere (sad to see AWS RDS wasn't in list of vendors that include/support it).
jakswa··on AWS SNS vs. SQS – Main Differences
If you're coming from a ruby/sidekiq/redis land, there is a sidekiq-inspired repo trying to make the transition easy https://github.com/ruby-shoryuken/shoryuken
jakswa··on Long-Chain Omega-3 Fatty Acids Improve Brain Function, Structure in Older Adults (2014)
I'm no nutritionist but I read that one source might be: high-oleic sunflower canola oils.

> Sunflower oil is naturally high in polyunsaturated fatty acids, which are great for frying and cooking with but can expire quickly. To remedy this, harvesters have bred a healthier form of this oil that is lower in polyunsaturated fats and higher in oleic acid.

https://soylent.com/blogs/news/healthy-plant-fats-your-body-...

jakswa··on Moving a macOS window by clicking anywhere on it
on gnome 42 it is middle click! you drove me to experiment, thanks
jakswa··on Show HN: Warp, a Rust-based terminal
Odd naming choice. "Warp" is already a rust crate and it's sitting at many more stars than this product https://github.com/seanmonstar/warp
jakswa··on Happy 10th Birthday, Sidekiq
Sidekiq has stayed with me for most of my rails projects. Happy to read this. And I bet I'll continue to remember it as I run into projects that were inspired by it, like Shoryuken (which tries to be "sidekiq for AWS SNS/SQS" https://github.com/ruby-shoryuken/shoryuken).
jakswa··on OneWeb will resume satellite launches with SpaceX as the launch provider
I assume by "operating telecomm satellites" you mean operating starlink? Last I read, SpaceX hoped to spin starlink out into a separate business, and even IPO it. So in the long run, it didn't seem like SpaceX wanted to count on the starlink market revenue. I'd be curious to hear that this is outdated/wrong now. It was interesting at the time because Musk has said he intends for SpaceX to stay private forever.
jakswa··on Towards a unified theory of web performance
I still remember how excited I was as a wannabe fullstack rails dev in 2012 trying explore more single-page-style UX. It felt like I was pursuing the "unified web" theory this article's title sucked me in with. "Could I make the UI less sluggish by writing a boatload more JS?" types of thoughts.

Ten years later we still have backend-rendered and frontend-rendered camps. Some of my rollercoaster ride has been filled with useless pursuits (coffeescript! I used to love how clean it was. Old style angularjs jargon like `$scope` and directives. The list goes on...). But overall I strangely think it has been worth it to keep up. The main champions have been SQL, HTML, and JS -- I use them heavily, across whatever newfangled trend I'm pursuing. I'm thankful a lot of what I learned over the years is still applicable, even as I (willingly) get yanked around by the hottest trends.

jakswa··on What is the purpose of check-in before flying? (2014)
Personal anecdote: I've found the tickets can be refunded/transferred. The airline recommended a 45min layover, and the airport's immigration machines broke and we were stuck in line for hours, missing our domestic flight in a separate area of the airport. In this case, I found out that the airline would've worked with me to reschedule another flight, if I could get ahold of them on the phone. Maybe not all airlines are like this, just one case.
jakswa··on Panasonic to begin mass producing new 4680 Tesla battery by March 2024
No problem! I keep it in mind because I keep hoping I see an updated report some day that goes that in-depth. Or possibly a report that refutes/contradicts what I've read. They dug into the USA regional energy mixes in the report I linked! And they claimed to include transmission + charging efficiency losses. I was surprised at how comprehensive it seemed.

edit: this report https://www.ucsusa.org/sites/default/files/attach/2015/11/Cl...

jakswa··on Panasonic to begin mass producing new 4680 Tesla battery by March 2024
Union of Concerned Scientists still did the most in-depth analysis I've seen, and they agree with the ~6mo-18mo time period to offset the more-intensive manufacturing. And it's so old now that I think you can assume the transition to cleaner grids has progressed further in some cases.

https://www.ucsusa.org/resources/cleaner-cars-cradle-grave

jakswa··on Slack is down for some users
I still have my pitchfork from all the bugs I encountered when they released the new formatting (still works wonky depending on the workspace for me). That said, I believe this is an option since they changed things:

  I have yet to hear a good argument for not having a little button to enable raw Markdown mode.
That toggle is buried in the preferences/settings under "advanced."

  Format messages with markup
  The text formatting toolbar won’t show in the composer.
jakswa··on I think I know why you can't hire engineers right now
Haha me and you both. I'll be honest I saw the "amazon pays $300k for rust" comment in this thread and I checked back in to make sure they don't have any remote positions... And I avoid amazon recruiters like the rest.
jakswa··on Self-Hosting Dozens of Web Applications and Services on a Single Server

  My only, tiny gripe would be excessive space consumption on the somewhat small 20gb SSDs you get with Hetzner VPSs.
I was trying to imagine the reason for this. Is it that dokku is similar to heroku, and does a build step upon git-push-to-deploy? So assets/compilation/etc have artifacts and a cache that sticks around to help speed up future pushes/builds?
jakswa··on Linux Has Grown into a Viable PC Gaming Platform and the Steam Stats Prove It
Yes! I had this same experience. I was in linux + steam for a while before I realized I had to opt into proton-ifying windows games. They should enable this by default and keep providing good UX about it being in play in case you want to disable it.
jakswa··on Linux Has Grown into a Viable PC Gaming Platform and the Steam Stats Prove It
Been several years since I even considered bringing a windows partition back to play some new game. It's pretty rare that I run into a game I want to play that isn't well-reviewed on protonDB. Albeit, I am only commenting because I went to launch a game just now and am sitting here waiting on the "Processing vulkan shaders" pre-launch step (that only processes shaders once afaik).
jakswa··on The FAANG Market Is Fading
I don't include microsoft so I can say they're "working for the MAAAN."
jakswa··on Do Dev Careers Die at 35?
34 reporting in, still just coding and avoiding leadership/management roles
jakswa··on PostgreSQL Subtransactions Considered Harmful
Am I right to interpret this as "do a non-changing UPDATE so that you get a returned row"? It's another great idea I hadn't considered, thank you. I'm worried this causes the row to get re-written on disk (an actual UPDATE, even though values aren't changing). That could be a moot concern, I'll dig more.
jakswa··on PostgreSQL Subtransactions Considered Harmful
It's a good idea to revisit, but I think I need SELSERT or something. Are you saying the `DO NOTHING` clause can still result in a row being returned with `RETURNING *`? My impression is that it can't but I'd be excited to be wrong!

edit: Ah, I bet the implicit suggestion was to do `INSERT ... ON CONFLICT DO NOTHING RETURNING *` and if no row was returned, you hope to know/guess the conflict and do an extra `SELECT`. I'll think more on this, thanks.

jakswa··on PostgreSQL Subtransactions Considered Harmful
My fuzzy take on a concern here could be: storage costs and memory usage. My impression is that it is written/copied to actual rows as xmin (https://www.postgresql.org/docs/current/ddl-system-columns.h...). So loading X rows from disk into memory is loading X transaction IDs into memory.

That said, I'm not sure the concern holds water. At 2bil rows we're talking 7.4GiB of disk vs 15GiB. Depending on what % of your database you want to keep in memory, maybe it goes ok.

jakswa··on PostgreSQL Subtransactions Considered Harmful
Unique constraints roll your transaction back. Put your `INSERT` in a nested transaction and you can fall back to `SELECT`, and keep going without throwing away previous work. In multi-table, write-heavy workloads, this insert-or-select path begs for nested transactions so you can lean on uniqueness constraints while keeping your transaction afloat. So far I'm not convinced to abandon that pattern by this article, but I'll keep an eye out for a happier path I guess.
jakswa··on Electric Cars and Batteries: How Will the World Produce Enough?
I wish utilities were more open about this data. I would love to see if EVs have done a good job (or maybe too good a job*) flattening out the overnight demand curve. Back in 2012, Georgia Power evangelists were marketing this as a path to greater efficiency: The "base load" caters to minimum demand, and if the curve flattens out, the way I understand it, they can get rid of some of that temporary/spiking demand generation.

But that's not saying it's better for the environment. Here in georgia, my impression is that base load is coal generation, and the more expensive natural gas peaker plants are actually cleaner-burning? The desire for more data is to really just verify all these half-baked impressions in my brain.

jakswa··on Mars has right ingredients for present-day microbial life: study
The fear I read is that we might be accidentally eradicating any life we don't yet know about, if we introduce life from earth.
jakswa··on We found and fixed a rare race condition in our session handling
This is what I'm going to be digging for later... I'm wondering if puma also shares `env` objects across requests.
jakswa··on AMD vs. Intel vs. Nvidia: How Users Are Switching
I keep flip-flopping between these as my needs change. I flipped to proprietary last time I tried some Steam games. I will gladly switch back to open source drivers if I'm wrong in thinking game performance on linux will suffer?
jakswa··on Open source means surrendering your monopoly over commercial exploitation
The time limit on patents/copyright imply to me that they are giving you time to recoup costs and enjoy the reward of your innovation. If that's so, I'd argue that over the last century the time required to enjoy innovation (time to market saturation) has gone down. Even for physical goods? I think that the radio took decades to become widespread. The ipod took... a few years?

All that to say, maybe virtual innovation takes even less time, and should have less time to enjoy monopoly? But I'm only playing your devil's advocate.

jakswa··on StimulusReflex, or LiveView for Rails
Thanks for posting this. I need to try it out. I'm specifically curious about how it performs when a certain amount of those 20k connections are busy and generating traffic. If I'm understanding, the anycable-go connection to ruby is over RPC? So individual websocket messages generate requests to ruby? I could see this performing better for idle connections, that's for sure.
jakswa··on Signal AppImage for Linux
Same deal on ubuntu/linux! For a year or so I've been really happy with Telegram's resource usage and snappiness.
jakswa··on Cabal: A peer-to-peer, off-grid, community-first, hackable chat platform
"Currently searches across and advertises on the Bittorrent DHT, centralized DNS servers and Multicast DNS simultaneously."
← PreviousPage 4 of 5Next →