cweijan / vscode-database-client Goto Github PK

View Code? Open in Web Editor NEW

2.4K 2.4K 264.0 9.45 MB

Database Client For Visual Studio Code

Home Page: https://database-client.com

License: MIT License

HTML 0.01% JavaScript 9.76% TypeScript 51.78% Vue 11.99% CSS 26.46%

mysql-database sql vscode vscode-extension

vscode-database-client's People

Contributors

Stargazers

Watchers

Forkers

carehart polakosz sktheboss emaiqi aritz-cracker whizsid yangliping-ql yi1991er crackercat itsdonnix jiangwu10057 forkrespositories dumpmemory anguschiang xieren58 lyhiving biggnuttso hilbsam gebni anhgeeky systemctls crisoz hgdhot anibalmorales thienohs donfresh10 mutalimov95 weijee study-model eshizhan ahmadshiddiqn forksrepo juhuahaoteng drtobbyas 89343671 fly2marss zilinweizhu gipipi sametaylak victorfontes misraviks stonethink appdirectory vitozyf foundations shangwong ideas-design bmandoki cake654326 hankovich euui kbrownnn flybyray profencer garcia123 demerson-demy ladykiller abeastofprey razihaivctl1 dorahasadream sar linleng ashutoshpw jadeli1 dong4am dagaiguanyu saskianoir fdiskas nicocanada baojd42 zhuomingliang davgit tyxo842 zone-backend mbtolou gscsnm findzyxu ferocknew devbox10 scrollsyou yeyeyeping manavx ww-k urigat cytelsystem royswale noblega-diego ertip4geek robertostermann qianniaoge kevenfrank33 atlantiswing moon1102 dc-avasilev smavo-all guoyingtan donald001 igaisin qdel abnercrack

vscode-database-client's Issues

Is it possiable to transfer "Generate Mock Data" feature into Python library?

"Generate Mock Data" is such a awesome feature for me, so I want bring it to my python code and try to generate db data with your way, so I wonder if Is this possiable to transfer "Generate Mock Data" feature into Python library?

Issue upon installation

Hi,

Not sure whether I missed something out but the extension doesn't seem to work I get
command 'mysql.connection.add' not found upon clicking + .

Do I need to configure or install something first before using this plugin. Thanks.

Connection error

Hi,

I got the following error when I tried to connect to localhost mysql:

Connection error! ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client.

Can you please advise how to solve this? Thanks.

Improve active database selection

OS INFO: Win 10 2004

I work with multiple hosts and databases at the same time and this MySQL client helps a lot!

However, there is a high risk of code running for the wrong host (even with the little host-IP in the status-bar).

The following changes would be a great asset to me:

Set active DB via Explorer: "Explorer / Host or Database / context menu / Set as active for current query"
Show active DB via Explorer - highlight the current active host and db when you switch through the queries / tabs
"Query / context menu / Change Active Database" is far too confusing because the host is only in front of the name if databasenames exist twice in all hosts. My suggestion would be to always put the connection name in front

Thanks for reading!

BTW: Keep the work up! This is by far the best client vor VSCode! Star nr. 100 for you!

table list is not sorted

it will be easier for user to find a table if table list is sorted.
thx for your great tools.

F9 Dead (v2.2.5 or more)

Sorry I can't speak english.

Run MYSQL Query(F9) is Dead

mysql password is null

v2.2.4 is work

windows10
xampp
Confirmed with php 5.6, 7.2

element with id **** is already registered

连接的时候出现"element with id **** is already registered"是怎么回事啊

bug report :command 'mysql.addConnection' not found

Browse window does not move horizontally in queries

Hi I don't now if this is a bug but when I do a query to show a data in table, does not move horizontally in in this windows resultset

USING关键字

希望支持USING关键字，这个关键字在连表时非常有用，在SELECT，UPDATE，DELETE中都经常使用

SELECT column_list
FROM table_1
JOIN table_2 USING (column_name);

[BUG] All "NOT NULL" colums show as "required" in the insertion dialog

OS INFO : Ubuntu 20.04, Linux 5.4.0-42-generic, x64

Hello! I'm really enjoying this plugin! It's very useful!

I'd like to report a small issue. When you click the (+) button to insert a new row in a table within the transactions menu, all NOT NULL columns are showed as "required", but this isn't true under the following conditions:

