dbb086835e
- In this PR: ClickHouse and SQLite pages improved What docs pages need: - Nav titles (mkdocs.yml) - Head Title - title in frontmatter - H1 Title - # in markdown - Description - description in frontmatter
2.1 KiB
title, summary, description, old_url, icon
| title | summary | description | old_url | icon |
|---|---|---|---|---|
| How To Connect To SQLite | Connect to a SQLite database by double clicking, from the command line, or from the app. You can also optionally load runtime extensions | Connect to SQLite by double clicking, from the command line, or from the app. Works on Mac, Linux and Windows. | https://docs.beekeeperstudio.io/docs/sqlite | simple/sqlite |
How To Connect To SQLite
Connecting to a SQLite database from the app is pretty easy, simply select SQLite from the dropdown, choose your SQLite file, then click connect.
Connect to SQLite by double clicking
When you install Beekeeper Studio it will create an association for files with the following extensions: .db, .sqlite3, and .sqlite.
So long as Beekeeper Studio remains the default app for these file types, you can now just double click any SQLite file to open it in Beekeeper Studio.
Opening SQLite files from the command line
You can also use your terminal to open a database in Beekeeper Studio so long as you have the file associations set-up.
- MacOS
open ./path/to/example.db - Linux
xdg-open ./path/to/example.db
Enabling SQLite Runtime Extensions
SQLite supports runtime extensions. This provides extended capabilities for interacting with SQLite.
There are many such extensions, a lot of them are open source. For example sqlean is an extension that provides a range of new functions and features from crypto functions, to array handling.
Beekeeper Studio provides the ability to load a SQLite extension whenever you connect to a SQLite database.
This is a global setting, so it applies to any and all SQLite connections on the machine.
To add a runtime extension, expand the Runtime Extension settings block and choose the file.
SQLite Extension Requirements
- The runtime extension must be compiled for the operating system you are currently using
- The runtime extension must have the correct file extension
- Windows:
.dll - MacOS:
.dylib - Linux:
.so
- Windows: