Commercial Database Client. Connect, Configure and Query Databases Directly From Sublime
- Total 657
- Win 287
- OS X 233
- Linux 137
|Apr 19||Apr 18||Apr 17||Apr 16||Apr 15||Apr 14||Apr 13||Apr 12||Apr 11||Apr 10||Apr 9||Apr 8||Apr 7||Apr 6||Apr 5||Apr 4||Apr 3||Apr 2||Apr 1||Mar 31||Mar 30||Mar 29||Mar 28||Mar 27||Mar 26||Mar 25||Mar 24||Mar 23||Mar 22||Mar 21||Mar 20||Mar 19||Mar 18||Mar 17||Mar 16||Mar 15||Mar 14||Mar 13||Mar 12||Mar 11||Mar 10||Mar 9||Mar 8||Mar 7||Mar 6|
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
If Package Control is already installed:
- Open the Sublime Text command palette (
"Tools" > "Command Palette")
Package Control: Install Package
Congratulations! DB1 will now be installed. If you are not greeted with the DB1 installation message from Package Control, please restart Sublime Text.
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.
- 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.
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.
- 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.
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
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 firstname.lastname@example.org
In addition to issues and feature requests, the documentation file used here is also hosted in that repository so as to track changes.
- Removed Ubuntu dependency on Libpython that caused DB1 to not load on x64_86 Linux.
- 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.
- Fixed a bug causing issues with older versions of postgresql.
- Fixed a bug that caused DB1 to sometimes ignore ports that were manually changed.
- You can now connect to MariaDB and local SQLite databases through DB1.
- Improved settings management and error correcting.
- 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.