menu
save_alt Download

Blog

Keep up with the latest Beekeeper Studio news.
Data Querying Tools 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
How to Create a JDBC SQL Server Connection String 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
How to use MariaDB with Docker 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
Postgres in Docker - A Practical Guide 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
5 Best Free & Open Source MySQL GUIs for 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
How to Query Active Record for Weekdays Only 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
5 Best Free & Open Source PostgreSQL GUIs for 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
How to Select Weekdays Only in Oracle SQL 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
How to Show Grants in MySQL 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
How to Extract Total Days, Hours, or Minutes from an Interval in PostgreSQL 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
How to Create a Table in Azure SQL Database 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
How to Show Tables in PostgreSQL Using `psql` 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
How to Subtract in SQL 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
How to Rename a Table in PostgreSQL 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
How to Use SQL Query Templates 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
How to Rename a Column Using ALTER TABLE in SQL 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
How to Subtract in PostgreSQL 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
How to Create a Table in Oracle 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
How to Drop a Column in PostgreSQL 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
How to Rename a Column in PostgreSQL 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
How to drop a table in MySQL 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
How to Kill a Session in PostgreSQL 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
How to Kill Queries in Amazon Redshift 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
How to Create Charts Using Ruby on Rails 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
How to Drop a Sequence in PostgreSQl 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
How to Limit Rows in Teradata 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
How to Drop Constraints in PostgreSQL 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
5 Free & Open Source DataGrip Alternatives for 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
Understanding and Resolving the "SQLite Database is Locked" Error 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
PostgreSQL Stored Procedure Example Tutorial 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
Storing Images in a Database: A How-To Guide 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
How to Show Tables in SQLite 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
Beekeeper Studio 4.6 - Azure SSO and LibSQL 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
Creating a User in MariaDB: A Step-by-Step Guide 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
How to Add a Column in Teradata: A Step-by-Step Guide 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
MySQL Change Column Type Guide 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
Beekeeper Studio 4.3.4 - Minimal mode Release

Beekeeper Studio 4.3.4 - Minimal mode

The start of a focus mode for Beekeeper Studio
Matthew Rathbone / May 22, 2024
Teradata Corporation (TDC) Revenue, Updated for 2024 Q1 Metrics

Teradata Corporation (TDC) Revenue, Updated for 2024 Q1

Teradata Corporation (TDC) booked $465,000,000 in 2024 Q1. Read for more metrics.
Matthew Rathbone / May 10, 2024
Splunk Inc. (SPLK) Revenue, Updated for 2024 Q3 Metrics

Splunk Inc. (SPLK) Revenue, Updated for 2024 Q3

Splunk Inc. (SPLK) booked $1,067,355,000 in 2024 Q3. Read for more metrics.
Matthew Rathbone / May 10, 2024
Snowflake Revenue, Updated for 2024 Q4 Metrics

Snowflake Revenue, Updated for 2024 Q4

Snowflake Inc. booked $774,699,000 in 2024 Q4. Read for more metrics.
Matthew Rathbone / May 10, 2024
MongoDB, Inc. (MDB) Revenue, Updated for 2024 Q4 Metrics

MongoDB, Inc. (MDB) Revenue, Updated for 2024 Q4

MongoDB, Inc. (MDB) booked $458,002,000 in 2024 Q4. Read for more metrics.
Matthew Rathbone / May 10, 2024
Elastic N.V. (ESTC) Revenue, Updated for 2024 Q3 Metrics

Elastic N.V. (ESTC) Revenue, Updated for 2024 Q3

Elastic N.V. (ESTC) booked $327,957,000 in 2024 Q3. Read for more metrics.
Matthew Rathbone / May 10, 2024
Dynatrace Inc. (DT) Revenue, Updated for 2024 Q3 Metrics

Dynatrace Inc. (DT) Revenue, Updated for 2024 Q3

Dynatrace Inc. (DT) booked $365,096,000 in 2024 Q3. Read for more metrics.
Matthew Rathbone / May 10, 2024
Datadog (DDOG) Revenue, Updated for 2024 Q1 Metrics

