datatug

README

DataTug agent

Open source codes in Go language under MIT license.

What it is and why?

This is an agent service for https://datatug.app that you can run on your local machine, or some server to allow DataTug app to scan databases & execute SQL requests.

It can be run with your user account credentials (e.g. trusted connection) or under some service account.

Would you steal my data?

No, we won't.

The project is free and open source codes available at https://github.com/datatug/datatug. You are welcome to check - we do not look into your data.

You can easily get executable of the agent from source codes using next command:

go install github.com/datatug/datatug

Note: Go language should be pre-installed

Where metadata are stored?

When DataTug agent scans or compare your database it stores meta information in a datatug project as set of simple to understand & easy to compare JSON files.

We recommend to check-in the project to some source versioning control system like GIT.

You can run commands for different projects by passing path to DataTugProject folder. E.g.:

> datatug show --project ~/my-datatug-projects/DemoProject

Paths to the DataTug project files, and their names are stored in ~/datatug.yaml in the root of your user's home directory. This allows you to address a DataTug project in a console using a short alias. Like this:

> datatug show --project DemoProject

If current directory is a DataTug project folder you don't need to specify project name or path.

> datatug show

How to get DataTug agent CLI?

Get from source codes by running:

> go install github.com/datatug/datatug

If it passes you are good to go:

> datatug --help

How to run?

Check the CLI section on how to run DataTug agent.

Supported databases

• Microsoft SQL Server - via https://github.com/denisenkom/go-mssqldb

At the moment we have connectors only to MS SQL Server.

We are open for pull requests to support other DBs.

Project structure

• ./datatug.go - entry point
• packages - source codes
• docs - documentation
• .github/workflows - continuous integration

Download

http://datatug.app/download

Dependencies & Credits

• https://github.com/denisenkom/go-mssqldb - Go language driver to connect to MS SQL Server
• https://gihub.com/strongo/validation - helpers for requests & models validations

Sample Databases

By Database Platform

• SQLite
  • Chinook Database
  • Northwind
• MS SQL Server
  • Northwind
• Oracle
  • Northwind

Northwind Database

• SQLite
• MS SQL Server
• Oracle

Plans for improvements

• https://github.com/rivo/tview - show tables & query text
• Dashboard: consider either https://github.com/gizak/termui or https://github.com/mum4k/termdash

CI/CD

There is a continuous integration build.

Contribution

Contributors wanted. For a start check issues tagged with help wanted and good first issue.

TODO integrations

• Dasel - Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.
• DbMate - A lightweight, framework-agnostic database migration tool.

Licensing

Free & open source under MIT license.