Shane da Silva

@sds

509 Following

27046 Followers

Shane da Silva pfp

You know you’re at SFO when:

1 reply

0 recast

11 reactions

Shane da Silva pfp

Making Postgres fun again: https://github.com/nuno-faria/tetris-sql

0 reply

1 recast

10 reactions

Shane da Silva pfp

Just squeaky clean fun. Particularly loved hearing Protoculture's "Out of Reality" (~1:00:20) and Underworld's "Dark and Long - Dark Train" (~1:23:23) elegantly incorporated into modernity. https://www.youtube.com/watch?v=AcIgj2Qt1-A

0 reply

0 recast

9 reactions

Shane da Silva pfp

Going to be experimenting with OrbStack this week. If its promises hold true, could be quite a perf boost for local dev with Docker. Anyone have personal experience? https://orbstack.dev

2 replies

0 recast

5 reactions

Shane da Silva pfp

Well this is fun. https://github.com/gruhn/typescript-sudoku

2 replies

0 recast

1 reaction

Shane da Silva pfp

Out of Africa Movie · 1985 · ★★★½☆ Didn’t know what I was getting into with this one—was just looking for an African-themed film for the flight. Ended up springing a few leaks in the process. While the delivery is at times clumsy in the typical way of 80s cinema, Streep and Redford’s performance shines through to showcase a precious kind of love—two minds simply wanting to be together—but with a complexity most relationships could not withstand. Impressive cinematography (for the time) with respect to filming wildlife altercations. Makes one want to watch a documentary on how they did it.

2 replies

1 recast

9 reactions

Shane da Silva pfp

Killers of the Flower Moon Movie · 2023 · ★★★★★ Late to this one, but that's what long flights are for. In traditional Scorsese fashion, it's a slow, painful burn—poignant. Casting all around was stellar, but the Lily+Leo interplay was particularly special.

4 replies

2 recasts

15 reactions

Shane da Silva pfp

Privileged to be “stuck” in Istanbul due to a missed connection. People here know how to enjoy the present moment.

5 replies

1 recast

7 reactions

Shane da Silva pfp

Fabulous font fun: https://blog.glyphdrawing.club/font-with-built-in-syntax-highlighting/

1 reply

0 recast

18 reactions

Shane da Silva pfp

FSMs as a core data primitive are going to get more popular. Combined with a runtime library for your preferred language, and you have a way to formally verify statements about business logic in your system. https://raphael.medaer.me/2019/06/12/pgfsm.html

2 replies

6 recasts

50 reactions

Shane da Silva pfp

Stoked for this.

0 reply

8 recasts

47 reactions

Shane da Silva pfp

8 replies

0 recast

37 reactions

Shane da Silva pfp

Impressive tool from Xata providing a solution for zero-downtime, REVERSIBLE (!!!) migrations—the holy grail. Excited for this to eventually reach v1. Current feature set is very impressive, but it's not yet ready to handle all possible migrations just yet. Something to keep an eye on. https://xata.io/blog/pgroll-schema-migrations-postgres

3 replies

1 recast

18 reactions

Shane da Silva pfp

Great post on how PG lock behavior during schema changes. It's surprising (but obvious in hindsight) how a statement that obtains a lock which doesn't conflict with a schema change could still be blocked by another statement that does obtain a blocking lock, due to the FIFO nature of the lock queue. https://xata.io/blog/migrations-and-exclusive-locks

1 reply

2 recasts

26 reactions

Shane da Silva pfp

Anyone ever used a higher-level language like PQL for expressing complex SQL queries? https://pql.dev Looks like heavy use of CTEs under the hood to make it easier to express queries as pipelines rather than declarative statements. Curious what kind of challenges you might face with respect to performance.

1 reply

1 recast

16 reactions

Shane da Silva pfp

Remember Growl? What a time to be alive. https://growl.github.io/growl/

4 replies

0 recast

25 reactions

Shane da Silva pfp

Migrating your half-terabyte production Redis cluster at midnight.

14 replies

15 recasts

152 reactions

Shane da Silva pfp

Anyone have a way to make the macOS Touch ID animation faster? It's painfully slow.

4 replies

0 recast

13 reactions

Shane da Silva pfp

We don’t deserve dogs

1 reply

0 recast

9 reactions

Shane da Silva pfp

With an unlogged table, Postgres is fast as a cache. Downside is unlogged tables aren't replicated, and so this pattern doesn't scale. https://www.cybertec-postgresql.com/en/postgresql-vs-redis-vs-memcached-performance/

5 replies

1 recast

14 reactions