#Best sql editor for vs code code#
#Best sql editor for vs code password#

You also get a basic report on the execution. It isn't noticeable in a screen shot (the video will make it clear), but you can copy rows, columns, and individual cells. sql file (or a file set to the SQL type), and when you execute the query (via the command palette), you get a much nicer result set: You can execute queries in a file, but not in the command paletteР”В«ut where things shine here is the view.You can define connections to a database.The feature set pretty much mimics the previous extension. The first thing I'll tell you is - it is probably a bad idea to try to use both this extension and the previous one in the same directory at the same time. As I said, I do think they need to work on the docs, but the extension is usable for sure. I found it a bit tricky at the column level (ie, the SELECT area), but it worked fine in FROM.Р”Р„nd that's pretty much it. As you write more queries, the output is just appended, which I like since it means I can do a few quick queries and check the output later.Р”Р„s I said, you do get autocomplete in the 'Advancer' query, and it does work well - showing tables and columns. The output is sent to the bottom panel along with the query you selected. Unless you use the 'Advancer' features, you'll write your queries in the command pallete - which works well enough but you won't get autocomplete: I didn't even notice it at first, but when connected, the lower left hand corner will tell you the server and database being used: It has an animated gif, which is cute, but totally not acceptable by itself. I'm going to ding this extension a few points (err, not that I'm assigning ratings or anything) for not having proper documentation on it's marketplace page. It seems to simply make a temp file for you to write a query in, which is helpful, but again shows where a 'panel' ala-Eclipse would come in handy. Writing/Running an 'Advancer' query - which I have no idea what that means.

#Best sql editor for vs code password#

Saving that connection (note, the password is stored in plain text).

That's a bit vague, I know, but I think in the video it will be a bit clearer.

#Best sql editor for vs code code#

I certainly don't want to see Code turn into that, but my gut feels there needs to be a UI/UX solution that is better suited for more complex tooling like this. Of course, Eclipse gets around this by having a gazallion panels and dedicated work 'areas' for stuff like this. One of the things that I noticed immediately, and this is not the fault of the extension, but I find that running everything in the command palette does not always work well. The first one I tried was vscode-database, which supports MySQL and Postgres. Surprisingly I couldn't find anything that supported a NoSQL solution. In my search of the marketplace, I only ran into two plugs that I thought matched what I was looking for. I thought it might be useful to take a look at how well this type of feature is supported with Code.

It supported anything ColdFusion itself supported, which had pretty good support for the RDMS world. I don't have it installed currently, but the basic feature set included being able to view all tables and structure as well as write ad hoq queries against it and see results. Now - CFBuilder was Eclipse-based so it was quite heavy, but I loved it's database viewer. In the past, when I was a heavy ColdFusion user, I was a huge fan of the database support in ColdFusion Builder. For today's review of Visual Studio Code extensions, I looked at two related extensions that provide basic database support.