linux fest talk proposals

I've submitted as series of talks. Let's see what happens

Robert

-----------------------------------------------------------------------------------------------------
AUDIENCE : beginner-intermediate

SUMMARY
This session details how to create and implememnt user-defined functions in the PostgreSQL rdbms. The audience will be shown functions using arguments that can be overloaded and defined as polymorphic. One will be able to return anything from individual values to entire record sets.

DETAILS
A lot of people don't realize that you can do more than just execute SQL in a database to get results, you can program it to do whatever you want. When it comes to programming, PostgreSQL is one of the most flexible RDBMS in the industry; for every programming language used in the wild, there's a procedural language that can create functions using that language.
-----------------------------------------------------------------------------------------------------
AUDIENCE : advanced

SUMMARY
This session instroduces the audience to the various mechanisms available in PostgreSQL. Features including such basics as defining user-accounts and its attributes, passwords, authentication mechansims, encryption, etc will be introduced and demonstrated. As well, potential gotchas and their remedies are covered.
-----------------------------------------------------------------------------------------------------
AUDIENCE : intermediate

SUMMARY
This session instroduces the audience to how one can implement PostgreSQL as a document based XML database engine. You will be shown not only how to express an entire database as a single XML document but how to load and query an XML document in postgres.

DETAILS
It's one of those silly facts of life that people simply don't realize that PostgreSQL is capable of not only generating XML documents but reading and querying them too.
-----------------------------------------------------------------------------------------------------
AUDIENCE : advanced

SUMMARY
This session introduces the audience to high performance string searches using the PostgreSQL text search capabilities. You will see how easy it is to query whole volumes of text in a fraction of a second. As well, the mechanism for ranking search results, similar to a Google search, will be demonstrated. Time permitting, you will be introduced to the means to setup your own dictionaries, synonyms, thesaurus and even spell checker!
-----------------------------------------------------------------------------------------------------
AUDIENCE : beginner

SUMMARY
This session introduces the audience to hottest trend in big data analysis, GIS! You will learn how to install and work with what is arguably the most powerful GIS database in the world. You will see how easy it is to answer complex questions in a single SQL statement.

DETAILS
Most people think that the trick to mastering GIS is to familiarize oneself with one of those big, powerful and well known GIS front-ends. Well I'm here to tell you a secret, it's that backend that makes the magic. This session introduces you to means of performing wonderous acts. All it takes is basic SQL, and a healthy does of geographical concepts; actually, it's not that hard. This session will focus on the basics of installing the postGIS extension to PostgreSQL with an introduction to the geographical way of doing things.