greydelamar / tdb

cross-platform SQL editor and database tool

---

Project Details

Project Idea

The idea behind TDB is to create a easy to use developer focused SQL Editor/Managment tool. While also keeping it similar to a vscode feel. With all these new tools available for us to use. We are hoping to bring them together into a solid easy to use and extendible database client.

Development

Project setup

npm install

Compiles and hot-reloads for development

npm run electron:serve

Compiles and minifies for production

npm run electron:build

tdb's Issues

Resize Issues

List of bugs with resizing the window

• Monaco Editor preview sidebar does not resize properly

Prevent UPDATES, DELETE without WHERE conditions

Show an alert before users run UPDATES or DELETES without a WHERE conditions.

Issue connecting to db

Think I was using the node-mssql package wrong. Change this to follow their docs.
https://github.com/tediousjs/node-mssql#connection-pools

Connection Tree Laggy

This should help this issue:
https://vuetifyjs.com/en/components/virtual-scrollers/#virtual-scroller

Add disconnect disconnect

Make it possible to disconnect from a server

Show error message on invalid login

Should show an error message/alert if connection to database cannot be established

What should be the project name?

Possible Options:

• new-db-client
• Iris Client
• Iron DB Client
• DataAble
• Your name could be here!

Disallow adding more than one of the same connection

Need to disable the login button until a response for the connection is received in order to not send multiple request to connect to same database.

Result table for Queries

Scope

• Show results from running queries in a table below the editor
• Allow multiple tables to be created when recordsets are > 1
• Result tables should be per tab
• Store results in vuex by editor guiID

Monaco IntelliSense

We should add in autocomplete for sql

Storing connection details locally

Feel free to edit, this is just an initial scope of the issue

After users provide valid connection details to a server we should store that locally in a JSON file.

When the app is reloaded it can read that file and list the possible connections a user can make.

Scope

• Process for writing and reading JSON files from a directory in the app
• Users should have a checkbox such as "Save Connection Details" that defaults to true
• A component that lists all possible connections from the JSON file. This could live as a list to the left side of the login screen or be its own page entirely

Security Risks

• Stored files will need to be encrypted eventually

Example of Connection Pages from other apps

MySQL Workbench:

Text editor does not adjust to fit full screen

When going full screen, I expect the text editor to auto-resize

MySQL Support

MySQL support would be great for my local Ubuntu environment. Is this a connection type you want to add soon or wait till more features are complete?

I'm thinking this library would work well https://github.com/mysqljs/mysql

Add ability to run query

Need to be able to run a query

Database source control

https://www.richard-banks.org/2014/02/tfs-internals-how-does-tfs-store-git.html

Display info on update

Update doesn't return any info when it runs successfully

Display Results

We need a way to view out data that we get back.

The goal would be to mimic ssms's results panel -> but clearly better looking

I think we should make it sortable also that would be incredible

Theses panels should be able to drag up and down to resize

Result Table Possible Features

• Show JSON syntax highlighting
• Click to view results
  Columns like JSON should open a popup to see the results better

More things to come...