Hachyderm.io

1 post1 participant0 posts today

Ein Philosophiker<a href="https://genserver.social/users/ThinkingElixir" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@ThinkingElixir</a> I urgently need stickers! <a href="https://social.saarland/tags/Elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Elixir</a> <a href="https://social.saarland/tags/Phoenix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Phoenix</a> <a href="https://social.saarland/tags/Ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Ecto</a> at least

Ein PhilosophikerRebuilding everything in order to apply a migration to a database is so '90s when you already have <a href="https://social.saarland/tags/Ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Ecto</a> in mind... 🙄 <a href="https://social.saarland/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Microsoft</a> <a href="https://social.saarland/tags/EfCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EfCore</a>

T0haEcto’s fragments still feel like ElixirBut what I also really love is that if I want to eject out and write plain SQL for a specific part, it still feels like Elixir, because everything else stays the same—it’s just a tiny fragment/1 that uses safe variable interpolation. And it turns out that Ecto.Tags: <a href="https://mastodon.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a>, <a href="https://mastodon.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>, <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a>via Pocket <a href="https://ift.tt/BVUuop1" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ift.tt/BVUuop1</a>February 17, 2025 at 06:25PM

T0haOptimizing batch operations with EctoWe had a feature in a product that required us to insert and update lots of data on a user action. Here is how we transformed 1000 SQL queries into 1. The way the code is structured is simple: An operations table and a translations table.Tags: <a href="https://mastodon.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a>, <a href="https://mastodon.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>via Pocket <a href="https://ift.tt/DeLJXAa" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ift.tt/DeLJXAa</a>February 11, 2025 at 11:42AM

T0haEcto Datetime With Time ZoneWhile implementing a feature to store event dates, I stumbled upon what I initially thought was a straightforward task: saving future dates in a database along with their time zones. How hard could it be, right? Turns out, it’s not so simple.Tags: <a href="https://mastodon.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a>, <a href="https://mastodon.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>, <a href="https://mastodon.social/tags/elixirlang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixirlang</a>via Pocket <a href="https://ift.tt/THrBwKm" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ift.tt/THrBwKm</a>February 03, 2025 at 05:07PM

T0haSearch Filters with Ecto QueriesWe have also written an accompanying Livebook for this article that includes the final code for you to play around with.Tags: <a href="https://mastodon.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a>, <a href="https://mastodon.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>, <a href="https://mastodon.social/tags/liveview" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#liveview</a>, <a href="https://mastodon.social/tags/myelixirstatus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#myelixirstatus</a>, <a href="https://mastodon.social/tags/phoenix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#phoenix</a>via Pocket <a href="https://ift.tt/NR2p0El" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ift.tt/NR2p0El</a>January 30, 2025 at 11:15AM

MaikelLatest and greatest episode about Schemas in Ecto <a href="https://www.twitch.tv/videos/2329133372" rel="nofollow noopener noreferrer" target="_blank">here</a> and the updated summary <a href="https://notes.maikel.dev/Learning/Book+Summaries/Programming+Ecto+by+Darrin+and+Eric" rel="nofollow noopener noreferrer" target="_blank">here</a> I'm using Sharkey for this toot because it has markdown, we're not savages this side of the fedi. <a href="https://blahaj.zone/tags/Ecto" rel="nofollow noopener noreferrer" target="_blank">#Ecto</a> <a href="https://blahaj.zone/tags/Elixir" rel="nofollow noopener noreferrer" target="_blank">#Elixir</a> <a href="https://blahaj.zone/tags/Schemas" rel="nofollow noopener noreferrer" target="_blank">#Schemas</a>

SenAnd this!<a href="https://www.youtube.com/watch?v=tmInKl7-6DM" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://www.youtube.com/watch?v=tmInKl7-6DM</a><a href="https://hachyderm.io/tags/Elixir" class="mention hashtag" rel="tag">#Elixir</a> <a href="https://hachyderm.io/tags/Ecto" class="mention hashtag" rel="tag">#Ecto</a>

SenI really wish I had these steps when I was getting started with <a href="https://hachyderm.io/tags/Ecto" class="mention hashtag" rel="tag">#Ecto</a> and wanted to use <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="tag">#SQLite</a> in an <a href="https://hachyderm.io/tags/Elixir" class="mention hashtag" rel="tag">#Elixir</a> project.<a href="https://sensen.dev/posts/create-new-elixir-project-with-ecto-and-sqlite/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://sensen.dev/posts/create-new-elixir-project-with-ecto-and-sqlite/</a>

Peter SolnicaSentry tracing for Elixir/Phoenix/Ecto update:✅ Live view traces ✅ Ecto db statements in tracesGetting there!<a href="https://hachyderm.io/tags/MyElixirStatus" class="mention hashtag" rel="tag">#MyElixirStatus</a> <a href="https://hachyderm.io/tags/observability" class="mention hashtag" rel="tag">#observability</a> <a href="https://hachyderm.io/tags/phoenixframework" class="mention hashtag" rel="tag">#phoenixframework</a> <a href="https://hachyderm.io/tags/ecto" class="mention hashtag" rel="tag">#ecto</a> <a href="https://hachyderm.io/tags/elixir" class="mention hashtag" rel="tag">#elixir</a>

