vonH
I have a simple relational database structure I want to do simple CRUD operations on.
Open the database, create a new record, open a result set, scan for those I want, update or delete them. If anyone has used the ADODB in PHP they will understand what I want. I have taken a look at Ecto, but what I have seen seems too complicated for what I need, or it may because the examples don’t focus on my immediate use case.
I have seen something that seems to fit the bill - GitHub - robconery/moebius: A functional query tool for Elixir · GitHub - which seems to fit the bill but only works for Postgres. If there is something similar which deals with multiple databases that will be better, as Postgres is overkill for what I want to accomplish. Something like moebius that handles SQLite will be better.
Is there some guide to ecto that teaches how to do the simple actions above on an existing database? It is a small database which is only expected to handle a few 1000 records, so if I am using ecto I am hoping ecto can inspect the schema and create its own schema code from it, like Django’s South.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Elixir, Erlang & messaging conferences from Code Sync. Next up: ElixirConf US (10–11 Sep) & Code BEAM Europe (21–22 Oct), Haarlem + online.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Producing high quality Elixir screencasts since 2017.
**Building the future of software with AI, trust, and human connection.**
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
karmajunkie
Per the Ecto docs, you can use the
Ecto.Adapter.SQLmodule to run SQL directly:In addition to
moebius, there’s also this project that looks interesting to me: GitHub - fazibear/defql: Create elixir functions with SQL as a body. · GitHub. I’ve gone so far as to install it but I’m not using it for anything so I can’t give much of a review of it.OvermindDL1
Also ecto does not require schema’s, that is only for having compile-time checks, schema-less is fine.
The only thing ecto cannot really do is do queries cross-prefix’s, which is a major stumbling block in some cases.
But worst case, it has an execute function for executing the raw SQL.