
SQLite Tools
Dolphin Service Menus database dolphin dolphin-service-menu sqlite3
Source (link to git-repo or to original if based on someone elses unmodified work):
Description:
This service menu aims to facilitate SQLite file management for those basic operations
or data presentation making them available in a few clicks.
In the last version
===================
- Added support for Plasma 6 in the installer script.
Features
========
- Fully translated into 4 languages besides English
(French, German, Italian, Spanish);
- Works from within the Dolphin, Konqueror, Krusader, and KFind-results context menu;
- Support for KDE Plasma 6;
- Register and unregister an SQLite file as ODBC data source to use it with software like LibreOffice;
- Show the ODBC file configuration paths;
- List the tables within the database in a Kdialog dialog;
- List the views within the database in a Kdialog dialog;
- Show the selected table schema within a Kdialog dialog;
- Export the table content in one of the supported formats -
CSV, JSON, HTML, Markdown, SQL INSERT, TCL,
inline, list, box, column, ASCII table, tabs;
- Export the table content for selected columns in one of the
supported formats -
CSV, JSON, HTML, Markdown, SQL INSERT, TCL,
inline, list, box, column, ASCII table, tabs;
- Database dump with or without the table schema in the SQL INSERT format.
Requirements
============
- KDE 4 or superior;
- KDialog;
- sqlite3
- unixODBC (only for ODBC-related actions)
- sql-formatter (optional and only for DB table schema action)
Install
=======
The recommended method to install this service menu is through *Dolphin*:
- From Settings > Context Menu > Download new services;
- Search for "sqlite_tools";
- Click on the *Install* button and select the localized archive of your choice.
That way the latest stable version is installed, updated, and easily removed from the same interface.
Also, the *Discover* application can install it, but doesn't allow to select a localized version:
- Under Application Addons > Servicemenu;
- Search for: "sqlite_tools";
- Click on the *Install* button.
For debugging purposes follow one of the other methods mentioned on the project page:
https://freeaptitude.altervista.org/downloads/sqlite-tools.html#installation
Get Help
========
- More info is available at: https://freeaptitude.altervista.org/downloads/sqlite-tools.html
- Changelog: https://freeaptitude.altervista.org/downloads/sqlite-tools.html#changelog
Contributing
============
If you like this addon and want to encourage me to improve the project or keep it
regularly updated, you can:
- Become a fan and add a positive rating here on this page;
- Star it on the GitHub page: https://github.com/fabiomux/kde-servicemenus;
- Report bugs or malfunctions or even ask for new features, just opening an issue
on the GitHub issues page: https://github.com/fabiomux/kde-servicemenus/issues;
- Localize it in your language using the file as a template:
https://github.com/fabiomux/kde-servicemenus/blob/main/sqlite_tools/locale/en.yaml
or data presentation making them available in a few clicks.
In the last version
===================
- Added support for Plasma 6 in the installer script.
Features
========
- Fully translated into 4 languages besides English
(French, German, Italian, Spanish);
- Works from within the Dolphin, Konqueror, Krusader, and KFind-results context menu;
- Support for KDE Plasma 6;
- Register and unregister an SQLite file as ODBC data source to use it with software like LibreOffice;
- Show the ODBC file configuration paths;
- List the tables within the database in a Kdialog dialog;
- List the views within the database in a Kdialog dialog;
- Show the selected table schema within a Kdialog dialog;
- Export the table content in one of the supported formats -
CSV, JSON, HTML, Markdown, SQL INSERT, TCL,
inline, list, box, column, ASCII table, tabs;
- Export the table content for selected columns in one of the
supported formats -
CSV, JSON, HTML, Markdown, SQL INSERT, TCL,
inline, list, box, column, ASCII table, tabs;
- Database dump with or without the table schema in the SQL INSERT format.
Requirements
============
- KDE 4 or superior;
- KDialog;
- sqlite3
- unixODBC (only for ODBC-related actions)
- sql-formatter (optional and only for DB table schema action)
Install
=======
The recommended method to install this service menu is through *Dolphin*:
- From Settings > Context Menu > Download new services;
- Search for "sqlite_tools";
- Click on the *Install* button and select the localized archive of your choice.
That way the latest stable version is installed, updated, and easily removed from the same interface.
Also, the *Discover* application can install it, but doesn't allow to select a localized version:
- Under Application Addons > Servicemenu;
- Search for: "sqlite_tools";
- Click on the *Install* button.
For debugging purposes follow one of the other methods mentioned on the project page:
https://freeaptitude.altervista.org/downloads/sqlite-tools.html#installation
Get Help
========
- More info is available at: https://freeaptitude.altervista.org/downloads/sqlite-tools.html
- Changelog: https://freeaptitude.altervista.org/downloads/sqlite-tools.html#changelog
Contributing
============
If you like this addon and want to encourage me to improve the project or keep it
regularly updated, you can:
- Become a fan and add a positive rating here on this page;
- Star it on the GitHub page: https://github.com/fabiomux/kde-servicemenus;
- Report bugs or malfunctions or even ask for new features, just opening an issue
on the GitHub issues page: https://github.com/fabiomux/kde-servicemenus/issues;
- Localize it in your language using the file as a template:
https://github.com/fabiomux/kde-servicemenus/blob/main/sqlite_tools/locale/en.yaml
Ratings & Comments
0 Comments