HNHacker News
TopNewBestAskShowJobs

ConnorLeet

34 karma · joined December 11, 2016

submissionscomments
ConnorLeet··on Partitioning Postgres tables by timestamp based UUIDs
A big benefit of partitioning is being able to drop partitions that expire instead of doing deletes. Assuming you’ll ever need to delete of course!
ConnorLeet··on AlloyDB Omni – run AlloyDB anywhere
All clouds do that for databases
ConnorLeet··on Oxy is Cloudflare's Rust-based next generation proxy framework
Naming things is hard.

https://www.urbandictionary.com/define.php?term=roxy (2nd entry)

ConnorLeet··on Hot Reloading Rust – For Fun and Faster Feedback Cycles
Sounds like Erlang from what I’ve heard about it
ConnorLeet··on Speeding up sort performance in Postgres 15
I think that this repo was created by a core PG dev.

https://github.com/orioledb/orioledb/commits?author=akorotko...

https://github.com/akorotkov

ConnorLeet··on I Trained My TikTok
Plenty of guys complaining about dating on TikTok too. It’s an absolutely massive platform and there’s videos on just about anything especially interpersonal relationships (coach industry)
ConnorLeet··on Monorepos done right
.NET
ConnorLeet··on Launch HN: Drifting in Space (YC W22) – A server process for every user
Do you have any resources to point me towards that elaborate on the benefits of a process-per-tenant/user for performance?

I work on a data-intensive app that fits the use-case you describe but I'm confused about the benefits for performance. (can certainly see how the code would end up nice/simpler) Is this mostly applicable to certain stacks?

ConnorLeet··on Embeddable, replicated and fault tolerant SQL engine based on Sqlite
SQLite does have a branch that solves the concurrent write issue - not sure if this dqlite uses it https://sqlite.org/src/doc/754ad35c/README-server-edition.ht...
ConnorLeet··on Use console.log() like a pro (2020)
Most IDEs, for that matter!
ConnorLeet··on In Defense of Myers Briggs (2020)
I’ve always been amazed by how much of the self-development & improvement industry seems to be based off of Scientology!
ConnorLeet··on Book Review: "This Is How They Tell Me the World Ends"
Wasn't the NSA tool leak due to an ex-NSA contractor intentionally leaking it?
ConnorLeet··on Exposing sequential IDs is bad Here is how to avoid it
Possessing an ID, shouldn’t give access, regardless of whether it’s a numerical PK or a UUID. (Unless that’s a feature, like shareable links) Still need to check if the user should be able to use that ID.

If that isn’t implemented, the system isn’t secure, doesn’t matter which path you use.

ConnorLeet··on Databricks is an RDBMS
Do you have any resources or examples of challenges with scaling up a shared-nothing architecture? At the crossroads between a shared-nothing and shared disk decision at the moment.
ConnorLeet··on Software effort estimation is mostly fake research
Although when working like this there can be a "Good enough" inertia
ConnorLeet··on The myth of “joins don't scale”
How many op/s was that? Bytes/s? Just curious because I was involved in migrating a write-heavy service off of C* to SQL Server. Our writes have higher latency now, but using managed SQL is worth it. (much cheaper too)
ConnorLeet··on SpaceX Starlink is now its own ASN and present at the Seattle Internet Exchange
Little bit off topic question

Is there a public API or a database ASN ownership? Contact information would be nice also...

ConnorLeet··on Ask HN: How do you make sure your servers are up as a single founder?
One thing that has helped me a lot with monitoring is custom application-level metrics.

If you have a good idea of the usage patterns of your service, create metrics backed by the patterns. This can help you find things that CPU/Memory will hide.

ConnorLeet··on YC Fall Hackathon 2019
Anyone looking for some help?
ConnorLeet··on They Were Promised Coding Jobs in Appalachia
Are problem solving skills something you are born with? To me the mismatch is that a traditional CS student spends more time practicing problem solving via homework and exam/exam prep.
ConnorLeet··on Live Views of Starman
You know, there's a lot of space out there to launch garbage into.
ConnorLeet··on Miners Aren’t Friends
If the whole crypto ecosystem crashes (unlikely in my opinion) graphics cards can be resold and recoup losses.
ConnorLeet··on Ask HN: Do you feel fulfilled with your work?
Yes.

The thing for me is that is fulfilling, is the talented and genuine people I work with, and from doing the best work I can.

People always talk about how fulfillment coming from "Changing the world," and helping people, but really if you mesh with the people - that's fulfilling enough for me!

ConnorLeet··on Ask HN: Am I the only one who keeps returning Apple's EarPods?
If a product breaks once, it could be the product, if it breaks multiple times - you might want to rule out something you are doing that could be breaking it.
ConnorLeet··on Justin Kan: I'm starting a new startup incubator, Zero-F
Zero-F's emblem is a fox, Zero-Fox given!
ConnorLeet··on Ask HN: What books fundamentally changed the way you think about the world?
"The Brothers Karamazov" by Fyodor Dostoyevsky.
ConnorLeet··on Why LINQ beats SQL
Array.reduce(), Array.filter(), Array.map(), in JavaScript are pretty LINQ-ish if you ask me!
ConnorLeet··on I’m a Bad Developer, That’s the Only Reasonable Explanation
Tools to help with a process, not to define the process.
ConnorLeet··on Ask HN: Interested in an e-book on building web apps with Node.js and React?
The tutorial you linked definitely requires a good grasp on React & Redux, I suggest starting with this course: https://www.udemy.com/react-redux/

Udemy frequently has sales on holidays and all courses are ~$15