31–40 of 64 posts
How is it different from SQL support in Jupyter notebook?
And superset[0]: https://github.com/apache/incubator-superset
Co-creator here! We wanted * A simple, flexible SQL client * A notebook interface that lets you drag stuff around and view things side-by-side * Query CSVs, JSON, and XLSX documents fully in-browser with Emscripten + SQLite * Postgres, MySQL and BigQuery through a local connection bridge. Your data never touches a third party server. I’ll be here with @antimatter15 for the rest of the morning answering questions!
This is really cool :) I nearly worked on such a project myself, out of frustration for simple solutions. I've seen similar things recently with SQL Notebook, Zeppelin, Jupyter, Flyspeed SQL query.. and more complex desktop apps like Tableau, QlikView, etc. I kept thinking to myself... why isn't there just a lighter weight query only tool. It helps people to learn, it's a handy utility, it helps you just use SQL as a…
It's sort of a mini ETL powertool.
Co-creator here! We wanted * A simple, flexible SQL client * A notebook interface that lets you drag stuff around and view things side-by-side * Query CSVs, JSON, and XLSX documents fully in-browser with Emscripten + SQLite * Postgres, MySQL and BigQuery through a local connection bridge. Your data never touches a third party server. I’ll be here with @antimatter15 for the rest of the morning answering questions!
* I really like the editor. It beats metabases ACE editor anyday.
* Here's the line graph comparison between the two: https://imgur.com/a/gd5P8 I think that metabase wins here because I can get more information off that graph rather than an area under the graph kinda thing that Franchise is trying to do. Is it configurable somewhere?
* Can I link other users to the question somehow?
This looks really cool! I've been meaning to learn SQL for a long time, but I'm unfortunately in an unrelated field. Could anyone recommend some resources for learning SQL? Preferable targeted towards an experienced programmer
You will need to set aside all your imperative, procedural habits. To use SQL effectively you need to think in terms of sets, unions, intersections, and declarative statements.
If you find yourself thinking "row at a time" you might need to stop yourself. It's not always wrong, but a common mistake many programmers make when first learning SQL.
Earlier quoted context omitted.
Co-creator here. For existing SQL tools there's currently basically two approaches: where either the full application is hosted, or where the full application is local. Jupyter and Zeppelin generally fall into the second category— you have to set up Docker (or the myriad of dependencies), and edit a bunch of configuration files to launch a local server before getting started. If someone sends you a notebook, and you…
Redash creator here. One correction about Redash: Redash is open source and you can host it yourself too, in case you have an issue trusting a 3rd party with your data. The proxy approach is something I thought about several times, but I am aiming at providing a collaborative tool, where it's easy to share the results and work with others. Depending on a proxy running on a user machine breaks this. But having said th…
I'd like to confirm, we are hosting redash 2.0 (recently updated from 1.0) to our own server and use it as a query portal and collaboration tool to a number of databases (including mysql, postgres and oracle). Query sharing is really important there are users that don't know SQL but know how to run "peter-21" or "jim-32" with redash.
Everything is smooth till now thank you for the great product!
Are there plans for Teradata support in the near future?
I just pulled up the crime stats example data: How do you tell it that a given table can be plotted on a map? I don't have the file with me at the moment, but I do have an SQLite database with coords and datetimes I'd love to plot.
Basically, it looks for geo-ish column names.