mirror of
https://github.com/beekeeper-studio/beekeeper-studio.git
synced 2026-03-13 10:12:54 +08:00
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
59 lines
2.1 KiB
Markdown
59 lines
2.1 KiB
Markdown
---
|
|
title: How To Connect To SQLite
|
|
summary: "Connect to a SQLite database by double clicking, from the command line, or from the app. You can also optionally load runtime extensions"
|
|
description: Connect to SQLite by double clicking, from the command line, or from the app. Works on Mac, Linux and Windows.
|
|
old_url: "https://docs.beekeeperstudio.io/docs/sqlite"
|
|
icon: 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](https://www.sqlite.org/loadext.html). This provides extended capabilities for interacting with SQLite.
|
|
|
|
There are many such extensions, a lot of them are open source. For example [sqlean](https://github.com/nalgeon/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
|
|
|
|
1. The runtime extension must be compiled for the operating system you are currently using
|
|
2. The runtime extension must have the correct file extension
|
|
- Windows: `.dll`
|
|
- MacOS: `.dylib`
|
|
- Linux: `.so`
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|