Shulou(Shulou.com)06/03 Report--

SQL development tools in the use of Beekeeper Studio, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Introduction to Beekeeper Studio

Beekeeper Studio is a free and open source SQL development and database management tool, with the characteristics of beautiful, efficient, easy to use. Beekeeper Studio is based on Vue.js development, follows the MIT open source protocol, and supports Windows, Linux and macOS platforms.

Download:

Https://www.yisu.com/database/791630.html

The databases supported by Beekeeper Studio include: MySQL/MariaDB, PostgreSQL, SQLite, SQL Server, CockroachDB, Amazon Redshift. The main functional features include:

Secure connection. In addition to normal connections, you can also use SSL encrypted connections or connect through SSH tunnels

SQL automatic completion. The code editor supports syntax highlighting and automatic completion of table names.

Multiple work windows are supported. You can open multiple code editing windows and write multiple queries at the same time.

Save the query statement. Organize and save commonly used query statements to facilitate repeated runs

View and edit the data in the table. Support sorting and filtering of data

View and modify the structure of the table. Create, edit, and delete fields, indexes, and foreign keys of a table through an intuitive interface

Export the data in the table. Supports CSV, JSON, JSONL, and SQL formats, allowing the export of specified data.

Beekeeper Studio installation

Beekeeper Studio supports Windows, Linux and macOS platforms, which can be downloaded and installed directly from the official website or through GitHub.

Beekeeper Studio supports automatic version updates.

Beekeeper Studio uses tutorials to connect to the database

After opening Beekeeper Studio, the following interface is displayed:

Select the type of database in the "Connect Type" drop-down list and open the connection options interface:

Among them, Host represents the address of the database server; Port represents the service port; User is the user name; Password is the password; Default Database is the default connected database; Enable SSL check box indicates that a secure SSL connection is used; if SSH Tunel is opened, you can set the SSH tunnel; the Test button can test the current connection settings; click the Connect button to establish a connection.

In addition, the Save Connection section can set a connection name, save the connection password, set the connection color, and click the Save button to save the settings. After a successful connection, the following interface is displayed:

The tables and views in the current database are listed on the left, which can be filtered by name; on the right is the query area and the result display.

Beekeeper Studio supports both Dark and Light themes. Click "View"-> "Theme" to select. The following is the effect of a bright theme:

File association

Beekeeper Studio provides a file association feature that allows you to do the following without opening the application:

Double-click a sqlite .db file to open it in Beekeeper Studio.

Open URL and files from the terminal command line:

Mac:open postgresql://user@host/database or open. / example.db

Linux:xdg-open postgresql://user@host/database or xdg-open. / example.db

SQL Editor

The SQL query area can be used to write and run SQL statements. Beekeeper Studio provides the field completion function of table name and field name. After the completion of writing, click the Run button to run the query:

The query results are displayed at the bottom of the interface, and the "Download" button in the lower right corner can be used to export query results, supporting CSV, Excel, JSON and other formats.

In addition, click the Save button to save the current query statement:

Saved queries can be viewed and repeated via the ⭐ button on the left.

Beekeeper Studio supports parameterized queries, such as:

Table browser

Right-click the table name in the list on the left to view and edit the data in the table, view and edit the table structure, export the data in the table, and generate table-building statements.

Shortcut key

Beekeeper Studio supports the following general shortcuts:

New window: Ctrl + Shift + N

Create a new tab: Ctrl + T

Close tabs; Ctrl + W

Formatted query statement: Ctrl + Shift + F

Execute query statement: Ctrl + ↩

Quick find: Ctrl + P

In addition, Beekeeper Studio supports the following editing function shortcuts:

Undo: Ctrl + Z

Redo: Shift + Ctrl + Z

Cut: Ctrl + X

Copy: Ctrl + C

Paste: Ctrl + V

Select all: Ctrl + A

SQLTools tool

SQLTools is a Beekeeper Studio-based website that provides online SQL formatting, table structure design, table structure templates and other tools.

The following is the users sample table structure provided by the tool.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.