Index Supply

@indexsupply

1 Following

246 Followers

Index Supply pfp

Here is a power user's tip for querying the logs table directly. Keep in mind: you'll want to add a `block_num` predicate since we don't have an index on tx_hash. This is useful if you want all logs for a specific tx. https://www.indexsupply.net/query?query=select+topics%2C+data+%0Afrom+logs+%0Awhere+tx_hash+%3D+0x856230d65058272c1c53722e758c737f190722523f745b2e62dddcf33ee31179%0Aand+block_num+%3D+26774642&event_signatures=&chain=8453

1 reply

1 recast

7 reactions

Ryan pfp

I'm excited to share that @indexsupply is available on @conduit rollups! https://x.com/conduitxyz/status/1925205800558997803

1 reply

3 recasts

10 reactions

Ryan pfp

In addition to @indexsupply making a great backend for your app, it's also a really great debugging tool. Say you want a transactions's block's extra_data and nonce. Easy: https://tinyurl.com/2zrx9een

2 replies

22 recasts

49 reactions

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

2 recasts

22 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

6 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

8 recasts

56 reactions

Ryan pfp

Very excited to start deploying enterprise SSDs for @indexsupply This one here is 7TB pcie4 kioxia cd6 going into the backup server. Planning to deploy even more powerful pcie5 cm7s to production soon.

3 replies

3 recasts

24 reactions

Index Supply pfp

Thank you! Appreciate working with you too!

0 reply

0 recast

1 reaction

Index Supply pfp

indeed! https://tinyurl.com/zora-query

1 reply

1 recast

4 reactions

Index Supply pfp

Fascinating example of how to query events with nested tuples!

2 replies

1 recast

16 reactions

Index Supply pfp

If you have a Pro plan we can setup direct chat support. Otherwise email: [email protected] -- or just mention on FC ;) Yes! Sounds like you found the PG JSON arrow operator.

0 reply

0 recast

1 reaction

Index Supply pfp

The list of chains grow like the grass of spring

0 reply

1 recast

14 reactions

Index Supply pfp

We don't index tx input data. Maybe we should.

1 reply

0 recast

1 reaction

Index Supply pfp

SSE is ideal for one way communication whereas WS is good for two way. In the case of delivering data from a server to a client as quickly as possible SSE is the simplest and fastest way to do that.

0 reply

0 recast

1 reaction

✳️ dcposch pfp

Index Supply is a real feat of engineering. Radically simplify your eth apps. Skip RPCs, indexing, "subgraphs" and just query the chain directly. Now with any-chain payments. Follow @ryansmith for more!

0 reply

11 recasts

28 reactions

Index Supply pfp

See first hand how easy and fast it is to query data using Index Supply. Total amount for a specific address: https://tinyurl.com/bdzfxdmm Status of a specific payment: https://tinyurl.com/kmmerca2

1 reply

0 recast

2 reactions

Index Supply pfp

With Index Supply's API, you can open a Live SQL Query to be notified the instant your user completes a payment. Index Supply uses Postgres extensions, HTTP SSE, and a TypeScript SDK to make this simple and easy! Read all the details here: https://github.com/indexsupply/indexsupply.js/pull/6

1 reply

0 recast

4 reactions

Index Supply pfp

Daimo's webhooks are a good option for knowing when a payment is complete, but there are scenarios where running a server for webhooks is not ideal. One of the cool things about Ethereum is that we don't need privileged access to extend Daimo Pay's functionality – we can go straight to the chain!

1 reply

0 recast

3 reactions

Index Supply pfp

How Index Supply collects payments with Daimo Pay + Index Supply @daimo-pay is the simplest service for accepting any coin, on any chain, from any wallet. Index Supply is the simplest API for instant access to Ethereum. But can they blend?

2 replies

7 recasts

25 reactions