Datadog (DDOG) Revenue, Updated for 2024 Q1

Datadog (DDOG) booked $611,253,000 in 2024 Q1. Read for more metrics.
Matthew Rathbone / May 10, 2024
Cloudera (CLDR) Revenue, Updated for 2022 Q2 Metrics

Cloudera (CLDR) Revenue, Updated for 2022 Q2

Cloudera (CLDR) booked $236,057,000 in 2022 Q2. Read for more metrics.
Matthew Rathbone / May 10, 2024
Alteryx, Inc. (AYX) Revenue, Updated for 2023 Q4 Metrics

Alteryx, Inc. (AYX) Revenue, Updated for 2023 Q4

Alteryx, Inc. (AYX) booked $351,000,000 in Q4 2023. Read for more metrics.
Matthew Rathbone / May 10, 2024
5 Free & Open Source DBeaver Alternatives for 2024 Reviews

5 Free & Open Source DBeaver Alternatives for 2024

Open source DBeaver alternatives that offer something different, all of them free and open!
Matthew Rathbone / May 8, 2024
Cassandra Show Tables: How to List Tables Using CQL Tutorial

Cassandra Show Tables: How to List Tables Using CQL

Learn to show tables in Cassandra with simple CQL commands. Step-by-step guide for listing keyspaces and tables using cqlsh.
Matthew Rathbone / May 8, 2024
Deleting a Database in MySQL: A Step-by-Step Guide Tutorial

Deleting a Database in MySQL: A Step-by-Step Guide

To delete a database in MySQL, use the DROP DATABASE command, be careful, this action is permanent.
Matthew Rathbone / May 6, 2024
MySQL Subtraction Techniques Tutorial

MySQL Subtraction Techniques

Learn how to perform subtractions in MySQL including numbers, columns, dates, aggregates, and handle NULL values effectively.
Matthew Rathbone / April 29, 2024
Adding a Primary Key to an Existing Table in PostgreSQL Tutorial

Adding a Primary Key to an Existing Table in PostgreSQL

Learn how to add a primary key to an existing table in PostgreSQL using the ALTER TABLE command
Matthew Rathbone / April 29, 2024
How to List Databases Using the psql command line tool Tutorial

How to List Databases Using the psql command line tool

Use \l or \list to list databases. In this tutorial we'll also show you how to get more detailed information, such as the size, description, use roles & permissions, and tablespace data.
Matthew Rathbone / April 21, 2024
Understanding and Implementing 'SELECT TOP 1' in SQL Tutorial

Understanding and Implementing 'SELECT TOP 1' in SQL

A guide to using 'SELECT TOP 1' for efficient data retrieval with equivalent methods for SQL Server, MySQL and PostgreSQL.
Matthew Rathbone / April 17, 2024
PostgreSQL Information_Schema Guide for Database Management Tutorial

PostgreSQL Information_Schema Guide for Database Management

Learn how to use PostgreSQL information_schema to view tables, columns, constraints, and more for effective database management.
Matthew Rathbone / April 9, 2024
Understanding PostgreSQL Information_Schema Views Tutorial

Understanding PostgreSQL Information_Schema Views

Explore the PostgreSQL information_schema views for insights on database structure, tables, columns, triggers, and constraints.
Matthew Rathbone / April 8, 2024
Beekeeper Studio 4.2 - Firebird, SQL importing, & scaling up Release

Beekeeper Studio 4.2 - Firebird, SQL importing, & scaling up

We've laid the groundwork for more quickly adding new databases.
Matthew Rathbone / April 5, 2024
PostgreSQL How To Select Weekdays Only Tutorial

PostgreSQL How To Select Weekdays Only

Learn how to extract weekdays from dates in PostgreSQL. Code samples included
Matthew Rathbone / February 19, 2024
SQLite Subtract Operations: Learn How to Do It Tutorial

SQLite Subtract Operations: Learn How to Do It

Discover how to perform SQLite subtract operations with our guide, including date and time calculations. Code samples included.
Matthew Rathbone / February 14, 2024
SQL Server Subtraction Operations Tutorial

SQL Server Subtraction Operations

