A quick introduction to which database index types are right for the task at hand in Postgresql.
Search through user-provided HTML content with PostgreSQL and Active Record.
could not connect to server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket?
Scheduling, recurring events and relative dates have always been hard. Until now.
The right tool for the right job, right? Well let me introduce you to psql.
Structs and maps are easy to work with in Elixir, but if they are stored in the database as JSON and accessed via an Ecto Schema, it’s not as clear how to query them. We’re going to explore how to do that, and make it clear and easy.
You can use PostgreSQL’s JSON data types to store embedded data on Ecto models. But the way Ecto tells you to store it might not be the best way.
Use interval and date_trunc to make working with SQL dates easier.
How to find the oldest or most recent record associated with a particular foreign key.
Write queries that combine data from multiple sources.