{"id":36902,"date":"2022-09-01T17:10:26","date_gmt":"2022-09-01T21:10:26","guid":{"rendered":"https:\/\/mjtsai.com\/blog\/?p=36902"},"modified":"2022-09-01T17:10:26","modified_gmt":"2022-09-01T21:10:26","slug":"sqlite-and-duckdb","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2022\/09\/01\/sqlite-and-duckdb\/","title":{"rendered":"SQLite and DuckDB"},"content":{"rendered":"<p><a href=\"https:\/\/simonwillison.net\/2022\/Sep\/1\/sqlite-duckdb-paper\/\">Simon Willison<\/a> (<a href=\"https:\/\/news.ycombinator.com\/item?id=32675861\">Hacker News<\/a>):<\/p>\n<blockquote cite=\"https:\/\/simonwillison.net\/2022\/Sep\/1\/sqlite-duckdb-paper\/\"><p><a href=\"https:\/\/vldb.org\/pvldb\/volumes\/15\/paper\/SQLite%3A%20Past%2C%20Present%2C%20and%20Future\">SQLite: Past, Present, and Future<\/a> is a newly published paper authored by Kevin P. Gaffney, Martin Prammer and Jignesh M. Patel from the University of Wisconsin-Madison and D. Richard Hipp, Larry Brasfield and Dan Kennedy from the core SQLite engineering team.<\/p><p>The paper compares <a href=\"https:\/\/www.sqlite.org\/\">SQLite<\/a> and <a href=\"https:\/\/duckdb.org\/\">DuckDB<\/a>, and describes some optimization work to make SQLite perform better for analytical queries.<\/p><p>[&#8230;]<\/p><p>The primary difference is that DuckDB is optimized for analytical queries: queries that apply aggregate calculations across large numbers of rows, rather than being optimized for fast scanning and lookup of individual rows of data.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Simon Willison (Hacker News): SQLite: Past, Present, and Future is a newly published paper authored by Kevin P. Gaffney, Martin Prammer and Jignesh M. Patel from the University of Wisconsin-Madison and D. Richard Hipp, Larry Brasfield and Dan Kennedy from the core SQLite engineering team.The paper compares SQLite and DuckDB, and describes some optimization work [&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":"2022-09-01T21:10:28Z","apple_news_api_id":"9c900299-98ee-4329-ac15-e70e91aa1b4a","apple_news_api_modified_at":"2022-09-01T21:10:29Z","apple_news_api_revision":"AAAAAAAAAAD\/\/\/\/\/\/\/\/\/\/w==","apple_news_api_share_url":"https:\/\/apple.news\/AnJACmZjuQymsFecOkaobSg","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":[143,138,71,425],"class_list":["post-36902","post","type-post","status-publish","format-standard","hentry","category-programming-category","tag-database","tag-optimization","tag-programming","tag-sqlite"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/36902","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=36902"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/36902\/revisions"}],"predecessor-version":[{"id":36903,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/36902\/revisions\/36903"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=36902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=36902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=36902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}