Update to querydiff.com -> mysql now supported!
- visual diff tree
- stat table
- ops list
- text diff
Need to provide the JSON format of your query plans, which you can see how to do on the mysql website:
dev.mysql.com/blog-a...
#mysql #database #queryplan #data
where is that terrain from?
very cool
I remember a time when computers were slow enough that we would turn it on in the morning and then go make coffee.
They got fast enough that we would make coffee first and then go turn the computer on.
Now I wait for #firefox to crash, and then go make my coffee cos it takes so long to force quit
Made a little post about facet plots:
bmjhayward.github.io...
#dataviz #data
Advertise your account with a GIF (prounounced "gif")
a blessed image
#sega #sonicthehedgehog
They say Danny Carey made a deal with the devil. We don't know what Danny got out of it, but the devil got drum lessons.
- some guy on youtube. had to share.
#tool #dannycarey #drums #music
Even if you decide not to delete, I feel like this incredible little book—only 150 pages—should be required reading for getting anywhere near a computer or phone. 1/6
Closest thing I know of, which isn't _exactly_ about group decision making, is Nicole Forsgren's work on team performance: scholar.google.com/citations?hl...
peasoup here, newcastle
actually better now, today breathing through wet moss
starting ww3 to distract us from * gestures wildly * everything else
We're not ready captain
We're not ready
We are hiring for group leaders again — EBI is a great place to start your research group!
embl.wd103.myworkdayjobs.com/EMBL/job/Hin...
scheissenkünt!
glorious
![Screenshot of an explain query with the json response in the new format:
{
"query": "/* select#1 */ select `world`.`country`.`Name` AS `Name` from `world`.`country` where (`world`.`country`.`Code` like 'A%')",
"inputs": [
{
"ranges": [
"('A' <= Code <= 'A????????')"
],
"covering": false,
"operation": "Index range scan on country using PRIMARY over ('A' <= Code < 'A????????')",
"index_name": "PRIMARY",
"table_name": "country",
"access_type": "index",
"estimated_rows": 17.0,
"index_access_type": "index_range_scan",
"estimated_total_cost": 3.668778400708174
}
],
"condition": "(country.`Code` like 'A%')",
"operation": "Filter: (country.`Code` like 'A%')",
"access_type": "filter",
"estimated_rows": 17.0,
"estimated_total_cost": 3.668778400708174
}](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:6nzygavqfr5uu22lq33vw76s/bafkreibcbytkemmt7kwliza3jyaghpoxcjyh4zbjl2jyindxw2kczw2vfm)
Screenshot of an explain query with the json response in the new format: { "query": "/* select#1 */ select `world`.`country`.`Name` AS `Name` from `world`.`country` where (`world`.`country`.`Code` like 'A%')", "inputs": [ { "ranges": [ "('A' <= Code <= 'A????????')" ], "covering": false, "operation": "Index range scan on country using PRIMARY over ('A' <= Code < 'A????????')", "index_name": "PRIMARY", "table_name": "country", "access_type": "index", "estimated_rows": 17.0, "index_access_type": "index_range_scan", "estimated_total_cost": 3.668778400708174 } ], "condition": "(country.`Code` like 'A%')", "operation": "Filter: (country.`Code` like 'A%')", "access_type": "filter", "estimated_rows": 17.0, "estimated_total_cost": 3.668778400708174 }
`mysql> EXPLAIN FORMAT=JSON SELECT Name FROM country WHERE Code LIKE 'A%';`
which gives you this nice little object that's easy for a human to read and easy for a machine to parse.
2/2
Haven't worked with #mysql query plans much before. I was _delighted_ to find this update that came out with version 8.3, and is default from 8.4 onwards.
first thing: `mysql> SET @@explain_json_format_version = 2;`
second thing, your query:
1/2
Who makes these what is the fascist supply chain?
these are awesome, like the flag on the big regiment
got it done before February: now supporting #postgres
upload or copy paste query plans in xml for #postgres, #sqlite and #sqlserver
c&c welcome
photo of a page from a children's colouring book, scribbled all over with blue and orange crayon. there are 2 sudoku grids each 6 by 6 squares. one is filled out with crayon, the other has not been started. there are outlines of a large birthday cake, balloons and streamers for the child to colour in
played my first ever game of sudoku today. playing crayons with my 2 year old
Totally just get the hardcover and give the paperbacks as a gift.
You only live once and you won't pass by this way again!
hny
sydney fiteworks were pretty flash
teaching my 2 year old to associate #heavymetal with chocolate
he does this cute side-to-side headbang
always push for better security
every hackaday headline is a banger
have a few on my reading list rn
Starcraft Brood War
Dear Santa,
for Christmas I would like
a Bluey collab with Thomas the Tank Engine
Five real global health wins in 2025
1.HPV vaccination scaled faster than expected;
2. measles/rubella eliminated in several countries;
3. long-acting HIV PrEP (lenacapavir) approved;
4. progress on TB vaccines/diagnostics;
5. A promising new antimalarial.
www.theguardian.com/global-devel...
