Releases: beekeeper-studio/beekeeper-studio
Minor bug fixes
v4.3.1 bump
4.3! Lots of tweaks and fixes
v4.3.0 bump for 4.3
v4.2.9
Download the latest release for Mac, Windows, and Linux here:
4.2.8 - Minor bug fix for mysql databases that don't have a default database
v4.2.8 4.2.8 - finally fixed the mysql race condition
4.2 - The life, universe and everything (again)
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 queriessection 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
ce2e016 Merge pull request #2050 from beekeeper-studio/fix/primary-keys-check
2a5b506 Merge pull request #2051 from beekeeper-studio/fix/pre-release-tests
edc3cb1 Merge pull request #2045 from beekeeper-studio/fix/mssql-autocomplete
b6feb2d Merge pull request #2047 from beekeeper-studio/fix/apply-badge-style
597373a Merge pull request #2046 from beekeeper-studio/fix/saved-queries-editor
994b038 Merge pull request #2044 from beekeeper-studio/fix/autocomplete
ee6b7a2 Merge pull request #2024 from beekeeper-studio/autocomplete-load-cols-fix
e8bfa7b Merge pull request #2023 from beekeeper-studio/feat/hidden-column-indicator
c0202f0 Merge pull request #2022 from beekeeper-studio/mssql-version-tests
89d98fc Merge pull request #2026 from beekeeper-studio/dependabot/npm_and_yarn/follow-redirects-1.15.6
202e305 Merge pull request #2016 from beekeeper-studio/cassandra-client
87445f8 Merge pull request #2014 from beekeeper-studio/fix-clashing-css-class
7c8c28b Merge pull request #2015 from beekeeper-studio/fix-nullable-editor-parser
56f2347 Merge pull request #1981 from beekeeper-studio/sqlite-result-as-array
989be53 Merge pull request #1975 from beekeeper-studio/tabulator-update
769776c Merge pull request #2004 from beekeeper-studio/fix-codemirror-gutters
bd7f6c0 Merge pull request #1966 from beekeeper-studio/fix-sqlite-generated-columns
2cb16a6 Merge pull request #1924 from beekeeper-studio/fix/insert-table-name
8187e67 Merge pull request #1972 from beekeeper-studio/dependabot/npm_and_yarn/ip-1.1.9
0c75163 Merge pull request #2001 from beekeeper-studio/table-filter-regressions
e3c2694 Merge pull request #2007 from beekeeper-studio/fix-empty-column-export
c1024f3 Merge pull request #1953 from beekeeper-studio/bigquery-client
dd3f581 Merge pull request #1989 from MiniGeospatial/getViewCreateScript
874b29c Merge pull request #1998 from beekeeper-studio/fix/focus-sql-text-editor
eeff3b5 Merge pull request #2000 from beekeeper-studio/fix/tabulator-table-regressions
8d25e15 Merge pull request #1996 from beekeeper-studio/fix/renaming-column
2c4c1ae Merge pull request #1991 from beekeeper-studio/bugfix/apply-changes-issue
90062a3 Merge pull request #1990 from beekeeper-studio/fix/redshift-error
a2e1965 Merge pull request #1988 from beekeeper-studio/bugfix/escapeHtml-Results-Table
450df82 Merge pull request #1983 from beekeeper-studio/ultimate-driver-backports
a2de0bd Merge pull request #1974 from beekeeper-studio/wmontgomery-patch-1
801ea7e Merge pull request #1971 from beekeeper-studio/ultimate-backports
991d166 Merge pull request #1965 from omahs/patch-1
8096c98 Merge pull request #1969 from beekeeper-studio/fix/css-vendor
0e6203c Merge pull request #1955 from beekeeper-studio/fix/spreadsheet-data
2c203e7 Merge pull request #1956 from beekeeper-studio/fix/tabletable-export
74ab88f Merge pull request #1835 from beekeeper-studio/feature/1738_Readable-DateTime
65af9cb Merge pull request #1935 from therealrinku/fix/popup-after-creating-table
e0b7e01 Merge pull request #1907 from beekeeper-studio/refactor/text-editor
823a516 Merge pull request #1928 from beekeeper-studio/feature/1851_SqlServerToClass
fd72536 Merge pull request #1934 from austinwilcox/fixVimQuit
6a1167f Merge pull request #1779 from beekeeper-studio/feature/data-picker
2f3db7b Merge pull request #1941 from beekeeper-studio/fix/header-tooltip-xss
0dd3d64 Merge pull request #1936 from therealrinku/fix/copy-json-fix
6701f22 Merge pull request #1938 from jc00ke/master
1d82f92 Merge pull request #1909 from beekeeper-studio/postgres-client
65d679b Merge pull request #1913 from beekeeper-studio/feat/import-export-sql
f696fa0 Merge pull request #1917 from beekeeper-studio/fix/minor-fixes
0ec8fae Merge pull request #1861 from beekeeper-studio/refactor/mysql-to-ts
46bde4c Merge pull request #1879 from austinwilcox/vimrcImprovements
b0aef6a Merge pull request #1869 from beekeeper-studio/dependabot/npm_and_yarn/follow-redirects-1.15.4
5e99ee3 Merge pull request #1834 from beekeeper-studio/fix/one-tab-one-table
be5ee18 Merge pull request #1873 from beekeeper-studio/sass-migration
04f10ea Merge pull request #1859 from luca1197/tablelength-formatting
14ddcda Merge pull request #1855 from invisal/feat/long-query-notification
9df859e Merge pull request #1843 from Christof-P/feat/show-password-option
d48b399 Merge pull request #1821 from marco-lavagnino/master
64493d2 Merge pull request #1829 from beekeeper-studio/finish-bigquery
c20d369 Merge pull request #1811 from beekeeper-studio/feat/initial-firebird
dcc2c67 Merge pull request #1904 from beekeeper-studio/add-sort-buttons
4.1 Bugfix release
Regression fixes following the 4.1 release. No new features.
4.1 - Spreadsheet mode, model editor, and more!
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
7a22a90 Merge pull request #1841 from beekeeper-studio/fix/language-editor
6ee968e Merge pull request #1844 from beekeeper-studio/fix/spreadsheet
4feefab Merge pull request #1826 from beekeeper-studio/fix/tabulator
6792d83 Merge pull request #1827 from beekeeper-studio/bugfix/the-nullening
8960c65 Merge pull request #1832 from beekeeper-studio/local-docs-again
32d86f2 Merge pull request #1825 from beekeeper-studio/fix/tabulator-styles
492458a Merge pull request #1824 from beekeeper-studio/wayland-native
744d50a Merge pull request #1784 from beekeeper-studio/bugfix/1750_Relations-Tables
64feac0 Merge pull request #1803 from beekeeper-studio/language-editor
bd4df16 Merge pull request #1819 from beekeeper-studio/feat/paste-in-multiple-cells
4fcc244 Merge pull request #1823 from beekeeper-studio/fix/sql-server-concat
d0f5fe6 Merge pull request #1820 from beekeeper-studio/fix/green-column-name
cc2645c Merge pull request #1822 from beekeeper-studio/fix/broken-sure-dialog
99a8bbb Merge pull request #1817 from beekeeper-studio/bugfix/1807_array-arrfulness
28f8298 Merge pull request #1793 from Christof-P/feat/add-color-coding-to-edit-form
ab68e50 Merge pull request #1815 from beekeeper-studio/fix/sql-query-identifier
db939c4 Merge pull request #1812 from beekeeper-studio/fix/spreadsheet-navigation
cac86af Merge pull request #1794 from Christof-P/feat/multi-select-quick-search
93ed237 Merge pull request #1740 from beekeeper-studio/fix/quoted-alias
fa2b88a Merge pull request #1810 from beekeeper-studio/bugfix/1808_editing-issue
884a487 Merge pull request #1785 from jc00ke/update-linux-deb-install-docs
177307b Merge pull request #1777 from beekeeper-studio/dependabot/npm_and_yarn/axios-1.6.0
d64d685 Merge pull request #1802 from beekeeper-studio/fix/set-vim-mode
c51e75f Merge pull request #1797 from maxoliverbr/fix-translations
e475f5a Merge pull request #1773 from beekeeper-studio/fix/non-reflective-table-columns
202709d Merge pull request #1781 from beekeeper-studio/fix/unuse-native-modals
bbeff86 Merge pull request #1799 from beekeeper-studio/fix/virtual-table-list
f5b5758 Merge pull request #1747 from beekeeper-studio/feat/initial-spreadsheet
24798be Merge pull request #1800 from beekeeper-studio/fix/slow-column-resize
8491b14 Merge pull request #1745 from p-Jimenez/show-table-comments
7ac2da3 Merge pull request #1792 from beekeeper-studio/fix/persistent-bg-column
df1a2a3 Merge pull request #1764 from beekeeper-studio/sqlite-client-class
5447614 Merge pull request #1788 from beekeeper-studio/sweep/add-prefix-to-error-messages
eff2485 Merge pull request #1789 from MasterOdin/patch-1
a8a9243 Merge pull request #1771 from beekeeper-studio/fix/virtual-table-list
42b7ff3 Merge pull request #1776 from beekeeper-studio/fix/escape-view-names
b1579e5 Merge pull request #1770 from trivikr/remove-aws-sdk
2b85a15 Merge pull request #1763 from beekeeper-studio/dependabot/npm_and_yarn/browserify-sign-4.2.2
6f2dd3d Merge pull request #1744 from beekeeper-studio/dependabot/npm_and_yarn/babel/traverse-7.23.2
2a0ee5c Merge pull request #1736 from beekeeper-studio/fix/1735
a6f4b32 Merge pull request #1760 from beekeeper-studio/fix/illegible-conn-type
83e2a42 Merge pull request #1697 from mohamedelhefni/feature-1685
7e889e8 Merge pull request #1722 from beekeeper-studio/fix/1721
4dcad06 Merge pull request #1708 from azmy60/fix/invalid-array-in-copy
7a953d3 Merge pull request #1725 from beekeeper-studio/feature/Vue-Linter
ff38570 Merge pull request #1718 from beekeeper-studio/fix/debounce-filter-builder
5dc95ad Merge pull request #1711 from beekeeper-studio/fix/tabulator-bool-option
1d92b24 Merge pull request #1717 from austinwilcox/fixVimEsc
ead61f9 Merge pull request #1715 from iifawzi/feat/1714-compound-foreign-keys
Contributors
Assets 23
4.0.3 - Minor bug fixes
v4.0.3 minor patch release
4.0.0 - Import, export, backup, restore, and more
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 🥇.
The Beekeeper Studio team, burning the midnight oil to bring you the app:
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
andoror(@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 🤷 - 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
e1071b0 Merge pull request #1672 from azmy60/mismatched-autocomplete-behavior
e4fc386 Merge pull request #1673 from azmy60/unsigned-columns-builder
3fb5131 Merge pull request #1699 from beekeeper-studio/bigquery-fixes
cf5fdb4 Merge pull request #1706 from azmy60/fix/fk-click
bb0a012 Merge pull request #1705 from azmy60/fix/empty-filter
e147775 Merge pull request #1702 from azmy60/feat/initial-multiple-filter
14d3aab Merge pull request #1686 from iifawzi/feat-change-result-hotkey
9e7bdaf Merge pull request #1701 from azmy60/add-comment-column
ac3fb77 Merge pull request #1326 from beekeeper-studio/tabletable-improvements
9803b88 Merge pull request #1690 from beekeeper-studio/feature/1662
19333d4 Merge pull request #1687 from azmy60/filtered-view-to-editor
a17b4a6 Merge pull request #1692 from azmy60/fix-invalid-bool
0a72cce Merge pull request #1691 from iifawzi/fix/1688-adding-record-no-primary
8fd6476 Merge pull request #1635 from chekolyn/saguilar_bigquery
cbde5ed Merge pull request #1694 from beekeeper-studio/upgrade-button
a22978b Merge pull request #1693 from azmy60/hide-titlebar-on-fullscreen
7ed7715 Merge pull request #1670 from austinwilcox/beekeeperVimrc
c419ad2 Merge pull request #1544 from michi-zuri/patch-1
b854429 Merge pull request #1601 from beekeeper-studio/remove-quotes-paste
db40332 Merge pull request #1503 from davidkaufman/issue-472-run-query-to-file
7f1dd1c Merge pull request #1600 from beekeeper-studio/1019-warn-on-sort
a84945e Merge pull request #1674 from azmy60/fix-row-copy-insert
6de2f18 Merge pull request #1666 from tkudlicka/hotfix/socket-connection
332dbde Merge pull request #1665 from tkudlicka/hotfix/filter-routine
f5fbfa7 Merge pull request #1664 from tkudlicka/feature/sqlserver-precision
6bb50e5 Merge pull request #1661 from azmy60/long-db-name
Contributors
Assets 21
3.9.20
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
-
Upgrade ssh2 from 1.110 to 1.14.0 by @davidkaufman in #1653
-
fix: remove extra wrapping div by @wmontgomery in #1655
-
fix: if row was array, it was parsing wrong, so have to force it a bit by @wmontgomery in #1654