HNHacker News
TopNewBestAskShowJobs

gelatocar

480 karma · joined March 25, 2013

submissionscomments
gelatocar··on Oh My Zsh adds bloat
I switched to zim years ago and found it has all the features that I need but is much faster and I think easier to install (though I haven’t installed either for some time).

https://zimfw.sh/

gelatocar··on From devastation to wonder as Kangaroo Island bushfires lead to cave discoveries
Whenever there are stories about bushfires in Australia there is inevitably discussion about how the regeneration is amazing and how fires are part of the ecosystem. While this is true to an extent, it is important to point out that in recent years due to climate change the frequency and intensity of the fires is causing huge ecosystem change to areas that are burnt multiple times before they can recover.

https://connectsci.au/wf/article-abstract/25/8/831/21102/Too...

gelatocar··on Show HN: An Alfred workflow to open GCP services and browse resources within
@ seems to show a list of configurations, not GCP projects
gelatocar··on Show HN: An Alfred workflow to open GCP services and browse resources within
This is really cool, one thing that would make it much more useful for me is to have the ability to easily select which project you want to use, especially if it could have the same fuzzy search as resources. My company has hundreds of GCP projects. At the moment it seems like I'd have to set up individual configurations for each project.
gelatocar··on Building a better and scalable system for data migrations
I found that liquibase doesn't really support rollbacks, particularly with mysql as you can't do transactions for schema updates, if the migration fails in the middle of an update it just gets left in a half-updated state.
gelatocar··on Show HN: Ambulate – Detailed Trip Planning
I tried using wanderlog on a recent 4 month long trip and it became totally unusable after adding maybe 2 months worth of things to it. It has some really baffling UI/UX decisions too, like not showing the address of accommodations, just the name. Really made me feel like no one working on it had ever tried to use it when actually traveling.

They had also gone big on AI slop for recommendations which made it really hard to trust any advice in the lists of things to do.

I think these sort of travel apps are really hard to find an audience for. Very very few people travel often enough to pay a subscription and it is hard to justify spending significant money as a one-off purchase when traveling is already so expensive.

gelatocar··on David Lynch Interview Project
you don't have to! all the interviews are there now https://www.youtube.com/@davidlynchpresentsIP/videos
gelatocar··on Ask HN: How different is AWS/GCP/Azure in everyday work
I'm surprised that more comments aren't mentioning this. I've recently moved from a stack managed by AWS CDK to one managed by Pulumi on GCP and the difference is stark. The building blocks that AWS provides allow spinning up complex services with relatively minimal configuration. The pulumi code required to create a simple GCP cloud run service with IAP behind a load balancer is literally hundreds of lines.

Plus GCPs documentation is far far worse than AWS's.

gelatocar··on StreamPot: Run FFmpeg as an API with fluent-FFmpeg compatibility, queues and S3
This is great, I don't have a concrete use-case right now but can definitely see myself returning to this in the future. One thing that would be handy is having a way to either accept a ffmpeg cli command, or convert from a cli command to the typescript syntax. My experience with ffmpeg if you often do a lot of copying and pasting of commands from documentation or random guides, it'd save a bit of time if you didn't need to transcribe the commands into streampot's syntax.
gelatocar··on The oldest known recording of a human voice [video]
FWIW I found the whole video quite interesting, I had never really considered that there could be sound recordings from before anyone had thought of a way to play them back. Though I do remember an old mythbusters episode [1] where they tested whether it was possible for audio to be "accidentally" recorded on a pot when a piece of grass happened to mark the pot while spinning.

[1] https://en.wikipedia.org/wiki/MythBusters_(2006_season)#Pott...

gelatocar··on My favourite animation trick: exponential smoothing (2023)
that's ease-out
gelatocar··on Show HN: SQL workbench in the browser
Yep, looking good now, thanks! Other datasets that don't have CORS headers still don't work ie. https://sql-workbench.com/#config=%7B%22plugin%22%3A%22Datag... but I'm guessing that's inherent limitation of running this without a backend
gelatocar··on Show HN: SQL workbench in the browser
Sorry, it seems to still be happening, running:

    SELECT count(*) FROM 'https://data.quacking.cloud/nyc-taxi-data/yellow_tripdata_2023-01.parquet';
Shows the error:

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://data.quacking.cloud/nyc-taxi-data/yellow_tripdata_20.... (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 200.

I get the same issue in both firefox and brave

edit: actually accessing that file directly gets a Access Denied error for me

gelatocar··on Show HN: SQL workbench in the browser
This is great, I've been meaning to build something similar for some time. I tried to run the queries from the tutorial but hit lots of CORS errors loading the datasets, is there any way that you have found to work around those?
gelatocar··on Warning: $14k BigQuery charge in 2 hours
Have you tried getting in touch with GCP to see if they would refund the charge? I've heard plenty of stories of cloud services refunding large one-off accidental spends like this one.
gelatocar··on The weirdest bug I've seen yet
As I was reading this I was thinking to myself "I wonder if it is grammarly related" because I experienced a bug some time ago that presented itself in a similar way. It was impossible to reproduce but affecting lots of people internally within certain departments. Eventually we figured out the thing they had in common was that they had the Grammarly extension installed.

