{"id":112047,"date":"2025-12-06T11:16:16","date_gmt":"2025-12-06T11:16:16","guid":{"rendered":"https:\/\/www.timestored.com\/b\/?p=112047"},"modified":"2025-12-06T11:16:16","modified_gmt":"2025-12-06T11:16:16","slug":"qstudio-now-open-source-release-5-01","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/qstudio-now-open-source-release-5-01\/","title":{"rendered":"QStudio Now Open Source &#8211; Release 5.01"},"content":{"rendered":"<h5>QStudio 5.0 is now <b>Open Source<\/b> after 13 years of development!<\/h5>\n<p>QStudio remains a fast, modern SQL editor supporting over 30 databases including MySQL, PostgreSQL, DuckDB, QuestDB, and kdb+\/q. Version 5.0 continues our focus on performance, analytics and extensibility now with an open community behind it.<\/p>\n<section>\n<div class=\"container\">\n<div class=\"row\">\n<div class=\"col-lg-12\">\n<h2>\ud83c\udf89 QStudio Is Now Open Source<\/h2>\n<p>After 13 years of development, QStudio is now fully open source under a permissive license. Developers, data analysts and companies can now contribute features, inspect the code, and build extensions.<\/p>\n<div class=\"col-lg-12\">\n<p><a title=\"QStudio 5.0\" href=\"https:\/\/www.timestored.com\/images\/qstudio\/qstudio-full.png\" rel=\"lightbox[a]\"> <img loading=\"lazy\" class=\"dropshadow\" src=\"https:\/\/www.timestored.com\/images\/qstudio\/qstudio-full.png\" alt=\"QStudio 5.0\" width=\"1120\" height=\"609\" \/> <\/a><\/p>\n<h5>Open Source Without the Fine Print.<\/h5>\n<p>No enterprise edition. No restrictions. No locked features. QStudio is fully open for personal, professional, and commercial use.<\/p>\n<\/div>\n<div>\n<div class=\"octf-btn-cta\">\n<div class=\"octf-header-module\">\n<div class=\"btn-cta-group btn-cta-header\"><a class=\"octf-btn octf-btn-second\" href=\"https:\/\/github.com\/timeseries\/qstudio\" target=\"_blank\" rel=\"noopener\">View QStudio on GitHub<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"row\">\n<div class=\"col-lg-12\">\n<h1>New Features with 5.0<\/h1>\n<h4>New Table Formatters, Better Visuals, Better Reporting<\/h4>\n<p><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/images\/qstudio\/sd-formatters.png\" alt=\"Table Formatters\" width=\"1708\" height=\"195\" \/><a href=\"https:\/\/www.timestored.com\/qstudio\/help\/smart-display\">SmartDisplay<\/a> is QStudio\u2019s column-based automatic formatting system. By adding simple _SD_* suffixes to column names, you can enable automatic number, percentage, and currency formatting,Sparklines, microcharts and much more. This mirrors the behaviour of the Pulse Web App, but implemented natively for QStudio\u2019s result panel.<\/p>\n<h5>Spark Lines + Micro Charts<\/h5>\n<p><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/sparkline-charts.png\" alt=\"sparklines sparkbars rendered from SQL queries\" width=\"1708\" height=\"195\" \/><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<section>\n<div class=\"container\">\n<div class=\"row\">\n<div class=\"col-lg-8\">\n<h1>Comprehensive Chart Configuration<\/h1>\n<p>Fine-tune axes, legends, palettes, gridlines and interactivity directly inside the <a href=\"https:\/\/www.timestored.com\/qstudio\/help\/chart-examples\">chart builder<\/a>.<\/p>\n<p><a title=\"Chart Config\" href=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/chart-config.png\" rel=\"lightbox[a]\"> <img loading=\"lazy\" class=\"dropshadow\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/chart-config.png\" alt=\"Chart Config\" width=\"425\" height=\"220\" \/> <\/a><\/p>\n<\/div>\n<div class=\"col-lg-4\">\n<h1>New Chart Themes<\/h1>\n<p><a href=\"https:\/\/www.timestored.com\/qstudio\/help\/chart-examples-excel\">Excel<\/a>, <a href=\"https:\/\/www.timestored.com\/qstudio\/help\/chart-examples-tabular\">Tableau<\/a> and <a href=\"https:\/\/www.timestored.com\/qstudio\/help\/chart-examples-powerbi\">PowerBI<\/a>-inspired styles for faster insight and cleaner dashboards.<\/p>\n<p><a title=\"Chart Themes\" href=\"https:\/\/www.timestored.com\/qstudio\/help\/cimg\/time-series-day-sines-powerbi.png\" rel=\"lightbox[a]\"> <img loading=\"lazy\" class=\"dropshadow\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/cimg\/time-series-day-sines-powerbi.png\" alt=\"Chart Themes\" width=\"425\" height=\"240\" \/> <\/a><\/p>\n<\/div>\n<\/div>\n<div class=\"row\">\n<div class=\"col-lg-8\">\n<h1>Other Major Additions<\/h1>\n<ul>\n<li><b>Back \/ Forward Navigation<\/b> \u2014 full browser-like movement between queries.<\/li>\n<li><b>Smart Display (SD)<\/b> \u2014 auto-formats tables with min\/max shading and type-aware formatting.<\/li>\n<li><b>Conditional Formatting<\/b> \u2014 highlight rows or columns based on value rules.<\/li>\n<li><b>New Code Editor Themes<\/b> \u2014 dark, light and popular IDE-style themes.<\/li>\n<li><b>Extended Syntax Highlighting<\/b> \u2014 Python, Scala, XPath, Clojure, RFL, JFlex and more.<\/li>\n<li><b>Improved kdb+\/q Support<\/b> \u2014 nested \/ curried functions now visible and navigable.<\/li>\n<li><b>Search All Open Files (Ctrl+Shift+F)<\/b><\/li>\n<li><b>Navigation Tabs in Query History<\/b> \u2014 with pinning.<\/li>\n<li><b>Improved Chinese Translation<\/b><\/li>\n<li><b>DuckDB Updated<\/b> to latest engine.<\/li>\n<li><b>Hundreds of minor UI and performance improvements<\/b><\/li>\n<li><b>Legacy Java Removed<\/b> \u2014 cleaner, modern codebase.<\/li>\n<\/ul>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"col-lg-4\">\n<h3>Code Editor Improvements<\/h3>\n<p>Better auto-complete, <b>themes<\/b> and tooling for large SQL files.<\/p>\n<p><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/images\/qstudio\/code-editor-theme.png\" alt=\"Code Themes\" width=\"635\" height=\"638\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"row\">\n<div class=\"col-lg-8\">\n<h2>Pinned Results<\/h2>\n<p>Pin results within the history pane for later review or comparison.<\/p>\n<p><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/pinned-results.png\" alt=\"Pinned Tabs\" width=\"635\" height=\"141\" \/><\/p>\n<\/div>\n<div class=\"col-lg-4\">\n<h3>Search Everywhere<\/h3>\n<p>Control+Shift+F to search all open files and your currently selected folder.<\/p>\n<p><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/images\/qstudio\/search-everywhere.png\" alt=\"Code Themes\" width=\"595\" height=\"242\" \/><\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"row\">\n<div class=\"col-lg-12\">\n<h4>Our History<\/h4>\n<ul>\n<li><b>2013\u20132024:<\/b> QStudio provided syntax highlighting, autocomplete, fast CSV\/Excel export and cross-database querying.<\/li>\n<li><b>Version 2.0:<\/b> QStudio expands support to 30+ Databases.<\/li>\n<li><b>Version 3.0:<\/b> Introduced DuckDB integration, Pulse-Pivot, Improved export options.<\/li>\n<li><b>Version 4.0:<\/b> Introduced SQL Notebooks and modern visuals.<\/li>\n<li><b>Version 5.0:<\/b> Open Source + hundreds of improvements across charts, editing, navigation and data analysis.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/section>\n<p>We aim to create the best open SQL editor for analysts and engineers. If you spot a bug or want a feature added, please <a href=\"https:\/\/github.com\/timeseries\/qstudio\/issues\">open an issue<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>QStudio 5.0 is now Open Source after 13 years of development! QStudio remains a fast, modern SQL editor supporting over 30 databases including MySQL, PostgreSQL, DuckDB, QuestDB, and kdb+\/q. Version 5.0 continues our focus on performance, analytics and extensibility now with an open community behind it. \ud83c\udf89 QStudio Is Now Open Source After 13 years [&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,92,23],"tags":[],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112047"}],"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=112047"}],"version-history":[{"count":1,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112047\/revisions"}],"predecessor-version":[{"id":112048,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112047\/revisions\/112048"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=112047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=112047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=112047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}