menu
save_alt Download

Blog

Keep up with the latest Beekeeper Studio news.
SQL JSON_EXTRACT Walkthrough With Examples Tutorial

SQL JSON_EXTRACT Walkthrough With Examples

How to use JSON_EXTRACT to interact with json data stored as a string in a SQL Database
Matthew Rathbone (with help from OpenAI) / December 5, 2022
PostgreSQL How To Use Schemas Tutorial

PostgreSQL How To Use Schemas

What are schemas in PostgreSQL and how to use them to make your life easier and organize your DB objects.
Matthew Rathbone (with help from OpenAI) / December 3, 2022
PostgreSQL CONSTRAINT Walkthrough Tutorial

PostgreSQL CONSTRAINT Walkthrough

Learn what a constraint is and how to use it on your PostgreSQL tables.
Matthew Rathbone (with help from OpenAI) / December 3, 2022
SQL CTE vs Subquery Walkthrough With Examples Tutorials

SQL CTE vs Subquery Walkthrough With Examples

You won't believe how nice these SQL statements look when turned into CTEs 😍.
Lucas Gray / November 18, 2022
Running Postgres in Docker for Local Development Tutorial

Running Postgres in Docker for Local Development

Docker is a great way to install Postgres in your development environment. Use the docker-compose templates we provide below
Matthew Rathbone / November 10, 2022
Oracle CREATE USER Tutorial With Examples Tutorial

Oracle CREATE USER Tutorial With Examples

How to use CREATE USER in Oracle to authenticate and permission a user. Syntax examples and advanced topics
Lisandro Fernigrini / November 4, 2022
How to Find Your Oracle Database Version Number Tutorial

How to Find Your Oracle Database Version Number

Need to know what version (or edition) of Oracle Database you are using? We'll walk through all the ways you can find it, even if your Oracle Database doesn't start.
Lisandro Fernigrini / October 30, 2022
Beekeeper Studio 3.7 - UI enhancements and compatibility improvements Release

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
Matthew Rathbone / September 29, 2022
7 Must-Have Tools For Developers That Use PostgreSQL Tutorial

7 Must-Have Tools For Developers That Use PostgreSQL

These tools will help you level up your PostgreSQL installation.
Etai Stein / September 26, 2022
Oracle Database Backups - A Beginners Guide Tutorial

Oracle Database Backups - A Beginners Guide

I'll discuss some backup strategies including offline backups, online backups, exports, and cloud specific options. I'll talk a lot about RMAN. Finally I'll weigh in on which backup strategy you should use.
Lisandro Fernigrini / September 26, 2022
Oracle CREATE DATABASE LINK Guide Tutorial

Oracle CREATE DATABASE LINK Guide

In this tutorial I'll teach you how to connect your Oracle Database to another datastore and query them together like they're a single database.
Lisandro Fernigrini / September 2, 2022
How To List Oracle Tables Tutorial

How To List Oracle Tables

Sometimes you need to explore your Oracle database to find an existing table. In this guide we'll show you how to list and filter your Oracle tables.
Matthew Rathbone / August 19, 2022
PostgreSQL - Change The Type Of A Column, A Walkthrough With Examples Tutorial

PostgreSQL - Change The Type Of A Column, A Walkthrough With Examples

How to change a PostgreSQL column type without messing up your table, losing data, or taking down your database.
Matthew Rathbone / June 16, 2022
How to create a database in SQLite Tutorials

How to create a database in SQLite

SQLite is a friendly database technology that uses .db files to store data, but it doesn't support the standard `CREATE DATABASE` SQL statement. Thankfully creating a new database is easier than you think.
Matthew Rathbone / May 30, 2022
Beekeeper Studio 3.3 - M1, Themes, and Shortcuts Release

Beekeeper Studio 3.3 - M1, Themes, and Shortcuts

System theming, M1 Mac support, keyboard shortcuts, SQLite STRICT syntax support, and more in today's release
Matthew Rathbone / March 28, 2022
SQLite DB Browser Guides

SQLite DB Browser

Browse your SQLite tables, edit data, alter columns and more using the most intuitive SQLite DB Browser on the market.
Matthew Rathbone / March 10, 2022
Beekeeper Studio Ultimate Edition Release

Beekeeper Studio Ultimate Edition

Tl;dr: Beekeeper Studio Ultimate Edition is now available, code is now GPL, and team workspaces are deprecated
Matthew Rathbone / February 21, 2022
Guide to Distributing Electron Apps For Linux Tutorial

Guide to Distributing Electron Apps For Linux

There are half a dozen different packages you can build for Linux, but should you? By the end of this article you'll know what to do and why.
Matthew Rathbone / January 15, 2022
Postgres Client For Ubuntu news

Postgres Client For Ubuntu

Beekeeper Studio is an open source, modern, and easy-to-use Postgres client for Ubuntu
Matthew Rathbone / January 14, 2022
Introducing Team Workspaces - Online Storage for Beekeeper Studio Release

Introducing Team Workspaces - Online Storage for Beekeeper Studio

Share connections and queries across machines, and maybe even collaborate with team members, if you have any.
Matthew Rathbone / December 13, 2021
Release 2.1 - Quick Search Release

