Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Franchise – An Open-Source SQL Notebook

franchise.cloud

Post reply on HN
Print view View original

41–50 of 64 posts

Re: Franchise – An Open-Source SQL Notebook

#41

Post by jordanwallwork »

bijection wrote: post #6

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!

Great work. Love the name too, tickled me when I read the strapline

Re: Franchise – An Open-Source SQL Notebook

#42

Post by ocdtrekkie »

bijection wrote: post #40
ocdtrekkie wrote: post #38

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.

Here's the test it currently runs: https://github.com/HVF/franchise/blob/b9b1b8414bbc930f7e1a68... Basically, it looks for geo-ish column names.

That should work for me! Thanks!

Re: Franchise – An Open-Source SQL Notebook

#43

Post by siddboots »

geokon wrote: 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

What's your unrelated field? In my experience there's a way to shoehorn SQL into any application if you really want to. Sometimes even when you really don't want to.

Re: Franchise – An Open-Source SQL Notebook

#45

Post by ptrott2017 »

bijection wrote: post #16
reaperducer wrote: post #14

> Disconnected from SQLite (Error: Invalid LatLng object: (NaN, NaN)) Too bad, I was looking forward to that mapping demo. It might be just what I need. I'll try again in a few hours.

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

#46

Post by SwellJoe »

This is super impressive, and small, too. This is a lot less code than I would have imagined for such an ambitious project. The JS ecosystem has gotten really strong in recent years in terms of library support and how concisely complex tasks can be implemented.

Re: Franchise – An Open-Source SQL Notebook

#47

Post by antimatter15 »

isatty wrote: post #33
bijection wrote: post #6

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!

Hello! This is a great product, I gave it a spin in a local setup with some actual production data. I'll compare it to Metabase (even though you aren't trying to do the same thing). * 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…

If you press the "Download" button, you can download the document as an HTML file. Share it through email or any other means, and it'll open in the Franchise web app— with all the queries, the results, and visualizations.

Re: Franchise – An Open-Source SQL Notebook

#49

Post by shaunol »

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:56:10)
    at Object.runInThisContext (vm.js:97:10)
    at Module._compile (module.js:542:28)
    at Object.Module._extensions..js (module.js:579:10)
    at Module.load (module.js:487:32)
    at tryModuleLoad (module.js:446:12)
    at Function.Module._load (module.js:438:3)
    at Module.runMain (module.js:604:10)
    at run (bootstrap_node.js:389:7)
    at startup (bootstrap_node.js:149:9)
Post reply on HN