geenat

12 ms·

151.
by geenat 3y ago
Longevity of PHP
152.
by geenat 3y ago
Fair warning: This will rm -rf the project directory you point it to. Careful to not point it to ~/Desktop or ~/Documents ... ): Quite dangerous, but I think the idea itself has merit.
153.
by geenat 3y ago
Would be nice if the deployment story became a bit more like CockroachDB too.
154.
by geenat 3y ago
App required = not so sure about this.. not in a rush to try it out.
155.
by geenat 3y ago
The problem with Javascript modules = Everyone will be forced to run a full web server to do anything (to handle CORS restrictions). We all lose the ability to simply have a local index.html file, and have it Just Work (TM): <script
156.
by geenat 3y ago
To save new people the trouble- this script just wraps this docker exec -it <container> <command>
157.
by geenat 3y ago
It won't stutter because the actual animation is done by the browser CSS engine. await is only used to build the non-blocking timeline: Think keyframes, not frames.
158.
by geenat 3y ago
haha I mean, it's just built into browsers now. Nothing stopping someone from still using anime.js
159.
by geenat 3y ago
The fundamental building block of the vanilla js snippet and anime.js is the ability to create non-blocking timelines + tweens- which we get for free now. the optional "lib" is just aliases to make vanilla js less verbose.
160.
by geenat 3y ago
Wanted to note, htmx's companion project at https://hyperscript.org/ does this naturally out of the box as well due to its async transparency.
161.
by geenat 3y ago
Sure but in many situations a vanilla async function gives you the same result without the extra layer.
162.
by geenat 3y ago
Mostly obsolete with CSS tweening. You can do non-blocking animation timelines without any library if you use async javascript. <html> <body> <div>Click me to change color every second, then remove. <script&
163.
by geenat 3y ago
> Google came to buy Digg, but figured out that really it's just a dude who works 22 hours a day that keeps the quality up, and all that talk of an algorithm was smoke and mirrors I am in shock- amazing story. Thanks for sharing. Th
164.
by geenat 3y ago
Kevins best ideas were always products that genuinely helped people, rather than self-serving concepts. Digg, Zero, etc. It's just sad he's using his fame for NFT crap now.
165.
by geenat 3y ago
The choice of PHP had very little to do with it. Digg was 3 webservers with 8 database slaves in 2006. https://web.archive.org/web/20060412174457/http://www.oreill... Digg even moved some processing from
166.
by geenat 3y ago
Note: Vanilla PHP was not the cause of the scaling issues. Digg was 3 webservers with 8 database slaves in 2006. https://web.archive.org/web/20060412174457/http://www.oreill... Digg even moved some pro
167.
by geenat 3y ago
This. Should have been taken out in Python 3, but nah, still present even today.
168.
by geenat 3y ago
May want to really consider Odin, watch: https://www.youtube.com/watch?v=nVa9mgRcVPs Made by gamedevs, for gamedevs.
169.
by geenat 3y ago
> This software is by no means ready for production. I use it in personal projects, but it has not been tested anywhere else other than my machine (as far as I know). Use it at your own (high) risk. if it's public, it's in prod
170.
by geenat 3y ago
I know it seems dumb, but postgres really needs to add the simple developer experience stuff like: SHOW CREATE TABLE; SHOW TABLES; SHOW DATABASES; SHOW PROCESSLIST; CockroachDB added these aliases ages ago.
171.
by geenat 3y ago
You're right, my mistake.
172.
by geenat 3y ago
> Can't secondary indexes just be implemented in your state machine? Secondary indexes are implemented as an additional smaller table in most databases (Index -> Primary Key), which requires a write, too. Don't take my word
173.
by geenat 3y ago
Strongly consistent FoundationDB = Likely similar write performance to CockroachDB or TiDB when you avoid secondary indexes. Secondary indexes in "distributed strongly consistent" systems is what ruins performance: because each in
174.
by geenat 3y ago
Game changer if you can turn raft checks on/off on a per-query basis, like scylladb / cassandra.
175.
by geenat 3y ago
> it's impossible to implement "optimistic UI," where the user creates a TODO item on the client side and posts the data back to the server in the background. Pretty common patterns for this- just use a sprinkle of client
176.
by geenat 3y ago
MySQL (then Vitess) ran Youtube, but nowadays I do believe most product teams are using Spanner.
177.
by geenat 3y ago
Found a solution to address the lack of WHERE x = NULL SELECT * FROM users; Then you can plug your PK into. UPDATE users SET address='' WHERE user_id IN (9affeac3-5d92-111d-779c-55eb6d78a806, ...) IF address=null; Then you can do
178.
by geenat 3y ago
Can confirm the inability to select null values. Have not yet found a reasonable pattern / workaround.. The reasoning seems to be that null values are not stored-- it's displayed as null in csql, but in reality, that data just doe
179.
by geenat 3y ago
So ScyllaDB allows you to choose how much Consistency in CAP you desire, in order to gain performance. Pretty interesting. In contrast to CockroachDB, Postgres, etc, where Consistency in CAP is always enforced and there's no way to tur
180.
by geenat 3y ago
One strategy I've considered: Write Postgres in a way that's fully compatible with CockroachDB, with the intention of transitioning to CockroachDB if needed. Basically: 1. BIGINT or UUID or TEXT or composite Primary Keys only. 2.

More ›