Columns with AUTO_INCREMENT applied
Columns with a DEFAULT value

Dark mode

The Table view should feature a dark mode to best fit with VSCode dark mode themes,

为啥下架了呀？？

我一直在用感觉挺好的

[BUG] Errors in autogenerated sql queries

OS INFO : Ubuntu WSL

Double backtics around column name:

No backtics around column name in where:

Queries were generated in ui.

[BUG] Why the query didn't show nothing?

OS INFO :
The query can show me sql result. And it worked in the past week. But when I use it and Run MySQL Query today, it somehow gets in trouble and show nothing. I don't do anything why this happens?

[BUG] On the VSCode update, it just shows blank.

OS INFO :

Add option to disable automatically showing extension output

Every time I'm open vscode, the output window is always opened, I think this is not expected behavior, or at least don't automatically show this. Thank's...

`UNSIGEND` keyword support

Can you add support for the UNSIGNED keyword? This keyword is very commonly used

Right Click Option Not Showing in 1.9.1

In issue (#4 (comment)) it was noted that the right click option was added, but this is not visible in 1.9.1.

Originally posted by @cweijan in #4 (comment)

Extension causes high cpu load

Issue Type: Performance
Extension Name: vscode-mysql-client
Extension Version: 1.7.22
OS Version: Linux x64 5.6.2-050602-generic
VSCode version: 1.44.2

⚠️ Make sure to attach this file from your home-directory:
⚠️/home/don/cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt
cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt

Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load

Bug report "EXECUTE FAIL: Message : ER_EMPTY_QUERY: Query was empty"

I do like this plug-in with its beautiful visual interface but there's a frustrating bug when I run queries, the Query board always shows me "EXECUTE FAIL:
Message :
ER_EMPTY_QUERY: Query was empty"

although my query is not empty at all.
I hope this bug be repaired soon.
Thanks for your effort.

command 'mysql.connection.add' not found

我已经更新了1.9.2，但是问题还是没有解决

[BUG] column display bug

OS INFO :

when I selected id (bigint(20)) from table, then it display like this:

1292434711813128200
1292434718599512000
1292434961730732000
1292434968399675400
1292434968399675400

The last two digits are carried forward.

Here's the real story：
+---------------------+
| id |
+---------------------+
| 1292434711813128194 |
| 1292434718599512065 |
| 1292434961730732034 |
| 1292434968399675393 |
| 1292434968399675394 |
+---------------------+
5 rows in set (0.00 sec)

[BUG] Auto generated SQL statements don't have backtics around table and column names

OS INFO : Any OS

SQL statements generated by extension don't use backtics, which breaks them when table or column names are reserved words.
Example:

Support to execute query from selected text from any file.

I'm already loving your extension bro. Awesome work. I gave you 5 star on Marketplace and stared on github already. Keep up the good work.

Just a suggestion only if you got enough time to support this. I found this feature in some other mysql client extension that you can execute a mysql query from any file selected text. The selected text query must end with a semi colon so the parser can pick query easily. And then execute it on the current connected session.
I couldn't find this feature in your extension, if it's already there let me know and I'll be happy to use it.

Extension causes high cpu load

Issue Type: Performance
Extension Name: vscode-mysql-client2
Extension Version: 2.1.8
OS Version: Windows_NT x64 10.0.17763
VSCode version: 1.45.1
can't connect
⚠️ Make sure to attach this file from your home-directory:
⚠️C:\Users\29220\cweijan.vscode-mysql-client2-unresponsive.cpuprofile.txt

Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load

[BUG]command 'mysql.connect.add' not found

OS INFO :

bug 报告

run query 无法显示结果，只能出现一个空窗口
vscode 为最新版
mysql版本为5.7.25

[BUG] Freeze when calling procedures

OS INFO : WINDOWS 10

When I try to call any store procedure, the output display only freezes on the loading page. I am not sure this feature is not supported yet or it's a bug, or there is something wrong in my vscode's settings. Additionally, if I click a procedure in the left control bar, the system will show "Error: ER_SP_DOES_NOT_EXIST: PROCEDURE undefined does not exist".

[BUG] Can't connect to MySQL 8.0 server.

OS INFO :
Windows 10 Pro 1903 1836.778

Error output VSCode:

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.module.exports.Sequence._packetToError (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:3310:14)
    at Handshake.module.exports.Handshake.ErrorPacket (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:59292:18)
    at Protocol.module.exports.Protocol._parsePacket (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:52087:23)
    at Parser._parsePacket (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:52698:10)
    at Parser.write (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:52308:10)
    at Protocol.module.exports.Protocol.write (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:51834:16)
    at Socket.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5016:28)
    at Socket.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5454:10)
    at Socket.emit (events.js:203:13)
    at addChunk (_stream_readable.js:295:12)
    at readableAddChunk (_stream_readable.js:276:11)
    at Socket.Readable.push (_stream_readable.js:210:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:166:17)
    --------------------
    at Protocol.module.exports.Protocol._enqueue (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:51940:48)
    at Protocol.handshake (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:51847:23)
    at Connection.connect (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5044:18)
    at Function.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:298:51)
    at Generator.next (<anonymous>)
    at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:214:71
    at new Promise (<anonymous>)
    at module.exports.__awaiter (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:210:12)
    at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:259:49
    at new Promise (<anonymous>)
    at Function.getConnection (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:259:16)
    at MysqlConnectService.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104581:57)
    at Generator.next (<anonymous>)
    at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104567:71
    at new Promise (<anonymous>)
    at module.exports.__awaiter (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104563:12)
    at MysqlConnectService.connect (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104575:16)
    at MysqlConnectService.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104633:40)
    at Generator.next (<anonymous>)
    at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104600:71
    at new Promise (<anonymous>)
    at module.exports.__awaiter (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104596:12)
    at Object.receiveListener (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104629:60)
    at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5880:35
    at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
    at K.$onMessage (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:786:33)
    at e._doInvokeHandler (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:804:1013)
    at e._invokeHandler (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:804:705)
    at e._receiveRequest (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:803:344)
    at e._receiveOneMessage (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:802:156)
    at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:800:416
    at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
    at v.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:274)
    at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:975:649
    at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
    at v.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:274)
    at t.PersistentProtocol._receiveMessage (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:243:629)
    at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:240:824
    at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
    at p.acceptChunk (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:737)
    at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:89
    at Socket.t (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:245:185)
    at Socket.emit (events.js:203:13)
    at addChunk (_stream_readable.js:295:12)
    at readableAddChunk (_stream_readable.js:276:11)
    at Socket.Readable.push (_stream_readable.js:210:10)
    at Pipe.onStreamRead (internal/stream_base_commons.js:166:17)
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
-----------------------------------------------------------------------------------------

