Sessions at Open Source Bridge 2010 matching your filters

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.