Blog | Beekeeper Studio

Release

Beekeeper Studio 5.0 Beta Release

ClickHouse support, IAM for Postgres, and JSON row view join the chat. Lots of behind the scenes changes to secure and modernize the app.

Matthew Rathbone / November 4, 2024

Tutorial

Data Querying Tools

Data querying is essential for managing and analyzing data stored in databases. In this guide, we will explore some of the most widely used data querying tools, highlighting their strengths, use cases, and practical examples.

Matthew Rathbone / October 21, 2024

Reviews

5 Best Free & Open Source MariaDB GUIs for 2024

The top MariaDB GUIs for 2024, all of them free and open!

Matthew Rathbone / September 30, 2024

Tutorial

How to Create a JDBC SQL Server Connection String

When connecting to a SQL Server database through a Java application, JDBC (Java Database Connectivity) is the bridge between your application and the database. A key component of this connection is the connection string. In this tutorial, we'll cover how to properly configure a JDBC connection string for SQL Server, what each part of the string means, and how to use it in your Java code.

Matthew Rathbone / September 23, 2024

Tutorial

How to use MariaDB with Docker

Using MariaDB with Docker and docker-compose can be a useful way to set up a development environment for your application. This guide will walk you through the process of setting up MariaDB with Docker, from installation to basic configuration.

Matthew Rathbone / September 21, 2024

Tutorial

Postgres in Docker - A Practical Guide

How to run Postgres using docker in development and in production - code examples included.

Matthew Rathbone / September 21, 2024

Reviews

5 Best Free & Open Source MySQL GUIs for 2024

The top MySQL GUIs for 2024, all of them free and open!

Matthew Rathbone / September 19, 2024

Tutorial

How to Query Active Record for Weekdays Only

When working with Rails applications, you might need to filter records based on weekdays only, excluding weekends. This requirement is common in scenarios like business hours reporting, scheduling, or other date-specific business logic. In this tutorial, we'll explore how to achieve this using 'Active Record' - Rails' built-in ORM (Object-Relational Mapping) tool.

Matthew Rathbone / September 12, 2024

Reviews

5 Best Free & Open Source PostgreSQL GUIs for 2024

The top PostgreSQL GUIs for 2024, all of them free and open!

Matthew Rathbone / September 11, 2024

Tutorial

How to Select Weekdays Only in Oracle SQL

In many business scenarios, you may need to perform operations or run queries that only consider weekdays. This can be especially important when dealing with working hours, schedules, or financial transactions, which typically exclude weekends. In this tutorial, we’ll walk through how to filter out weekends in Oracle SQL and work with weekdays only.

Matthew Rathbone / September 9, 2024

Tutorial

How to Show Grants in MySQL

Understanding and managing user permissions in MySQL is necessary for maintaining database security and proper access control. In this tutorial we will focus on displaying user privileges in MySQL using the `SHOW GRANTS` command.

Matthew Rathbone / September 8, 2024

Tutorial

How to Extract Total Days, Hours, or Minutes from an Interval in PostgreSQL

When working with date and time data in PostgreSQL, intervals are a common way to represent a span of time. Sometimes, you may need to extract specific components from an interval, such as total days, hours, or minutes. In this tutorial, we will cover how to extract these specific components from an interval.

Matthew Rathbone / August 28, 2024

Tutorial

How to Create a Table in Azure SQL Database

Creating tables is a fundamental task when working with databases, and Azure SQL Database is no exception. This tutorial will walk you through the steps to create a table in Azure SQL Database using SQL queries. We'll also cover some essential options and considerations to help you make the most out of your table creation.

Matthew Rathbone / August 26, 2024

Tutorial

How to Show Tables in PostgreSQL Using `psql`

When working with PostgreSQL, especially from the command line interface `psql`, one of the common tasks you'll perform is listing all tables in your current database. This guide will show you how to do that using various methods within psql.

Matthew Rathbone / August 25, 2024

Tutorial

How to Subtract in SQL

When working with databases, there are numerous scenarios where you might need to subtract values, whether it's to calculate differences between dates, subtract numeric values, or compare results across rows. This tutorial will guide you through the different ways to subtract in SQL, using practical examples that you can directly apply.

Matthew Rathbone / August 23, 2024

Tutorial

How to Rename a Table in PostgreSQL

Renaming a table in PostgreSQL is a straightforward task, but there are some important considerations to keep in mind. This tutorial will guide you through the process of renaming a table in PostgreSQL, explaining not only how to do it but also why it works the way it does.

Matthew Rathbone / August 19, 2024

Tutorial

How to Use SQL Query Templates

SQL query templates are a powerful tool to streamline your database operations and reduce repetitive coding. In this article, we'll walk through how to create and use SQL query templates, why they are beneficial, and provide code examples with expected outputs.

Matthew Rathbone / August 13, 2024

Tutorial

How to Rename a Column Using ALTER TABLE in SQL

Learn the different syntaxes for renaming columns using the ALTER TABLE command in SQL databases like MySQL, PostgreSQL, SQL Server, and SQLite.

