Sessions at Open Source Bridge 2010 about Databases on Thursday 3rd June

Interested in using PostgreSQL for you next project, or migrating to it? This tutorial will go over the basics of PostgreSQL administration and database application design, including coverage of the features available in version 9.0.

Topics to be covered include:

• Installation & packaging options
• Basic performance configuration
• Basic security configuration
• Creating your first database
• Backups, PITR and Replication
• Common administrative tasks
• Application design patterns
• Managing database changes over time
• Special features you might not know about
• Tools you're likely to need

In order to get the most out of this tutorial, all users should bring a laptop with PostgreSQL Version 8.4 and pgAdmin installed. For users unfamiliar with installing PostgreSQL, the One-Click installer is here: http://www.enterprisedb.com/prod...

What kind of database do you need?

Thanks to new database projects like CouchDB, TokyoCabinet, Solr and others, there are more non-relational database options available than ever for developers. Yet good information on how to choose what kind of database you need is still scarce. We'll cure that in this talk.

When do you want to use a SQL-relational database? When do you want to use a non-relational database? What are the types of non-relational databases available today? What kinds of things is each well-suited for?

Database geek Josh Berkus will explain how to evaluate the database tasks you need to accomplish, and put you on the road to choosing the database product ... or more likely, products ... which are right for you.

The talk will describe in detail the new features in MariaDB 5.1 (stable), the new features in MariaDB 5.2 (beta / RC) and what's in the upcoming MariaDB 5.3 (alpha).

The talk will also explains the challenges we have had to do this fork, and the various systems (like buildbot) that we used to build the binaries and how we are working with the MariaDB/MySQL community.

This talk also includes information how we plan to continue developing MariaDB so that it still a drop in replacement of MySQL as times goes by.