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?
It’s dead simple.
You can of course nest queries, export and share your SQL notebooks.
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 ;)
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.
Please fill out the below form and we'll be in touch real soon.