README
¶
duitsql - simple sql database browser and query executor
about
Duitsql lets you connect to SQL database (only postgres currently), and list databases, tables & views, and data in them. It also lets you execute queries and view the results. Duitsql was created to showcase duit, the developer ui toolkit, and vice versa.
install
make dep build
license
MIT-license, see LICENSE.md
todo
-
improve showing structure for tables, try to keep it cross-database through information_schema. should show check constraints, foreign key constraint, indexes.
-
fetch rows from resultset on demand. requires updating duit.Gridlist. and/or do paging.
-
add buttons to refresh list of database, list of tables/views, data for table/view
-
fix todo's
-
find cause of not being able to cancel queries that cause a new db connection to be created
-
colors in UI to indicate which connection you have open
Documentation
¶
Overview ¶
SQL database browser and query executor, created with duit.
Duitsql can connect to PostgreSQL, MySQL and SQLServer servers through their pure Go database drivers. Only these provide basic SQL introspection through an information_schema.
Using ¶
Select and manage connections to database servers on the left (type/user/password/host/port). Select a database, then a table/view or write your own SQL query. You will see the rows in the selected table/view or the query results. You can also choose to view the structure of the database objects (columns and types, etc).
Connections are stored in $appdata/duitsql/connections.json, including passwords. SQL scripts are stored in $appdata/duitsql/$connectionname.$databasename.sql.
Source Files