18272
Ryan
@ryansmith #18272
Building @indexsupply
https://r.32k.io
4761 Follower 142 Following
Very excited for this one. You can now query decoded tx inputs
https://tinyurl.com/3cyjfvx7
--ps v2 release announcement coming soon.
https://tinyurl.com/3cyjfvx7
--ps v2 release announcement coming soon.
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
Give x-chain queries a try and lmk what you think. May still be rough around the edges.
https://tinyurl.com/istxs4242
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)
Get a list of active connections on your @indexsupply api key
(the api key in video has been deleted. no freebees)
Interesting to see people try to delete my data
I recently added DB size and active connections to the status page! Fun.
There's a lot of data...
There's a lot of data...
Tooling is one of my favorite parts of C++ development.
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?
We are doing beautiful things with Postgres this evening. V2 @indexsupply is going to have a lot of fun new features.
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
https://www.orioledb.com/blog
email is better than all the other chat apps
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.
This one here is 7TB pcie4 kioxia cd6 going into the backup server. Planning to deploy even more powerful pcie5 cm7s to production soon.
Few things feel as good as a wise decision patiently executed
I went to the frequency domain and everyone knew you and your imaginary friend
FFT and IFFT are fucking wild
The elegance of going from value form back to coeff form is out of this world. It must have felt so good to figure that out.
The elegance of going from value form back to coeff form is out of this world. It must have felt so good to figure that out.
Implementing complex numbers and FFT with just datatypes (no floats)
https://gist.github.com/VictorTaelin/5776ede998d0039ad1cc9b12fd96811c
absolutely goated
https://gist.github.com/VictorTaelin/5776ede998d0039ad1cc9b12fd96811c
absolutely goated
We're going to be changing the name of "Chinese Remainder Theorem" to "Remainder Theorem of America". What a beautiful name.
the blocks never stop
1237
nicholas 🧨
@nicholas·17:00 04/03/2025
https://chipsandcheese.com/p/zen-5s-avx-512-frequency-behavior
Looks like AMD is increasingly the correct choice for vectorized workloads.
Looks like AMD is increasingly the correct choice for vectorized workloads.
Neat site on learning FPGAs: https://nandland.com
You may not like it, but many new and interesting low level projects are written in C++
Clickhouse
Duckdb
Ladybird
OpenFHE
Clickhouse
Duckdb
Ladybird
OpenFHE
If you're in FFTs pivot to NTTs
NANDtucket
@indexsupply CAN DECODE ALL KINDS OF ABI ENCODED DATA
18272
Ryan
@ryansmith·19:51 19/06/2024
It is possible to form tuples of tuples, arrays of tuples and so on.
I'm looking to lease a primo dwelling in SF.
Criteria: high quality build in a tranquil location.
I've had no luck on CL/Zillow. If anyone has a lead on such a dwelling please do let me know.
Criteria: high quality build in a tranquil location.
I've had no luck on CL/Zillow. If anyone has a lead on such a dwelling please do let me know.
Very excited about this for a few reasons
1) My latest PG extension decodes arbitrarily complex ABI data
2) Crypto companies should accept crypto payments
3) @daimo-pay is really good
1) My latest PG extension decodes arbitrarily complex ABI data
2) Crypto companies should accept crypto payments
3) @daimo-pay is really good
18268
Index Supply
@indexsupply·19:25 18/02/2025
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?
@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?
https://www.phoronix.com/review/amd-epyc-9965-9755-benchmarks/3
Interesting to see the comparison of the 9965 (more cores) and the 9755 (higher freq.) on ClickHouse and RocksDB tests.
More cores helps random reads while higher freq. presumably helped all of CH's compression and vectorized query processing.
I wonder if the CPUs have different io characteristics.
Interesting to see the comparison of the 9965 (more cores) and the 9755 (higher freq.) on ClickHouse and RocksDB tests.
More cores helps random reads while higher freq. presumably helped all of CH's compression and vectorized query processing.
I wonder if the CPUs have different io characteristics.
A while back I wondered if SSD vendors would start building for specific database implementation. Apparently the gods are on our side
https://blocksandfiles.com/2024/10/16/kioxia-speeds-rocksdb-1-8x-with-flexible-data-placement-ssd/
https://warpcast.com/ryansmith/0x40563ad3
https://blocksandfiles.com/2024/10/16/kioxia-speeds-rocksdb-1-8x-with-flexible-data-placement-ssd/
https://warpcast.com/ryansmith/0x40563ad3
Kioxia speeds up RocksDB with Flexible Data Placement SSD – Blocks and Files
Kioxia says it has accelerated RocksDB performance 1.8x and increased an SSD’s endurance 300 percent by using Flexible Data Placement (FDP) when writing data to the SSD. It has also launched a new XD8 PCIe gen 5 SSD for cloud providers and hyperscalers. FDP allows the placement of different data types in separate NAND blocks […]
blocksandfiles.com
18272
Ryan
@ryansmith·18:48 22/11/2024
https://transactional.blog/blog/2024-modern-database-hardware
Very excited for the future. I wonder how many new DB features will be implemented within the SSD.
Very excited for the future. I wonder how many new DB features will be implemented within the SSD.
What a beautiful motherboard. Notice the positions of the PCIe connectors. So close to the backplane. Wow.
wow!
I didn't realize AWS has a mechanism for taking consistent snapshots across EBS volumes.
https://aws.amazon.com/blogs/storage/taking-crash-consistent-snapshots-across-multiple-amazon-ebs-volumes-on-an-amazon-ec2-instance/
I didn't realize AWS has a mechanism for taking consistent snapshots across EBS volumes.
https://aws.amazon.com/blogs/storage/taking-crash-consistent-snapshots-across-multiple-amazon-ebs-volumes-on-an-amazon-ec2-instance/
What's stopping you from processing 576 GB/s?
Went on a little tour of IPMI/BMC security discussions. A few notes
- Seems more problematic at scale when you have many servers and require remote management
- You don't need to worry about network security if no one can access the network (ie don't plug a cable into the management port)
Schneier has a good summary post: https://www.schneier.com/blog/archives/2013/01/the_eavesdroppi.html
- Seems more problematic at scale when you have many servers and require remote management
- You don't need to worry about network security if no one can access the network (ie don't plug a cable into the management port)
Schneier has a good summary post: https://www.schneier.com/blog/archives/2013/01/the_eavesdroppi.html
Fascinating to think about optimizing loops for CPUs. I wonder if PG's numeric additions could benefit from a more branchless approach
https://github.com/postgres/postgres/blob/4f15759bdcddd23e874526a6b2c0ff86e0beb042/src/interfaces/ecpg/pgtypeslib/numeric.c#L637-L754
https://15721.courses.cs.cmu.edu/spring2023/slides/06-execution.pdf
https://github.com/postgres/postgres/blob/4f15759bdcddd23e874526a6b2c0ff86e0beb042/src/interfaces/ecpg/pgtypeslib/numeric.c#L637-L754
https://15721.courses.cs.cmu.edu/spring2023/slides/06-execution.pdf
People who are really serious about coffee should mineralize their own water.
Most queries in Snowflake / Redshift scan only 100MB of data!
https://www.fivetran.com/blog/how-do-people-use-snowflake-and-redshift
https://www.fivetran.com/blog/how-do-people-use-snowflake-and-redshift
Excellent paper on the pitfalls of MMAP files for DBMS workloads.
I've personally reached for the MMAP silver bullet and it didn't work out for me and this paper helped me understand why. Great read! A++
https://db.cs.cmu.edu/mmap-cidr2022/
I've personally reached for the MMAP silver bullet and it didn't work out for me and this paper helped me understand why. Great read! A++
https://db.cs.cmu.edu/mmap-cidr2022/
Are You Sure You Want to Use MMAP in Your Database Management System?
MMAP Databases = 💩
db.cs.cmu.edu
Just discovered Bundlephobia! Neat site for checking size / impact of an NPM package.
https://bundlephobia.com/package/@indexsupply/indexsupply.js
https://bundlephobia.com/package/@indexsupply/indexsupply.js
It's fun and telling to look at these sparklines
People aren't ready to hear that you can solve most problems with a little thinking and a little SQL.
You know the old expression: You don't get fired for buying IBM?
The expression is a little dated but you could probably make similar statements today; like:
You don't get fired for building a web app in React.
What are examples of the expression's antonym?
You certainly could get fired for building your web app in Haskell.
The expression is a little dated but you could probably make similar statements today; like:
You don't get fired for building a web app in React.
What are examples of the expression's antonym?
You certainly could get fired for building your web app in Haskell.
