You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Markus Bergholz 68e6efb114 update todo 3 years ago
db formatting and geany.status formatting 3 years ago
docs add screenshots and readme draft 3 years ago
README.md update todo 3 years ago
hotkeys.cfg init 3 years ago

README.md

geany-database

Running SQL statements instantly in geany

supported databases

  • sqlite3
  • mysql
  • postgres

output formats

  • csv
  • tab separated (for geany-tableconvert plugin)
  • html
  • luatable
  • JSON

Howto

  1. Clone this repository in your ~/.config/geany/plugins/geanylua/
  2. cp hotkeys.cfg one folder level up to ~/.config/geany/plugins/geanylua/
  3. Install dependencies for Lua 5.1 (luasql for sqlite3, mysql and postgres)
  4. Configure shortcuts for register, profile_switcher and run.
  5. Setup a Profile with register
  6. Write your sql statements in geany editor
  7. use run to execute your statements with geany
  8. profit

register

Sign up a new Database connection.

register

profile_switcher

Set another default database connection and/or change the outputformat.

profile_switcher

run

run will open the return of your statement in a new file /tmp/db_out.md.

  • The current active editor tab will be used as the statement.
  • Tab separated outputformat can be easily converted in any other table format with the geany-tableconvert plugin
  • HTML outputformat can be easily previewed with the markdown plugin
  • run will print some information in the geany status window

run

todo

Until now it’s very quick hack using Geanylua Plugin. So the dialogs and the outputformat are very limited at the moment.

  • gtk sheet/table widget plugin
    • dunno atm. I guess this will need some C implementations too
    • insert/updates after changes in the gtk sheet/table
  • more databases
    • redis
  • dialog
    • test connection
    • status dialog / db infos
    • edit profile