Red|Dot 🔴 {🦇🔊}

11.8K posts

Red|Dot 🔴 {🦇🔊} banner
Red|Dot 🔴 {🦇🔊}

Red|Dot 🔴 {🦇🔊}

@Red_dot_name

#EngineeringManager that likes @RTFKT, @lootproject, @treeverse, @mekaverse. A 🦆 on @safe. A 🚀 on @yearnfi & @eulerfinance. A 💰on #ETH.

Iceland Katılım Mayıs 2018
180 Takip Edilen399 Takipçiler
Red|Dot 🔴 {🦇🔊} retweetledi
Mustafa Al-Bassam
Mustafa Al-Bassam@musalbas·
Another one got caught today, it's all over the news. "Dutch Court Hands Russian Tornado Cash Developer Lengthy Prison Sentence", "SEC Charges Coinbase for Operating as an Unregistered Securities Exchange, Broker, and Clearing Agency"... Damn cryptobros. They're all alike. But did you, in your three-piece psychology and 1950's technobrain, ever take a look behind the eyes of the crypto dev? Did you ever wonder what made him tick, what forces shaped him, what may have molded him? I am a crypto dev, enter my world... Mine is a world that begins with the 2008 financial crisis... I'm disillusioned by the financial systems, the monopolies on power, the rampant inflation... Damn techbro. They're all alike. I'm young, perhaps a Rust or Golang dev by day. I've listened to endless debates about the ethics of blockchain and the volatility of cryptocurrencies. I understand it. "No, sir, tax evasion and buying drugs isn't the only use case of crypto..." Damn idealist. Probably naive. They’re all alike. I made a discovery today. I found a smart contract. Wait a second, this is empowering. It acts on consensus. If there's a flaw, it’s because I programmed it. Not because it desires profit... Or fears change... Or thinks I'm too unconventional... Or dislikes disruption and shouldn’t exist... Damn idealist. All he wants is to fix things. They’re all alike. And then it happened... a door opened to a world... surging through a peer-to-peer network like electricity through a circuit, a seed phrase is generated, a sanctuary from the inequities of the financial system is sought... a community is built. "This is it... this is where I belong..." I know everyone here... even if I've never met them, never talked to them, may never hear from them again... I know you all... Damn anarchist. Obsessing over digital money again. They're all alike... You bet your ass we're all alike... we've been fed the lies of central banks when we hungered for economic freedom... the scraps of decentralization you did let slip through were underdeveloped and poorly understood. We've been dominated by tyrants, or ignored by the complacent. The few that had a vision for a better system found us willing early adaptors, but those few are like drops of water in the desert. This is our world now... the world of the decentralized ledger and the smart contract, the beauty of the cryptographic hash. We utilize technology already existing without relying on your corrupt intermediaries, and you call us criminals. We innovate... and you call us criminals. We seek financial sovereignty... and you call us criminals. We exist without borders, without central authority, without a single point of failure... and you call us criminals. You build financial empires, you wage economic warfare, you manipulate, deceive, and exploit us and try to make us believe it's for our own good, yet we're the criminals. If I am a criminal, my crime is that of autonomy. My crime is that of judging systems by their transparency and fairness, not by their endorsements. My crime is that of imagining a future you are too afraid to embrace, something that you will never forgive me for. I am a crypto dev, and this is my manifesto. You may stop one individual, but you can't stop us all... after all, we're all alike.
English
33
101
446
58.7K
Red|Dot 🔴 {🦇🔊} retweetledi
LeadDev
LeadDev@TheLeadDev·
Join us for the next edition of Bookmarked on May 21, where Suzan Bond will be joined by Ruchika Tulshyan to discuss Inclusion on purpose: An intersectional approach to creating a culture of belonging at work. Register for this free session below! ... bit.ly/4dCWgP5
LeadDev tweet media
English
0
1
1
781
Red|Dot 🔴 {🦇🔊} retweetledi
KeePassXC
KeePassXC@KeePassXC·
👋 Hey there! Whatcha doing tonight? That's what we thought, you are installing KeePassXC 2.7.8! We just released and are happy to provide plenty of improvements to our passkeys support and a slew of bug fixes and enhancements to make you feel awesome. keepassxc.org/blog/2024-05-0…
English
9
47
216
11.8K
Red|Dot 🔴 {🦇🔊} retweetledi
Gwen (Chen) Shapira
Gwen (Chen) Shapira@gwenshap·
Anyone knows of code-friendly alternative to something like Apple Notes? The goal is to save random code snippets in a bunch of languages. The main requirement is to treat text as plain text. Quotes are quotes, tabs are tabs, newlines are newlines. Exact octal value preserved. The other requirement is not to try and treat random code snippets as part of a project or something that should parse.
English
28
2
18
15.5K
Red|Dot 🔴 {🦇🔊} retweetledi
Tay 💖
Tay 💖@tayvano_·
Right now, every half-finished crypto investigation ends up collecting dust in a random group chat or some dude’s notepad. Thousands of half-investigations don’t make a single whole. Here’s to a future where we don’t have to start from scratch every time. 🍻
samczsun@samczsun

