Open Source Bridge

Excerpt

Description

Application developers and programmers everywhere need SQL databases, but find their actual database an albatross. Data is duplicated, hard to find, or missing. Performance is terrible. And you find yourself writing too much SQL and not your chosen language. ORMs promised to take this pain away, but, well … nice try.

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. I’ll introduce some easy basic rules hard-learned over 15 years of SQL database design and how to avoid some of the most common simple mistakes which take dozens of hours to fix in production.
Content will include:

• Data modeling for normal humans
• The Atomic Age
• Where are my keys?
• The embarrassment of premature optimization
• Data extensibility and EAVil

Slides are available at http://www.pgexperts.com/presentations.html

Tags

SQL, database, design

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