Release 2.1 - Quick Search

Quickly jump between tables and saved queries with Quick Search. Simply hit CTRL-P (or CMD-P) and start typing.
Matthew Rathbone / September 14, 2021
Beekeeper Studio 2.0 - Celebrating 10x YoY Growth With New Features And A Small Retrospective Release

Beekeeper Studio 2.0 - Celebrating 10x YoY Growth With New Features And A Small Retrospective

Schema editing, index editing, and relation editing are our big ticket new features. But wait, there's more! We also talk through growth metrics over the last year [with charts] and go all starry eyed about what the future holds.
Matthew Rathbone / August 30, 2021
Release 1.13 - Build and Edit Database Tables Release

Release 1.13 - Build and Edit Database Tables

Use a visual interface to create and modify table schemas, no need to remember esotoric SQL. Available for all databases - Postgres, MySQL, SQL Server, Redshift, Cockroach, and SQLite.
Matthew Rathbone / July 26, 2021
Introducing SQLTools - relational database tools in your browser SQLTools

Introducing SQLTools - relational database tools in your browser

SQLTools provides SQL formatting, table building, and table templates to everyone on the internet. It's FOSS and powered by Beekeeper Studio and Vue.js.
Matthew Rathbone / June 29, 2021
Release 1.12 - Table Properties and File Associations Release

Release 1.12 - Table Properties and File Associations

Document tables and inspect table schemas, triggers, indexes, and relations.
Matthew Rathbone / June 7, 2021
Release 1.11 - Data exports and better table editing tools Release

Release 1.11 - Data exports and better table editing tools

Export database table data, clone rows, and add new rows for all databases.
Matthew Rathbone / May 17, 2021
1.10 Engine Improvements Release

1.10 Engine Improvements

Knocking out some deep gnarley issues to make using Beekeeper for SQL and Table editing much smoother
Matthew Rathbone / March 15, 2021
1.9 Functions, Procedures, and SSL love Release

1.9 Functions, Procedures, and SSL love

View functions and procedures, use sslMode=require, and reorder tabs at will.
Matthew Rathbone / January 4, 2021
Release 1.8 - ARM build, Custom SSL certs, performance improvements, tweaks, and bug fixes Release

Release 1.8 - ARM build, Custom SSL certs, performance improvements, tweaks, and bug fixes

Our SQL editor gets a little better thanks to many quality community contributions.
Matthew Rathbone / October 23, 2020
Beekeeper Studio Launch and Q3 2020 by the numbers Metrics

Beekeeper Studio Launch and Q3 2020 by the numbers

A regular review of our performance metrics, this time including a reflection on our launch in April 2020.
Matthew Rathbone / October 5, 2020
Quick Guide to Building Electon Apps For ARM Linux and the Raspberry Pi Tutorials

Quick Guide to Building Electon Apps For ARM Linux and the Raspberry Pi

Building apps on ARM isn't as simple as it should be. AppImage building is easy, but DEB, RPM and Snap packages are trouble. Fear not! Help is at hand.
Matthew Rathbone / September 14, 2020
Release 1.7 - SQL Table Editing and Foreign Key Lookups Release

Release 1.7 - SQL Table Editing and Foreign Key Lookups

Edit your SQL tables, one-click navigate to foreign key records, and format your SQL queries in one click. Huge feature release!
Matthew Rathbone / August 28, 2020
Building an Electron App in Windows with WSL 2 and Ubuntu Tutorials

Building an Electron App in Windows with WSL 2 and Ubuntu

Windows Subsystem for Linux (WSL) version 2 provides a native Linux runtime right inside of Windows. It's pretty rad. I'll show you how to use that environment to build cross-platform apps with Ubuntu 20.04, Electron, and Vue.
Matthew Rathbone / August 2, 2020
Redshift Client for Linux, MacOS, and Windows Guides

Redshift Client for Linux, MacOS, and Windows

Beekeeper Studio is a free and open source database client. We support many databases, but we really love Redshift.
Matthew Rathbone / July 24, 2020
Release 1.6 - Statusbars, Menus, and Yak Shaving Release

Release 1.6 - Statusbars, Menus, and Yak Shaving

We're pushing our UX forward with some major usability improvements -- but at what cost?
Matthew Rathbone / July 20, 2020
Release 1.5 - Community Enhancement Megapack Release

Release 1.5 - Community Enhancement Megapack

A whole bunch of new features, usability improvements, and bugfixes. This whole release is community developed!
Matthew Rathbone / June 14, 2020
Release 1.4 - SSH Tunnels, SQL Server, and Multiple Queries Release

Release 1.4 - SSH Tunnels, SQL Server, and Multiple Queries

Windows Integrated Login, Jump Hosts, and being able to click things are some of this week's key features.
Matthew Rathbone / May 22, 2020
Release 1.3 - Bugfix Bonanza Release

Release 1.3 - Bugfix Bonanza

Lots of UI tweaks and database enhancements, especially if you use Postgres
Matthew Rathbone / May 12, 2020
Release V1.2 Release

Release V1.2

Filter, Sort, and Filter SQL table data with the new version of Beekeeper Studio.
Matthew Rathbone / May 5, 2020