Ryan

@ryansmith

142 Following

1572 Followers

Ryan pfp

I’ve been wanting to put together some Morpho example queries for @indexsupply. Got any suggestions?

1 reply

0 recast

2 reactions

Ryan pfp

0 reply

0 recast

1 reaction

Ryan pfp

0 reply

0 recast

0 reaction

Ryan pfp

I feel bad because I just leaked some alpha on X (formerly know as Twitter) when I should Casting Ethereum content here instead... Give x-chain queries a try and lmk what you think. May still be rough around the edges. https://tinyurl.com/istxs4242

0 reply

1 recast

18 reactions

Ryan pfp

A fun debugging tool: Get a list of active connections on your @indexsupply api key (the api key in video has been deleted. no freebees)

1 reply

1 recast

7 reactions

Ryan pfp

Interesting to see people try to delete my data

0 reply

0 recast

4 reactions

Ryan pfp

I recently added DB size and active connections to the status page! Fun. There's a lot of data...

0 reply

0 recast

10 reactions

Ryan pfp

Give it a try: https://www.indexsupply.net/query?chain=7777777&block_height=0&event_signatures=&query=select+hash%2C+block_timestamp+from+txs+limit+1

0 reply

2 recasts

3 reactions

Ryan pfp

V2 is coming Timestamps, Blocks, Transactions -- all via SQL!

5 replies

9 recasts

52 reactions

Ryan pfp

Tooling is one of my favorite parts of C++ development.

0 reply

0 recast

0 reaction

Ryan pfp

Good point. Got any suggestions?

0 reply

0 recast

0 reaction

Ryan pfp

Can a subgraph even benefit from the lower latency? I assume you’d just want to have quicker access to the confirmations. Or is there something else you are after.

1 reply

0 recast

1 reaction

Ryan pfp

Do you want something other than the standard flashblocks api? https://flashblocks.base.org/docs

1 reply

0 recast

1 reaction

Ryan pfp

Of course people are going to want to know what sorts of beautiful things you can do with postgres on a friday night. Well, easy. Have you ever thought about adjusting the toast tuple target to a small power of 2?

1 reply

1 recast

6 reactions

Ryan pfp

We are doing beautiful things with Postgres this evening. V2 @indexsupply is going to have a lot of fun new features.

0 reply

0 recast

16 reactions

Ryan pfp

OrioleDB is an interesting PG extension that offers a different storage system than the standard tuple heap. But that's not why I'm Casting; there blog is a treasure trove of PG knowledge: https://www.orioledb.com/blog

0 reply

0 recast

5 reactions

Ryan pfp

Nice. Be sure that column is TOASTed

0 reply

0 recast

0 reaction

Ryan pfp

Raid is handled by ZFS. It's not technically 10 but similar.

0 reply

0 recast

0 reaction

Ryan pfp

1 reply

0 recast

0 reaction

Ryan pfp

Software stack is: Rust, Postgres, Postgres C extensions, and ZFS on Ubuntu. I wrote a custom ABI decoder and SQL rewriting system — the workhorses of the system. I will make a video about the hardware stack soon.

1 reply

0 recast

3 reactions