Shane da Silva

@sds

493 Following

25418 Followers

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

7 recasts

60 reactions

Shane da Silva pfp

Stoked for this.

2 replies

9 recasts

60 reactions

Shane da Silva pfp

12 replies

1 recast

47 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

2 recasts

21 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

2 replies

1 recast

31 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

0 recast

14 reactions

Shane da Silva pfp

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

4 replies

1 recast

31 reactions

Shane da Silva pfp

Migrating your half-terabyte production Redis cluster at midnight.

18 replies

19 recasts

178 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

12 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/

4 replies

2 recasts

20 reactions

Shane da Silva pfp

Love seeing unintuitive results like this proven from first principles. TL;DR: halving service time results in almost 11x reduction in latency. https://pveentjer.github.io/misc/2022/04/18/service-time-cut-in-half.html

10 replies

2 recasts

41 reactions

Shane da Silva pfp

fname-registry was starting to experience significant latency in API responses. Allocating more servers made a huge difference.

5 replies

1 recast

42 reactions

Shane da Silva pfp

Excellent overview of all the different kinds of lock in Postgres and the various SQL statements that invoke them: https://medium.com/@hnasr/postgres-locks-a-deep-dive-9fc158a5641c

4 replies

3 recasts

24 reactions

Shane da Silva pfp

Huge kudos to @sanjay for extracting this into a reusable component that we also use to power Warpcast itself!

0 reply

0 recast

19 reactions

Shane da Silva pfp

Anyone using mise (asdf/nvm/etc alternative, formally called rtx)? Interesting but perhaps risky to fuse tool version management with environment variable setting and traditional Makefile tasks—but a lower barrier to entry than nix. https://mise.jdx.dev

2 replies

3 recasts

14 reactions

Shane da Silva pfp

Fun Farcaster Fact: the port that Hubs use to gossip information—2282—comes from the year the Hegira began in the Hyperion series: the exodus of humanity from Earth to the stars. https://hyperioncantos.fandom.com/wiki/Hegira

4 replies

3 recasts

32 reactions

Shane da Silva pfp

Postgres in the browser. This space is starting to get really interesting. https://github.com/electric-sql/pglite

3 replies

1 recast

21 reactions

Shane da Silva pfp

Anyone had a chance to try Zellij as an alternative to tmux/screen? Hearing good things. https://zellij.dev/about/

2 replies

1 recast

20 reactions

Shane da Silva pfp

Thank you Görli for all you did in the early days of Farcaster. May you find peace in the digital afterlife.

0 reply

2 recasts

18 reactions