SQLiteExplorer
SQLiteExplorer is a command-line application designed for the manipulation of SQLite databases. With SQLiteExplorer, you can easily visualize table schemas, execute SQL queries, manage data within tables, and list tables and columns. It provides a convenient and efficient way to interact with SQLite databases directly from the command line.
Features
Visualization of table schemas.
Execution of SQL queries.
Data management in tables.
Listing of tables and columns.
Export to csv files. (Since version 0.1.2)
Create generic SQL export file (Since version 0.1.4)
Quick Start
Install
pip install sqlite-explorerUsage
sqlexp --helpUsage: sqlexp [OPTIONS] COMMAND [ARGS]... Options: --help Show this message and exit. Commands: data Retrieve and print data for a specific table. exec Execute a SQL statement in the database. ls-col List columns for a specific table. ls-tab List all tables in the database. schemas Print schema for all tables in the database. sqlite-csv Export table to CSV file table Print schema for a specific table.
License
This project is licensed under the GNU-GPL License. See the LICENSE file for more details.
1 maintainer
Metadata
1 maintainer
Release files for sqlite-explorer 0.1.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlite-explorer-0.1.4.tar.gz | 44.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlite_explorer-0.1.4-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 77.4 kB
Release files / sqlite-explorer-0.1.4.tar.gz
| Download URL | sqlite-explorer-0.1.4.tar.gz |
|---|---|
| Size | 44.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
c25ae3bc6b5ca7f62d77ca1bcd662cba5bc6e1a50d24abede26b49d9693900e7
|
|
BLAKE2b-256 checksum How to use checksums |
ba6e919e3521a8fd49d0f934a8d07af8112bedfe833e226c697af27959ea4487
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.12
|
Release files / sqlite_explorer-0.1.4-py3-none-any.whl
| Download URL | sqlite_explorer-0.1.4-py3-none-any.whl |
|---|---|
| Size | 33.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
d7c5b7041cec9b7748cc667f84c188c1391b0c8424ea3175c532fdef9d760cc5
|
|
BLAKE2b-256 checksum How to use checksums |
fd14eb1c0f2eeb6fe2639f43a2aab24292085674cb7b7dfd17c86a9425a6df05
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.12
|
