HNHacker News
TopNewBestAskShowJobs

cccybernetic

216 karma · joined December 10, 2022

Based out of NYC. marko@getsubsystem.com

subsystem.ai

submissionscomments
cccybernetic··on Show HN: Plato – Airtable for your SQL database
Yes, these are essentially links to the corresponding rows in the child table. Airtable solves this problem via the "linkedRecordsField", though I'm not sure it's actually "solved", as the interface around them is a bit clunky and having more than a few is pointless as they get truncated and you can't see them regardless.

I've spent quite a bit of time plumbing Airtable's APIs, and am currently developing an app around Airtable to address some of these issues (zemanir.com) in case anyone is interested.

cccybernetic··on How Spotify's podcast bet went wrong
I find your phrasing and mindset interesting. What you suggest somewhat maliciously as "lock others in at high rates", I read as "shower them with more cash than they could ever conceivably dream of"

I'd love if my employer "locked me in" at a higher rate lol.

cccybernetic··on How Spotify's podcast bet went wrong
"Terrible" was too strong of a word -- I actually like Overcast, but find Spotify superior.
cccybernetic··on How Spotify's podcast bet went wrong
iPhone - I'm happy to take recommendations.
cccybernetic··on How Spotify's podcast bet went wrong
Overall I like Overcast, definitely better than Apple’s app. I don’t like UI though — the teal blue color, oversized controls, the “+ + + +” on the playback speed slider, strange layout choices, etc. (I know that these are relatively minor things to most people).
cccybernetic··on How Spotify's podcast bet went wrong
Meh, you can call it value extraction if you want, but ultimately they're paying these people. Didn't Rogan get like 100MM? Didn't they fund a bunch of studios and new podcast creators? From the article:

Its drastic cuts have triggered a podcast winter, as the small studios it helped support consolidate and lavish narrative productions wane

Also, I've tried 4 different podcast players and found Spotify's player to best of the bunch. Controls work like you would expect, it's very snappy, search and sorting are also polished. I've pretty much stopped listening to Podcasts on Apple's native app because Spotify's superior experience.

I do get what you're saying about RSS feeds though, but it's not quite as black and white as you make it.

Edit - updated wording:

+ "found Spotify's player to best of the bunch"

- "they're all terrible except for Spotify's"

cccybernetic··on Tell HN: DEI initiatives undermine the self esteem of PoC within a company
Maybe I'm just more of a private person than some people, but I'm absolutely floored that people would volunteer such private life details to a group of random strangers. I'm not saying it's a bad thing either, it may very well be healthier to share more about ourselves, but I can't wrap my head around it.
cccybernetic··on I lost $209k of my own money trying to start a business
As a technical founder, I agree with you to a degree, but not completely. I've come to appreciate sharp, non-technical founders with business acumen and who can see the "forest for the trees". There are times where being "technical" is actually a crutch, because you're more likely to:

1. Waste time / obsess over small technical details that in the grand scheme of things don't really matter, or at the very least, don't matter until you have validated product market fit. These details can be anything, from the design or shape of a button, or the perfect fully-normalized schema for your database or whatever.

2. You over-engineer technical solutions, like building a homegrown SaaS app or fleshing out a database for something that should have been validated inside of Google Sheets or email.

3. Idea generation - because they are non-technical, they often see potential products where technical people won’t because the technical person overestimates the amount that a non-technical person will commit to solving a problem. If you asked a technical person how to do XYZ, they might say something like, "oh that's easy, just set up a ABC server and VPN into it and run this bash script and blah blah blah". A sharp non-technical founder would immediately sense that to the average person this is absurd, and thus a potential product opportunity. I see this particular bias all the time on Hacker News.

cccybernetic··on Ask HN: Why are so many PHP projects moving to Node?
I've always loved this project / product:

https://github.com/outline/outline

I think the guy who built it posts here. There's also pg-promise, a "Postgres interface for Node.js":

https://github.com/vitaly-t/pg-promise

cccybernetic··on Coinbase’s chief product officer will leave with a $105M payday
As a first-generation immigrant I completely disagree with your framing here and it makes me sad that you view the United States in such an incredibly dismal way. There are many problems here, to be sure, but the US is undoubtedly one of the best places in the world to live, and, like very few other countries, tries to improve on its past, generation after generation.
cccybernetic··on Choosing a Postgres primary key
The existence of a synthetic key contradicts the idea that we're modeling the "world". Of course, this is a debate that’s been around forever, and I understand the advantages of synthetic keys, but I've found that the intuitive elegance of a natural key will often flow into the business logic, untangling nests of code dedicated to id look-ups, id-matching, filtering, mapping, and the general slicing and dicing and shaping of data. Queries that once referenced obscure ids now point directly to fields which intuitively make sense: yes, if I want to update the user_apps table, I know or can reasonably infer pk(user_id, app_id), and I know those values and I have them right here in my pocket, don't need to look them up, and they mean something very tangible and real and I don’t have to say “…WHERE id = ‘…’”

Of course, nothing is ever perfect and natural keys have their issues, especially when migrating data, but there’s something about them that’s always “clicked” with how I reason about software systems.

cccybernetic··on Ask HN: Math books that made you significantly better at math?
The best resource I've found is this random, somewhat obscure website (though I've learned that it has grown in popularity) called Paul's Online Notes. The professor has a real knack of pedagogy, and the problems are perfectly structured in terms of their difficulty. His explanations are clear and without jargon, and it goes from algebra to diff eq.

A note: this isn't a resource for higher-level, proof based maths. It will give you a solid foundation and a pragmatic understanding to build upon. Very useful for STEM.

Link: https://tutorial.math.lamar.edu

cccybernetic··on NYC Slice
Yeah, while not my favorite, Sal & Carmines is great. Only other truly great slice joint on the UWS is Freddie's (which is phenomenal). A new-ish place, Mama's Too on 106th, isn't too bad either.
cccybernetic··on Ask HN: Programs that saved you 100 hours? (2022 edition)
Woah, this is a blast from the past. I switched over to Mac a few years so I can't use this anymore, but this was my favorite piece of software from a prior job when I had a PC. This thing completely changed how I thought about performance and speed in software. I know there's the old adage about avoiding "premature optimization", but occasionally you use something like this that leaves your jaw on the floor in terms of what hyper-optimized software is capable of.
cccybernetic··on Ask HN: What is the best income stream you have created till date?
This is so cool. How long did it take you to get some of highly sought after photos?
cccybernetic··on Ask HN: What is the best income stream you have created till date?
To make a long story short … I built a delivery service that unexpectedly went semi-viral. Within a matter of hours we went from 2-5 orders per day, to 10, 20, 30, 40 … I had a small crew, and it got to the point where I was ordering Ubers and handing the drivers wads of cash to make the deliveries. Somehow we managed, and I eventually shut the service down to pursue a more interesting opportunity. It was a wild ride, and I learned more about business in those 2 short months than the 10 years prior.
cccybernetic··on Ask HN: What is the best income stream you have created till date?
Not OP, but also run a tech consulting firm. Email is in bio, happy to talk.
← PreviousPage 2 of 2