Beekeeper Studio 4.0 - export, backup and restore your database

September 28, 2023 By Matthew Rathbone

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

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

Beekeeper Studio 4.0 - export, backup and restore your database

On This Page

Meet the 4.0 team

Headline features

Even more amazing features and fixes (long list warning)

Pull requests

Join our newsletter for SQL tips and more