DEV Community

Discussion on: Who's looking for open source contributors? (April 30 edition)

Collapse
 
andreujuanc profile image
Juan C. Andreu

I had the need to run Sql Queries to multiple databases. Can be any type, insert, select, alter.

So I build a simple query executor, that allows to set each database target. Or to dynamically get all the database in a database server (with some filters).

Features:

  • Allows you to deploy multiple files.
  • Save the "document/project".
  • Each connection/query runs in parallel. (makes it really fast for multiple migrations)
  • Set Command Timeout
  • Validates Sql queries before executions
  • Syntax highlight in editor
  • Shows On-the-fly messages on each target (ie, results from print)

As of now it works only for SqlServer, but i tried (with little time) to make it agnostic as possible.

Uses WPF (since i needed SqlConnection). Tried to start a electron version but had not time to even mock the UI.

Has some unit tests, but would love to improve more on that.

Also, i want to make it cross-platform since Sql Server now runs in Linux D:

github.com/andreujuanc/TakoDeploy