Add right click to change databases

Add an ability to change database context via right click option instead of requiring a new query

Adopt VS Code's 'asWebviewUri' API

Hi, I maintain VS Code's Webview API

Issue

Our telemetry suggests that your extension uses webviews and may be loading resources in these webviews using hardcoded vscode-resource: URIs. These URIs have some important limitations and don't work properly when VS Code is run in a browser. We are also making changes in the desktop version of VS Code that may cause these URIs to not work properly in future versions of VS Code.

While we are making our best effort to continue support existing webview extensions that use vscode-resource: URIs on desktop versions of VS Code, we will not able to fully support all uses cases.

Fix

To ensure that your extension continues to work in as many environments as possible—including on web and remotely—please:

Switch to use the Webview.asWebviewUri function for loading resources.
Switch to use the Webview.cspSource property in content security policies.

These APIs shipped around 2 years ago so they should be available in all modern versions of VS Code. You can find additional information about the issue here: microsoft/vscode#97962

Let me know if you have any questions about this change

`Delimiter` keyword support

Can u add support for the delimiter keyword to support modifying stored procs? The other MySql plugin supports it (https://marketplace.visualstudio.com/items?itemName=poreklo.vscode-mysql)

Extension causes high cpu load

Issue Type: Performance
Extension Name: vscode-mysql-client
Extension Version: 1.9.8
OS Version: Linux x64 5.3.0-61-generic
VSCode version: 1.46.0

⚠️ Make sure to attach this file from your home-directory:
⚠️/home/hemant/cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt

Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load

Add row limit in Settings JSON

OS Info: Xubuntu 18.04

Hello!
First of all, I would like to say this is the best extension I've found so far for MySQL.

The only feature I miss is the same as the MySQL workbench, where you can limit the row count, not having to specify the LIMIT XX in every query.

Thank you :)

[BUG] The extension always tries to connect to a db when VSCODE is opened

OS INFO : Windos 10, latest version, vscode latest version, vscode-mysql latest version

The MySQL I connect to is behind a VPN. This plugin always tries to connect to MySQL even if I don't want to. If I open vscode to edit some file without being connected to the VPN, the plugin won't be able to connect to the database and it would give this error

2020-08-12 09:59:04 : Error: connect ETIMEDOUT
	at Connection.module.exports.Connection._handleConnectTimeout (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:5524:13)
	at Object.onceWrapper (events.js:291:20)
	at Socket.emit (events.js:203:13)
	at Socket._onTimeout (net.js:434:8)
	at listOnTimeout (internal/timers.js:531:17)
	at processTimers (internal/timers.js:475:7)
    --------------------
	at Protocol.module.exports.Protocol._enqueue (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:52105:48)
	at Protocol.handshake (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:52012:23)
	at Connection.connect (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:5231:18)
	at Function.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:300:51)
	at Generator.next (<anonymous>)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:216:71
	at new Promise (<anonymous>)
	at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:212:12)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:261:49
	at new Promise (<anonymous>)
	at Function.getConnection (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:261:16)
	at ConnectionNode.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9925:74)
	at Generator.next (<anonymous>)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9885:71
	at new Promise (<anonymous>)
	at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9881:12)
	at ConnectionNode.getChildren (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9922:16)
	at DbTreeDataProvider.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1887:43)
	at Generator.next (<anonymous>)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1861:71
	at new Promise (<anonymous>)
	at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1857:12)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1886:79
	at Array.forEach (<anonymous>)
	at DbTreeDataProvider.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1886:51)
	at Generator.next (<anonymous>)
	at fulfilled (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1858:58)
	at processTicksAndRejections (internal/process/task_queues.js:85:5)
connect ETIMEDOUT
-----------------------------------------------------------------------------------------

The extension should only try to connect o a db when I click on it and ask it to connect.

Adopt VS Code's 'asWebviewUri' API

Hi, I maintain VS Code's Webview API

Issue

While we are making our best effort to continue support existing webview extensions that use vscode-resource: URIs on desktop versions of VS Code, we will not able to fully support all uses cases.

Fix

To ensure that your extension continues to work in as many environments as possible—including on web and remotely—please:

Switch to use the Webview.asWebviewUri function for loading resources.
Switch to use the Webview.cspSource property in content security policies.

These APIs shipped around 2 years ago so they should be available in all modern versions of VS Code. You can find additional information about the issue here: microsoft/vscode#97962

Let me know if you have any questions about this change

[BUG] Error: read ECONNRESET

OS INFO : Windows 10 latest version, vscode latest version, this extension latest version

I disabled this plugin autoconnect feature as per your recommendation here. I see the error below, not sure if they're related.

2020-08-17 15:31:15 : Error: read ECONNRESET
	at TCP.onStreamRead (internal/stream_base_commons.js:183:27)
    --------------------
	at Protocol._enqueue (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:52105:48)
	at Protocol.handshake (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:52012:23)
	at Connection.connect (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:5231:18)
	at Function.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:300:51)
	at Generator.next (<anonymous>)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:216:71
	at new Promise (<anonymous>)
	at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:212:12)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:261:49
	at new Promise (<anonymous>)
	at Function.getConnection (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:261:16)
	at ConnectionNode.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9925:74)
	at Generator.next (<anonymous>)
	at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9885:71
	at new Promise (<anonymous>)
	at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9881:12)
	at ConnectionNode.getChildren (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9922:16)
	at DbTreeDataProvider.getChildren (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:1909:24)
	at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:620:416
	at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:52:136
	at new Promise (<anonymous>)
	at Object.t.asPromise (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:52:108)
	at m.fetchChildrenNodes (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:620:384)
	at m.getChildren (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:617:739)
	at t.ExtHostTreeViews.$getChildren (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:614:695)
	at m._doInvokeHandler (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:819:926)
	at m._invokeHandler (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:819:618)
	at m._receiveRequest (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:818:252)
	at m._receiveOneMessage (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:817:6)
	at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:815:161
	at l.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:222)
	at v.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:494)
	at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:1007:179
	at l.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:222)
	at v.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:494)
	at t.PersistentProtocol._receiveMessage (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:244:17)
	at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:241:67
	at l.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:222)
	at p.acceptChunk (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:949)
	at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:301
	at Socket.t (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:245:572)
	at Socket.emit (events.js:203:13)
	at addChunk (_stream_readable.js:295:12)
	at readableAddChunk (_stream_readable.js:276:11)
	at Socket.Readable.push (_stream_readable.js:210:10)
	at Pipe.onStreamRead (internal/stream_base_commons.js:166:17)
