Abstract: The intention of this VERY hands on workshop is to get you introduced and playing with some of the great features you never knew about in PostgreSQL. You know, and probably already love, PostgreSQL as your relational database. We will show you how you can forget about using ElasticSearch, MongoDB, and Redis for a broad array of use cases. We will add in some nice statistical work with R embedded in PostgreSQL. Finally we will bring this all together using the gold standard in spatial databases, PostGIS. Unless you have a specialized use case, PostgreSQL is the answer. The session will be very hands on with plenty of interactive exercises.
By the end of the workshop participants will leave with hands on experience doing:
Full Text Search
Using R for stored procedures and functions
All in PostgreSQL