{"id":8622,"date":"2014-03-28T17:25:15","date_gmt":"2014-03-28T21:25:15","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=8622"},"modified":"2014-03-28T17:26:39","modified_gmt":"2014-03-28T21:26:39","slug":"outlandish-sqlite-recursive-query-examples","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2014\/03\/28\/outlandish-sqlite-recursive-query-examples\/","title":{"rendered":"Outlandish SQLite Recursive Query Examples"},"content":{"rendered":"<p><a href=\"https:\/\/sqlite.org\/lang_with.html#mandelbrot\">SQLite<\/a>:<\/p>\n<blockquote cite=\"https:\/\/sqlite.org\/lang_with.html#mandelbrot\"><p>The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art.<\/p>\n<p>[&#8230;]<\/p>\n<p>This next query solves a Sudoku puzzle.<\/p>\n<p>[&#8230;]<\/p>\n<p>The final answer is found by looking for a string with ind==0. If the original sudoku problem did not have a unique solution, then the query will return all possible solutions. If the original problem was unsolvable, then no rows will be returned.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>SQLite: The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art. [&#8230;] This next query solves a Sudoku puzzle. [&#8230;] The final answer is found by looking for a string with ind==0. If the original sudoku problem did not have a unique solution, then the query will return all [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[4],"tags":[71,677,425],"class_list":["post-8622","post","type-post","status-publish","format-standard","hentry","category-programming-category","tag-programming","tag-sql","tag-sqlite"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/8622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=8622"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/8622\/revisions"}],"predecessor-version":[{"id":8623,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/8622\/revisions\/8623"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=8622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=8622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=8622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}