v4.2.9

Update README.md

4.2.8 - minor bug fix for connections with no default database

v4.2.8

Update README.md

4.2 Life, the universe, and everything

v4.2.7

Update README.md

4.1 Bugfix release

Fixing bugs from the 4.1 release. No new features.

4.1 - Spreadsheet mode, model editor, and more!

See the blog for more details

4.0.3 - Minor bug fixes

v4.0.3

Update README.md

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:

• @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
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

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

• **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 beekeeper-studio/beekeeper-studio#1610

• Upgrade ssh2 from 1.110 to 1.14.0 by @davidkaufman in beekeeper-studio/beekeeper-studio#1653

• fix: remove extra wrapping div by @wmontgomery in beekeeper-studio/beekeeper-studio#1655

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

• Create table SQL script fix by @rathboma in beekeeper-studio/beekeeper-studio#1657

3.9.18

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.

3.9.17 - minor bugfixes and new Windows cert

New windows cert! Minor bug fixes, all good things.