Learn how to perform subtraction in SQL Server, handle NULL values, datetime calculations, and aggregate data sets with clear examples.
Matthew Rathbone / February 14, 2024
Formatting Dates in Oracle Database - Quick Guide Tutorial

Formatting Dates in Oracle Database - Quick Guide

Discover how TO_CHAR and TO_DATE functions can help you display and convert date values using various format codes. Perfect for developers aiming to refine their SQL skills.
Matthew Rathbone / January 13, 2024
Beekeeper Studio 4.1 - Spreadsheet Mode, Modal Editor, Wayland Support, & More Release

Beekeeper Studio 4.1 - Spreadsheet Mode, Modal Editor, Wayland Support, & More

Beekeeper Studio SQL Editor now behaves more like a spreadsheet (in the ways that matter).
Matthew Rathbone / January 12, 2024
Guide to Formatting Dates in PostgreSQL Tutorial

Guide to Formatting Dates in PostgreSQL

Learn the ins and outs of formatting dates in PostgreSQL with our comprehensive guide. Dive into date types with examples and the TO_CHAR function to master PostgreSQL date formatting.
Matthew Rathbone / January 12, 2024
MySQL Create Index Tutorial: Optimizing MySQL Queries Tutorial

MySQL Create Index Tutorial: Optimizing MySQL Queries

How to create indexes in MySQL to enhance query performance. This guide with examples will introduce you to index creation for faster data retrieval and efficient querying.
Matthew Rathbone / January 6, 2024
MySQL Full Outer Join Explained With Code Examples Tutorial

MySQL Full Outer Join Explained With Code Examples

FULL OUTER JOIN is not supported by MySQL, in this guide we'll show you how to accomplish the same thing with a workaround
Matthew Rathbone / January 2, 2024
Beekeeper Studio 4.0 - export, backup and restore your database Release

Beekeeper Studio 4.0 - export, backup and restore your database

Create native database backups, restore backups, and create multi-table exports in Beekeeper Studio 3.20
Matthew Rathbone / September 28, 2023
Beekeeper Studio 3.9.20 - export, backup and restore your database Release

Beekeeper Studio 3.9.20 - export, backup and restore your database

Create native database backups, restore backups, and create multi-table exports in Beekeeper Studio 3.20
Matthew Rathbone / August 3, 2023
How to drop a foreign key constraint in PostgreSQL Tutorial

How to drop a foreign key constraint in PostgreSQL

Matthew Rathbone / May 24, 2023
How To Limit The Number Of Rows Returned In Oracle Database Tutorial

How To Limit The Number Of Rows Returned In Oracle Database

Oracle doesn't have the LIMIT keywords, but fear not, we have other tools....but really hope you're using 12c+.
Matthew Rathbone / May 17, 2023
How To Limit The Number Of Rows Returned In Redshift Tutorial

How To Limit The Number Of Rows Returned In Redshift

When you only want a subset of your results in Redshift, this is how you do it.
Matthew Rathbone / May 3, 2023
How To Limit The Number Of Rows Returned In SQLite Tutorial

How To Limit The Number Of Rows Returned In SQLite

If you don't want to pull back all records for a large SQLite dataset, or page through data, here's how
Matthew Rathbone / April 26, 2023
How To Limit The Number Of Rows Returned In SQL Server Tutorial

How To Limit The Number Of Rows Returned In SQL Server

If you don't want to pull back all records for a large SQL Server dataset, or page through data, here's how
Matthew Rathbone / April 19, 2023
How To Limit The Number Of Rows Returned In BigQuery Tutorial

How To Limit The Number Of Rows Returned In BigQuery

Use the LIMIT clause to limit the number of rows returned. Combine with OFFSET to page through your data. But be careful - costs can mount quickly with BigQuery.
Matthew Rathbone / April 12, 2023
Beekeeper Studio 3.9 - Ramping up after a slow winter Release

Beekeeper Studio 3.9 - Ramping up after a slow winter

User enums, better sorting, PostgreSQL partition support, massive Electron upgrade and a whole lot of bug fixes
Matthew Rathbone / April 7, 2023
How To Limit The Number Of Rows Returned In PostgreSQL Tutorial