The other key thing was that the bug only appeared on our staging preview urls, not on the live website. It turned out it was because of a bad regex in the grammarly extension that caused the page to hang if the domain name was more than about 100 characters. Our staging domains were pretty long, I think they contained a few subdomains and had a job number or something in there.

This one is more crazy though if it is really caused by the desktop app - that's pretty scary!

gelatocar··on How Modern SQL Databases Are Changing Web Development: Part 1
Not sure if you're thinking more of an official standard but PouchDB is open source and sounds similar to what you're talking about: https://pouchdb.com/
gelatocar··on Data Rabbit – canvas for composable data exploration and experimentation
I've bookmarked this to check out on the desktop later because it looks like it could be exactly what I've been looking for for a while.

But being on a laptop right now I have to say it is a very frustrating experience as there appears to be no way to scroll/move the canvas so that you can see all the blocks.

gelatocar··on Show HN: Cito – Actionable data observability for data teams
This looks really cool, one note on the homepage though - the volume on the intro video is really really low, I had to crank my system volume way up to be able to hear it at all.
gelatocar··on Phantom forests: Ambitious tree planting projects are failing
While that is obviously rorting the system, isn't it kind of ideal from a carbon capture perspective? One of the big problems with planting forests for carbon capture is that they often burn down, and even when they don't, the natural cycle of the forest trees dying or falling and breaking down releases the captured carbon too. Harvesting the trees and using them as a building material seems like a better way to ensure that the captured carbon stays stored for longer. As long as they aren't used for firewood...
gelatocar··on The NuBike Is a Chain-Less Bicycle That Set Out to Reimagine Pedaling
Seems like some pretty dubious claims. If the bike was more efficient than a normal bike it'd be pretty easy to demonstrate that by having the same rider ride the same course on the NuBike and a normal bike.
gelatocar··on Learn Postgres at the Playground – Postgres compiled to WASM running in browser
This is really cool, one nitpick on the basics tutorial though. It could be confusing for beginners to write `select distinct(event_type)` because it makes it look like `distinct` is a function, and makes it looks like distinct only applies to certain columns. I've seen postgres beginners confused by syntax like this writing queries like `select distinct(event_type), magnitude` and expecting the query to only do a distinct on `event_type`.
gelatocar··on AWS DNS Issues?
Yeah we're noticing issues too. Able to only intermittently load the status page and AWS console.
gelatocar··on Using QGIS to apply a 1777 style to today's OpenStreetMap data
just in case you haven't already seen it, David Rumsey's website is the most amazing collection of historical maps. https://www.davidrumsey.com/
gelatocar··on Show HN: Radiopaper – Troll-resistant public conversations
This is really interesting, one question that comes to mind is whether popular discussions will become stressful for the original two people as others create new threads off certain comments. It seems that you would either have to ignore those new threads or inevitably end up having to keep track of a potentially deeply branching, difficult to follow discussion - having to make the same points in parallel to multiple people.

Some way to fan in the conversation and allow multiple participants as points converge could solve this but it sounds like it would be rather complex to get right.

gelatocar··on My Stripe Tax Story
Hi Edwin, I appreciate you offering. I did message support about this but it pretty quickly hit the limit of the time I was willing to put in to try and retrieve the money we lost (which wasn't all that much). It is one of those things where the way Stripe charges is technically correct as you need to calculate tax for all transactions even if they aren't fulfilled. But the odd behavior of trying to charge at end of trial even if a user doesn't have a payment method combined with charging 0.5% of all transactions whether fulfilled or not results in a pretty unexpected outcome. Changing any one of these behaviors, or even making the documentation clearer would stop this happening to anyone else probably.
gelatocar··on My Stripe Tax Story
I also had issues with stripe's automatic tax. We use stripe's subscriptions with free trials but don't collect credit card details up front, preferring to make sign up simple and low friction. Automatic tax is charged at 0.5% of each transaction, and apparently a trial ending is considered a transaction even if the user has no payment method, so we were hit with automatic tax fees for every trial end even if we received no money for them.

Overall my experience with stripe has been pretty negative and the large gap between my perception of the quality of their products, and the reality I discovered in actually using them has made me realize how much effort they put in to marketing to developers.

gelatocar··on Ask HN: Pinboard Archiving Working for You?
I think you are thinking of Pinterest?
gelatocar··on Australia media can be sued for social media comments, court rules
I didn't really think it was necessary to provide a source as it is literally as simple as googling "nsw population", "melbourne population", and "australia population". The results of those are a little out of date but still in the ballpark of 50%. If you are after official numbers then the ABS is the place to go: https://www.abs.gov.au/statistics/people/population/national...
gelatocar··on Australia media can be sued for social media comments, court rules
Closer to 50%, not quite sure where you got 65% from. (8.17 + 5.08) / 25.69 = 51.58%

it is still a lot of people, but it would be good if you could try and be accurate with this stuff. There's been a lot of incorrect stuff being said about Australian lockdowns on HN lately.

Page 1 of 3Next →