I made another libcluster strategy, a simple database backend one :)

https://hex.pm/packages/libcluster_db
#myelixirstatus #elixir #ecto

@bmarinov That's exactly what I was trying to do! #Ecto from #Elixir is the best ORM I've ever seen, and part of what makes it great is that migrations, schemas, objects, changes, and validation are all separate and independent components. But again, I can't quite make it work (at least in a type safe manner) in #golang.

Upcoming Ecto feature: Data-modifying CTEs in PostgreSQL.
And I have a story on how I used them to mitigate OAuth Refresh Token Replay attacks https://medium.com/@mpotra/repel-oauth-refresh-token-replay-attacks-with-elixir-and-ecto-1ac5c6d2495b
#MyElixirStatus #OAuth #Ecto #Elixir

@tylerayoung yes! They even have `tap` function in `Kernel`.

My feeling that the ecosystem around it (most of which is also made by core team) like #Ecto and #Phoenix is the exact opposite off that quote though.

But yeah, a huge fan of most of stdlib (except for Enum).

My adventures into #MongoDB via #Postgres nearly ground to a halt since boolean query expressions were not fully supported until a recent version (https://github.com/EnterpriseDB/mongo_fdw/issues/58#issuecomment-1569464315 ) which I don’t think #CrunchyBridge are use yet but then #Ecto query fragments (https://hexdocs.pm/ecto/Ecto.Query.html#module-fragments) came to the rescue.

In Postgres, “WHERE ‘active’ = false” doesn’t work but “WHERE ‘active’ is false” does but Ecto’s queries become the former.

My fragment is:

“where: fragment(“? Is false”, d.active)”

#MyElixirStatus

Happy Ghostbusters Day everyone !
Ich habe keine Angst vor Gespenstern.....

#ghostbusters #ghostbusters2 #ghosbustersafterlife #ghostbustersfirehouse #yhspodcast
#ghostbustersday #venkman #ecto #slimer #spengler #zeddemore #firehouse #filming #movienews #staypuft

I’ve never really done this before but it is so lovely and easy to prototype a database schema in #Ecto via migrations.

I’ve just been working on a major database design change and had a lot of small migrations that tweak and fix things after the tables were created. Being able to rollback migrations to various points, refactor and re-apply them means I have fewer, cleaner, and more readable migration scripts.

#MyElixirStatus

⚗️ Under the Hood of Ecto
— Sapan Diwakar
#Elixir #MyElixirStatus #Ecto
https://dev.to/appsignal/under-the-hood-of-ecto-n1a

And the last talk of the Erlang/Elixir devroom, "Dealing with a Monster [#Ecto / daabase] Query",
a story of Elixir & optimization by Mackenzie Morgan

(Yet another talk with Beamer slides)

Max requsts/s : 700 % improvment

Yeah, sex is cool, but have you ever tried swapping out #Ecto changesets for plain old structs in performance critical #Elixir code?

Congrats to author Peter Ullrich
@pul, whose book, Building Table Views with Phoenix LiveView, is now out of beta and fully released.

https://pragprog.com/titles/puphoe/building-table-views-with-phoenix-liveview/

#elixir #data #tables #ecto #erlang #phoenix #liveview

@darius

Maybe you might look in combining efforts with #Ecto cc @weex ?

David is exploring Hintjens C4 approach to Ecto development, see: https://magicstone.dev/why-c4

@nolan @baldur

FYI @RyunoKi and I followed-up with some further thoughts on the Social Coding forum:

https://discuss.coding.social/t/foss-dynamics-from-joy-of-coding-to-duty-and-burdens/234/2

I wrote about validating request params in #elixir #phoenix with #ecto https://0x7f.dev/post/validating-pheonix-with-ecto/

#myelixirstatus

:blobwizard: Complex queries with Ecto
— Lucas Cegatti
#Elixir #ElixirLang #Ecto Ectohttps://dev.to/lucascegatti/complex-queries-with-ecto-3gp9

Me last week: why would you use #duckdb? This is dumb. There's so many ways you can do what it does.😑

Me this week: so I figured I could use #duckdb to parse #parquet data for #elixir without having to write a line for a parquet lib in elixir.🤯 All using #ecto. 🙌

I will fight you to death if you say not to use duckdb now. 😛

I also play around with #elixir #liveview #phoenix. Actually I am more the #erlang syntax fan. Now I have a project without #ecto. Can I add this later to a simple project? Or do I have to create a completely new project again? Thought something like this would be easier.....🤔

https://dev.to/tylerlwsmith/creating-a-text-column-using-ecto-in-elixirs-phoenix-framework-39im

#elixir #ecto

Every single time I have to touch the fucking #Phoenix / #Ecto stacks it wastes a ton of my time and fills me with infernal rage.

Wanna run hermetic postgres instead of systemwide? Fuck you, user, we know better! State dump in error messages? Nah.

Seriously, CTOs who allow #Ecto in their stack are very-very wrong.

Finally learning #ecto with postgres... I'll already say that my 2023 goal will be "become a #phoenix expert." Hopefully I won't drop it after just 2 weeks :blobcatgrimacing:

Today I learned about

mix ecto.dump and mix ecto.load

thanks to @whatyouhide

https://andrealeopardi.com/posts/get-rid-of-your-old-database-migrations/

Very useful!

#myElixirStatus #ecto