{"id":112049,"date":"2026-01-17T11:43:59","date_gmt":"2026-01-17T11:43:59","guid":{"rendered":"https:\/\/www.timestored.com\/b\/?p=112049"},"modified":"2026-01-17T11:48:40","modified_gmt":"2026-01-17T11:48:40","slug":"size-isnt-everything-with-databases","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/size-isnt-everything-with-databases\/","title":{"rendered":"Size Isn&#8217;t Everything with Databases"},"content":{"rendered":"<h2>Size Isn&#8217;t Everything with Databases &#8211; Nor When It Comes to Database Driver size.<\/h2>\n<p>With QStudio and Pulse, we get to work hands-on with <strong data-start=\"528\" data-end=\"545\">30+ databases<\/strong>. That gives us a lot of appreciation for teams that do <em data-start=\"601\" data-end=\"617\">more with less<\/em> &#8211; especially some of the smaller teams building compact databases and drivers that deliver an outsized amount of value.<\/p>\n<p>In both Pulse and QStudio, we bundle a core set of JDBC drivers and optionally download others when a user adds a specific database. We do this deliberately to keep the applications lightweight. We care about every megabyte and don\u2019t want to bloat either our product or our users\u2019 SSDs.<\/p>\n<h3><span style=\"text-decoration: underline;\">Database Driver Size<\/span><\/h3>\n<p>Notice:<\/p>\n<ul>\n<li><strong>DuckDB<\/strong>\u00a0 &#8211; An entire database that is smaller than both the Snowflake and the Arrow\/flight SQL driver.<\/li>\n<li><strong>H2<\/strong> &#8211; Another full database (Java-specific) that is smaller than roughly a third of the drivers we ship.<\/li>\n<li><strong>Kdb+ &#8211; Supports JDBC<\/strong> and has the fastest industry wide bulk inserts while being one .java file (1900 lines, 60KB)<\/li>\n<\/ul>\n<p>Obviously, a smaller driver or database isn\u2019t always \u201cbetter\u201d in isolation. But having worked closely with these three in production settings, we can say they are exceptional pieces of engineering. The performance these teams achieve with such compact codebases is a testament to strong engineering discipline and a relentless focus on efficiency end-to-end. Huge congratulations to the teams behind them.<\/p>\n<p><strong>Scale matters\u00a0 but Efficiency is what makes scale sustainable.<\/strong><\/p>\n<div id=\"attachment_112050\" style=\"width: 1023px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2026\/01\/jdbc-driver-sizes.png\"><img aria-describedby=\"caption-attachment-112050\" loading=\"lazy\" class=\"size-full wp-image-112050\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2026\/01\/jdbc-driver-sizes.png\" alt=\"database driver size\" width=\"1013\" height=\"700\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2026\/01\/jdbc-driver-sizes.png 1013w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2026\/01\/jdbc-driver-sizes-300x207.png 300w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2026\/01\/jdbc-driver-sizes-768x531.png 768w\" sizes=\"(max-width: 1013px) 100vw, 1013px\" \/><\/a><p id=\"caption-attachment-112050\" class=\"wp-caption-text\">Database Driver Size<\/p><\/div>\n<p>&nbsp;<\/p>\n<h2>Full Sizes (in KB):<\/h2>\n<p><strong>42776 flight-sql-jdbc-driver-18.1.0.jar<\/strong><br \/>\n<strong>27644 snowflake-jdbc-3.13.6.jar<\/strong><br \/>\n19144 athena-jdbc-3.2.0-with-dependencies.jar<br \/>\n16696 kyuubi-hive-jdbc-shaded-1.7.1.jar<br \/>\n13904 ignite-core-2.15.0.jar<br \/>\n12728 sqlite-jdbc-3.42.0.0.jar<br \/>\n10284 kylin-jdbc-5.0.0-alpha.jar<br \/>\n10180 neo4j-jdbc-driver-4.0.9.jar<br \/>\n9856 trino-jdbc-422.jar<br \/>\n9652 presto-jdbc-0.282.jar<br \/>\n8984 redshift-jdbc42-2.1.0.28.jar<br \/>\n6564 jt400-20.0.0.jar<br \/>\n6504 presto-jdbc-350.jar<br \/>\n6268 mongodb-jdbc-2.0.2-all.jar<br \/>\n5652 taos-jdbcdriver-3.2.4-dist.jar<br \/>\n4964 gemfirexd-client-2.0-BETA.jar<br \/>\n4400 ojdbc8-19.19.0.0.jar<br \/>\n4060 jdbc-1.30.22.3-jar-with-dependencies.jar<br \/>\n3856 omnisci-jdbc-5.10.0.jar<br \/>\n3600 derby-10.15.2.0.jar<br \/>\n<strong>2556 h2-2.2.224.jar<\/strong><br \/>\n2540 mysql-connector-j-9.1.0.jar<br \/>\n1628 hsqldb-2.7.2-jdk8.jar<br \/>\n1608 hsqldb-2.7.2.jar<br \/>\n1488 jdbc-3.00.0.1-jar-with-dependencies.jar<br \/>\n1456 redis-jdbc-driver-1.4.jar<br \/>\n1380 clickhouse-jdbc-0.6.0.jar<br \/>\n1368 jdbc-1.30.22.5-jar-with-dependencies.jar<br \/>\n1324 ngdbc-2.17.12.jar<br \/>\n1324 ngdbc-2.17.10.jar<br \/>\n1308 mssql-jdbc-10.2.1.jre8.jar<br \/>\n1268 avatica-core-1.17.0.jar<br \/>\n1240 clickhouse-jdbc-0.4.6.jar<br \/>\n1204 terajdbc-20.00.00.11.jar<br \/>\n1136 sqream-jdbc-4.5.9.jar<br \/>\n1084 solr-solrj-9.2.1.jar<br \/>\n1080 solr-solrj-9.3.0.jar<br \/>\n1064 postgresql-42.7.4.jar<br \/>\n1060 jdbc-4.50.4.1.jar<br \/>\n952 snappydata-store-client-1.6.7.jar<br \/>\n792 x-pack-sql-jdbc-7.9.1.jar<br \/>\n752 crate-jdbc-2.7.0.jar<br \/>\n516 nuodb-jdbc-24.1.0.jar<br \/>\n380 ucanaccess-5.0.1.jar<br \/>\n300 clickhouse-jdbc-0.2.6.jar<br \/>\n284 taos-jdbcdriver-3.2.1.jar<br \/>\n248 csvjdbc-1.0.40.jar<br \/>\n228 ignite-core-3.0.0-beta1.jar<br \/>\n124 lz4-pure-java-1.8.0.jar<br \/>\n100 hive-jdbc-1.2.1.spark2.jar<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Size Isn&#8217;t Everything with Databases &#8211; Nor When It Comes to Database Driver size. With QStudio and Pulse, we get to work hands-on with 30+ databases. That gives us a lot of appreciation for teams that do more with less &#8211; especially some of the smaller teams building compact databases and drivers that deliver an [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","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},"categories":[115,2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112049"}],"collection":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=112049"}],"version-history":[{"count":3,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112049\/revisions"}],"predecessor-version":[{"id":112053,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112049\/revisions\/112053"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=112049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=112049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=112049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}