How To Limit The Number Of Rows Returned In PostgreSQL

How to limit the number of rows returned for pagination, reporting, or debugging.
Matthew Rathbone / April 5, 2023
How To Limit The Number Of Rows Returned In MySQL Tutorial

How To Limit The Number Of Rows Returned In MySQL

Use row limiting to paginate, debug, or perform reporting in your MySQL database.
Matthew Rathbone / March 29, 2023
How to Rename a Column in Oracle Database Tutorial

How to Rename a Column in Oracle Database

Sometimes you just need a column to have a different name, but don't worry, it's super easy to do in Oracle.
Matthew Rathbone / March 22, 2023
How to Create a Custom Function in PostgreSQL Tutorial

How to Create a Custom Function in PostgreSQL

Custom functions are a great way to perform computations in Postgres, you won't believe how easy they are to create.
Matthew Rathbone / March 15, 2023
How (Any Why) To Add Source Control To SQL Server Tutorial

How (Any Why) To Add Source Control To SQL Server

The benefits of source control include improving troubleshooting, consistency, collaboration, and auditing. Discover a reliable and easy-to-use tool to source control your SQL Server database, and see how it can help you track and document changes while ensuring code consistency across your team.
Matthew Rathbone / March 8, 2023
How to Drop a Constraint in SQL Server Tutorial

How to Drop a Constraint in SQL Server

Constraints in SQL Server are super useful for data integrity, but sometimes you have to get rid of them. Here is how.
Matthew Rathbone / March 8, 2023
How to Drop a Constraint in Oracle Database Tutorial

How to Drop a Constraint in Oracle Database

Constraints are great, but sometimes you have to remove them. Here is how
Matthew Rathbone / March 1, 2023
What Is Atomicity In Databases? Tutorial

What Is Atomicity In Databases?

Atomicity is important if you need to run several SQL statements as a single batch. Read on to learn more.
Matthew Rathbone / February 26, 2023
What Is A Transactional Database? Tutorial

What Is A Transactional Database?

Transactional databases are used to manage operational data for a range of industries. Read on to learn more.
Matthew Rathbone / February 24, 2023
SQLite in Python Tutorial Tutorial

SQLite in Python Tutorial

Starting to use SQLite in Python is pretty straightforward. Here's a quick 10 minute tutorial to get you started.
Matthew Rathbone / February 16, 2023
SQL Server How To Solve 'The transaction log for database x is full due to ACTIVE_TRANSACTION' Tutorial

SQL Server How To Solve 'The transaction log for database x is full due to ACTIVE_TRANSACTION'

This is usually due to a long running transaction, or a low log file size.
Matthew Rathbone / February 14, 2023
PostgreSQL vs SQLite: Comparing Two Popular Databases Tutorial

PostgreSQL vs SQLite: Comparing Two Popular Databases

PostgreSQL and SQLite are both popular relational database management systems (RDBMS), but they are designed for different types of applications and have different strengths and weaknesses.
Matthew Rathbone / February 12, 2023
Comparing PostgreSQL and MariaDB: Origins, Features, and Performance Tutorial

Comparing PostgreSQL and MariaDB: Origins, Features, and Performance

PostgreSQL and MariaDB are two popular open-source relational database management systems. Both have many similar features and capabilities, but there are also some key differences that may make one a better choice for certain use cases over the other.
Matthew Rathbone / February 10, 2023
PostgreSQL limitations Tutorial

PostgreSQL limitations

PostgreSQL is a popular open-source database system that is suitable for many projects, but it does have some limitations as you'll see below.
Matthew Rathbone / February 8, 2023
Using the ON DELETE CASCADE Behavior in Postgres to Maintain Database Integrity Tutorial

Using the ON DELETE CASCADE Behavior in Postgres to Maintain Database Integrity

In Postgres, the delete cascade behavior can be used to automatically delete child records when their parent is deleted, maintaining the integrity of the database.
Matthew Rathbone / February 4, 2023
Quick guide to using the python-oracledb library Tutorial

Quick guide to using the python-oracledb library

