Live data from Hacker News

Franchise – An Open-Source SQL Notebook

franchise.cloud

51–60 of 64 posts

Re: Franchise – An Open-Source SQL Notebook

#51
post #49

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…

Since it fails after an "async" keyword which is supported since node v7.6 I assume they mean bleeding edge.

Re: Franchise – An Open-Source SQL Notebook

#52
Would love to use it. But I get this error in Chrome when I try to connect:

> 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

#53
This looks great! Support for Google sheets, other than export/import? I was recently surprised at how horrible an experience it is to script Google sheets - in that case for "survey" (questionnaire form) data - either locally with python or (shudder) the js/script functionality of Google sheets...

Re: Franchise – An Open-Source SQL Notebook

#54

Earlier 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.

Thanks! We're looking into it.

Re: Franchise – An Open-Source SQL Notebook

#55

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!

Can you query an elasticsearch instance in this way? i.e. as an alternative/complement to kibana?

Re: Franchise – An Open-Source SQL Notebook

#57
post #12

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

I thought this text adventure approach is a cool way of learning: http://wwwlgis.informatik.uni-kl.de/extra/game/

Re: Franchise – An Open-Source SQL Notebook

#59
post #9

How 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…

This is fantastic!

Re: Franchise – An Open-Source SQL Notebook

#60
post #31
post #15

Earlier 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.

Could you elaborate? Currently evaluating it for internal use.
Post reply on HN