HN user

michaelmior

6,650 karma

Senior Data Engineer at OneChronos

Personal site: https://michael.mior.ca

[ my public key: https://keybase.io/michaelmior; my proof: https://keybase.io/michaelmior/sigs/BpTU6skpVwr4X8MVODgsjjPXAPdaSLAjYbPl2EEDYeA ]

Verifying my Blockstack ID is secured with the address 19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm https://explorer.blockstack.org/address/19AvsK3Zo1cmFZg4D1c4pDaavHRZKvPEWm wonderfuldev_gceng9nu6y0g2kpciawxmwzc

Posts85
Comments3,301
View on HN
blog.denv.it 6mo ago

I'm a Happy Engineer Now

michaelmior
1pts0
json-render.dev 6mo ago

JSON-Render: AI –> JSON –> UI

michaelmior
2pts1
twitter.com 6mo ago

Tool Search Now in Claude Code

michaelmior
1pts0
github.com 9mo ago

Skills

michaelmior
2pts0
www.theregister.com 9mo ago

Framework flame war erupts over support of politically polarizing Linux projects

michaelmior
7pts1
github.com 10mo ago

Open-Sourcing ComfyDeploy

michaelmior
2pts0
reshaped.so 10mo ago

Reshaped is now open source

michaelmior
314pts47
www.raspberrypi.com 11mo ago

AI interdimensional phone entertains party guests like it's 1999

michaelmior
1pts0
github.com 1y ago

QA via natural language AI tests

michaelmior
1pts0
github.blog 1y ago

GitHub Skyline CLI extension now available

michaelmior
1pts0
github.com 2y ago

Bussin Web X – An Alternative to the World Wide Web

michaelmior
2pts0
instantid.github.io 2y ago

InstantID: Zero-Shot Identity-Preserving Generation in Seconds

michaelmior
2pts0
news.ycombinator.com 2y ago

Ask HN: Why don't emails seem use interactive Gmail features?

michaelmior
3pts12
hyperlaps.io 3y ago

Innovative DIY Board Game – Hyperlaps.io

michaelmior
1pts0
spectrum.ieee.org 3y ago

The first posit-based processor core gave a ten-thousandfold accuracy boost

michaelmior
4pts0
ir.hertz.com 4y ago

Hertz Invests in Largest Electric Vehicle Rental Fleet

michaelmior
2pts0
news.ycombinator.com 5y ago

Ask HN: What's the most entertaining story of a technical mistake you've made?

michaelmior
4pts4
www.nytimes.com 6y ago

Grant Imahara, Engineer Who Co-Hosted ‘MythBusters,’ Dies at 49

michaelmior
1pts0
www.osapublishing.org 6y ago

General formula for bi-aspheric singlet lens design free of spherical aberration

michaelmior
1pts1
iabtechlab.com 6y ago

Final Version of App-Ads.txt Ready for Adoption

michaelmior
2pts0
www.blog.google 6y ago

Support for app-ads.txt to protect your app revenue and brand

michaelmior
2pts0
www.cnn.com 7y ago

Lyft files confidential plans for an IPO

michaelmior
1pts0
techcrunch.com 7y ago

Microsoft Edge Goes Chromium (and MacOS)

michaelmior
1pts0
news.ycombinator.com 7y ago

Tell HN: Careful When Trying Google's Advanced Protection Program

michaelmior
12pts4
www.smashingmagazine.com 7y ago

Measuring Performance with Server Timing

michaelmior
2pts0
hackernoon.com 7y ago

Why feature weights in a machine learning model are meaningless

michaelmior
1pts0
github.com 7y ago

Vid2vid – photorealistic video-to-video translation

michaelmior
3pts0
www.omgubuntu.co.uk 8y ago

Dell Unveils New Ubuntu Laptops

michaelmior
1pts0
thelastpickle.com 8y ago

Garbage Collection Tuning for Apache Cassandra

michaelmior
4pts0
towardsdatascience.com 8y ago

Deep Neural Network Implemented in Pure SQL Over BigQuery

michaelmior
3pts0

I think most successful ORMs have an additional layer of semantics beyond what can be directly expressed in SQL. For example, Active Record has multiple types of associations (belongs_to, has_one, has_many, etc.) that I would argue align more closely to the ER model than the relational model. Of course you can come up with a set of conventions to go from ER to relational when everything is fed through the ORM, but you are losing some semantic information in the process. (That is, if you just look at the SQL table definitions, you don't have the same information about relationships).

Inheritance is one case. In an ER diagram, you may have Employee and Client entities which both inherit from a Person entity. You could choose to have these represented as a single table (with nullable fields where not relevant). They could be three completely separate tables with common fields duplicated across the tables. Or there could be three tables where one table has the common fields from Person with Employee and Client having foreign keys to this table along with whatever unique fields they have.

Aside from what else is mentioned in the sibling comment, inheritance is another big one. Inheritance is not explicit in SQL and in fact, when going from ER to SQL, there are multiple choices you can make about how to materialize the inheritance hierarchy.

Another is that in ER diagrams, relationships themselves can have attributes. Personally I think it tends to make more sense to convert relationships to entities in this case most of the time, but it can be useful.

Finally, relationships in ER diagrams can be N-ary and connect more than two entities while foreign keys in SQL always reference one other table. Of course you can have multiple foreign keys on a table to represent this, but not without some loss of semantics.

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram.

That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

Bun.Image 2 months ago

I think that's a fair take. I think we definitely still need specs that describe the desired behavior as an artifact. But documentation describing the implementation definitely feels less important.

Bun.Image 2 months ago

Humans also tend to forget to update documentation and the same confusion happens. I don't think it's really a new problem.

I'm not saying our experience is unimportant. I'm talking about how we communicate what colors are. I'm not an expert by any means, but it seems like the way we communicate a shared understanding of what colors are is based on observing things that are the same color. I just don't think we have a way of communicating our subjective view of what a color looks like without reference to some other color.

The scenario you're describing seems like more of a language thing than a perception thing. We generally learn names of colors by references to common objects. I would argue that if people agree something is "Red, like a strawberry, tomato, or apple" then it doesn't really matter what you're seeing, that color is red.

On this note, one thing I've found Codex to do is worry more than necessary about breaking changes for internal APIs. Maybe a bit more prompting would fix this, but I found even when iteratively implementing larger new features, it worries about breaking APIs that aren't used by anything but the new code yet.

I worry about the costs from an energy and environmental impact perspective. I love that AI tools make me more productive, but I don't like the side effects.

I'm surprised that Cloudflare hasn't started hosting a pre-scraped version of websites that use Cloudflare's proxy

It's entirely possible that they're doing this under the hood for cases where they can clearly identify the content they have cached is public.

Would it be a fair argument to say the police have a better opportunity to prevent crimes if they can enter your house without a warrant?

This is a false equivalency. I don't have to use TikTok DMs if I want E2EE. I don't have a choice about laws that allow the police to violate my rights. I'm not claiming that all E2EE apps should be banned.

Right, but this is worlds apart from "sharing the encryption key with a private company", is it not?

Exactly why I suggested that as a possible alternative.

Yes, but this leaves the only way to identify this behavior as by reporting from a minor. I'm not saying I trust TikTok to only do good things with access to DMs, but I think it's a fair argument in this scenario to say that a platform has a better opportunity to protect minors if messages aren't encrypted.

I'm not saying no E2E messaging apps should exist, but maybe it doesn't need to for minors in social media apps. However, an alternative could be allowing the sharing of the encryption key with a parent so that there is the ability for someone to monitor messages.