Is your feature request related to a problem? Please describe. A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like A clear and concise description of what you want to happen.

Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.

Is your feature request related to a problem? Please describe. It's quiet annoying If you have a lot of database to manage mostly If you can't organize & filter them(The color's is not enough too).

Describe the solution you'd like Being able to create folders(Create, Delete, Rename) and drag & drop databases on them, basicly just like a normal file explorer.

Describe alternatives you've considered Being able to use tags and filter tags.

Describe the bug loading database structure very slowly, there are about 500 tables in my database

Screenshots

Version Information (please complete the following information):

• OS: Mac
• App Version: 4.8.7
• Install source: installer
• Type - Application
• Database engine: MySQL5.7.29

Hi

I see someone else asked for something similar, anyway that issue has never been updated or closed. I'm trying a mysql connection via ssh tunnel, and it fails:

Creating SSH tunnel to ***, using local port 10000 (node:1253845) [DEP0005] DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead. (Use dbgate --trace-deprecation ... to show where the warning was created) Error at e.exports (/tmp/.mount_dbgatePuj8fl/resources/app.asar/packages/api/dist/bundle.js:9:85138) at processTicksAndRejections (internal/process/task_queues.js:93:5) at async process. (/tmp/.mount_dbgatePuj8fl/resources/app.asar/packages/api/dist/bundle.js:187:409014)

Any hint? I do hope to get this working, by far best looking and lighter sql gui I found on Linux!

I am sorry to reopen bug #215 but even after updating to the latest version I still have difficulties accessing a SQLite file.

• same config as in #215
• I changed the permissions of the mounted directory where the database file is located to root
• I can now see the database in DBGate's interface allright: it has a specific yellow icon
• BUT the structure is not displayed: a Loading database structure message is displayed and goes forever.

Questions:

• do I have to stop the database that is using the database file? In other terms, is there a lock on SQLite files?
• are the file permissions I am using correct?

Describe the bug When I change the editor theme or the font size, nothing happens. As far as I can remember, changing the editor theme worked as it should in the prior version.

To Reproduce Open Settings->Themes and change the editor theme or font size.

Expected behavior The theme and font size should change accordingly.

Screenshots N/A

Version Information (please complete the following information):

• OS: Ubuntu 20.04
• App Version: 4.7.2
• Install source: Snap
• Type: Desktop client
• Database engine: PostgreSQL

Is your feature request related to a problem? Please describe.

No problem, just a nice-to-have wish/idea for shared DBGate deployments as a web server.

Describe the solution you'd like

Instead of only offering user authentication using usernames and passwords, support OAuth providers like Github/Google/Microsoft etc. Permissions could still be set as environment variables using the user's ID

# default: credentials
LOGIN_PROVIDERS=credentials,github

# current logins implementation

LOGIN_CREDENTIALS_USERS=user1
LOGIN_CREDENTIALS_USER_PASSWORD_user1=123
LOGIN_CREDENTIALS_PERMISSIONS_user1=~/connections/*, connections/con1

# Github OAuth

LOGIN_GITHUB_CLIENT_ID=[client_id]
LOGIN_GITHUB_CLIENT_SECRET=[client_secret]

# restrict uids that are allowed to login
# another option would be to disable all permissions by default for OAuth users perhaps?
LOGIN_GITHUB_USERS=[uid],[uid2]
LOGIN_GITHUB_USER_PERMISSIONS_[uid]=connections/con1

# optional default permissions
# could be written in JSON to make it easier to parse
LOGIN_GITHUB_DEFAULT_PERMISSIONS=~widgets/*,~/connections/*

This would be great to not necessarily have passwords stored in environment variables.

Another great option would be configuration files written in JSON or YAML that are placed in a specific folder using the provider's name like:

// credentials.json
{
  "users": [
    {
      "name": "user1",
      "password": "123",
      "permissions": [
        "~/connections/*, connections/con1"
      ]
    }
  ],
}

# github.yaml
config:
  clientId: [client_id]
  clientSecret: [client_secret]
users:
  - uid: [uid]
    permissions:
      - connections/con1
defaultPermissions:
  - ~widgets/*
  - ~connections/*

Describe alternatives you've considered

Is your feature request related to a problem? Please describe. The app cannot launch on my M1 MacBook Air (without installing Rosetta which I'm trying to avoid).

Describe the solution you'd like It would be great if there was a build for arm64 in addition to x86_64.

Describe alternatives you've considered One alternativ is running thru Rosetta, but this has some performance and battery life disadvantages.

Additional context This should be easy to accomplish, we just need to make sure that we have the necessary versions of some packages:

Dependency | Version Requirement -- | -- Xcode | >=12.2.0 node-gyp | >=7.1.0 electron | >= 11.0.0-beta.1 electron-rebuild | >=1.12.0 electron-packager | >=15.1.0

ref: https://www.electronjs.org/blog/apple-silicon

Then it should be as simple as to add arm64 to the list of platforms that we build for 🚀

Details: I've been trying to serve DbGate on Docker as a db admin utility accesible in a subpath (say /db-admin) proxypassed with Nginx, but although it seems to start loading correctly it gets hanged forever at 'Starting DbGate ...' spinner. Web browser developer mode shows that it can't handle a request to '/config/get-setting' giving back a 405 response as it is not requested as '/db-admin/config/get-setting' as it should so Nginx can proxypass to DbGate service.

My Nginx configuration is as follows:

location ~ ^/db-admin(.*)?$ {
  resolver 127.0.0.11 valid=10s;
  set $upstream_dbadmin db-admin:3000;
  proxy_pass http://$upstream_dbadmin/$1;
}

Version Information [might be relevant to your issue] Operating System: WSL2 Debian 11 (bullseye) @ Win10 Pro Docker: 20.10.12 App Version [help -> about]: 4.6.3

Trying to connect to a windows sql server with self signed certificate:

Error JSON: {
  "code": "ELOGIN"
}

Connection: {
  "server": "***",
  "engine": "mssql@dbgate-plugin-mssql",
  "user": "***",
  "password": "***",
  "defaultDatabase": "***",
  "unsaved": false,
  "_id": "***",
  "connectionColor": "***",
  "useSshTunnel": false,
  "useSsl": true,
  "sshMode": "userPassword",
  "sshKeyfile": "***",
  "sslRejectUnauthorized": false
}

Platform: linux

SSL is enabled, unauthorized access is allowed:

From my understanding this should work, or?

Details: I see that with the last versions of DB Gate, its needed new environment variable with default database name: DATABASE_connName.

For example, if I use "master" as default, then in the list of databases I cannot see the other created databases in the server, but exists because I can run queries on the other databases.

Version Information [might be relevant to your issue]

Screenshot [if appropriate]:

Additional info Nothing

The error message like that

Uncaught NetworkError: Failed to execute 'importScripts' on 'WorkerGlobalScope': The script at 'file:///xxxxx/dbgate-windows/resources/app.asar/packages/web/public/worker-json.js' failed to load.

Describe the bug

I encountered a major issue happening when (re)connecting to a database: the loading stucks a long time on "Loading foreign keys..." step.

It usually resolves in a dozens of seconds, but sometimes it keeps struck forever. Closing and re-opening the app fix it.

I initially thought it was a minor bug, just a little annoying, before we had to investigate with my team an issue of very high CPU usage on our development Postgres cluster... and we finally found out it was caused by my dbgate client flooding it with the following request:

select 
	fk.constraint_name as "constraint_name",
	fk.constraint_schema as "constraint_schema",
	base.table_name as "pure_name",
	base.table_schema as "schema_name",
	fk.update_rule as "update_action",
	fk.delete_rule as "delete_action",
	ref.table_name as "ref_table_name",
	ref.table_schema as "ref_schema_name",
	basecol.column_name as "column_name",
	refcol.column_name as "ref_column_name"
from information_schema.referential_constraints fk
inner join information_schema.table_constraints base on fk.constraint_name = base.constraint_name and fk.constraint_schema = base.constraint_schema
inner join information_schema.table_constraints ref on fk.unique_constraint_name = ref.constraint_name and fk.unique_constraint_schema = ref.constraint_schema 
inner join information_schema.key_column_usage basecol on base.table_name = basecol.table_name and base.constraint_name = basecol.constraint_name
inner join information_schema.key_column_usage refcol on ref.table_name = refcol.table_name and ref.constraint_name = refcol.constraint_name and basecol.ordinal_position = refcol.ordinal_position
where 
		base.table_schema <> 'information_schema' 
		and base.table_schema <> 'pg_catalog' 
		and base.table_schema !~ '^pg_toast' 
		and ('tables:' || base.table_schema || '.' || base.table_name)  = '0'
order by basecol.ordinal_position

See attached screenshots of CPU usages, corresponding to times DBeaver was running (and stuck), before I noticed it.

To Reproduce

It looks like it happens only after a long time with a database connexion, although I'm not really sure; it looks pretty random to me.

No need to say I consider this as a pretty critical bug that can have severe consequences on a system!

Expected behavior

Do not stuck on a loading step, and if even, do not flood server with queries

Screenshots

Version Information:

• OS: Mac
• App Version: 5.1.6
• Install source: Installer
• Type: Application
• Database engine: PostgreSQL

Thanks for the investigation; I love this soft nevertheless!

Describe the bug I have a query and when I click format code the query becomes invalid. We have a column named "født", born in English.

The selector looks like this: date_format(født, '%d.%m.%Y') as birthdate After clicking format code it is formatted into: date_format(f ø dt, '%d.%m.%Y') as birthdate which is invalid SQL.

To Reproduce Steps to reproduce the behavior:

1. Create query
2. Include Norwegian characters (perhaps other special characters also cause this)
3. Click format code.
4. Execute query.
5. See error.

Version Information (please complete the following information):

• OS: Linux
• App Version [see Help -> About]: 5.2.0
• Install source [e.g. installer/SNAP/Docker/NPM]: Installer
• Type - Web/Application: Application
• Database engine: [e.g. MySQL/PostgreSQL/SQL Server]: MariaDB

Bumps json5 from 1.0.1 to 1.0.2.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps json5 from 2.2.1 to 2.2.3.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Hello,

maybe i missed this. If not, it would be helpful, to get a option in the context menu, to drop all tables of a database. Right now, i have to drop every single table by its own.

Thanks