Skip to content

Details

Since we had such a great time together with our friends at Elixir Sydney, we're going to keep our combined Elixir Australia meetup going, at least while we're all still locked down.

We start later on in an attempt to accomodate all our Elixir friends around Australia's timezones, so we would like to especially encourage talk submissions from outside MEL/SYD/Australia!

This month, we've got two great talks, live via satellite from Brisbane and Wellington, New Zealand, both talking about our favourite not-an-ORM database wrapper and query generator, Ecto!

###

5 ways to solve the preload-top-n problem with Ecto 3.4

  • Mike Buhot :: @MikeBuhot

Ecto associations are incredibly useful for working with relational data.
They simplify joins, inserts, and give an easy means to load related records with a query.

There's one problem that hasn't been well supported well until recently: preload the top N items from a has_many association.

In this talk I'll present 5 different ways to approach the problem with ecto, covering some recently added features including:

  • subqueries
  • named bindings
  • lateral joins
  • window functions
  • common table expressions

###

Ecto.Multi: Composable transactions

  • Eduardo Gurgel :: @edgurjas

Ecto.Multi provides a simple interface to compose database operations into a single transaction.

I will present how Ecto.Multi works and how to write tests when using it. I also want to talk about what not to do with Ecto.Multi!

---

A Zoom link for the meetup will be visible beforehand but only if you've RSVP'd. If you don't RSVP then please request the link from an organiser.

Looking forward to seeing you there!

The Elixir Australia team

---

Follow us on Twitter at @ElixirSydney and @ElixirMelbourne!

Want to speak at an Elixir Australia event? Tell us about what you want to present here! https://github.com/elixirsydney/elixirsydney/issues
You can also get a sneak peak of which talks are likely coming up there, too!

You may also like