read ECONNRESET
-----------------------------------------------------------------------------------------

Can't open settings

When I click the settings button, the output is:

Error: ENOENT: no such file or directory, scandir 'C:\Program Files (x86)\MySQL'

Support varbinary fields

Definately the best MySQL editor for VSCode. Any chance you support the varbinary field type in the near future?

Currently the addon only shows a number (probably the value of the first byte) in a varbinary field. Editing the field also doesn't work.

syntax error, insert item into table, by extension query web

EXECUTE FAIL:

  INSERT INTO test_table(user_id,meeting_id,text,modified_on,created_on) VALUES(1,1,测试 文本,1588133313,1588133313)

ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '文本,1588133313,1588133313)' at line 1

it seams that single quotes has bean omitted with text type.

extension version: 1.9.4

Extension issue

Issue Type: Bug
Extension Name: vscode-mysql-client
Extension Version: 1.7.32
OS Version: Windows_NT x64 10.0.18363
VSCode version: 1.44.2

⚠️ We have written the needed data into your clipboard. Please paste! ⚠️

Extension issue

Issue Type: Bug
Extension Name: vscode-mysql-client2
Extension Version: 2.4.2
OS Version: Windows_NT x64 6.3.9600
VSCode version: 1.47.3

⚠️ We have written the needed data into your clipboard. Please paste! ⚠️

Feature Request: SSH key authentication for SSH tunneling

I think it's pretty clear, currently the SSH tunneling only supports password authentication.
Could you add support for pubkey authentication?

And let me use this FR to thank you for your work on this extension!

[BUG] Delete All rows in table not working.

When I try to select all rows and delete the rows on provided GUI it does not perform the required action. The reason is it prepends a comma(,) before the first id which makes an invalid SQL syntax. You can see from the image below.

OS INFO : Ubuntu 18.04

Extension causes high cpu load

Issue Type: Performance
Extension Name: vscode-mysql-client
Extension Version: 1.7.20
OS Version: Windows_NT x64 10.0.18363
VSCode version: 1.45.0-insider

⚠️ Make sure to attach this file from your home-directory:
⚠️C:\Users\druide\cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt

Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load

[BUG]IP address connection error

OS INFO : Windos 10:Windows_NT x64 10.0.19041, vscode : 1.47.3, vscode-mysql :v2.4.6
172.18.56.185
When I enter host as 172.18.56.185, I find that the IP address prompted is not correct. The specific information is as follows：
Connection error! ER_HOST_NOT_PRIVILEGED: Host '172.18.48.1' is not allowed to connect to this MySQL server
When I enter host as 10.0.10.27, I find that the IP address prompted is not correct. The specific information is as follows:
Connection error! ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'10.222.0.1' (using password: YES)

REFERENCES关键字

REFERENCES和CHECK关键字虽然已经能够高亮，但是还是不能补全，希望作者能够添加？

Extension causes high cpu load

Issue Type: Performance
Extension Name: vscode-mysql-manager
Extension Version: 1.6.37
OS Version: Windows_NT x64 10.0.18363
VSCode version: 1.45.1

⚠️ Make sure to attach this file from your home-directory:
⚠️C:\Users\dramm\cweijan.vscode-mysql-manager-unresponsive.cpuprofile.txt

Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load

Can we input one more db names on "Connect to MySQL server" Panel?

For now, we only two choices for database field on "Connect to MySQL server" Panel: one db or empty( all db), but for some scenarios, we got so many dbs here and only want some of them to show on connect items, can we input one more db names on "Connect to MySQL server" Panel? or, provide a setting item on the UI to display or hidden the specified dbs?

cweijan / vscode-database-client Goto Github PK

vscode-database-client's People

Contributors

Stargazers

Watchers

Forkers

vscode-database-client's Issues

Issue

Fix

Issue

Fix

Recommend Projects

Recommend Topics

Recommend Org