Michael Maguire
@morshonrai.bsky.social
Database programming, data modelling, data management, spreadsheet automation (VBA&GAS) and data analysis. General data munger and data wrangler in life sciences.
SQL|Shell|Python|Go
Data Matters Blog: https://rotifer.github.io/
SQL|Shell|Python|Go
Data Matters Blog: https://rotifer.github.io/
Reposted by Michael Maguire
I wrote a bit about my sidequest at Earendil: Building Absurd which implements durable execution (𝚞𝚜𝚎 𝚠𝚘𝚛𝚔𝚏𝚕𝚘𝚠, Temporal, Inngest, etc.) on just Postgres. How it works and why I like it. lucumr.pocoo.org/2025/11/3/ab...
Absurd Workflows: Durable Execution With Just Postgres
Durable execution with just postgres.
lucumr.pocoo.org
November 3, 2025 at 8:53 AM
I wrote a bit about my sidequest at Earendil: Building Absurd which implements durable execution (𝚞𝚜𝚎 𝚠𝚘𝚛𝚔𝚏𝚕𝚘𝚠, Temporal, Inngest, etc.) on just Postgres. How it works and why I like it. lucumr.pocoo.org/2025/11/3/ab...
Reposted by Michael Maguire
Is it possible to combine text, reproducible code, and reproducible results (tables or figures) all into one document? 📑 Find out how with the LMU Open Science Center tutorial about Quarto.
Self-Paced Tutorial of the Day: Intro. to Literate Programming with Quarto 💻 lmu-osc.github.io/introduction...
Self-Paced Tutorial of the Day: Intro. to Literate Programming with Quarto 💻 lmu-osc.github.io/introduction...
1. Welcome to the Quarto Workshop – Introduction to Quarto
lmu-osc.github.io
October 13, 2025 at 10:03 AM
Is it possible to combine text, reproducible code, and reproducible results (tables or figures) all into one document? 📑 Find out how with the LMU Open Science Center tutorial about Quarto.
Self-Paced Tutorial of the Day: Intro. to Literate Programming with Quarto 💻 lmu-osc.github.io/introduction...
Self-Paced Tutorial of the Day: Intro. to Literate Programming with Quarto 💻 lmu-osc.github.io/introduction...
Reposted by Michael Maguire
“Much as they have paid the price for their promotion of lies regarding the 2020 election and voting machines, it’s time for outfits that attack science and scientists to pay the price for the threat they pose to human civilisation.”
www.theguardian.com/commentisfre...
@michaelemann.bsky.social
www.theguardian.com/commentisfre...
@michaelemann.bsky.social
Science is under siege from weaponised disinformation – posing a threat to human civilisation | Michael Mann and Peter Hotez
From Covid misinformation to climate denialism, understanding the divergent paths of Australia and the US can help us fight the powerful forces that threaten our world
www.theguardian.com
September 9, 2025 at 4:12 AM
“Much as they have paid the price for their promotion of lies regarding the 2020 election and voting machines, it’s time for outfits that attack science and scientists to pay the price for the threat they pose to human civilisation.”
www.theguardian.com/commentisfre...
@michaelemann.bsky.social
www.theguardian.com/commentisfre...
@michaelemann.bsky.social
Reposted by Michael Maguire
RFK Jr. is an outright danger to this country, and he should resign or be fired. Do we still have the sort of government that does such things? Or have we turned into. . . that other kind. You know the one.
RFK Jr. Must Go. And He's Not the Only One.
www.science.org
August 28, 2025 at 5:07 PM
RFK Jr. is an outright danger to this country, and he should resign or be fired. Do we still have the sort of government that does such things? Or have we turned into. . . that other kind. You know the one.
Reposted by Michael Maguire
This week, I learned how to create and explore a data lake with duckdb, using its new ducklake extension. It was surprisingly easy to hand over the creation and management of parquet files with larg(ish) tables to ducklake. I loved being able to explore the data using R, python or plain SQL - […]
Original post on genomic.social
genomic.social
July 11, 2025 at 3:31 PM
This week, I learned how to create and explore a data lake with duckdb, using its new ducklake extension. It was surprisingly easy to hand over the creation and management of parquet files with larg(ish) tables to ducklake. I loved being able to explore the data using R, python or plain SQL - […]
Reposted by Michael Maguire
Dear PostgreSQL, Explain my bottleneck !
PostgreSQL Basics : lire un plan d’exécution comme un·e pro (ou presque) blog.capdata.fr/index.php/po...
PostgreSQL Basics : lire un plan d'exécution comme un·e pro (ou presque) - Capdata TECH BLOG
Introduction : Quand une requête PostgreSQL est considérée comme lente ou que ses performances se dégradent soudainement, il y a un réflexe à toujours avoir : utiliser les plans d’exécution. Je n’appr...
blog.capdata.fr
July 10, 2025 at 9:01 PM
Dear PostgreSQL, Explain my bottleneck !
Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)
www.hey.earth/posts/duckdb...
www.hey.earth/posts/duckdb...
Patrick Trainer
Personal blog and portfolio site
www.hey.earth
May 12, 2025 at 12:41 PM
Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)
www.hey.earth/posts/duckdb...
www.hey.earth/posts/duckdb...
Reposted by Michael Maguire
A wide-angle look at the ugly principles behind the current attacks on US science:
The Continuing Crisis, Part XIV: The Trumpist Worldview
www.science.org
May 6, 2025 at 4:23 PM
A wide-angle look at the ugly principles behind the current attacks on US science:
Reposted by Michael Maguire
The lasting damage that the Trump administration is doing to US science is barbaric. But more and more of the general public is hearing about it and just how bad it is:
The Continuing Crisis, Part XIII: Lasting Damage
www.science.org
April 28, 2025 at 4:46 PM
The lasting damage that the Trump administration is doing to US science is barbaric. But more and more of the general public is hearing about it and just how bad it is:
Reposted by Michael Maguire
One of the many problems with current working conditions at the FDA is that you have to listen to rambling conspiracy theory garble from RFK, Jr:
The Continuing Crisis, Part XII: Behold RFK Jr.'s FDA
www.science.org
April 14, 2025 at 6:11 PM
One of the many problems with current working conditions at the FDA is that you have to listen to rambling conspiracy theory garble from RFK, Jr:
Reposted by Michael Maguire
Life Altering Postgresql Patterns
#database #postgresql #reading-list
mccue.dev
April 5, 2025 at 1:05 PM
Reposted by Michael Maguire
DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/d...
March 12, 2025 at 1:18 PM
DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/d...
Reposted by Michael Maguire
Many normalized tables to join, or a few collections of application-oriented documents? 👇🏻 Some thoughts on relational versus document data modeling
www.linkedin.com/pulse/relati...
www.linkedin.com/pulse/relati...
Relational and Document Data Modeling (50 years ago, 25 years ago, and today)
Relational data modeling or document data modeling? This question has existed for 50 years of database technologies, and the response mirrors the wisdom of database consultants: it depends. The best d...
www.linkedin.com
March 11, 2025 at 7:02 PM
Many normalized tables to join, or a few collections of application-oriented documents? 👇🏻 Some thoughts on relational versus document data modeling
www.linkedin.com/pulse/relati...
www.linkedin.com/pulse/relati...
Gotta give this a try!
duckdb.org/2025/02/26/g...
duckdb.org/2025/02/26/g...
Reading and Writing Google Sheets in DuckDB
Securely read from and write to Google Sheets directly in DuckDB using the GSheets community extension! For ad hoc querying, authentication is as easy as logging into Google from a browser. Scheduled ...
duckdb.org
March 5, 2025 at 8:38 AM
Gotta give this a try!
duckdb.org/2025/02/26/g...
duckdb.org/2025/02/26/g...
Reposted by Michael Maguire
Repost & like, if you stand with President Zelensky!
February 28, 2025 at 8:34 PM
Repost & like, if you stand with President Zelensky!
Reposted by Michael Maguire
I'm starting a DuckDB newsletter, feel free to subscribe at learningduckdb.com
Learn DuckDB by example
Subscribe to the newsletter to get your dose of DuckDB tips, SQL tricks, and links to learn more about the swiss knife of analytical databases.
learningduckdb.com
February 17, 2025 at 3:46 PM
I'm starting a DuckDB newsletter, feel free to subscribe at learningduckdb.com
Reposted by Michael Maguire
This week, we are publishing two blog posts about window functions from our group-by therapist, Richard Wesley.
The first post describes new window function features in DuckDB, including GROUPS framing and aggregate/function modifiers.
Read more at duckdb.org/2025/02/10/w...
The first post describes new window function features in DuckDB, including GROUPS framing and aggregate/function modifiers.
Read more at duckdb.org/2025/02/10/w...
Catching up with Windowing
DuckDB implements a number of modern windowing features, some of which are extensions to the SQL standard. In version 1.2.0, we introduced GROUPS framing as well as aggregate and function modifiers.
duckdb.org
February 10, 2025 at 8:21 PM
This week, we are publishing two blog posts about window functions from our group-by therapist, Richard Wesley.
The first post describes new window function features in DuckDB, including GROUPS framing and aggregate/function modifiers.
Read more at duckdb.org/2025/02/10/w...
The first post describes new window function features in DuckDB, including GROUPS framing and aggregate/function modifiers.
Read more at duckdb.org/2025/02/10/w...
Reposted by Michael Maguire
[Blog] Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver
Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server – SQLpassion
www.sqlpassion.at
February 10, 2025 at 1:47 PM
[Blog] Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver