This looks really nice. Having a bit of trouble getting the bridge running on node v6.11 on Windows 10. The app mentions requiring the latest version of node but it's not clear whether you need the standard LTS (6.11) or the bleeding edge (8.5). Thanks! > npx franchise-client@0.2.2 franchise-client\server.js:16 ws.on('message', async message => { ^^^^^ SyntaxError: missing ) after argument list at createScript (vm.js…
Franchise – An Open-Source SQL Notebook
51–60 of 64 posts
Re: Franchise – An Open-Source SQL Notebook
#52> Disconnected from PostgreSQL (Error: Too many result rows to serialize: Try using a LIMIT statement.)
This is on my console (my credentials replaced with ellipses):
~> npx franchise-client@0.2.2
npx: installed 140 in 12.533s
franchise-client listening on port 14645
opened connection
received: {"action":"get_postgres_credentials","id":1}
received: {"action":"open","db":"postgres","credentials":{"id":1,"host":"localhost","user":"...","database":"...","port":"...","autofilled":true,"password":"..."},"id":2}
received: {"action":"exec","sql":"SELECT table_schema, table_name, column_name\n FROM information_schema.columns \n WHERE table_schema not in ('pg_catalog', 'information_schema', 'pg_internal')","id":3}
Error: Too many result rows to serialize: Try using a LIMIT statement.
at Object.query (~/.npm/_npx/736/lib/node_modules/franchise-client/response.js:128:23)
at
at process._tickCallback (internal/process/next_tick.js:188:7)
I ran the SELECT query in Valentina Studio and got 11000+ rows in 4s. Maybe raise the acceptable row count to 100,000?Re: Franchise – An Open-Source SQL Notebook
#53Re: Franchise – An Open-Source SQL Notebook
#54Earlier quoted context omitted.
What browser are you using? It's working for me on chrome and safari.
Not OP - but you get that error in Microsoft Edge on windows 10. Demo works on Internet Explorer 11 on windows (but without map option using Crime in LA example) and in Edge all the demos appear to run, map and graphs get populated etc, then page looses the db connection.
Re: Franchise – An Open-Source SQL Notebook
#55Co-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!
Re: Franchise – An Open-Source SQL Notebook
#56node_modules: 329 715 665 bytes (435,4 MB on disk) for 37 881 items
I know it looks cool and animates and all that, but... really?!
Re: Franchise – An Open-Source SQL Notebook
#57This 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
Re: Franchise – An Open-Source SQL Notebook
#58Re: Franchise – An Open-Source SQL Notebook
#59How is it different from SQL support in Jupyter notebook?
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…
Re: Franchise – An Open-Source SQL Notebook
#60Earlier quoted context omitted.
And superset[0]: https://github.com/apache/incubator-superset
I've used superset and honestly, it kinda sucked as a user. Maybe it will thrive now it's not under AirBnB's ownership, but I more than welcome competition in this space.