How to connect to Oracle in Python. It's pretty simple, but the Oracle library has a few requirements that are unique compared to other databases.
Matthew Rathbone / January 31, 2023
How to use foreign keys in PostgreSQL Tutorial

How to use foreign keys in PostgreSQL

Use a foreign key to link one table to another, like linking orders to a customer. I'll walk through some real examples of foreign keys in action.
Matthew Rathbone / January 27, 2023
Storing and Querying JSON in SQLite: Examples and Best Practices Tutorial

Storing and Querying JSON in SQLite: Examples and Best Practices

SQLite provides two ways to store and query JSON data: using the JSON1 extension and using the BLOB type. Both approaches have their own advantages and disadvantages. Examples and best practices are discussed.
Matthew Rathbone / January 25, 2023
How to store and query JSON in SQLite using a TEXT column with examples Tutorial

How to store and query JSON in SQLite using a TEXT column with examples

The TEXT column is a great way to store JSON as it it still legible when editing the database, and a little searchable.
Matthew Rathbone / January 25, 2023
How To Store And Query JSON in SQLite Using A BLOB Column Tutorial

How To Store And Query JSON in SQLite Using A BLOB Column

BLOB columns are for binary data, but with a bit of work we can use them to store JSON data too. There are limitations to this approach however. Examples in Python
Matthew Rathbone / January 25, 2023
Solving Postgres "Peer Authentication Failed for User" Errors Tutorial

Solving Postgres "Peer Authentication Failed for User" Errors

Peer authentication failed for user errors in Postgres occur when the user is not authorized to access the database. This is commonly due to incorrect configuration in the pg_hba.conf file or a mismatch in the operating system and database user name
Matthew Rathbone / January 21, 2023
Solving MySQL 2003: can't connect to mysql server on localhost Tutorial

Solving MySQL 2003: can't connect to mysql server on localhost

If you're unable to connect to the MySQL server on localhost, there are a few potential causes and solutions to consider. This article provides a step-by-step guide to troubleshooting and resolving this issue
Matthew Rathbone / January 21, 2023
Creating Pivot Tables in Oracle Database Using PIVOT and UNPIVOT Operators Tutorial

Creating Pivot Tables in Oracle Database Using PIVOT and UNPIVOT Operators

To create a pivot table in Oracle Database, you can use the PIVOT and UNPIVOT operators in combination with other SQL statements. This allows you to quickly and easily organize and summarize large sets of data, providing valuable insights into your data.
Matthew Rathbone / January 19, 2023
Creating Pivot Tables in PostgreSQL using the crosstab() function Tutorial

Creating Pivot Tables in PostgreSQL using the crosstab() function

To create a pivot table in PostgreSQL, you can use the crosstab() function from the tablefunc extension. This function allows you to pivot data from a source table to create a new table with the data organized in a more useful way. This can be a powerful tool for summarizing and analyzing large amounts of data.
Matthew Rathbone / January 17, 2023
Composite Primary Keys in SQL Tutorial

Composite Primary Keys in SQL

A composite primary key is a type of database key that consists of two or more columns in a table. In this guide, we will provide examples of how to create, modify, and use composite primary keys in SQL
Matthew Rathbone / January 14, 2023
Ultimate Guide To Database Transactions Tutorial

Ultimate Guide To Database Transactions

An outline of what a database transaction is, why they are important, code examples of how to use them, and a walkthrough of the different transaction states.
Lisandro Fernigrini / January 13, 2023
Creating Indexes in Postgresql: How to Use the CREATE INDEX Statement Tutorial

Creating Indexes in Postgresql: How to Use the CREATE INDEX Statement

To create an index in Postgresql, you can use the CREATE INDEX statement. This allows you to specify the index name, table and column, and index type. Indexes can improve query performance, but can also impact write performance, so use them wisely.
Matthew Rathbone / January 9, 2023
What Is A Deadlock In SQL Tutorial

What Is A Deadlock In SQL

A deadlock in SQL occurs when two transactions are waiting for each other to release locks on database resources, causing a standstill in execution. To avoid deadlocks, keep reading.
Matthew Rathbone / January 7, 2023
Rails Migrations: Using bigint Tutorial

