yashap

16 ms·

121.
by yashap 3y ago
Joins are not inherently expensive, but they can lead to expensive queries. For example, say I want to find the 10 most recent users with a phone number as their primary contact method: SELECT … FROM User JOIN ContactMethod on ContactMethod
122.
by yashap 3y ago
I wonder, how does this handle a single transaction that contains both reads and writes? Maybe it just says "within a transaction, all reads and writes go through the Postgres proxy, SQLite is ignored"?
123.
by yashap 3y ago
That is a much safer way to go for most use cases. Well actually, most use cases don't need edge compute at all, but for those that do, this setup is indeed common, and fine for most apps: - Say we do edge compute in San Francisco, Mon
124.
by yashap 3y ago
2FA is not the main target here, it’s SMS one time password flows. Where you never go through a traditional account setup, you just enter your phone number, it sends you a text with a one time password (generally embedded in a URL you can c
125.
by yashap 3y ago
100%, my current company had to build fraud protection specifically for our Twilio SMS OTP flow. I’m sure essentially every Twilio customer that does SMS OTP flows with them has had to do the same. Took them forever to build their own featu
126.
by yashap 3y ago
Depends how it’s used. If it’s used in an org where major, high impact problems are ignored, as a way to just say “ignore all problems”, then yeah, it’s a shit comment. However, if it’s used to legitimately say “don’t just complain, fix”, t
127.
by yashap 3y ago
They even talk about this in the article: > “The environmental impact of near-term ACBM production is likely to be orders of magnitude higher than median beef production if a highly refined growth medium is utilized for ACBM production,
128.
by yashap 3y ago
Yeah, TS has a very flexible/powerful type system. You can have a type like ‘full_name’, that can only be that exact string, or a type like ‘full_name’ | ‘id’ | ‘email’, that can only be those 3 strings, etc. Kysely takes advantage of
129.
by yashap 3y ago
There’s a popular sister project, kysely-codegen, that lets you do the same (generate types from the DB schema).
130.
by yashap 3y ago
If you use it with kysely-codegen, it generates the types from your DB schema, guaranteeing they match. And the strings are verified at compile time - you can’t typo a table name, field name, etc., it won’t compile. Plus, from an ergonomics
131.
by yashap 3y ago
Have recently started using it, big fan, especially in concert with kysely-codegen (generate Kysely types from DB schema). The combo is similar to Prisma, but IMO better in practice - Prisma is too limited, too little support for any sort o
132.
by yashap 3y ago
Sure, the odd RPC style HTTP call is fine - not everything is cleanly modelled as a resource. But the lack of a clean way to make GET requests with a more complex request payload is simply a wart/shortcoming in the HTTP protocol IMO, a
133.
by yashap 3y ago
I’d like to see this (or something like it) ship. Right now the two most common alternatives are: 1) GET, but base64 encode a json payload as a query param. Main downsides are that you can hit URL size limits, it makes the client and server
134.
by yashap 3y ago
Yeah, I’d imagine this will be cheaper than AWS RDS for low storage use cases (lack of fixed monthly compute costs wins out), but more expensive for high storage. Like quite cheap for a 10-100 GB DB, quite expensive for a 1-10 TB GB. Though
135.
by yashap 3y ago
IMO - log every 5xx (4xxs too), ensure your logs/error messages are groupable by message (e.g. keep variables like ids in a metadata object separate from the message), and keep a close eye on errors grouped by message and HTTP status c
136.
by yashap 3y ago
Only vaguely related, but mentioned in the article: “In Down and Out in Paris and London,[6] George Orwell described the term débrouillard as something the lowest-level kitchen workers, the plongeurs, wanted to be called, indicating that th
137.
by yashap 3y ago
I think you're almost always gonna pay far more for cloud compute than on-prem. It's pretty standard for companies to have roughly 2x the "peak" load than "minimum" load, so while with on-prem you maybe have to
138.
by yashap 4y ago
You can get around these limitations with jailbreak prompts: https://www.jailbreakchat.com/
139.
by yashap 4y ago
Sort of, but not exactly. The Great Filter is meant to be an explanation for “why isn’t the Milky Way full of colonies”, but if the answer is “AI kills off civilizations before a colonization explosion”, we should still see AI colonies, pro
140.
by yashap 4y ago
Consciousness is a vague term anyways, but I basically mean that for an AI to be a true threat to human existence, it would need to be aware of itself and it’s environment. Making decisions and taking actions without being asked to do so by
141.
by yashap 4y ago
Job loss is one thing, but in all honesty, my main concern with AI is that it’ll wipe out humanity. My thoughts: - If we ever achieve an AGI with legitimate consciousness/self-awareness/agency, I believe it will be dramatically mo
142.
by yashap 4y ago
Tools like Buffer or Hootsuite make it pretty easy to cross-post content across many networks.
143.
by yashap 4y ago
Mostly agree, but it doesn’t make sense to call Vancouver a big city, but Montreal only “maybe” a big city. Montreal’s metro population is 4.3 mil, Vancouver’s 2.6 mil, Montreal is a much bigger city than Vancouver, not the other way around
144.
by yashap 4y ago
The “credibility” value is pretty huge IMO. If you’re a small startup, the assumption from potential customers, employees and investors is that you’re super likely to fail, probably soon. Because YC companies have a strong track record, you
145.
by yashap 4y ago
They’re a shady crypto exchange (is there any other kind?) that’s been banned in a tonne of countries around the world for flaunting financial regulations. If there’s a major run on Binance, I’d be shocked if depositors get their deposits b
146.
by yashap 4y ago
Life imitates art: https://youtu.be/u48vYSLvKNQ
147.
by yashap 4y ago
Yeah, if you have a big team, everyone is going to be specialized anyways. You can have: - Dedicated Android devs working on your Java/Kotlin/whatever Android app - Dedicated iOS devs working on your Swift/Objective-C/wh
148.
by yashap 4y ago
Ooh interesting! Similar to React Native in that it’s a JS interface to native components, didn’t know about this, worth a look!
149.
by yashap 4y ago
See my comment here with more about my take: https://news.ycombinator.com/item?id=35066431 But React/React Native is the only mature/popular web/mobile approach I’ve seen that embraces web components on the w
150.
by yashap 4y ago
Interesting, have never played around with it. Is it just a WebView on mobile, though? What I like about React/React Native is that it’s web-native components on the web, mobile-native components on mobile, so you get true native look&

More ›