Hacker News: atwebb

New comment by atwebb in "Show HN: PostgreSQL index advisor"

atwebb — Mon, 15 Apr 2024 02:39:30 +0000

>Is there really such a thing as a bad query that can be rewritten to give the same results but faster? For me, that's already the query optimizer's job.

I can't tell if your disclaimer covers it but, yes, there are lots of bad queries that take a little bit of a re-write and run significantly faster. Generally it is someone taking a procedural vs set based approach or including things they don't need to try and help (adding an index to a temp table when it is only used once and going to be full scanned anyways). That's outside the general data typing/generally missing indexes.

New comment by atwebb in "Fossil is quitting smartwatches"

atwebb — Sun, 28 Jan 2024 14:28:30 +0000

I was wondering the same thing, the Galaxy Watches (before and after Tizen) have always been solid for me, granted we don't really have Apple products and I get the ecosystem advantage. Samsung does seem to iterate really, really fast...or just not sell out of the prior model.

New comment by atwebb in "Open table formats are inevitable for analytical datasets"

atwebb — Thu, 18 Jan 2024 14:40:42 +0000

I think it is also wrong in the capabilities, example: Redshift should be able to read Iceberg via Redshift Spectrum.

https://docs.aws.amazon.com/redshift/latest/dg/querying-iceb...

New comment by atwebb in "Open table formats are inevitable for analytical datasets"

atwebb — Thu, 18 Jan 2024 14:38:59 +0000

That's what it originally meant, at least in my experience. It was when warehouses got access to commodity storage through virtualization options (Hey! I can read S3 from Redshift and it looks like a Redshift table). Similar to Postgres foreign data wrappers or polybase in sql server.

Databricks (with Delta as the underpinning) seems to have lead the charge of lakehouse meaning, your data lake+file formats/helpers+compute==data lake+datawarehouse==lakehouse.

The latter seems to be the prevailing definition today with the former aging in place.

New comment by atwebb in "Tolkien, 50 Years On"

atwebb — Sun, 03 Sep 2023 15:41:53 +0000

I also isn't accurate. The Elves are generally good but don't help at all costs, they are fairly self-serving (or seem to be). Gollum is a swing b/w pity and anger. Gandalf and Aragorn tend to hide information (for the betterment of the mission it seems). Plenty of other "characters" are self-serving, Eagles, Beorn, Mr. Bombadil. Even Sauron was once good and there's hints that people believe he isn't pure evil or had some good to do.

New comment by atwebb in "AI demand is already shrinking"

atwebb — Wed, 23 Aug 2023 18:25:01 +0000

Even with the graphic in the article, it has tablets in around 2010, there were definitely tablets well before that. They took a while to grow and take off, seems similar here.

New comment by atwebb in "AI demand is already shrinking"

atwebb — Wed, 23 Aug 2023 18:23:35 +0000

I think you're referring to the Gartner hype cycle

https://en.wikipedia.org/wiki/Gartner_hype_cycle

New comment by atwebb in "Uses and abuses of cloud data warehouses"

atwebb — Wed, 16 Aug 2023 15:15:25 +0000

Real-time generally means near-real-time and even then I liken it to availability.

If asked people would say "I need to always be up" until they see the costs associated with it, then being out for a few hours a year tends to be ok.

New comment by atwebb in "Uses and abuses of cloud data warehouses"

atwebb — Wed, 16 Aug 2023 15:13:48 +0000

> run a Python function as a UDF

Is that a differentiator? I'm unfamiliar with Snowpark's actual implementation but know SQL Server introduced Python/R in engine in 2016? something like that.

New comment by atwebb in "Reduced cancer mortality with daily Vitamin D intake"

atwebb — Thu, 11 May 2023 15:09:17 +0000

Late reply, I was wondering that but also, at least in the US, they tend to have older folks and retirees so that it may skew the stats. I really don't have any data on it, just speculating.

New comment by atwebb in "Reduced cancer mortality with daily Vitamin D intake"

atwebb — Tue, 09 May 2023 16:55:08 +0000

Would especially sunny areas not produce people with more cancer (or certain types)?

New comment by atwebb in "US on track to set record in 2023 for mass killings after series of shootings"

atwebb — Tue, 09 May 2023 15:16:59 +0000

Watching city sub-reddits devolve over the years has me feeling the same way. It seems coordinated.

New comment by atwebb in "What's up in the Python community? – April 2023"

atwebb — Fri, 28 Apr 2023 22:25:30 +0000

Lambda support was added this month:

https://aws.amazon.com/about-aws/whats-new/2023/04/aws-lambd...

New comment by atwebb in "US 5-year credit default swaps rise to highest since 2011"

atwebb — Fri, 21 Apr 2023 22:58:11 +0000

There are 4 comments in this thread (5 including mine) and ChatGPT is already mentioned twice. Interesting how quickly things adapt/change.

New comment by atwebb in "Tell HN: The ratio of wants-to-be-hired to is-hiring is at a record high 0.94"

atwebb — Tue, 04 Apr 2023 15:27:00 +0000

Who's hiring also has many positions in each listing though, if that is consistent across time it wouldn't seem to matter as much.

New comment by atwebb in "UK airport scraps 100ml liquid rule with new scanners"

atwebb — Tue, 04 Apr 2023 12:43:54 +0000

Just flew out of Memphis and these (or something very similar) were amazing, it felt archaic flying back and doing it the other way. Security time was a few seconds. Now if I can skip the shoes part...

New comment by atwebb in "Nearly 40% of software engineers will only work remotely"

atwebb — Fri, 10 Mar 2023 14:20:21 +0000

>My kids could walk back from school but primary school do not allows them to get out without me.

Where is this? Our kids flood the park and walk home, that's how it has been in a few places we've lived. Maybe y'all are near major roads or no walkable paths?

New comment by atwebb in "Nearly 40% of software engineers will only work remotely"

atwebb — Fri, 10 Mar 2023 14:19:06 +0000

>I have it on good authority though that kids are distraction machines.

More of a nuance here, they are mainly only distraction machines for 5-7 years, after that it is more about scheduling conflicts and being able to be "present" when they are. Especially for children attending traditional school programs (public or private), they are gone most of the day and then have their own distractions (homework, hobbies, trainings, friends, etc).

New comment by atwebb in "Learnings from employing ChatGPT as a ML Engineer for a day"

atwebb — Wed, 22 Feb 2023 22:19:30 +0000

find replace name with ABCEDFG HIJKLMNOP

feed to ChatGPT

find replace ABCEDFG HIJKLMNOP with name?

New comment by atwebb in "Why Steam Deck Is One of the Most Significant PC Gaming Moments in Years"

atwebb — Wed, 08 Feb 2023 20:53:46 +0000

>The docking to a TV / monitor is a joke with the standard UI...I have never gotten it to work well, so if I need to dock I have to go into desktop mode.

Really? I'm just using an Anker USB-C dock and it works fine, everything runs great and it allows me to charge as well.