Rails Migrations: Using bigint

Ints to small for you? Here's how to use bitint in rails migrations.
Matthew Rathbone / January 7, 2023
PostgreSQL ON CONFLICT Walkthrough Tutorial

PostgreSQL ON CONFLICT Walkthrough

Learn how to use the ON CONFLICT clause in PostgreSQL to handle unique constraint violations and update existing records.
Matthew Rathbone / January 7, 2023
Beekeeper Studio 3.8 - Cassandra support & read-only connections Release

Beekeeper Studio 3.8 - Cassandra support & read-only connections

New beta support for Cassandra along with optimizations and read-only connections.
Matthew Rathbone / January 6, 2023
Rails Migration: Add Default Value to a Column Tutorial

Rails Migration: Add Default Value to a Column

Learn how to set default values for columns in Rails using migrations. This post covers adding and changing default values with simple commands.
Matthew Rathbone / January 6, 2023
rails migration belongs_to Tutorial

rails migration belongs_to

Matthew Rathbone / January 4, 2023
Rails Migrations: Basic data Types Tutorial

Rails Migrations: Basic data Types

what types does rails provide for migrations? Well all of them really, but it has helpers for the most common.
Matthew Rathbone / January 3, 2023
Rails Migration: Add Foreign Key Tutorial

Rails Migration: Add Foreign Key

Foreign keys add relationships between tables in your database, here's how to add them using a Rails migration.
Matthew Rathbone / January 2, 2023
How to Use 'rails generate migration' to Create a Table in Rails Tutorial

How to Use 'rails generate migration' to Create a Table in Rails

Learn how to efficiently use the Rails command line tool to generate migrations for table creation without writing custom code.
Matthew Rathbone / January 1, 2023
Creating Unique Constraints in PostgreSQL: A Guide Tutorial

Creating Unique Constraints in PostgreSQL: A Guide

A unique constraint in PostgreSQL ensures that no two rows in a table have the same values in a specified column or set of columns. Here's how to create one
Matthew Rathbone / January 1, 2023
Comparing SQLite and MySQL Tutorial

Comparing SQLite and MySQL

SQLite and MySQL are two popular databases that are often used in web applications. Although both are relational databases, they have some significant differences in terms of performance, features, and capabilities. In this article, we'll compare the two databases and discuss their key differences.
Matthew Rathbone / December 31, 2022
Rails Migration: add index syntax Tutorial

Rails Migration: add index syntax

Speed up your database queries with indexes. Here's how to create them in a rails migration.
Matthew Rathbone / December 31, 2022
PostgreSQL Comparing Two Values Tutorial

PostgreSQL Comparing Two Values

How to compare two values in PostgreSQL
Matthew Rathbone / December 31, 2022
How long does it take to learn SQL? Tutorial

How long does it take to learn SQL?

It typically takes a few weeks to a couple of months to learn SQL, depending on the individual's prior experience and dedication to learning the language.
Matthew Rathbone / December 31, 2022
Rails Migration: Rename Column Tutorial

Rails Migration: Rename Column

Matthew Rathbone / December 30, 2022
Rails Migration: Remove Column Tutorial

Rails Migration: Remove Column

Oh man you left that column in by mistake? Here's how to remove it.
Matthew Rathbone / December 28, 2022
Boolean Columns in SQLite: A Beginner's Guide Tutorial

Boolean Columns in SQLite: A Beginner's Guide

Boolean columns in SQLite are useful for storing data with a binary nature, but in SQLite they're a little different...
Matthew Rathbone / December 28, 2022
Beginners Guide To Columnar Databases Tutorial

Beginners Guide To Columnar Databases

A columnar database is a type of database management system (DBMS) that stores data in columns rather than rows.
Matthew Rathbone / December 28, 2022
How to Use "rails g migration add column" in Rails Tutorial

How to Use "rails g migration add column" in Rails

Learn how to efficiently add a column to your database table using the Rails command line tool with the "rails g migration" command.
Matthew Rathbone / December 27, 2022
Top 5 Open Source Databases Tutorial

