ctrl+shift+p filters: :st2 :st3 :win :osx :linux
Browse

DB1

by Sequoia Studios ST2/ST3 Missing

Commercial Database Client. Connect, Configure and Query Databases Directly From Sublime

Details

Installs

  • Total 656
  • Win 287
  • OS X 233
  • Linux 136
Jan 20 Jan 19 Jan 18 Jan 17 Jan 16 Jan 15 Jan 14 Jan 13 Jan 12 Jan 11 Jan 10 Jan 9 Jan 8 Jan 7 Jan 6 Jan 5 Jan 4 Jan 3 Jan 2 Jan 1 Dec 31 Dec 30 Dec 29 Dec 28 Dec 27 Dec 26 Dec 25 Dec 24 Dec 23 Dec 22 Dec 21 Dec 20 Dec 19 Dec 18 Dec 17 Dec 16 Dec 15 Dec 14 Dec 13 Dec 12 Dec 11 Dec 10 Dec 9 Dec 8 Dec 7
Windows 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
OS X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Linux 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Readme

Source
raw.​githubusercontent.​com

DB1: A Sublime Text Database Client

DB1 allows you to execute queries against multiple database types (currently PostgreSQL, MySQL, SQLite, and MariaDB) from inside Sublime without installing any dependencies (a local database installation is not required).

If you'd like to read the full documentation for DB1, you can see it here

As an introduction to DB1 (after installing), we'd highly suggest the Quick Start guide.

INDEX

Installation

If Package Control is already installed:

  1. Open the Sublime Text command palette ("Tools" > "Command Palette")
  2. Enter Package Control: Install Package
  3. Enter DB1

Congratulations! DB1 will now be installed. If you are not greeted with the DB1 installation message from Package Control, please restart Sublime Text.

If Package Control is not already installed, please follow the instructions for installation, and then follow the above instructions.

Quick Start

The first step to getting started is making sure that DB1 is installed.

Once that's finished, the first big command is DB1: Connect to a Database. DB1: Connect to a Database initiates a connection for a single view in Sublime Text. This means that there's a one-to-one relationship of connections to views. Each connection is then tied to the database it's connected to, such that in view #1 you can execute queries on database 'A', and in View #2 you can execute queries on database 'B'.

When using the DB1: Connect to a Database you'll need to know the username, host, port (if it's not the default) and password of the database you're connecting to. In cases like PostgreSQL authentication (where authentication is trust based) a password is not required.

To help streamline workflow, if there is not a connection active in the view, then running one of the DB1: Execute ... SQL will initiate the connection process before the query is then run.

Once you're connected, DB1 will prompt you with a list of databases to choose from. The database you select is the one you can now execute queries against. You can then change databases using the DB1: Change Database command.

Now that we're ready to run some queries, DB1 supports a couple different workflows.

  1. The Results Window Workflow

The Results Window workflow allows for you to have a continuously open window to display query results. This contrasts the disposability of the Quick Query window, where results are lost when the window is closed.

Results Window

As you can see above, we are free to execute queries in the left view, while the results are displayed in the Results Window on the right.

A quick note: By default, when executing queries to the Results Window, after the query execution, the focus is changed to the Results Window. This can be annoying to some as you then have to reselect the query view on the left to write new queries. However, you can change functionality of it using the "focus_results_window_on_execution" setting to leave the focus on the execution view.

In addition to the above setting, by default the contents of Results Window is deleted with every query, but that setting can be changed to either "results_window_append_style": "prepend" or "results_window_append_style": "append" the prepend or append the results.

This workflow tends to work really well if you'd like to be able to interact with results, as you can do things like search for text in the Results Window.

  1. The Quick Query view. The Quick Query view outputs the results of a query to a disposable (you can't save it, and when it's gone, you can't recover the contents) output view at the bottom of a sublime window.

Quick Query view

Much like the Results Window, many aspects of the Quick Query view are fully customizable.

For more information about the DB1 Settings and commands please see the full documentation

Reporting Issues and Feature Requests

Please report all issues and feedback to the DB1 Issue and Request Tracker. All issues will be posted and followed there. In the event that Github is unavailable or extremely inconvenient, please email support@sequoiastudios.io

In addition to issues and feature requests, the documentation file used here is also hosted in that repository so as to track changes.

Changelog

V1.0.1

Improvements:
  • None.
Bug Fixes:
  • Removed Ubuntu dependency on Libpython that caused DB1 to not load on x64_86 Linux.

V1.0.2

Improvements:
  • You can now specify ports using user@host:port syntax.
  • Postgresql 8.1 and early have increased performance.
  • You can now customize all aspects of a connection in the “stored_connections” setting.
Bug Fixes:
  • Fixed a bug causing issues with older versions of postgresql.
  • Fixed a bug that caused DB1 to sometimes ignore ports that were manually changed.

V1.1.0

Feature Additions:
  • You can now connect to MariaDB and local SQLite databases through DB1.
Improvements:
  • Improved settings management and error correcting.
Bug Fixes:
  • Fixed 'null' port storage for some databases using the default port.
  • Fixed result window being reopened if the results window was in a separate window pane.
  • Fixed some connection timeout issues.