![]() ![]() When it's the only thing I have to switch over to the browser for, it is a distraction. In the web interface there is the convenience of viewing tables and other datasets as well as saved queries, but code completion and the entire GCP console interface feels somewhat slow. I can also compose parameterized queries for applications there and just treat them as another source code file. Connections can be shared between projects, autocomplete is fast and sensible, and I can view all the tables/views available directly in the IDE. With a regular DB, say a PostgresSQL instance that I'm working with via the IDE I get a lot of the convenience in terms of setup and connection. Hey happy to help! In answer to your question, I think it's a couple things. These are just some of my preferences and I know there could be some redundancy with the built-in BQ support now, but maybe this work could be used by the VS Code plugin as well where there may be less support overall for these SQL dialects etc. Though I personally don't have a use case for it, I think the Cloud SQL Proxy support is an especially great idea! If you can use the proxy info that the IDE uses, that could be a real QoL improvement for devs dealing with corporate network proxies. This is one of my favorite features of the online editor and it's one of the API's that I take advantage of in my analysis applications that let you query a public dataset hosted in BQ. One thing I'd really like to see is the estimated query cost populated somewhere on screen before running my query like in the web interface. After that, the integrated connection support would be ideal, so the queries can be written and run within the IDE. I think the most critical stuff for me, and probably most users, is getting parsing support for the SQL dialects used by the popular GCP DB's like BQ, Cloud SQL, Firebase, and though maybe not as popular(?) Spanner. Though, I totally get that there's a tradeoff there with broader exposure with paid vs free users of the JetBrains IDE's. Since DataGrip is directly integrated with most of those when using the paid version, I typically like to stick with that, so I don't have to leave the IDE. Personally, I use P圜harm/IntelliJ/CLion (for Rust)/Android Studio (for Flutter) depending on the project. It looks like they're planning on integrating BQ support into DataGrip the same way they do for other databases, including packaging the driver now, which is great news, but you bring up a good point about the broader support for other GCP DB products. There was a bit more information from JetBrains in that post that I linked. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |