Beekeeper Studio Versions Save

Download the latest release for Mac, Windows, and Linux here:

https://www.beekeeperstudio.io/get-community

We've spent the first few months of the year working on resolving small complaints, fixing bugs, and smoothing rough edges.

In particular we've made maintaining the two different apps a lot easier by moving a lot of code into the open source repo.

That said there's a LOT of stuff in this release.

Headline features

• One tab per table - Ok fine, you all asked for this, now we only allow one tab open per table. :-)
• Firebird support - The Ultimate edition now has support for the Firebird database engine
• SQLite duplicate column bug fix - you can now select two columns with the same name without them becoming a single column
• .sql file import - In the saved queries section you can now import .sql files into your saved queries.
• Better drag/drop support for .sql files - drag and drop a .sql file anywhere to open in a new query tab

Loads of other stuff

• Show/hide your database passwords with a little eye button
• Spreadsheet mode improvements - better resizing, multi-select, and range select behavior.
• Some regression fixes
• Generated columns are now shown and correctly labelled
• Exactly 3 bajillion tweaks and minor fixes

Under the hood

• We spent a LOT of time trying to make Beekeeper Studio more maintainable, backporting a lot of code from the ultimate version, and rewriting entire components to make them more modular. This has probably resulted in a few bugs, but it helps us move faster in the future.
  • In particular, merge conflicts when merging community and master have been a real problem lately, these changes should help alleviate that.
• We also migrated all of our database drivers to a typescript-based class model. While this also probably introduced a few bugs we haven't yet found, it allowed us to remove ~1000+ lines of generic code, and makes implementing a new database driver a lot quicker.

PR's merged

ce2e016f Merge pull request #2050 from beekeeper-studio/fix/primary-keys-check 2a5b5069 Merge pull request #2051 from beekeeper-studio/fix/pre-release-tests edc3cb17 Merge pull request #2045 from beekeeper-studio/fix/mssql-autocomplete b6feb2d3 Merge pull request #2047 from beekeeper-studio/fix/apply-badge-style 597373ad Merge pull request #2046 from beekeeper-studio/fix/saved-queries-editor 994b0387 Merge pull request #2044 from beekeeper-studio/fix/autocomplete ee6b7a20 Merge pull request #2024 from beekeeper-studio/autocomplete-load-cols-fix e8bfa7b4 Merge pull request #2023 from beekeeper-studio/feat/hidden-column-indicator c0202f00 Merge pull request #2022 from beekeeper-studio/mssql-version-tests 89d98fc5 Merge pull request #2026 from beekeeper-studio/dependabot/npm_and_yarn/follow-redirects-1.15.6 202e3055 Merge pull request #2016 from beekeeper-studio/cassandra-client 87445f86 Merge pull request #2014 from beekeeper-studio/fix-clashing-css-class 7c8c28b9 Merge pull request #2015 from beekeeper-studio/fix-nullable-editor-parser 56f23474 Merge pull request #1981 from beekeeper-studio/sqlite-result-as-array 989be53f Merge pull request #1975 from beekeeper-studio/tabulator-update 769776cd Merge pull request #2004 from beekeeper-studio/fix-codemirror-gutters bd7f6c08 Merge pull request #1966 from beekeeper-studio/fix-sqlite-generated-columns 2cb16a65 Merge pull request #1924 from beekeeper-studio/fix/insert-table-name 8187e675 Merge pull request #1972 from beekeeper-studio/dependabot/npm_and_yarn/ip-1.1.9 0c75163d Merge pull request #2001 from beekeeper-studio/table-filter-regressions e3c2694e Merge pull request #2007 from beekeeper-studio/fix-empty-column-export c1024f36 Merge pull request #1953 from beekeeper-studio/bigquery-client dd3f5819 Merge pull request #1989 from MiniGeospatial/getViewCreateScript 874b29ce Merge pull request #1998 from beekeeper-studio/fix/focus-sql-text-editor eeff3b50 Merge pull request #2000 from beekeeper-studio/fix/tabulator-table-regressions 8d25e159 Merge pull request #1996 from beekeeper-studio/fix/renaming-column 2c4c1aed Merge pull request #1991 from beekeeper-studio/bugfix/apply-changes-issue 90062a3f Merge pull request #1990 from beekeeper-studio/fix/redshift-error a2e19655 Merge pull request #1988 from beekeeper-studio/bugfix/escapeHtml-Results-Table 450df82f Merge pull request #1983 from beekeeper-studio/ultimate-driver-backports a2de0bda Merge pull request #1974 from beekeeper-studio/wmontgomery-patch-1 801ea7e9 Merge pull request #1971 from beekeeper-studio/ultimate-backports 991d1667 Merge pull request #1965 from omahs/patch-1 8096c987 Merge pull request #1969 from beekeeper-studio/fix/css-vendor 0e6203c3 Merge pull request #1955 from beekeeper-studio/fix/spreadsheet-data 2c203e7b Merge pull request #1956 from beekeeper-studio/fix/tabletable-export 74ab88f6 Merge pull request #1835 from beekeeper-studio/feature/1738_Readable-DateTime 65af9cb6 Merge pull request #1935 from therealrinku/fix/popup-after-creating-table e0b7e016 Merge pull request #1907 from beekeeper-studio/refactor/text-editor 823a5164 Merge pull request #1928 from beekeeper-studio/feature/1851_SqlServerToClass fd725361 Merge pull request #1934 from austinwilcox/fixVimQuit 6a1167ff Merge pull request #1779 from beekeeper-studio/feature/data-picker 2f3db7b5 Merge pull request #1941 from beekeeper-studio/fix/header-tooltip-xss 0dd3d644 Merge pull request #1936 from therealrinku/fix/copy-json-fix 6701f227 Merge pull request #1938 from jc00ke/master 1d82f920 Merge pull request #1909 from beekeeper-studio/postgres-client 65d679b0 Merge pull request #1913 from beekeeper-studio/feat/import-export-sql f696fa0a Merge pull request #1917 from beekeeper-studio/fix/minor-fixes 0ec8fae9 Merge pull request #1861 from beekeeper-studio/refactor/mysql-to-ts 46bde4c6 Merge pull request #1879 from austinwilcox/vimrcImprovements b0aef6a4 Merge pull request #1869 from beekeeper-studio/dependabot/npm_and_yarn/follow-redirects-1.15.4 5e99ee35 Merge pull request #1834 from beekeeper-studio/fix/one-tab-one-table be5ee18c Merge pull request #1873 from beekeeper-studio/sass-migration 04f10ea9 Merge pull request #1859 from luca1197/tablelength-formatting 14ddcdaf Merge pull request #1855 from invisal/feat/long-query-notification 9df859ef Merge pull request #1843 from Christof-P/feat/show-password-option d48b399c Merge pull request #1821 from marco-lavagnino/master 64493d24 Merge pull request #1829 from beekeeper-studio/finish-bigquery c20d3692 Merge pull request #1811 from beekeeper-studio/feat/initial-firebird dcc2c67b Merge pull request #1904 from beekeeper-studio/add-sort-buttons

Regression fixes following the 4.1 release. No new features.

This was intended to be a small point release after the release of 4.0. I guess things got a little out of hand :-).

Headline features this month are thanks to the small group of part time contractors helping me build Beekeeper Studio on nights and weekends - @not-night-but, @azmy60, and @wmontgomery

Watch the video walkthrough on YouTube

Headline Features

Spreadsheet style table interactions!

You can do a bunch of stuff with tables that 'just makes sense' now including:

• Selecting rows / columns
• Selecting a range of cells
• Copying data from the selected cells/columns/rows
• Pasting data into a table across multiple cells
• Navigating with the keyboard

It's a huge improvement. @azmy60++ for all the work on this feature. We've also contributed this feature back to Tabulator.

Modal editor for large values

Ever tried to edit JSON or HTML in a Beekeeper Studio table view? It's horrible. Or rather it WAS horrible. It's now a lot nicer.

Right click a cell and select edit in modal to edit the value in a larger editor.

If you're editing JSON, Beekeeper Studio will automatically prettify it for you to make editing easier (and minify it for you when you save, if you so choose).

Wayland fractional scaling support

I'm a Linux user. Gnome now uses Wayland, so I use Wayland. Unfortunately my screen requires me to run at 150% fractional scaling. Up until now there was no real way to make Beekeeper Studio look right in this environment -- the app would be blurry and hard to read.

This release includes proper support for Wayland, but it's not enabled by default (due to remaining problems with NVIDIA), rather Wayland has to be enabled by setting a couple of flags in a configuration file.

Here is the user guide for enabling Wayland.

More changes

• Beekeeper Studio docs moved into the repo under [docs]

PRs Merged