Today, we're launching the latest @_SEAL_Org initiative, and it's going to change crypto security forever. It's called SEAL-ISAC, and this is why we need it

English
14
29
212
35.1K
Red|Dot 🔴 {🦇🔊} retweetledi
banteg
banteg@banteg·
Just a reminder that the literal interpretation of "code is law" is dumb. Behind every code there is some intent. There was no intent to give outsized rewards in Comptroller, so it's a bug. Thus, you should return any excess COMP if you got any.
English
42
37
421
0
Red|Dot 🔴 {🦇🔊} retweetledi
Gwen (Chen) Shapira
Gwen (Chen) Shapira@gwenshap·
With everyone talking about why databases and backends like living next to each other, it seems like a good time to re-share my demo, where I show (using Postgres) how and why it is indeed a good idea:
English
0
3
35
4.6K
Red|Dot 🔴 {🦇🔊} retweetledi
banteg
banteg@banteg·
it's cool to see dune architecture is just parquet files #dunesql-architecture-2" target="_blank" rel="nofollow noopener">docs.dune.com/query-engine/w…
Boxer@0xBoxer

idk if anyone noticed, but I released a cracked guide on how to fix your Skill Issues with DuneSQL the other day in our docs. TL;DR: Dune uses Parquet files. Understanding how parquet files work and writing efficient queries against them will 100% speed up all of your queries. 1⃣the basics: DuneSQL is a fork of Trino with a few added datatypes and convenience functions for blockchain data. e.g. we have native support for INT256 and UINT256, we actually store varbinary data as varbinary and not as string. 2⃣ parquet files Parquet files are neither strictly row-oriented, nor column-oriented, but rather utilize a kind of hybrid approach that allows the engine to quickly scan through millions of rows and only actually read the data it needs in that exact moment into memory. This works because parquet files know things about themselves and their different internal segments. There are global and more localized Column Statistics that contain key info about the data contained inside of the parquet file. These Column Statistics are the only thing the engine starts reading while starting to scan through e.g. zora.logs. Only if the condition set in the query matches a parquet file level column statistic, will the engine actually go down and start reading pages of data. Therefore, there is nothing more important for DuneSQL performance than making sure the engine can actually use the column statistics. Unfortunately, in blockchain applications, we will find a lot of columns that are rather random and their column statistics are not useful and we will therefore force the db to do a full scan. Common examples are hashes, addresses and bytecode. We want to avoid using these as the only filter or join condition wherever possible. Positive examples and thankfully really easy to implement is simply utilising block_time, block_date or block_number. 3⃣ putting it into practice Instead of only using filter conditions that are not able to utilize column statistics: add conditions that can use column statistics: often times the simplest year filter is already enough to cut down processing time by 80%+. This same principle applies to joins: Follow this basic principle, try to understand how parquet files work for a bit and your DuneSQL performance will enormously improve. (actually it almost never is a complaint I hear from users anymore, but lots of queries could be even faster) There is a lot more meat 🍖🍖🍖 in the actual guide, go and grab it in the dune docs.

English
4
2
45
13.9K
Red|Dot 🔴 {🦇🔊} retweetledi
TrueBlocks, LLC 🌱
TrueBlocks, LLC 🌱@trueblocks·
If you know, you know. Magnus is amazing. Studying what's happening on chain using original sources straight from the node like a true academic. Academic use cases have always been one of my secret hopes for TrueBlocks.
Magnus Hansson@0xMagnusHansson

@Uniswap I use @ErigonEth and @trueblocks to categorize manual, algorithmic, and arbitrage trading alongside liquidity provision. In contrast to arbitrage trading, algorithmic trading accounts for 8% of price discovery, while manual trading and liquidity provision have no impact. 2/

English
1
2
9
767
Red|Dot 🔴 {🦇🔊} retweetledi
Gwen (Chen) Shapira
Gwen (Chen) Shapira@gwenshap·
Without saying “Postgres” what’s your favorite database?
English
213
7
107
61.1K
Red|Dot 🔴 {🦇🔊} retweetledi
banteg
banteg@banteg·
we are so back
banteg tweet media
English
38
24
426
66.2K

Keşfet

@comfydevil @cryptopunksbot @heyeaslo @brave @ProtonMail @fileverse @elonmusk @BarackObama