frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Inner-Platform Effect

https://en.wikipedia.org/wiki/Inner-platform_effect
25•tosh•2h ago

Comments

jstanley•57m ago
> While this entity-attribute-value model enables the developer to break out from the structure imposed by an SQL database, it loses out on all the benefits,[1] since all of the work that could be done efficiently by the RDBMS is forced onto the application instead. Queries become much more convoluted,[2] the indexes and query optimizer can no longer work effectively, and data validity constraints are not enforced. Performance and maintainability can be extremely poor.

This is only true if you try to do this for all of your data.

I've used key-value tables loads of times, it's convenient for storing things like global configuration.

What else can you do? Make a table that has every configuration value as a separate column and populate it with only a single row? That seems absurd and worse.

bastawhiz•16m ago
> What else can you do? Make a table that has every configuration value as a separate column and populate it with only a single row?

If the values are singletons, what you're describing is the most efficient. What the author is describing is a surprisingly common anti-pattern where someone has a table with three columns: entity id, property name, property value. Almost like a graph database. Fetching data for one entity (normally one row in a properly built db) is fine, but fetching the data for multiple entities is instantly a mess.

It's worth noting, though, that unless the configuration values are all the same type, you lose type safety with just one column for values. "I'll parse the data as JSON" means your service will fail hard at runtime if someone changes the configuration and uses invalid data.

pixl97•25m ago
I mean with things like webbrowsers it's so a group of people can have a similar experience regardless of which operating system they are on.
bastawhiz•10m ago
This is the opposite of what I want. If I'm on my Mac, I don't want menus at the top of the window. I don't want an Office-style ribbon. I don't want buttons that don't look native, or UIs that don't obey the configuration I've set up at the OS level.

Each OS has its own idioms and design patterns. I don't want my experience to be more similar to what someone on Windows sees, I want it to look like the rest of the things on my computer.

Let's not pretend this is what users want. It's what developers want so they don't have to write their UI once for each platform.

LT6502: A 6502-based homebrew laptop

https://github.com/TechPaula/LT6502
20•classichasclass•24m ago•0 comments

I Fixed Windows Native Development

https://marler8997.github.io/blog/fixed-windows/
388•deevus•6h ago•205 comments

EU bans the destruction of unsold apparel, clothing, accessories and footwear

https://environment.ec.europa.eu/news/new-eu-rules-stop-destruction-unsold-clothes-and-shoes-2026...
67•giuliomagnifico•26m ago•44 comments

Hideki Sato, designer of all Sega's consoles, has died

https://www.videogameschronicle.com/news/hideki-sato-designer-of-segas-consoles-dies-age-75/
80•magoghm•1h ago•1 comments

I love the work of the ArchWiki maintainers

https://k7r.eu/i-love-the-work-of-the-archwiki-maintainers/
764•panic•16h ago•128 comments

An Enslaved Gardener Transformed the Pecan into a Cash Crop

https://lithub.com/how-an-enslaved-gardener-transformed-the-pecan-into-a-cash-crop/
31•PaulHoule•1h ago•23 comments

Gwtar: A static efficient single-file HTML format

https://gwern.net/gwtar
13•theblazehen•1h ago•0 comments

Flashpoint Archive – Over 200k web games and animations preserved

https://flashpointarchive.org
255•helloplanets•11h ago•58 comments

Reversed engineered game Starflight (1986)

https://github.com/s-macke/starflight-reverse
58•tosh•5h ago•31 comments

Oat – Ultra-lightweight, semantic, zero-dependency HTML UI component library

https://oat.ink/
285•twapi•9h ago•81 comments

Amazon, Google Unwittingly Reveal the Severity of the U.S. Surveillance State

https://greenwald.substack.com/p/amazons-ring-and-googles-nest-unwittingly
394•mikece•4h ago•261 comments

How Is Data Stored?

https://www.makingsoftware.com/chapters/how-is-data-stored
59•tzury•5d ago•3 comments

RynnBrain

https://github.com/alibaba-damo-academy/RynnBrain
40•jsemrau•4d ago•1 comments

My smart sleep mask broadcasts users' brainwaves to an open MQTT broker

https://aimilios.bearblog.dev/reverse-engineering-sleep-mask/
547•minimalthinker•1d ago•233 comments

The seam through the center of things

https://usefulfictions.substack.com/p/the-seam-through-the-center-of-things
14•surprisetalk•2d ago•0 comments

A practical guide to observing the night sky for real skies and real equipment

https://stargazingbuddy.com/
96•constantinum•3d ago•16 comments

Two different tricks for fast LLM inference

https://www.seangoedecke.com/fast-llm-inference/
120•swah•8h ago•53 comments

Constraint Propagation for Fun

https://eli.li/constraint-propagation-for-fun
32•rickcarlino•5d ago•0 comments

Zvec: A lightweight, fast, in-process vector database

https://github.com/alibaba/zvec
196•dvrp•2d ago•35 comments

Interference Pattern Formed in a Finger Gap Is Not Single Slit Diffraction

https://note.com/hydraenids/n/nbe89030deaba
79•uolmir•2d ago•10 comments

Build Gaussian Splat Experiences with SuperSplat Studio

https://blog.playcanvas.com/build-gaussian-splat-experiences-with-supersplat-studio/
12•ovenchips•4d ago•1 comments

Inner-Platform Effect

https://en.wikipedia.org/wiki/Inner-platform_effect
25•tosh•2h ago•4 comments

1940s Irish sci-fi novel features early mecha and gravity assists

https://github.com/cavedave/Manannan
4•donohoe•2h ago•2 comments

Instagram's URL Blackhole

https://medium.com/@shredlife/instagrams-url-blackhole-c1733e081664
274•tkp-415•2d ago•44 comments

DjVu and its connection to Deep Learning (2023)

https://scottlocklin.wordpress.com/2023/05/31/djvu-and-its-connection-to-deep-learning/
44•tosh•8h ago•7 comments

Palantir vs. the "Republik": US analytics firm takes magazine to court

https://www.heise.de/en/news/Palantir-vs-the-Republik-US-analytics-firm-takes-magazine-to-court-1...
11•cdrnsf•45m ago•0 comments

uBlock filter list to hide all YouTube Shorts

https://github.com/i5heu/ublock-hide-yt-shorts/
1049•i5heu•23h ago•311 comments

Show HN: Copy-and-patch compiler for hard real-time Python

https://github.com/Nonannet/copapy
45•Saloc•4d ago•2 comments

5,300-year-old 'bow drill' rewrites story of ancient Egyptian tools

https://www.ncl.ac.uk/press/articles/latest/2026/02/ancientegyptiandrillbit/
149•geox•4d ago•61 comments

Guitars of the USSR and the Jolana Special in Azerbaijani Music (2012)

https://caucascapades.wordpress.com/2012/06/14/guitars-of-the-ussr-and-the-jolana-special-in-azer...
83•bpierre•14h ago•12 comments