7a22a90a Merge pull request #1841 from beekeeper-studio/fix/language-editor 6ee968eb Merge pull request #1844 from beekeeper-studio/fix/spreadsheet 4feefabc Merge pull request #1826 from beekeeper-studio/fix/tabulator 6792d832 Merge pull request #1827 from beekeeper-studio/bugfix/the-nullening 8960c657 Merge pull request #1832 from beekeeper-studio/local-docs-again 32d86f2d Merge pull request #1825 from beekeeper-studio/fix/tabulator-styles 492458ac Merge pull request #1824 from beekeeper-studio/wayland-native 744d50a2 Merge pull request #1784 from beekeeper-studio/bugfix/1750_Relations-Tables 64feac0f Merge pull request #1803 from beekeeper-studio/language-editor bd4df166 Merge pull request #1819 from beekeeper-studio/feat/paste-in-multiple-cells 4fcc2449 Merge pull request #1823 from beekeeper-studio/fix/sql-server-concat d0f5fe63 Merge pull request #1820 from beekeeper-studio/fix/green-column-name cc2645cf Merge pull request #1822 from beekeeper-studio/fix/broken-sure-dialog 99a8bbb4 Merge pull request #1817 from beekeeper-studio/bugfix/1807_array-arrfulness 28f82983 Merge pull request #1793 from Christof-P/feat/add-color-coding-to-edit-form ab68e50b Merge pull request #1815 from beekeeper-studio/fix/sql-query-identifier db939c4b Merge pull request #1812 from beekeeper-studio/fix/spreadsheet-navigation cac86af2 Merge pull request #1794 from Christof-P/feat/multi-select-quick-search 93ed237b Merge pull request #1740 from beekeeper-studio/fix/quoted-alias fa2b88a9 Merge pull request #1810 from beekeeper-studio/bugfix/1808_editing-issue 884a487a Merge pull request #1785 from jc00ke/update-linux-deb-install-docs 177307b7 Merge pull request #1777 from beekeeper-studio/dependabot/npm_and_yarn/axios-1.6.0 d64d685a Merge pull request #1802 from beekeeper-studio/fix/set-vim-mode c51e75f6 Merge pull request #1797 from maxoliverbr/fix-translations e475f5ad Merge pull request #1773 from beekeeper-studio/fix/non-reflective-table-columns 202709d7 Merge pull request #1781 from beekeeper-studio/fix/unuse-native-modals bbeff863 Merge pull request #1799 from beekeeper-studio/fix/virtual-table-list f5b5758b Merge pull request #1747 from beekeeper-studio/feat/initial-spreadsheet 24798bec Merge pull request #1800 from beekeeper-studio/fix/slow-column-resize 8491b141 Merge pull request #1745 from p-Jimenez/show-table-comments 7ac2da36 Merge pull request #1792 from beekeeper-studio/fix/persistent-bg-column df1a2a36 Merge pull request #1764 from beekeeper-studio/sqlite-client-class 54476146 Merge pull request #1788 from beekeeper-studio/sweep/add-prefix-to-error-messages eff24858 Merge pull request #1789 from MasterOdin/patch-1 a8a92439 Merge pull request #1771 from beekeeper-studio/fix/virtual-table-list 42b7ff3e Merge pull request #1776 from beekeeper-studio/fix/escape-view-names b1579e5b Merge pull request #1770 from trivikr/remove-aws-sdk 2b85a154 Merge pull request #1763 from beekeeper-studio/dependabot/npm_and_yarn/browserify-sign-4.2.2 6f2dd3db Merge pull request #1744 from beekeeper-studio/dependabot/npm_and_yarn/babel/traverse-7.23.2 2a0ee5c8 Merge pull request #1736 from beekeeper-studio/fix/1735 a6f4b324 Merge pull request #1760 from beekeeper-studio/fix/illegible-conn-type 83e2a42f Merge pull request #1697 from mohamedelhefni/feature-1685 7e889e89 Merge pull request #1722 from beekeeper-studio/fix/1721 4dcad062 Merge pull request #1708 from azmy60/fix/invalid-array-in-copy 7a953d3f Merge pull request #1725 from beekeeper-studio/feature/Vue-Linter ff385701 Merge pull request #1718 from beekeeper-studio/fix/debounce-filter-builder 5dc95adc Merge pull request #1711 from beekeeper-studio/fix/tabulator-bool-option 1d92b24e Merge pull request #1717 from austinwilcox/fixVimEsc ead61f9f Merge pull request #1715 from iifawzi/feat/1714-compound-foreign-keys

Hello friends,

Huge release for you today, with some massive, and long-requested features.

These features are so big, that we're calling this release 4.0. I also turned 40 this month, and my daughter turned 6 which if you think about it is also 4 ᴾᴸᵁˢ ², so you get a 4, I get a 4, we all get a 4!

This release would not be possible without amazing community contributors. Thank you! Some seriously top knotch features were contributed by the community for this release.

Meet the 4.0 team

Beekeeper Studio also has a very talented set of part-time developers contributing features during nights and weekends. No-one is full time, but I think you'll agree that the features they've developed are :1st_place_medal:.

The Beekeeper Studio team, burning the midnight oil to bring you the app:

• @rathboma
• @wmontgomery
• @not-night-but
• @davidkaufman
• @azmy60

Headline features

Please note that I am including all features here, but some are only available in the paid, commercial edition of Beekeeper Studio, available for download on our website

• Download full query results by sending the data (over 50k rows) directly to file (@davidkaufman)
• Import data into any table from a CSV (@wmontgomery)
• Backup & restore databases using database-provided backup tools (@not-night-but)
• SQLite extensions - add an extension to your SQLite connections (@davidkaufman)
• Google BigQuery support in beta - 🎉 community contribution by @chekolyn
• Multiple table filters - filter multiple filters, use either and or or (@azmy60)

Even more amazing features and fixes (long list warning)

• Multi-row selection - In the table view select multiple rows to copy or delete (literally the only thing I did @rathboma)

• Apache Cassandra - full support - (@wmontgomery)

• Vim Keybindings in the query editor - Advanced keybindings and vimrc support for you weird people who like Vim more than emacs :shrug: - community contribution by @austinwilcox - more coming soon!

• Open a table view as SQL (so you can use it as a light query builder)

• Unsigned INTS now supported in MySQL and MariaDB

• Change resultset hotkeys (shift up / shift down)

• Added the column comment column to the table builder / editor

• Fixed fullscreen mode with the client-side titlebar

• Get warned if you're going to blitz your data edits when sorting the table

• Several table view performance improvements for large datasets

• Automatically remove quotes surrounding a SQL query when pasting into the query editor

• Fixed bool editing in SQLite

• Fixed Postgres array editing problems