Matthew Rathbone / August 8, 2024

Tutorial

How to Subtract in PostgreSQL

Learn how to perform subtraction ops in PostgreSQL, from basic numbers to dates and timestamps, with clear examples.

Matthew Rathbone / August 7, 2024

Tutorial

How to Create a Table in Oracle

Creating tables in Oracle is a fundamental task for managing your database schema. This guide will walk you through the essential steps and considerations when creating tables, including syntax, data types, and best practices.

Matthew Rathbone / July 29, 2024

Tutorial

How to Drop a Column in PostgreSQL

Dropping a column in PostgreSQL is a common operation when you need to clean up or optimize your database schema. This tutorial will walk you through the process of dropping a column, including why and how it works.

Matthew Rathbone / July 25, 2024

Tutorial

How to Rename a Column in PostgreSQL

Renaming a column in PostgreSQL is a common task when you need to make your database schema more intuitive and maintainable. This tutorial will guide you through the process, including potential pitfalls and considerations.

Matthew Rathbone / July 23, 2024

Tutorial

How to drop a table in MySQL

This tutorial will cover the syntax and practical use cases for dropping tables in MySQL, including safety precautions and potential pitfalls.

Matthew Rathbone / July 22, 2024

Tutorial

How to Kill a Session in PostgreSQL

Learn to kill sessions in PostgreSQL with our guide on using pg_terminate_backend and pg_cancel_backend functions effectively.

Matthew Rathbone / July 17, 2024

Tutorial

How to Kill Queries in Amazon Redshift

Learn how to identify, terminate, and automate problematic queries in Amazon Redshift to maintain optimal database performance.

Matthew Rathbone / July 15, 2024

Tutorial

How to Create Charts Using Ruby on Rails

Learn to create charts in Ruby on Rails using Chartkick. A simple tutorial for visualizing SQL data with charts.

Matthew Rathbone / July 10, 2024

Tutorial

How to Drop a Sequence in PostgreSQl

Learn how to drop a sequence in PostgreSQL efficiently using commands like DROP SEQUENCE, IF EXISTS, CASCADE, and RESTRICT.

Matthew Rathbone / July 6, 2024

Tutorial

How to Limit Rows in Teradata

Learn how to limit rows in Teradata using TOP, SAMPLE, and QUALIFY with practical examples to ennhance query performance and efficiency.

Matthew Rathbone / July 6, 2024

Tutorial

How to Drop Constraints in PostgreSQL

To drop a constraint in PostgreSQL, use the `ALTER TABLE` command followed by the `DROP CONSTRAINT` clause, specifying the name of the constraint to be dropped. Be careful, as this can potentially lead to data integrity issues.

Matthew Rathbone / July 6, 2024

Reviews

5 Free & Open Source DataGrip Alternatives for 2024

Open source DataGrip alternatives that offer something different, all of them free and open source!

Matthew Rathbone / July 2, 2024

Tutorial

Understanding and Resolving the "SQLite Database is Locked" Error

When working with SQLite databases, encountering a "database is locked" error can be a frustrating roadblock. This tutorial explains why this error occurs and provides practical solutions to resolve it, complete with code examples and their expected outputs.

Matthew Rathbone / June 25, 2024

Tutorial

PostgreSQL Stored Procedure Example Tutorial

Learn how to write and call PostgreSQL Stored Procedures with step-by-step examples

Matthew Rathbone / June 20, 2024

Tutorial

Storing Images in a Database: A How-To Guide

This tutorial will guide you through the process of storing images in SQL databases using BLOB (Binary Large Object) data types, providing practical examples and explanations.

Matthew Rathbone / June 18, 2024

Tutorial

How to Show Tables in SQLite

Learn how to show tables in SQLite using .tables & SELECT statements. Discover methods to see table schemas and utilize Beekeeper Studio for easy SQLite database management.

Matthew Rathbone / June 16, 2024

Release

Beekeeper Studio 4.6 - Azure SSO and LibSQL

Azure SQL SSO, support for LibSQL, and a bunch of bug fixes

Matthew Rathbone / June 12, 2024

Tutorial

Creating a User in MariaDB: A Step-by-Step Guide

To create a new user in MariaDB, use the `CREATE USER` and `GRANT` statements to create the user and grant necessary privileges, then use `FLUSH PRIVILEGES` to make the changes take effect. Manage user accounts carefully for security and integrity.

Matthew Rathbone / June 10, 2024

Tutorial

How to Add a Column in Teradata: A Step-by-Step Guide

Learn how to add a column in Teradata using the ALTER TABLE command with practical examples.

Matthew Rathbone / June 4, 2024

Tutorial

MySQL Change Column Type Guide

Learn how to change column type in MySQL using the ALTER TABLE statement. Follow practical examples to modify column data types efficiently.

Matthew Rathbone / May 28, 2024

Release

Beekeeper Studio 4.3.4 - Minimal mode

The start of a focus mode for Beekeeper Studio

Matthew Rathbone / May 22, 2024