BonfireNeedle also comes with two other homegrown libraries: needle_ulid which provides a ULID datatype for Ecto (using ex_ulid) and related helpers, and exto which enables extending Ecto schema definitions in config (especially useful for adding Mixin associations to different schemas)… --- 📣 🏴‍☠️ Camp! expedition: We have some open bounties to improve bonfire performance : Read more: <a href="https://indieweb.social/@bonfire/112943944096656953" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://indieweb.social/@bonfire/112943944096656953</a> Repository: <a href="https://github.com/bonfire-networks/bounties" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/bonfire-networks/bounties</a> <a href="https://indieweb.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a> <a href="https://indieweb.social/tags/myElixirStatus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#myElixirStatus</a> <a href="https://indieweb.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a> 6/6

BonfireBesides regular schemas with universal foreign keys (Pointable), Needle provides Virtual for schemas that don’t have any fields on their own, and Mixin for storing common fields that can be re-used by multiple Pointables or Virtuals (eg. if you have multiple types that all have a name/description/body, they can share those and optionally the associated changesets and other logic).<a href="https://indieweb.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a> <a href="https://indieweb.social/tags/myElixirStatus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#myElixirStatus</a> <a href="https://indieweb.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>5/6

BonfireBut what if you don’t just have posts that can be liked, but also videos, images, polls, etc, each with their own table, but probably do not want to have to add liked_video_id, liked_image_id, ad infinitum?We needed the flexibility to have a foreign key that can reference any referenceable object. We call our system Needle.<a href="https://indieweb.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a> <a href="https://indieweb.social/tags/myElixirStatus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#myElixirStatus</a> <a href="https://indieweb.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a> 4/6

BonfireA simple example would be a blogging app, which might have a post table with author field that references the user table.A social network, by contrast, usually requires a graph of objects, meaning objects need to be able to refer to other objects by their ID without knowing their type.A simple example would be likes, you might have a likes table with liked_post_id field that references the post table.<a href="https://indieweb.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a> <a href="https://indieweb.social/tags/myElixirStatus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#myElixirStatus</a> <a href="https://indieweb.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a> 3/6

BonfireNeedle is an <a href="https://indieweb.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a> library that we have developed to provide universal foreign keys, shared data fields, and virtual & configurable schemas for Ecto.🔗 Read the docs: <a href="https://hexdocs.pm/needle/readme.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://hexdocs.pm/needle/readme.html</a> 💬 Join the discussion on Elixir Forum: <a href="https://elixirforum.com/t/needle-universal-foreign-keys-shared-data-fields-virtual-and-configurable-schemas-for-ecto/65644" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://elixirforum.com/t/needle-universal-foreign-keys-shared-data-fields-virtual-and-configurable-schemas-for-ecto/65644</a><a href="https://indieweb.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a> <a href="https://indieweb.social/tags/myElixirStatus" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#myElixirStatus</a> 1/6

AdrianC<a href="https://vmst.io/@maikel" class="u-url mention">@maikel</a> yeah! If you’re interested in more Ecto stuff, Dashbit wrote a « Little Ecto Cookbook » <a href="https://dashbit.co/ebooks/the-little-ecto-cookbook" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://dashbit.co/ebooks/the-little-ecto-cookbook</a> too btw<a href="https://hachyderm.io/tags/MyElixirStatus" class="mention hashtag" rel="tag">#MyElixirStatus</a> <a href="https://hachyderm.io/tags/Elixir" class="mention hashtag" rel="tag">#Elixir</a> <a href="https://hachyderm.io/tags/Ecto" class="mention hashtag" rel="tag">#Ecto</a>

T0haSoft deletes with Ecto and PostgreSQLOne of our clients at Dashbit has recently asked us what is the best way to implement soft-deletes with Ecto.Tags: <a href="https://mastodon.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a>, <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a>, <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a>via Pocket <a href="https://ift.tt/gXvkM12" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ift.tt/gXvkM12</a>August 16, 2024 at 06:02PM

T0haHow to update multiple records with different values in Ecto.Repo.update_allIn this particular case, I was dealing with a table that leveraged parent_id to model a basic parent-child hierarchy. Through some larger business logic, I end up with a list of tuples [{1, "new root"}, {2, "Child 1"}, {3, "Child 2}] that essentially maps id => new name.Tags: <a href="https://mastodon.social/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a>, <a href="https://mastodon.social/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>, <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a>, <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a>, №удшчшкvia Pocket <a href="https://ift.tt/5zNAP0i" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ift.tt/5zNAP0i</a>August 09, 2024 at 02:54PM

Alejandro BaezI been slowly utilizing <a href="https://fosstodon.org/tags/prql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#prql</a> instead of raw <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a>. 😅 So far, it makes sense when doing analytical jobs. But for language support, it is far more natural to use DSL features made for languages like <a href="https://fosstodon.org/tags/ecto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ecto</a> in <a href="https://fosstodon.org/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elixir</a>. 😎<a href="https://prql-lang.org/book/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://prql-lang.org/book/</a>

Paweł ŚwiątkowskiNew blog post: Improving upserts in Ecto and PostgreSQL (Ab)using database internals a bit to learn what my upsert just did. <a href="https://katafrakt.me/2024/06/04/improving-upserts-ecto-postgresql/" rel="nofollow noopener noreferrer" target="_blank">https://katafrakt.me/2024/06/04/improving-upserts-ecto-postgresql/</a> <a class="hashtag" href="https://genserver.social/tag/elixir" rel="nofollow noopener noreferrer" target="_blank">#Elixir</a> <a class="hashtag" href="https://genserver.social/tag/ecto" rel="nofollow noopener noreferrer" target="_blank">#Ecto</a> <a class="hashtag" href="https://genserver.social/tag/postgresql" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a>

Recent searches

Search options

Administered by:

Server stats:

#ecto