Exploiting PostgreSQL's Power with Elixir / Ecto Applications

When creating new apps with Elixir, we usually set up the database, then create users and groups tables, and proceed to define the rest of the data model according to the requirements. That's when we start coding the business logic and probably find ourselves writing a lot of access control logic for each query. Let's explore a different approach, that takes advantage of Postgres to write less code, keeping the important parts of the business logic agnostic to the language, but still enjoying the benefits of Elixir.

Objectives Show a different way to write Elixir/Ecto/Postgrex applications using existent PostgreSQL features. Motivate the audience to explore alternative uses of PostgreSQL while writing Elixir applications.

Audience Developers creating Elixir/Ecto/Phoenix applications that connect to PostgreSQL databases.