squite 0.2.0

A UI for SQLite databases, written in Rust
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

<h1 align="center">SqUIte</h1>
<h2 align="center">A UI for SQLite databases, written in Rust🦀</h2>
<div align="center">
    <img src="./assets/squite.png" alt="SqUIte Logo">
</div>

**SqUIte** (pronounced like SQLite but without the 'L') is a small desktop application built to be a quick and dirty UI to visualize SQLite data.

It is built on top of [`rusqlite`](https://github.com/rusqlite/rusqlite) and [`egui`](https://github.com/emilk/egui).

## Installation And Usage

Install with Cargo:

```bash
cargo install squite
```

> In the near future, there will be a website where you will be able to download pre-compiled application binaries!

You can then run with:

```bash
squite
```

The command will open a window like this:

![Initial Window](./assets/screenshot_1.png)

You can then run SQL `SELECT` statements on file-based SQLite databases, and obtain a table of results:

![Window with Results](./assets/screenshot_2.png)

Or you can run statements that modify data (such ass `INSERT`, `UPDATE` or `DELETE`), and get the number of affected rows:

![Window with Affected Rows](./assets/screenshot_3.png)

Note that statements that modify data require you to check the *"This query modifies data"* checkbox, to acknowledge that you are performing a potentially destructive or irreversible operation. If the checkbox is left unchecked, the operation will be rejected.

![Window with Rejected Query](./assets/screenshot_4.png)

## Contributing

Take a look at the [contributing guidelines](./CONTRIBUTING.md) to get started with your first contribution!

## License

This project is provided under [MIT license](./LICENSE).