• Even more stuff to list! (phew, that's a lot)

Pull requests

af175949 Merge pull request #45 from beekeeper-studio/feature/cassandra-write-take-2 27d29316 Merge pull request #47 from beekeeper-studio/feat/ultimate-multiple-filters be793ae6 Merge pull request #48 from beekeeper-studio/backup-log-file fb534eb4 Merge pull request #44 from beekeeper-studio/bugfix/import fc6407fa Merge branch 'issue-1360-sqlite-load_extension' 6c174f99 Merge pull request #42 from beekeeper-studio/issue-1360-sqlite-load_extension e5a80a57 Merge pull request #43 from beekeeper-studio/select-top-sql cfae002b Merge pull request #40 from beekeeper-studio/feature/560_funhancements da1809e2 merged fk_click centralized code 61849309 Merge pull request #39 from beekeeper-studio/feature/560_import-from-file e1071b0f Merge pull request #1672 from azmy60/mismatched-autocomplete-behavior e4fc386a Merge pull request #1673 from azmy60/unsigned-columns-builder 3fb51310 Merge pull request #1699 from beekeeper-studio/bigquery-fixes cf5fdb4d Merge pull request #1706 from azmy60/fix/fk-click bb0a0126 Merge pull request #1705 from azmy60/fix/empty-filter e147775c Merge pull request #1702 from azmy60/feat/initial-multiple-filter 14d3aabf Merge pull request #1686 from iifawzi/feat-change-result-hotkey 9e7bdaf9 Merge pull request #1701 from azmy60/add-comment-column ac3fb77e Merge pull request #1326 from beekeeper-studio/tabletable-improvements 9803b889 Merge pull request #1690 from beekeeper-studio/feature/1662 19333d4d Merge pull request #1687 from azmy60/filtered-view-to-editor a17b4a67 Merge pull request #1692 from azmy60/fix-invalid-bool 0a72cce7 Merge pull request #1691 from iifawzi/fix/1688-adding-record-no-primary 8fd64769 Merge pull request #1635 from chekolyn/saguilar_bigquery cbde5ed6 Merge pull request #1694 from beekeeper-studio/upgrade-button a22978b9 Merge pull request #1693 from azmy60/hide-titlebar-on-fullscreen 7ed77155 Merge pull request #1670 from austinwilcox/beekeeperVimrc c419ad2a Merge pull request #1544 from michi-zuri/patch-1 b8544294 Merge pull request #1601 from beekeeper-studio/remove-quotes-paste db403326 Merge pull request #1503 from davidkaufman/issue-472-run-query-to-file 7f1dd1ca Merge pull request #1600 from beekeeper-studio/1019-warn-on-sort a84945e6 Merge pull request #1674 from azmy60/fix-row-copy-insert 6de2f187 Merge pull request #1666 from tkudlicka/hotfix/socket-connection 332dbde1 Merge pull request #1665 from tkudlicka/hotfix/filter-routine f5fbfa7e Merge pull request #1664 from tkudlicka/feature/sqlserver-precision 6bb50e59 Merge pull request #1661 from azmy60/long-db-name

Howdy y’all,

It’s a cool 115f degrees (47c) here in Texas, so I’m here to drop some 🔥🔥 features into your lives.

There are some MASSIVE features dropping in this release, despite the rather conservative point release version. Consider this a soft-launch for the full 4.0 launch later this year.

🧚 Hey listen! Did you know that Beekeeper Studio is run by a single person (me)? Recently I’ve been able to afford to hire some part-time help from several talented folks (@not-night-but, @wmontgomery, and @davidkaufman), but this is still a small indie operation. Thank you all for your support and for the community contributions!

🚀 HEADLINE FEATURES (these are only in the commercial edition)

• Multi-table data exports (🤯) by @wmontgomery, that’s right, export a whole schema if you like, or get wild and export 10 schemas, I won’t tell, no one is watching.
  • Just like single-table exports, you can export to a range of formats, including CSV, JSON, and SQL.
• Native database backups (🤯🤯) (Postgres, MySQL, and Sqlite) - by @not-night-but - exports are great, but they’re not a real backup...but you know what is a real backup? A real backup generated by the vendor-provided backup tool.
  • Yep, our backups use the native backup tools (eg pg_dump for postgres) provided by the database vendors.
  • Beekeeper provides sensible defaults and an intuitive point and click interface. So the backup generated is exactly like the one you’d generate running the tool manually.
  • Nothing like this exists anywhere else, we’re really proud of it.
• Restore native database backups (🤯🤯🤯) - also by @not-night-but - come on, you had to see this one coming. Just like native backups, our restoration tool uses the vendor-provided restoration binary (eg pg_restore for postgres), but adds an easy to use interface with sensible defaults.
  • Again, we think this is pretty unique and believe most folks want to use native tooling whenever possible for backups and restores, we hope the feature makes that process easier.

Phew

Also in this release

• New and improved autocomplete that can complete your schemas and filters tables by that schema! Thanks @azmy60!!
• Added safeguard for keymap types, you shall no longer get a blank window!

Community Edition PRs

• feat: support schema autocomplete by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/1610

• Upgrade ssh2 from 1.110 to 1.14.0 by @davidkaufman in https://github.com/beekeeper-studio/beekeeper-studio/pull/1653

• fix: remove extra wrapping div by @wmontgomery in https://github.com/beekeeper-studio/beekeeper-studio/pull/1655

• fix: if row was array, it was parsing wrong, so have to force it a bit by @wmontgomery in https://github.com/beekeeper-studio/beekeeper-studio/pull/1654

• Create table SQL script fix by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/1657

We've fixed the issue with the query editor breaking that was caused by the new vim mode, as well as fixing save results as markdown.

For contributors: eslint has been fixed and now provides style guidelines. Thanks @ndom91 !!! If you're working on a PR you can now run yarn run all:lint for auto formatting fixes and warnings for any code style issues that exist in your code.

What's Changed

• Fix keymap user setting type and update styles by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/1619
• fix: eslint/TS setup and all initial errors by @ndom91 in https://github.com/beekeeper-studio/beekeeper-studio/pull/1529
• Fix save as markdown by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/1623

New Contributors

• @ndom91 made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/1529

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v3.9.17...v3.9.18

We have a new fancy EV windows certificate that makes our app 'trusted' by microsoft right off the bat.

Also included - a couple of minor bug fixes, but to be honest it took 3 weeks to figure out the cert along with Azure Keyvault.