{"id":8543,"date":"2025-10-11T06:33:36","date_gmt":"2025-10-11T06:33:36","guid":{"rendered":"https:\/\/www.aiproblog.com\/index.php\/2025\/10\/11\/we-benchmarked-duckdb-sqlite-and-pandas-on-1m-rows-heres-what-happened\/"},"modified":"2025-10-11T06:33:36","modified_gmt":"2025-10-11T06:33:36","slug":"we-benchmarked-duckdb-sqlite-and-pandas-on-1m-rows-heres-what-happened","status":"publish","type":"post","link":"https:\/\/www.aiproblog.com\/index.php\/2025\/10\/11\/we-benchmarked-duckdb-sqlite-and-pandas-on-1m-rows-heres-what-happened\/","title":{"rendered":"We Benchmarked DuckDB, SQLite, and Pandas on 1M Rows: Here\u2019s What Happened"},"content":{"rendered":"<p>Author: Nate Rosidi<\/p>\n<div>See the results of comparing speed and memory efficiency of DuckDB, SQLite, and Pandas on a million-row dataset.<\/div>\n<p><a href=\"https:\/\/www.kdnuggets.com\/we-benchmarked-duckdb-sqlite-and-pandas-on-1m-rows-heres-what-happened\">Go to Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Author: Nate Rosidi See the results of comparing speed and memory efficiency of DuckDB, SQLite, and Pandas on a million-row dataset. Go to Source<\/p>\n","protected":false},"author":1,"featured_media":475,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[26],"tags":[],"_links":{"self":[{"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/posts\/8543"}],"collection":[{"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/comments?post=8543"}],"version-history":[{"count":0,"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/posts\/8543\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/media\/463"}],"wp:attachment":[{"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/media?parent=8543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/categories?post=8543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aiproblog.com\/index.php\/wp-json\/wp\/v2\/tags?post=8543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}