# PostgresOpen: PostgreSQL Schema Design and Application Development

DevFeed: [PostgresOpen: PostgreSQL Schema Design and Application Development](<https://devfeed.tech/articles/postgres-open-34647.md>)

Original publisher: [Read original article](<https://tapoueh.org/conf/postgres-open/>)

Published: 2019-09-11T22:00:00Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [App](<https://devfeed.tech/topics/app.md>), [Unit testing](<https://devfeed.tech/topics/unit-testing.md>)

Tags: [application](<https://devfeed.tech/tags/application.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [unit-testing](<https://devfeed.tech/tags/unit-testing.md>)

## AI overview

A conference talk about modeling PostgreSQL database schemas for applications, including schema design trade-offs, practical database use, and unit testing.

## Source excerpt

As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it's important to understand how the schema is then going to be used as well as the trade-offs it involves. PostgreSQL is the World's Most Advanced Open Source Relational Database and by the end of this talk you will understand what that means for you, an application developer. What kind of problems PostgreSQL can solve for you, and how much you can rely on PostgreSQL in your daily activities, including unit-testing.