#Datagrip sqlite professional#
It is not a tool for a professional analyst, but a means to collaborate with others. JetBrains DataGrip can connect to the sgr engine and use it as a data source to query checked out Splitgraph tables directly or through layered querying. I believe there is also an extension that allows you to generate and save new queries through the web interface. Now the user is empowered to ask anything and they do not need to engage me for "simple questions". Instead, I can dump all of the processed results into a table, create some views highlighting analysis X vs Y, and share links that give others the ability to ask questions I had not even considered. Not that the other data is uninteresting, but the volume is such that Excel cannot handle it and even distributing it can be challenging for non-computer-technical folks without dedicated solutions. I work in a research organization where I am responsible for crunching data and produce reports highlighting the most "notable" results. It's intended more as a tool for exploratory data analysis - I've put very little work into running UPDATE/INSERT statements for example, it's much more about turning a set of relational data into something people can interactively explore.
#Datagrip sqlite install#
You can install plugins like and to add visualizations, which again are bookmarkable and hence easy to share with other people.Īll of that said, I don't really see Datasette as competing with existing SQL clients. ĭatasette's plugin system is pretty unique too. Demo here (the owner, country_long and primary_fuel columns).
I don't know if those alternatives have this feature or not, but I use this constantly.
It also does web-style tricks like turning foreign key references into hyperlinks through to the associated records.ĭatasette's table browsing feature has faceting, which is enormously powerful. Queries you execute end up in your URL bar as ?sql= parameters, which means you can navigate to them in your history, bookmark them, share links with other people (if your Datasette is shared) and open them in new tabs. Obviously I'm biased, so I'd love to hear answers to this from other people (plus I've not really used any of those alternatives much).ĭatasette is very "webby".
0 kommentar(er)
