Andrea Borruso aborruso

$ wget https://usaminedroads.blob.core.windows.net/road-detections/MiddleEast-Full.zip
$ unzip MiddleEast-Full.zip
$ ~/duckdb roads.duckdb

CREATE OR REPLACE TABLE roads AS
    SELECT column0 as iso2,
 ST_GEOMFROMGeoJSON(column1::JSON-&gt;'$.geometry') geom

	name = "newsletter"
	prompt = """
	Take the latest blog post and convert it into a raw Markdown format suitable for an email newsletter, saving the output to a temporary file.

	Here is the process to follow:
	1. Read the file `src/pages/latest.astro` to identify the URL of the latest post.
	2. Construct the full path to the post's `.astro` file from that URL. For example, if the URL is `/posts/my-post`, the file path is `src/pages/posts/my-post.astro`.
	3. Read the content of the latest post's file.
	4. Apply the following conversion rules to transform the Astro file's content into clean Markdown:
	- Remove Frontmatter: The `---` block at the top of the Astro file must be deleted.