{"id":158,"date":"2026-05-29T03:32:00","date_gmt":"2026-05-29T03:32:00","guid":{"rendered":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/"},"modified":"2026-06-04T18:41:47","modified_gmt":"2026-06-04T18:41:47","slug":"atom-everything","status":"publish","type":"post","link":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/","title":{"rendered":"Launch: datasette 1.0a31"},"content":{"rendered":"<p><br \/>\n<\/p>\n<div>\n<p>One other important alpha launch, with two new headline options.<\/p>\n<blockquote>\n<p>Datasette now gives customers with the mandatory permissions the flexibility to each execute write queries towards their database and to save lots of saved queries (renamed from &#8220;canned queries&#8221;) each privately and to be used by different members of their Datasette occasion.<\/p>\n<\/blockquote>\n<p>There&#8217;s extra element in SQL write queries and saved queries in Datasette 1.0a31 on the Datasette weblog, which now has three posts introducing new options for the reason that weblog launched two weeks in the past.<\/p>\n<p>Here is an animated demo from the weblog submit exhibiting how the brand new execute question interface lets individuals get began with templated insert\/replace\/delete queries from tables they&#8217;ve permission to edit:<\/p>\n<p><img decoding=\"async\" alt=\"The user starts on the data database page, selects actions and &quot;Execute write SQL&quot;, then selects the insert document template on the next page and executes it with a title of &quot;My document!&quot;. Also demonstrates that a create table statement cannot be executed because the user does not have create-table permission.\" src=\"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif\"\/><\/p>\n<\/div>\n<p><br \/>\n<br \/><a href=\"https:\/\/simonwillison.net\/2026\/May\/29\/datasette\/#atom-everything\">Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>One other important alpha launch, with two new headline options. Datasette now gives customers with the mandatory permissions the flexibility to each execute write queries towards their database and to save lots of saved queries (renamed from &#8220;canned queries&#8221;) each privately and to be used by different members of their Datasette occasion. There&#8217;s extra element [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":160,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif","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":[245,244,243],"class_list":["post-158","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-ai-open-source-ecosystem","tag-1-0a31","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.0a31 - 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\/05\/29\/atom-everything\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Launch: datasette 1.0a31 - Future News 24\" \/>\n<meta property=\"og:description\" content=\"One other important alpha launch, with two new headline options. Datasette now gives customers with the mandatory permissions the flexibility to each execute write queries towards their database and to save lots of saved queries (renamed from &#8220;canned queries&#8221;) each privately and to be used by different members of their Datasette occasion. There&#8217;s extra element [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/\" \/>\n<meta property=\"og:site_name\" content=\"Future News 24\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-29T03:32:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-04T18:41:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif\" \/>\n<meta name=\"author\" content=\"Future News 24\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif\" \/>\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\\\/05\\\/29\\\/atom-everything\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/\"},\"author\":{\"name\":\"Future News 24\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#\\\/schema\\\/person\\\/cecad1bde21cfc357cf70128144d6c83\"},\"headline\":\"Launch: datasette 1.0a31\",\"datePublished\":\"2026-05-29T03:32:00+00:00\",\"dateModified\":\"2026-06-04T18:41:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/\"},\"wordCount\":130,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/datasette.io\\\/static\\\/blog\\\/2026\\\/sql-write-ui.gif\",\"keywords\":[\"1.0a31\",\"datasette\",\"Release\"],\"articleSection\":[\"Developer AI &amp; Open-Source Ecosystem\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/\",\"url\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/\",\"name\":\"Launch: datasette 1.0a31 - Future News 24\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/datasette.io\\\/static\\\/blog\\\/2026\\\/sql-write-ui.gif\",\"datePublished\":\"2026-05-29T03:32:00+00:00\",\"dateModified\":\"2026-06-04T18:41:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#primaryimage\",\"url\":\"https:\\\/\\\/datasette.io\\\/static\\\/blog\\\/2026\\\/sql-write-ui.gif\",\"contentUrl\":\"https:\\\/\\\/datasette.io\\\/static\\\/blog\\\/2026\\\/sql-write-ui.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/futurenews24.com\\\/index.php\\\/2026\\\/05\\\/29\\\/atom-everything\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/futurenews24.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Launch: datasette 1.0a31\"}]},{\"@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.0a31 - 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\/05\/29\/atom-everything\/","og_locale":"en_US","og_type":"article","og_title":"Launch: datasette 1.0a31 - Future News 24","og_description":"One other important alpha launch, with two new headline options. Datasette now gives customers with the mandatory permissions the flexibility to each execute write queries towards their database and to save lots of saved queries (renamed from &#8220;canned queries&#8221;) each privately and to be used by different members of their Datasette occasion. There&#8217;s extra element [&hellip;]","og_url":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/","og_site_name":"Future News 24","article_published_time":"2026-05-29T03:32:00+00:00","article_modified_time":"2026-06-04T18:41:47+00:00","og_image":[{"url":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif","type":"","width":"","height":""}],"author":"Future News 24","twitter_card":"summary_large_image","twitter_image":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif","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\/05\/29\/atom-everything\/#article","isPartOf":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/"},"author":{"name":"Future News 24","@id":"https:\/\/futurenews24.com\/#\/schema\/person\/cecad1bde21cfc357cf70128144d6c83"},"headline":"Launch: datasette 1.0a31","datePublished":"2026-05-29T03:32:00+00:00","dateModified":"2026-06-04T18:41:47+00:00","mainEntityOfPage":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/"},"wordCount":130,"commentCount":0,"publisher":{"@id":"https:\/\/futurenews24.com\/#organization"},"image":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#primaryimage"},"thumbnailUrl":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif","keywords":["1.0a31","datasette","Release"],"articleSection":["Developer AI &amp; Open-Source Ecosystem"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/","url":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/","name":"Launch: datasette 1.0a31 - Future News 24","isPartOf":{"@id":"https:\/\/futurenews24.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#primaryimage"},"image":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#primaryimage"},"thumbnailUrl":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif","datePublished":"2026-05-29T03:32:00+00:00","dateModified":"2026-06-04T18:41:47+00:00","breadcrumb":{"@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#primaryimage","url":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif","contentUrl":"https:\/\/datasette.io\/static\/blog\/2026\/sql-write-ui.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/futurenews24.com\/index.php\/2026\/05\/29\/atom-everything\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/futurenews24.com\/"},{"@type":"ListItem","position":2,"name":"Launch: datasette 1.0a31"}]},{"@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\/158","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=158"}],"version-history":[{"count":1,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"predecessor-version":[{"id":159,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/posts\/158\/revisions\/159"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/media\/160"}],"wp:attachment":[{"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/futurenews24.com\/index.php\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}