Ryan

@ryansmith

121 Following

3449 Followers

Ryan pfp

I've been working on a TS client for @indexsupply. Coming soon (or now if you sleuth the GH account)

0 reply

2 recasts

11 reactions

Ryan pfp

I was having some issues getting my @indexsupply transactional emails delivered timely. I found this absolutely cracked email guy https://www.helloinbox.email who helped me figure it out. (problem was part dns and part message formatting) would highly recommend if you want to speed run your email issues

0 reply

1 recast

6 reactions

Ryan pfp

2 replies

3 recasts

11 reactions

Ryan pfp

4 replies

2 recasts

14 reactions

Ryan pfp

I'm tempted to run @indexsupply on FreeBSD. It's long since been known for its networking stack (netflix) and it ships with ZFS.

3 replies

0 recast

9 reactions

Ryan pfp

Another smooth launch (mostly. had a bit of latency from a remote node) on @indexsupply. It's fun to have a dialed stack where new traffic can be handled without any intervention or fuss. I'm living the sysadmin's dream.

0 reply

1 recast

9 reactions

Ryan pfp

I love a good manual. ZFS continues to be amazing!

0 reply

1 recast

6 reactions

Ryan pfp

Legendary hacker @okwme (who has strange casts) shipped a fun new thing: https://kudzu.christmas

0 reply

4 recasts

4 reactions

Ryan pfp

Two things: 1) Counts can be slow in PG. (known issue) If you don't need exact, use this query: SELECT reltuples FROM pg_class WHERE relname = 'foo'; 2) Why does the gnosis chain have 6 BILLION logs?

1 reply

1 recast

14 reactions

Ryan pfp

I'll be using this for @indexsupply

0 reply

5 recasts

18 reactions

Ryan pfp

I'm obsessed with ZFS right now. The standard tooling is blowing my mind

1 reply

4 recasts

20 reactions

Ryan pfp

Here is my Devcon talk -- which includes fun PG tips. https://www.youtube.com/watch?v=WgBab6kamtg

1 reply

3 recasts

28 reactions

Ryan pfp

Hire for slope not y-intercept

1 reply

5 recasts

31 reactions

Ryan pfp

https://www.youtube.com/watch?v=K7Ny64iMMPY

2 replies

3 recasts

20 reactions

Ryan pfp

initial thoughts on AWS DSQL 1. PG compatible (pg is dominant at this point) 2. Most of the article talked about HA 3. AWS has a proprietary, internal distributed transaction log service that is supposedly the most important piece of AWS and everything in AWS depends on it. Hope that teams makes 10M annual tc each. 4. It depresses me to think that the future of compute and storage is: run it on aws It's really neat to think about having a network storage layer that can support many database frontends. this seems like the future. Neon et al. are moving in this direction. Also something that Stonebraker has been talking about for a while now. https://aws.amazon.com/blogs/database/introducing-amazon-aurora-dsql/

4 replies

5 recasts

31 reactions

Ryan pfp

ZFS with LZ4 compression is wild! From 2.2TB to 0.4TB.

2 replies

3 recasts

18 reactions

Ryan pfp

I asked how often people mistakenly ask them for Ethereum indexing.

4 replies

2 recasts

20 reactions

Ryan pfp

https://avi.im/blag/2024/zero-disk-architecture/ This is a really neat idea. Low latency, CAS, and append are killer S3 features. But kind of dystopian to think that all our data is owned and operated by a single US company. WDYT?

1 reply

1 recast

10 reactions

Ryan pfp

When he's right he's right

1 reply

4 recasts

11 reactions

Ryan pfp

I think the word 'strong' in 'strongly typed' gives the same energy as 'science' in 'political science'

2 replies

1 recast

10 reactions