{"id":1505,"date":"2026-06-23T21:34:00","date_gmt":"2026-06-23T21:34:00","guid":{"rendered":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/"},"modified":"2026-06-26T03:59:56","modified_gmt":"2026-06-26T03:59:56","slug":"atom-everything-15","status":"publish","type":"post","link":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/","title":{"rendered":"Launch: datasette 1.0a35"},"content":{"rendered":"<p><br \/>\n<\/p>\n<div>\n<p>I will write extra about this one quickly, nevertheless it&#8217;s a giant launch. Three highlights from the discharge notes:<\/p>\n<blockquote>\n<p>New &#8220;Create desk&#8221; interface within the database actions menu, backed by the \/\/-\/create JSON API. It may possibly outline columns, main keys, customized column sorts, NOT NULL constraints, literal defaults, expression defaults and single-column international keys. (#2787)<br \/>\nNew &#8220;Alter desk&#8221; desk motion and \/\/\/-\/alter JSON API for altering current tables: add, rename, reorder and drop columns; change column sorts, defaults, NOT NULLconstraints, main keys and international keys; and rename the desk. The alter desk dialog additionally features a &#8220;Drop desk&#8221; button. (#2788)<br \/>\nNew Template context documentation itemizing the variables obtainable to customized templates for Datasette&#8217;s core pages. Variables documented there are handled as a steady API for customized templates till Datasette 2.0. The documentation is generated from dataclass definitions subsequent to the view code, with exams that evaluate the documented fields towards the precise contexts rendered by the database, desk, question and row pages. (#1510, #2127, #1477, #2803)<\/p>\n<p>This is a tough video demo I made from the brand new create\/alter desk characteristic as a part of reviewing the PR:<\/p>\n<\/blockquote>\n<\/div>\n<p><br \/>\n<br \/><a href=\"https:\/\/simonwillison.net\/2026\/Jun\/23\/datasette\/#atom-everything\">Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I will write extra about this one quickly, nevertheless it&#8217;s a giant launch. Three highlights from the discharge notes: New &#8220;Create desk&#8221; interface within the database actions menu, backed by the \/\/-\/create JSON API. It may possibly outline columns, main keys, customized column sorts, NOT NULL constraints, literal defaults, expression defaults and single-column international keys. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1507,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg","fifu_image_alt":"","jnews-multi-image_gallery":[],"jnews_single_post":[],"jnews_primary_category":[],"jnews_override_bookmark_settings":[],"jnews_social_meta":[],"jnews_override_counter":[],"footnotes":""},"categories":[5],"tags":[1960,244,243],"class_list":["post-1505","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-ai-open-source-ecosystem","tag-1-0a35","tag-datasette","tag-release"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Launch: datasette 1.0a35 - Future News 24<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Launch: datasette 1.0a35 - Future News 24\" \/>\n<meta property=\"og:description\" content=\"I will write extra about this one quickly, nevertheless it&#8217;s a giant launch. Three highlights from the discharge notes: New &#8220;Create desk&#8221; interface within the database actions menu, backed by the \/\/-\/create JSON API. It may possibly outline columns, main keys, customized column sorts, NOT NULL constraints, literal defaults, expression defaults and single-column international keys. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/\" \/>\n<meta property=\"og:site_name\" content=\"Future News 24\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-23T21:34:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-26T03:59:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg\" \/>\n<meta name=\"author\" content=\"Future News 24\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Future News 24\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/\"},\"author\":{\"name\":\"Future News 24\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#\\\/schema\\\/person\\\/cecad1bde21cfc357cf70128144d6c83\"},\"headline\":\"Launch: datasette 1.0a35\",\"datePublished\":\"2026-06-23T21:34:00+00:00\",\"dateModified\":\"2026-06-26T03:59:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/\"},\"wordCount\":194,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/static.simonwillison.net\\\/static\\\/2026\\\/create-alter-demo-first-frame.jpg\",\"keywords\":[\"1.0a35\",\"datasette\",\"Release\"],\"articleSection\":[\"Developer AI &amp; Open-Source Ecosystem\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/\",\"url\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/\",\"name\":\"Launch: datasette 1.0a35 - Future News 24\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/static.simonwillison.net\\\/static\\\/2026\\\/create-alter-demo-first-frame.jpg\",\"datePublished\":\"2026-06-23T21:34:00+00:00\",\"dateModified\":\"2026-06-26T03:59:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#primaryimage\",\"url\":\"https:\\\/\\\/static.simonwillison.net\\\/static\\\/2026\\\/create-alter-demo-first-frame.jpg\",\"contentUrl\":\"https:\\\/\\\/static.simonwillison.net\\\/static\\\/2026\\\/create-alter-demo-first-frame.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/06\\\/23\\\/atom-everything-15\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/futurenews24.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Launch: datasette 1.0a35\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#website\",\"url\":\"https:\\\/\\\/futurenews24.com\\\/\",\"name\":\"Future News 24\",\"description\":\"The Smart Hub for AI and Next-Gen Innovation\",\"publisher\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/futurenews24.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#organization\",\"name\":\"Future News 24\",\"url\":\"https:\\\/\\\/futurenews24.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/futurenews24.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/fn24-favicon.png\",\"contentUrl\":\"https:\\\/\\\/futurenews24.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/fn24-favicon.png\",\"width\":250,\"height\":250,\"caption\":\"Future News 24\"},\"image\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#\\\/schema\\\/person\\\/cecad1bde21cfc357cf70128144d6c83\",\"name\":\"Future News 24\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d57f07142d73cb5503ab2446ea7bc9ef3d0a5ba378d64a6157692311e42bf097?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d57f07142d73cb5503ab2446ea7bc9ef3d0a5ba378d64a6157692311e42bf097?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d57f07142d73cb5503ab2446ea7bc9ef3d0a5ba378d64a6157692311e42bf097?s=96&d=mm&r=g\",\"caption\":\"Future News 24\"},\"sameAs\":[\"https:\\\/\\\/futurenews24.com\"],\"url\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/author\\\/mridulpahuja20\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Launch: datasette 1.0a35 - Future News 24","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/","og_locale":"en_US","og_type":"article","og_title":"Launch: datasette 1.0a35 - Future News 24","og_description":"I will write extra about this one quickly, nevertheless it&#8217;s a giant launch. Three highlights from the discharge notes: New &#8220;Create desk&#8221; interface within the database actions menu, backed by the \/\/-\/create JSON API. It may possibly outline columns, main keys, customized column sorts, NOT NULL constraints, literal defaults, expression defaults and single-column international keys. [&hellip;]","og_url":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/","og_site_name":"Future News 24","article_published_time":"2026-06-23T21:34:00+00:00","article_modified_time":"2026-06-26T03:59:56+00:00","og_image":[{"url":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg","type":"","width":"","height":""}],"author":"Future News 24","twitter_card":"summary_large_image","twitter_image":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg","twitter_misc":{"Written by":"Future News 24","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#article","isPartOf":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/"},"author":{"name":"Future News 24","@id":"https:\/\/futurenews24.com\/#\/schema\/person\/cecad1bde21cfc357cf70128144d6c83"},"headline":"Launch: datasette 1.0a35","datePublished":"2026-06-23T21:34:00+00:00","dateModified":"2026-06-26T03:59:56+00:00","mainEntityOfPage":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/"},"wordCount":194,"commentCount":0,"publisher":{"@id":"https:\/\/futurenews24.com\/#organization"},"image":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#primaryimage"},"thumbnailUrl":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg","keywords":["1.0a35","datasette","Release"],"articleSection":["Developer AI &amp; Open-Source Ecosystem"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/","url":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/","name":"Launch: datasette 1.0a35 - Future News 24","isPartOf":{"@id":"https:\/\/futurenews24.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#primaryimage"},"image":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#primaryimage"},"thumbnailUrl":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg","datePublished":"2026-06-23T21:34:00+00:00","dateModified":"2026-06-26T03:59:56+00:00","breadcrumb":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#primaryimage","url":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg","contentUrl":"https:\/\/static.simonwillison.net\/static\/2026\/create-alter-demo-first-frame.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/futurenews24.com\/index.php\/2026\/06\/23\/atom-everything-15\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/futurenews24.com\/"},{"@type":"ListItem","position":2,"name":"Launch: datasette 1.0a35"}]},{"@type":"WebSite","@id":"https:\/\/futurenews24.com\/#website","url":"https:\/\/futurenews24.com\/","name":"Future News 24","description":"The Smart Hub for AI and Next-Gen Innovation","publisher":{"@id":"https:\/\/futurenews24.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/futurenews24.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/futurenews24.com\/#organization","name":"Future News 24","url":"https:\/\/futurenews24.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/futurenews24.com\/#\/schema\/logo\/image\/","url":"https:\/\/futurenews24.com\/wp-content\/uploads\/2026\/06\/fn24-favicon.png","contentUrl":"https:\/\/futurenews24.com\/wp-content\/uploads\/2026\/06\/fn24-favicon.png","width":250,"height":250,"caption":"Future News 24"},"image":{"@id":"https:\/\/futurenews24.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/futurenews24.com\/#\/schema\/person\/cecad1bde21cfc357cf70128144d6c83","name":"Future News 24","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d57f07142d73cb5503ab2446ea7bc9ef3d0a5ba378d64a6157692311e42bf097?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d57f07142d73cb5503ab2446ea7bc9ef3d0a5ba378d64a6157692311e42bf097?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d57f07142d73cb5503ab2446ea7bc9ef3d0a5ba378d64a6157692311e42bf097?s=96&d=mm&r=g","caption":"Future News 24"},"sameAs":["https:\/\/futurenews24.com"],"url":"https:\/\/futurenews24.com\/index.php\/author\/mridulpahuja20\/"}]}},"_links":{"self":[{"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/posts\/1505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/comments?post=1505"}],"version-history":[{"count":1,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/posts\/1505\/revisions"}],"predecessor-version":[{"id":1506,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/posts\/1505\/revisions\/1506"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/media\/1507"}],"wp:attachment":[{"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/media?parent=1505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/categories?post=1505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/tags?post=1505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}