Top 5 Open Source Databases

If you need a database, you can't go wrong with one of these top-knotch open source databases used by millions of developers all over the world.
Matthew Rathbone / December 25, 2022
Rails Migrations - Drop Table Tutorial

Rails Migrations - Drop Table

How to drop a table in a rails migration.
Matthew Rathbone / December 24, 2022
Listing Databases in PostgreSQL: The Equivalent of MySQL's SHOW DATABASES Command Tutorial

Listing Databases in PostgreSQL: The Equivalent of MySQL's SHOW DATABASES Command

To list all databases on a PostgreSQL server, use the commands shown below, they accomplish the same as the SHOW DATABASES command from MySQL
Matthew Rathbone / December 24, 2022
Rails How To Rollback A Migration Tutorial

Rails How To Rollback A Migration

If something goes wrong, you'll want to roll back your migrations to a safe spot. Here's how.
Matthew Rathbone / December 23, 2022
How To Generate A Rails Migration Tutorial

How To Generate A Rails Migration

using the rails command line tools to generate a migration
Matthew Rathbone / December 22, 2022
Having vs Where in SQL Tutorial

Having vs Where in SQL

Both WHERE and HAVING are used to filter query results, but HAVING can only be used on aggregate function results.
Matthew Rathbone / December 21, 2022
Databricks Competitors Tutorial

Databricks Competitors

Databricks faces competition from other companies in the big data analytics and cloud computing space.
Matthew Rathbone / December 20, 2022
Understanding the Differences between Databases and Data Warehouses Tutorial

Understanding the Differences between Databases and Data Warehouses

While both databases and data warehouses are used to store data, there are key differences in the way they are designed and used. Databases are designed for transactional needs, while data warehouses are designed for analysis and reporting.
Matthew Rathbone / December 18, 2022
Comparing Amazon RDS and Redshift: Key Differences and Use Cases Tutorial

Comparing Amazon RDS and Redshift: Key Differences and Use Cases

Amazon RDS and Redshift are both cloud-based data storage services offered by AWS, but are intended for different use cases. RDS is a fully-managed relational database service, while Redshift is a partially-managed data warehousing service optimized for fast querying of large datasets. Key differences include pricing and management requirements.
Matthew Rathbone / December 18, 2022
Amazon Athena vs Redshift: Comparing Cloud-Based Data Storage and Analysis Services Tutorial

Amazon Athena vs Redshift: Comparing Cloud-Based Data Storage and Analysis Services

Amazon Athena and Amazon Redshift are two cloud-based data storage and analysis services offered by AWS. While they share some similarities, they are designed for different use cases and have a number of key differences. Athena is a querying service for structured and unstructured data, while Redshift is a data warehousing service for large volumes of structured data.
Matthew Rathbone / December 16, 2022
PostgreSQL CREATE TABLE Walkthrough With Examples Tutorial

PostgreSQL CREATE TABLE Walkthrough With Examples

How to create tables in Postgres taking into account schemas, permissions, primary keys, existing data, and more.
Shanika Wickramasinghe / December 14, 2022
10+ Best Oracle Database Tools Tutorial

10+ Best Oracle Database Tools

Level up your Oracle Database work with these amazing tools.
Lisandro Fernigrini / December 14, 2022
Understanding Database Relationships: A Beginner's Guide Tutorial

Understanding Database Relationships: A Beginner's Guide

A database relationship is a connection between two or more pieces of data in a database. By understanding the different types of relationships that can exist between data, you can effectively manage and work with a database. This is important for ensuring that your data is organized, consistent, and accurate.
Matthew Rathbone / December 14, 2022
How to make a pivot table in SQL Tutorial

How to make a pivot table in SQL

A pivot table is a two dimensional table to summarize data, here's how to make a simple pivot table using only SQL.
Matthew Rathbone / December 12, 2022
MariaDB vs MySQL Tutorial

MariaDB vs MySQL

MariaDB and MySQL are both excellent databases. Which one you use will depend on what you need most - new features or corporate support.
Matthew Rathbone / December 12, 2022
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 / 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 / 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 / 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
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