alliao

rare as an unicorn though, especially the smaller version

not every console stays connected to my tv... and wii stayed. wii sports is still fun and get everyone moving during a rainy day which is quite an achievement all by itself

probably should look into what Japan is doing with their 8020 campaign.. idea is you get to keep 20 of your teeth by the time you're 80yrs old

I really hope AI can democratise custom designs and push it further... just improve a simple Bubble-pump Absorption to either cool directly or use it to make ice etc... so much opportunities

they just said no ipo this year, most chinese models are distilled from claude anyway

very interesting thanks for the insight, I feel like there are broadly two camps of developers, one like yourself probably wants to know every last detail, and the other that are somewhat prefer to stay naive and taking the "declarative" part very broadly...

there's a bit of cyclic relationship at play here, the data changes the query plan, and the query plan affects the performance, while the performance is being optimised by the engine. if the architecture is bad then sooner or later the engine runs out of tricks and performance suffers but then nobody never is quite sure whether the current architecture's good enough.

I totally get the whole nosql that was the rage for a while... quick to prototype but I do believe once it's somewhat settled, moving the consolidated parts back to SQL is much easier to manage and optimise

I think it strikes a good balance between still human-readable and low-ish.. any lower I suspect you'd need to dedicate a lot more documentation else where..

did you use llm to create the llm-friendly schema.md? This sounds like a brilliant idea I might need to steal it... thanks!

dba here and I really don't get why SQL is so feared... I get that it requires very different way to think about data but it is quite simple in terms of you tell it what to do, and if it does it badly you probably told it wrong so just try something different...

the fingerprint exists to do dynamic/adaptive pricing... if you never return anything they assume you'll take any price as you enjoy their services more

if coding is free, the number 1 issue that need to be resolved is separating features so people can roll back any part they don't like and the magic would be resolving all the gory consequences of such action well enough

usual shortsightedness from bean counters, while studio do lost revenue on second hand trades they gained another player! I can't believe they think that's not a worth while trade. Games are like books, the amount of time people spent on it far outweighs their opportunity cost in earnings, and you only have such a short window to capture that audience so do it however you can, allowing piracy is a legit business strategy, let alone trading second hand games!

same rule applied during housing boom in taiwan in the 1970s, my parents bought an apartment as the construction company had their headquarter in the very same building on the 2nd floor!

they can lean at all sort of weird angles too, experienced finish carpenter are worth their weight in gold