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

11–20 of 64 posts

Re: Franchise – An Open-Source SQL Notebook

#11

Post by dvfjsdhgfv »

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!

Thank you so much for your great work! This is exactly the kind of post I visit HN for!

Re: Franchise – An Open-Source SQL Notebook

#16

Post by bijection »

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.

Re: Franchise – An Open-Source SQL Notebook

#17

Post by bijection »

bduerst wrote: post #13

Looks cool. Any plans for D3.js reporting integration? How would someone add their own reporting types?

Take a look at https://github.com/HVF/franchise/blob/master/src/cell/visual...

Basically, each visualization is a react widget with some static properties that define its icon / when to show it / etc.

Re: Franchise – An Open-Source SQL Notebook

#18

Post by zengid »

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

Khan academy has a great in-browser environment for learning. Unfortunately the lessons are given in a tone that seems to be targeted towards middle-schoolers, so it can feel a bit irritating at times.

Re: Franchise – An Open-Source SQL Notebook

#19

Post by felixge »

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

Check out https://www.pgexercises.com/ . If you like learning by doing, it's a great resource.

Re: Franchise – An Open-Source SQL Notebook

#20

Post by gglanzani »

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!

Hi,

Any plan to support jdbc so that it’s possible to connect to things such is HiveServer2/SparkSql?

Post reply on HN