At CARTO we <3 PostGIS. And we love PostGIS not only because it's a fully-fledged geospatial analytics engine but because being at the roots of our technology it helps us building tools to help companies and individuals better understand their geospatial data through Location Intelligence.
Recently we have found out Franchise. Franchise is a SQL tool with a notebook interface built by some colleagues at MIT. It is used to explore your data in PostgreSQL BigQuery MySQL and other databases by means of SQL queries.
Wouldn't it be cool having a SQL notebook not only to explore but also to visualise and style your geospatial analysis against PostGIS using CARTO?
How it works
It's dead simple.
- Connect to CARTO with your user credentials. It works both with personal or enterprise accounts.
- Choose one of your CARTO datasets and write your analysis in the SQL console.
- Open the CARTO View style and visualise
You can of course nest queries export and share your SQL notebooks.
How it's done
There are a couple of cool things to remark about this integration of CARTO in Franchise.
About this there's still some work to do to have a general purpose CARTO.js React component but serve this as an example on how to integrate CARTO.js in your own React applications.
Stay tunned for more news about this in the following weeks ;)
Where to start
Again dead simple if you have a CARTO account just use your credentials otherwise you can sign up for an account here
And that's it happy PostGIS day!
If you liked this post you might be interested in joining us.
Kudos to Guillermo Webster for bringing Franchise to life.