squite 0.2.0

A UI for SQLite databases, written in Rust
squite-0.2.0 is not a library.

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 and egui.

Installation And Usage

Install with Cargo:

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:

squite

The command will open a window like this:

Initial Window

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

Window with Results

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

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

Contributing

Take a look at the contributing guidelines to get started with your first contribution!

License

This project is provided under MIT license.