Andrey Satarin
@asatarin.bsky.social
Staff SRE at Google. Distributed systems / databases / reliability / correctness. Views my own. Repost / like is not an endorsement.
http://asatarin.github.io
http://asatarin.github.io
Hades 2? What's your game preferences?
October 26, 2025 at 9:55 PM
Hades 2? What's your game preferences?
AFAIR circa 10 years ago ApacheCommons (or other popular library) had matcher using reflection to compare two objects. I think it even supported excluding fields, but not nested exclusion.
July 14, 2025 at 11:51 AM
AFAIR circa 10 years ago ApacheCommons (or other popular library) had matcher using reflection to compare two objects. I think it even supported excluding fields, but not nested exclusion.
Calvin protocol has shards communicate read-write sets and values via messages.
July 10, 2025 at 12:28 PM
Calvin protocol has shards communicate read-write sets and values via messages.
Reposted by Andrey Satarin
-------
"Jepsen 18: Serializable Mom", Kyle Kingsbury/@aphyr.com , #sd25
Engineers are tasked with building towers of abstraction, building everything higher and higher above the towering tire fire that is databases.
"I professionally set those tires on fire".
"Jepsen 18: Serializable Mom", Kyle Kingsbury/@aphyr.com , #sd25
Engineers are tasked with building towers of abstraction, building everything higher and higher above the towering tire fire that is databases.
"I professionally set those tires on fire".
June 20, 2025 at 1:22 PM
-------
"Jepsen 18: Serializable Mom", Kyle Kingsbury/@aphyr.com , #sd25
Engineers are tasked with building towers of abstraction, building everything higher and higher above the towering tire fire that is databases.
"I professionally set those tires on fire".
"Jepsen 18: Serializable Mom", Kyle Kingsbury/@aphyr.com , #sd25
Engineers are tasked with building towers of abstraction, building everything higher and higher above the towering tire fire that is databases.
"I professionally set those tires on fire".
AFAIU very few disaggregated / serverless databases scale to true zero. It’s a pretty special feature
June 20, 2025 at 8:40 AM
AFAIU very few disaggregated / serverless databases scale to true zero. It’s a pretty special feature
Are these different CPUs? E.g. oversubscribed or something? Should one compare to pure VM costs to see what the premium is for the database?
June 19, 2025 at 8:29 AM
Are these different CPUs? E.g. oversubscribed or something? Should one compare to pure VM costs to see what the premium is for the database?
Notepad++ is awesome.
Long time ago it was the only (or one of the few) option to open 1G+ text files on windows. Not sure if still.
Long time ago it was the only (or one of the few) option to open 1G+ text files on windows. Not sure if still.
May 29, 2025 at 1:28 AM
Notepad++ is awesome.
Long time ago it was the only (or one of the few) option to open 1G+ text files on windows. Not sure if still.
Long time ago it was the only (or one of the few) option to open 1G+ text files on windows. Not sure if still.
If you are interested in more real world experience reports @cliffclick.bsky.social talked about it
youtu.be/GEkeOHw87Sg
youtu.be/GEkeOHw87Sg
Cliff Click — The Azul Hardware Transactional Memory experience
YouTube video by Hydra
youtu.be
May 17, 2025 at 10:45 PM
If you are interested in more real world experience reports @cliffclick.bsky.social talked about it
youtu.be/GEkeOHw87Sg
youtu.be/GEkeOHw87Sg
More on:
- reusing corpora of tests from existing systems
- metamorphic tests with SQLancer
- verifying control plan with fault injection and fuzzing
Added to the list
https://asatarin.github.io/testing-distributed-systems/#feldera
- reusing corpora of tests from existing systems
- metamorphic tests with SQLancer
- verifying control plan with fault injection and fuzzing
Added to the list
https://asatarin.github.io/testing-distributed-systems/#feldera
Testing Distributed Systems
Curated list of resources on testing distributed systems
asatarin.github.io
January 13, 2025 at 4:49 PM
More on:
- reusing corpora of tests from existing systems
- metamorphic tests with SQLancer
- verifying control plan with fault injection and fuzzing
Added to the list
https://asatarin.github.io/testing-distributed-systems/#feldera
- reusing corpora of tests from existing systems
- metamorphic tests with SQLancer
- verifying control plan with fault injection and fuzzing
Added to the list
https://asatarin.github.io/testing-distributed-systems/#feldera
Reposted by Andrey Satarin
Reposted by Andrey Satarin
This is a sample from a list "testing-sql-databases" I have.
It's more drafty, most likely missing a ton from big tech, startups and academia alike and not published.
It's more drafty, most likely missing a ton from big tech, startups and academia alike and not published.
December 12, 2024 at 6:35 AM
This is a sample from a list "testing-sql-databases" I have.
It's more drafty, most likely missing a ton from big tech, startups and academia alike and not published.
It's more drafty, most likely missing a ton from big tech, startups and academia alike and not published.
Reposted by Andrey Satarin
Good old Microsoft published some work:
- "Deploying a Steered Query Optimizer in Production at Microsoft" dl.acm.org/doi/abs/10.1...
- This great talk "The Cascades Framework for Query Optimization at Microsoft" touches on correctness youtu.be/pQe1LQJiXN0
- "Deploying a Steered Query Optimizer in Production at Microsoft" dl.acm.org/doi/abs/10.1...
- This great talk "The Cascades Framework for Query Optimization at Microsoft" touches on correctness youtu.be/pQe1LQJiXN0
Deploying a Steered Query Optimizer in Production at Microsoft | Proceedings of the 2022 International Conference on Management of Data
You will be notified whenever a record that you have chosen has been cited.
dl.acm.org
December 12, 2024 at 6:35 AM
Good old Microsoft published some work:
- "Deploying a Steered Query Optimizer in Production at Microsoft" dl.acm.org/doi/abs/10.1...
- This great talk "The Cascades Framework for Query Optimization at Microsoft" touches on correctness youtu.be/pQe1LQJiXN0
- "Deploying a Steered Query Optimizer in Production at Microsoft" dl.acm.org/doi/abs/10.1...
- This great talk "The Cascades Framework for Query Optimization at Microsoft" touches on correctness youtu.be/pQe1LQJiXN0
Reposted by Andrey Satarin
Work on correctness of optimizers from Greenplum
- "Automatic capture of minimal, portable, and executable bug repros using AMPERe" dl.acm.org/doi/10.1145/...
- "Testing the accuracy of query optimizers" dl.acm.org/doi/10.1145/...
- "Automatic capture of minimal, portable, and executable bug repros using AMPERe" dl.acm.org/doi/10.1145/...
- "Testing the accuracy of query optimizers" dl.acm.org/doi/10.1145/...
Automatic capture of minimal, portable, and executable bug repros using AMPERe | Proceedings of the Fifth International Workshop on Testing Database Systems
You will be notified whenever a record that you have chosen has been cited.
dl.acm.org
December 12, 2024 at 6:35 AM
Work on correctness of optimizers from Greenplum
- "Automatic capture of minimal, portable, and executable bug repros using AMPERe" dl.acm.org/doi/10.1145/...
- "Testing the accuracy of query optimizers" dl.acm.org/doi/10.1145/...
- "Automatic capture of minimal, portable, and executable bug repros using AMPERe" dl.acm.org/doi/10.1145/...
- "Testing the accuracy of query optimizers" dl.acm.org/doi/10.1145/...
Reposted by Andrey Satarin
Similar work from Databricks:
- "SparkFuzz: searching correctness regressions in modern query engines" dl.acm.org/doi/abs/10.1...
- "Correctness and Performance of Apache Spark SQL" youtu.be/fddBOZxdUKI
- "SparkFuzz: searching correctness regressions in modern query engines" dl.acm.org/doi/abs/10.1...
- "Correctness and Performance of Apache Spark SQL" youtu.be/fddBOZxdUKI
SparkFuzz | Proceedings of the workshop on Testing Database Systems
dl.acm.org
December 12, 2024 at 6:35 AM
Similar work from Databricks:
- "SparkFuzz: searching correctness regressions in modern query engines" dl.acm.org/doi/abs/10.1...
- "Correctness and Performance of Apache Spark SQL" youtu.be/fddBOZxdUKI
- "SparkFuzz: searching correctness regressions in modern query engines" dl.acm.org/doi/abs/10.1...
- "Correctness and Performance of Apache Spark SQL" youtu.be/fddBOZxdUKI
Reposted by Andrey Satarin
You already mentioned "Snowtrail: Testing with Production Queries on a Cloud Database" from Snowflake
dl.acm.org/doi/10.1145/...
dl.acm.org/doi/10.1145/...
Snowtrail | Proceedings of the Workshop on Testing Database Systems
dl.acm.org
December 12, 2024 at 6:35 AM
You already mentioned "Snowtrail: Testing with Production Queries on a Cloud Database" from Snowflake
dl.acm.org/doi/10.1145/...
dl.acm.org/doi/10.1145/...