Lawrence_elixir

Lawrence_elixir

18) ElixirConf EU 2019 - Exploiting PostgreSQL's power with Elixir / Ecto applications - José San Gil

José San Gil - Software Engineer

Exploiting PostgreSQL’s power with Elixir and Ecto applications

Talk in three words: Elixir Postgresql ecto

Abstract
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.

The speaker
José is a computer engineer from Caracas, Venezuela with 8 years experience. He started as a mobile application developer for Blackberry devices but quickly moved to web application and APIs. He has worked on different financial startups, coding infrastructure in Java, Python, and Javascript. He switched to Elixir, along with his team, and now writes Elixir 60% of his time.

All will be added to the ElixirConf EU 2019 Talks List or via the #elixirConfEU2019 tag.

Where Next?

Popular in Talks Top

axelson
Architecting communication between microservices is a vital decision to be made when building scalable, sustainable software. In this tal...
New
axelson
by @SophieDeBenedetto LiveView’s reliance on server-rendered HTML and leveraging of bi-directional communication over WebSockets means ...
New
axelson
ElixirConf 2018 – Day 2 Opening Keynote – Justin Schneck (@mobileoverlord) All talks thread:
New
CodeSync
Code Sync: Vaxine, the Rich CRDT Database for ElixirPhoenix Apps | James Arthur | Code BEAM America 2022 Comments welcome! View the #cod...
New
axelson
ElixirConf 2017 - The Power of Zero - Andrew Forward Automation is hard, but the benefits can be phenomenal....
New
CodeSync
Code Sync: Fast IP Address Matching in Elixir (…) & Persistent Term | Michael Lubas | Code BEAM America 2022 Comments welcome! View ...
New
New
derpycoder
QUIC protocol support coming to BEAM. As of now, I am using Caddy in front of Phoenix server to experience HTTP/3 goodness.
New
kokolegorille
Lonestar Elixir 2018 videos are starting to pop up :slight_smile: https://www.youtube.com/channel/UCOy-_b9bqjokoWX9Hg5ZgUg Day 1 Chris ...
New
axelson
by @jola Can you write a performant string processing scripts in Elixir? This talk attempts to answer that question while incrementally...
New

Other popular topics Top

Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
joaquinalcerro
Hi there, I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 record...
New
Harrisonl
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service. Currently when I de...
New
vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
script
If I have a string “1000 cfu/ml” . I want to remove the characters and / and space . So the string is like this "1000" What is the ...
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New
fireproofsocks
Forgive me if this is obvious, but how does one delete a database record WITHOUT selecting it first? https://hexdocs.pm/ecto/Ecto.Repo.h...
New
AstonJ
We’ve put together this wiki for Phoenix LiveView - please feel free to add any info you feel is worth including. What is Phoenix LiveV...
New
lanycrost
Hi everyone! I need implement if…else if…else condition from my elixir code, and anymore of this control flow structures not work proper...
New

We're in Beta

About us Mission Statement