Open Source Bridge

Excerpt

Description

Most developers find they have to use SQL databases for their projects, but few have any idea how to index those databases. Which columns to index, what kinds of indexes to use, multicolumn indexes, foreign keys … it’s all very confusing to anyone who’s not a career database person (and even some that are).

Josh Berkus, PostgreSQL Project Core Team, will cover:

- Assorted Types of Indexes
- The Three Methods of Indexing your Database
- The Four Reasons to Index a column or table
- How to think about Multicolumn Indexes

Given that this is a 45-minute session, specialty index types will be mentioned, but not detailed.

Tags

database, SQL, performance

Speaking experience

Speaker

• 

  Josh Berkus

  PostgreSQL Project
  • Website: http://www.pgexperts.com/
  • Blog: http://it.toolbox.com/blogs/database-soup
  • Twitter: fuzzychef

  Biography

  Josh Berkus is best known as a Core Team member of the world-spanning PostgreSQL project. He is CEO of PostgreSQL Experts, Inc. and in his 12 years as a database consultant he has worked with CouchDB, MySQL, Oracle, and MSSQL Server as well as Postgres, and is heavily involved in many OSS communities, including BIRT, OSCON, OSfA, Noisebridge and more. He’s also a potter and a mean cook.

  Sessions

  • * Building a SQL Database That Works
    • Title: Building a SQL Database That Works
    • Track: Cooking
    • Room: St. Johns
    • Time: 11:20am – 12:05pm
    • Excerpt:

      As a developer, what you really need are some simple recipes for how to think about designing your SQL databases so that they are simple, maintainable, expandable and easy to troubleshoot.

    • Speakers: Josh Berkus
  • * Open Source Press Relations
    • Title: Open Source Press Relations
    • Track: Business
    • Room: Hawthorne
    • Time: 11:20am – 12:05pm
    • Excerpt:

      You have a really cool open source project and everyone should see it, try it, and use it. But … they don’t seem to know about it. How can you make sure your project gets the press coverage it deserves?

    • Speakers: Josh Berkus