Blog

SQL

4 blog posts

Posted on Dec 3, 2016 by Alexej Bondarenko

In this blog post, you will learn how to create simple seed data for your Yesod application. Such seed data can be useful during development or if you plan to run your tests against test data.

Posted on Nov 22, 2016 by Alexej Bondarenko

Adding, modifying and removing records in a database (like Postgres) is a very common use case. Usually we perform single actions to a single record. In this tutorial we would like to show how to perform a set of actions in one transaction, so all of them are applied or none in a case of failure.

Posted on Nov 12, 2016 by Alexej Bondarenko

Postgres is a fantastic database, even in times of any hyped NoSQL solutions. At Ersocon we often use Postgres as our core database and extend applications according to new needs. In this tutorial we will cover how to easily set up a Postgres database for development with Vagrant.

Posted on Sep 29, 2016 by Alexej Bondarenko

The Yesod book contains only sparse information on how to handle relations. In many cases only 1:n relations are used, which are easy to understand and to load. In this blog post we will have a look at m:n relations and how to load related content with the Esqueleto library.