What's new in Beekeeper Studio 4.3.0
Apr 28, 2024
New in Beekeeper Studio 4.2.9 (Apr 6, 2024)
New in Beekeeper Studio 4.2.8 (Apr 6, 2024)
- finally fixed the mysql race condition
New in Beekeeper Studio 4.2.7 (Apr 6, 2024)
- HEADLINES 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:
- 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
New in Beekeeper Studio 4.2.5 (Apr 1, 2024)
- 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.
- HEADLINES 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.
New in Beekeeper Studio 4.1.13 (Jan 17, 2024)
- Regression fixes following the 4.1 release. No new features.
New in Beekeeper Studio 4.1.10 (Jan 13, 2024)
- 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
- 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]
- MERGED:
- Merge pull request #1841 from beekeeper-studio/fix/language-editor
- Merge pull request #1844 from beekeeper-studio/fix/spreadsheet
- Merge pull request #1826 from beekeeper-studio/fix/tabulator
- Merge pull request #1827 from beekeeper-studio/bugfix/the-nullening
- Merge pull request #1832 from beekeeper-studio/local-docs-again
- Merge pull request #1825 from beekeeper-studio/fix/tabulator-styles
- Merge pull request #1824 from beekeeper-studio/wayland-native
- Merge pull request #1784 from beekeeper-studio/bugfix/1750_Relations-Tables
- Merge pull request #1803 from beekeeper-studio/language-editor
- Merge pull request #1819 from beekeeper-studio/feat/paste-in-multiple-cells
- Merge pull request #1823 from beekeeper-studio/fix/sql-server-concat
- Merge pull request #1820 from beekeeper-studio/fix/green-column-name
- Merge pull request #1822 from beekeeper-studio/fix/broken-sure-dialog
- Merge pull request #1817 from beekeeper-studio/bugfix/1807_array-arrfulness
- Merge pull request #1793 from Christof-P/feat/add-color-coding-to-edit-form
- Merge pull request #1815 from beekeeper-studio/fix/sql-query-identifier
- Merge pull request #1812 from beekeeper-studio/fix/spreadsheet-navigation
- Merge pull request #1794 from Christof-P/feat/multi-select-quick-search
- Merge pull request #1740 from beekeeper-studio/fix/quoted-alias
- Merge pull request #1810 from beekeeper-studio/bugfix/1808_editing-issue
- Merge pull request #1785 from jc00ke/update-linux-deb-install-docs
- Merge pull request #1777 from beekeeper-studio/dependabot/npm_and_yarn/axios-1.6.0
- Merge pull request #1802 from beekeeper-studio/fix/set-vim-mode
- Merge pull request #1797 from maxoliverbr/fix-translations
- Merge pull request #1773 from beekeeper-studio/fix/non-reflective-table-columns
- Merge pull request #1781 from beekeeper-studio/fix/unuse-native-modals
- Merge pull request #1799 from beekeeper-studio/fix/virtual-table-list
- Merge pull request #1747 from beekeeper-studio/feat/initial-spreadsheet
- Merge pull request #1800 from beekeeper-studio/fix/slow-column-resize
- Merge pull request #1745 from p-Jimenez/show-table-comments
- Merge pull request #1792 from beekeeper-studio/fix/persistent-bg-column
- Merge pull request #1764 from beekeeper-studio/sqlite-client-class
- Merge pull request #1788 from beekeeper-studio/sweep/add-prefix-to-error-messages
- Merge pull request #1789 from MasterOdin/patch-1
- Merge pull request #1771 from beekeeper-studio/fix/virtual-table-list
- Merge pull request #1776 from beekeeper-studio/fix/escape-view-names
- Merge pull request #1770 from trivikr/remove-aws-sdk
- Merge pull request #1763 from beekeeper-studio/dependabot/npm_and_yarn/browserify-sign-4.2.2
- Merge pull request #1744 from beekeeper-studio/dependabot/npm_and_yarn/babel/traverse-7.23.2
- Merge pull request #1736 from beekeeper-studio/fix/1735
- Merge pull request #1760 from beekeeper-studio/fix/illegible-conn-type
- Merge pull request #1697 from mohamedelhefni/feature-1685
- Merge pull request #1722 from beekeeper-studio/fix/1721
- Merge pull request #1708 from azmy60/fix/invalid-array-in-copy
- Merge pull request #1725 from beekeeper-studio/feature/Vue-Linter
- Merge pull request #1718 from beekeeper-studio/fix/debounce-filter-builder
- Merge pull request #1711 from beekeeper-studio/fix/tabulator-bool-option
- Merge pull request #1717 from austinwilcox/fixVimEsc
- Merge pull request #1715 from iifawzi/feat/1714-compound-foreign-keys
New in Beekeeper Studio 4.0.3 (Oct 1, 2023)
New in Beekeeper Studio 4.0.0 (Sep 29, 2023)
- 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:
- @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 🤷 - 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
New in Beekeeper Studio 3.9.20 (Aug 7, 2023)
- 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.
- 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 #1610
- 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
- Create table SQL script fix by @rathboma in #1657
New in Beekeeper Studio 3.9.18 (Jul 17, 2023)
- 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 #1619
- fix: eslint/TS setup and all initial errors by @ndom91 in #1529
- Fix save as markdown by @not-night-but in #1623
- NEW CONTRIBUTORS:
- @ndom91 made their first contribution in #1529
New in Beekeeper Studio 3.9.17 (Jun 13, 2023)
New in Beekeeper Studio 3.9.16 (Jun 11, 2023)
New in Beekeeper Studio 3.9.15 (Jun 11, 2023)
- Including keyvault auth as an env variable
- Added a sign.js file for windows signing
- Hopefully figured out how to install azuresigntool
- Install dotnet (windows only)
New in Beekeeper Studio 3.9.14 (May 27, 2023)
- Fixed a couple of security problems and other general bugs.
New in Beekeeper Studio 3.9.12 (May 27, 2023)
New in Beekeeper Studio 3.9.10.2 (May 25, 2023)
New in Beekeeper Studio 3.9.9 (Apr 20, 2023)
New in Beekeeper Studio 3.9.8 (Apr 12, 2023)
- This fixes a couple of issues with postgres schema and table fetching
New in Beekeeper Studio 3.9.5 (Apr 12, 2023)
- My wife had heart surgery in Feb (she's doing great!) and I've been helping her recover, so it's been a while since the last Beekeeper Studio release (It's not a coincidence that I put out a super stable release at the end of Jan).
- If you are a customer of the commercial edition - Thank you, your financial support makes all of this possible.
- If you use the community edition, please consider upgrading to the commercial edition. Every purchase supports me, and the continued development of the community edition.
- I also have a few part time folks helping me keep Beekeeper Studio features rolling:
- Big thanks to them for their help.
- HIGHLIGHTS:
- Added support for PostgreSQL partitions in the table structure view (@not-night-but)
- Added support for Query Magic enum substitution (@not-night-but)
- Added support for alphanumeric sorting of pinned tables (@tomaskudlicka)
- Added the ability to pin saved connections (just like pinned tables) (@not-night-but)
- Added custom user-enum support to query magics, [read more here]https://app.duckdocs.com/sites/2/pages/query-magics#replace-values-with-a-custom-enum) (@not-night-but)
- MORE AWESOME FEATURES AND FIXES:
- Added support to copy table data modifications to SQL instead of applying them automatically
- Added the ability to select field names in the table structure view when they're not editable
- Huuuuuge upgrade from Electron 13 to Electron 18
- Colo(u)r sorting of connections fixed
- SSH2 library upgraded
- Fixing column names in the JSON download
- ...more stuff below, man this took a while to write
- MERGED RPS:
- 85e68d5 Merge pull request #1558 from beekeeper-studio/partitions-fix-96
- a44371d Merge pull request #1548 from beekeeper-studio/partitions
- 4719c4c Merge pull request #1525 from MaximeRaynal/master
- 7512516 Merge pull request #1551 from tomaskudlicka/feat/pin-tables-sorting
- d61910a Merge pull request #1541 from beekeeper-studio/copy-to-sql
- 8a97f1d Merge pull request #1530 from beekeeper-studio/pinned-connections
- 93694b9 Merge pull request #1512 from beekeeper-studio/1472-selectable-fields
- 94f733f Merge pull request #1502 from krystxf/fix/materialized_view
- 8333115 Merge pull request #1537 from beekeeper-studio/interval-sorting
- 3ab8ca5 Merge pull request #1511 from beekeeper-studio/electron-15
- 5015438 Merge pull request #1492 from beekeeper-studio/dependabot/npm_and_yarn/http-cache-semantics-4.1.1
- 470e1d2 Merge pull request #1509 from beekeeper-studio/editing-disabled
- 13a4b9c Merge pull request #1513 from beekeeper-studio/colour-sorting
- 7d931d6 Merge pull request #1516 from beekeeper-studio/mainline-ssh2
- 68f0917 Merge pull request #1510 from beekeeper-studio/electron-remote-migration
- 245f58d Merge pull request #1447 from beekeeper-studio/dependabot/npm_and_yarn/decode-uri-component-0.2.2
- e777f10 Merge pull request #1464 from beekeeper-studio/feature/747_find-replace-in-editor
- 0240976 Merge pull request #1487 from leduard/master
- 1cda180 Merge pull request #1494 from davidkaufman/issue-1493-colnames-json-download
- 0b475e0 Merge pull request #1473 from beekeeper-studio/dependabot/npm_and_yarn/knex-2.4.0
- 76718b8 Merge pull request #1480 from henryliang2/master
- aefa5ff Merge pull request #1482 from beekeeper-studio/bugfix/empty-value-on-select
New in Beekeeper Studio 3.9.4 (Apr 8, 2023)
- My wife had heart surgery in Feb (she's doing great!) and I've been helping her recover, so it's been a while since the last Beekeeper Studio release (It's not a coincidence that I put out a super stable release at the end of Jan).
- If you are a customer of the commercial edition - Thank you, your financial support makes all of this possible.
- If you use the community edition, please consider upgrading to the commercial edition. Every purchase supports me, and the continued development of the community edition.
- I also have a few part time folks helping me keep Beekeeper Studio features rolling:
- @wmontgomery
- @not-night-but
- @davidkaufman
- Highlights sparkles:
- Added support for PostgreSQL partitions in the table structure view (@not-night-but)
- Added support for Query Magic enum substitution (@not-night-but)
- Added support for alphanumeric sorting of pinned tables (@tomaskudlicka)
- Added the ability to pin saved connections (just like pinned tables) (@not-night-but)
- Added custom user-enum support to query magics, [read more here]https://app.duckdocs.com/sites/2/pages/query-magics#replace-values-with-a-custom-enum) (@not-night-but)
- More awesome features lollipop and lady_beetle fixes:
- Added support to copy table data modifications to SQL instead of applying them automatically
- Added the ability to select field names in the table structure view when they're not editable
- Huuuuuge upgrade from Electron 13 to Electron 22
- Colo(u)r sorting of connections fixed
- SSH2 library upgraded
- Fixing column names in the JSON download
- ...more stuff below, man this took a while to write
- Merged PRs:
- 85e68d5 Merge pull request #1558 from beekeeper-studio/partitions-fix-96
- a44371d Merge pull request #1548 from beekeeper-studio/partitions
- 4719c4c Merge pull request #1525 from MaximeRaynal/master
- 7512516 Merge pull request #1551 from tomaskudlicka/feat/pin-tables-sorting
- d61910a Merge pull request #1541 from beekeeper-studio/copy-to-sql
- 8a97f1d Merge pull request #1530 from beekeeper-studio/pinned-connections
- 93694b9 Merge pull request #1512 from beekeeper-studio/1472-selectable-fields
- 94f733f Merge pull request #1502 from krystxf/fix/materialized_view
- 8333115 Merge pull request #1537 from beekeeper-studio/interval-sorting
- 3ab8ca5 Merge pull request #1511 from beekeeper-studio/electron-15
- 5015438 Merge pull request #1492 from beekeeper-studio/dependabot/npm_and_yarn/http-cache-semantics-4.1.1
- 470e1d2 Merge pull request #1509 from beekeeper-studio/editing-disabled
- 13a4b9c Merge pull request #1513 from beekeeper-studio/colour-sorting
- 7d931d6 Merge pull request #1516 from beekeeper-studio/mainline-ssh2
- 68f0917 Merge pull request #1510 from beekeeper-studio/electron-remote-migration
- 245f58d Merge pull request #1447 from beekeeper-studio/dependabot/npm_and_yarn/decode-uri-component-0.2.2
- e777f10 Merge pull request #1464 from beekeeper-studio/feature/747_find-replace-in-editor
- 0240976 Merge pull request #1487 from leduard/master
- 1cda180 Merge pull request #1494 from davidkaufman/issue-1493-colnames-json-download
- 0b475e0 Merge pull request #1473 from beekeeper-studio/dependabot/npm_and_yarn/knex-2.4.0
- 76718b8 Merge pull request #1480 from henryliang2/master
- aefa5ff Merge pull request #1482 from beekeeper-studio/bugfix/empty-value-on-select
New in Beekeeper Studio 3.9.1 (Apr 6, 2023)
New in Beekeeper Studio 3.8.8 (Jan 14, 2023)
- Beekeeper Studio 3.8 - Cassandra support & read-only connections
- New beta support for Cassandra along with optimizations and read-only connections.
- Firstly, Happy New Year!!! 2023 is here, it’s going to be a great year for all you SQL users.
- Release 3.8 contains some great new features:
- Apache Cassandra support (read-only beta) - Casssandra support is dropping in the commercial version of Beekeeper Studio. Currently support is read-only, but full read/write support is being worked on.
- Create database GUI - Create databases directly from Beekeeper Studio with the click of a button. Also in the community edition
- Hide entities in the sidebar - Hide tables, views, or functions. Also in the community edition.
- Dynamic column loading - This is a HUUUUGEEE performance improvement for large databases. We only load table columns when you need them, not when connecting. Also in the community edition.
- Oracle performance improvements - Oracle support keeps getting stronger.
- Oracle SSH support - You can SSH to an oracle host if you’re not using TLS.
- Read-only connection mode [BETA] - Beekeeper will stop you from executing queries that modify data or schemas in this mode.
New in Beekeeper Studio 3.7.10 (Nov 21, 2022)
New in Beekeeper Studio 3.7.9 (Nov 16, 2022)
- Beekeeper Studio 3.7 - UI enhancements and compatibility improvements
- BKS now has new superpowers such as drop/truncate support, Redshift IAM auth, markdown data exports, and gained some formatting memory
- Wow, what a summer. It was here in Texas, but that gave us time to cook some delicious new features for Beekeeper Studio.
- TRUNCATE and DROP entities right from the Beekeeper Studio sidebar.
- Redshift IAM connections credentials are now supported
- Hide columns on the Table Data view, and Beekeeper will remember the layout between restarts.
- Beekeeper Studio will maintain the horizontal scroll position on a table when sorting a column
- Beekeeper Studio will remember column sizes on the table data view
- Export of JSONB data will export as an object, not an array
- Bit conversion errors when updating a MySQL row are no longer a problem
- Improved Oracle Database TNSADMIN support
- Copy and export data in the Markdown table format (!)
- Added Keep Alive for SSH connections
- Cloning a row will null the primary key
- You can now filter table data using IN
- Plus a bunch of other little fixes and tweaks.
- Legendary Contributors:
- A big thanks to everyone who contributed to this release. For the first time, most features were authored by someone else other than me (!).
- Commercial Version - Out Now. Community Edition - Later:
- You might have noticed that the last release was almost 3 months ago. That’s a long time.
- It takes such a massive effort to put together and publish a release - testing, bug fixing, documentation, release notes, and closely watching for errors after release. The amount of work has made me procrastinate a little and put off doing a release.
- I’m solving this by staggering the releases a little between the commercial and community editions of Beekeeper Studio.
- Release plan going forwards:
- Release new features to the commercial edition
- One to two weeks later release to the community edition
New in Beekeeper Studio 3.6.2 (Oct 26, 2022)
- In certain situations the UI went into an infinite loop of refreshing columns. This stops it from doing that.