Solana is... interesting

Dune data has weird gaps in data and timeouts when you try to lookup a tx, nothing works like EVM, it's just all so strange... and yet look at those MCs...

Husband, dad, dev • @dune.eth wizard • Ultimate Ⓜ️oxie Dashboard https://tinyurl.com/moxiedash •  I'm just zis guy, you know?

yeah I wonder why they're not as reliable given how popular solana is? look at this, for example, missing symbol names -- I assume there's a way to figure them out, but I haven't found it yet, and it's surprising they're missing from curated data to begin with.... unless there is some convention here I'm not aware of yet

Stay Curious // iixii // Lazer Technologies // Prev: CoinDesk, Roc Nation // based

Providers for indexing solana aren’t as reliable as ETH today. It’s like indexing ETH during defi summer on Solana today.

Plus Solana probably has a lot more transaction velocity to index

Crypto enthusiast, ethics, movies and photography.

Founder of /gentlemanswagers

It's a shit chain made by shitty team, endorsed by even shittier people. It was crap back in 2021 and is crap now. 

I really wish I bought (and held) some.

dune

Whatever your decentralized, borderless, neutral, censorship-resistant open blockchain question is, the answer is YES… to Crypto!

probably should have posted in /dune because I'm specifically talking sol data in Dune; can't speak for Solana as a whole

if it can't be reliably verified, is it any better than Enron?

Founder far.quest & @wieldlabs.eth. Investing miy.com ventures. FID #274. Previously Square/Cash App. https://hiimnico.xyz/

literally just been poking around the Dune tables so I can simulate some trading strategies out of curiosity

dex_solana.trades (EVM stuff is on dex.trades)
solana.transactions
etc.

What dev tools are you using? Can’t seem to find even the basic stuff

yeah, doing select * from solana.transactions where id = 'xxx' timed out after 30min with medium 🤯

adding in block_slot was nearly instant, though, luckily I have that on hand

Data is so large that you can’t generally just look for a hash - need to provide more guidance to the query engine or use a tool that’s built for oltp not olap

dadjokes

fortune cookie casts, memes, parenting, building frames, /framedl, /framedl-pro & /calmer

there may be a reason for the existence of places where sol doesn't shine 

(stupid pun, sue me)

🤣 I don't mean anything is amiss, just what appears to be poor data quality on some basic stuff and poorly indexed tables... which is surprising given how popular it is, I'd have thought people were crunching this data all the time! other possibility is I'm just making a noob mistake somewhere.....

Careful…gonna end up exposing something massive and be disappeared by the SOL mob…

Who's got the skills issue?

Didn't say Solana data is bad -- I see the appeal in some of what they're doing, and IMO the EVM is way too low level and it seems like Solana is designed to tackle that. I'm commenting on my experience trying to do some stuff that is very simple on Dune with EVM-based data, but nowhere near as simple or intuitive with the Solana data.

When you say you're biased, I was trying to identify what product you work on... is it envio? is envio data only accessible via graphql or can I run SQL queries over it?

"skills issue"

Up to the data consumer to decide where in the stack that lies 😉

I'm super biased, but imo, most providers add Solana as an after thought / marketing ploy. Solana data is different, and large, but it's not inherently bad. Some of it is actually very good (e.g. balance snapshots with each tx)