collegeimprovements
Hi ElixirCommunity,
We have a data-centric elixir project.
Currenlty we are using ecto-3, ecto_sql with postgres and oracle.
We need to fetch a lot of data from mssql but currently there is no adapter ready for ecto-3.
However, there is an adapter which relies on ecto-2 and support mssql.
Is there any way to use that adapter in same project ?
If not, what is the best way to fetch data from MSSQL database and use that data for api-calls or transferring that data to other dbs.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Bringing learning, work and compliance together since 1987.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #ai
- #genstage
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Bringing learning, work and compliance together since 1987.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 4 of 4 Posts
Fl4m3Ph03n1x
If you want to connect to MSSQL, this article may be of relevance to you: GitHub - findmypast-oss/mssqlex: Microsoft SQL Server Adapter for Elixir · GitHub
Once you have a driver that works in place, there are many things you can do. Recently I just heard in Elixir Mix Daniel Serrano using Flow to read in parallel from a DB.
Link to Flow
I also know some people like GraphQL and the author of Search is rather active in this forum, as well as a really nice guy too ! (which I could remember his username, i’m sure someone will!)
So you have quite a number of options, it all depends on how much time you’re wiling to invest.
kokolegorille
The author of the graphql book is @benwilson512
collegeimprovements
Thanks for reply @Fl4m3Ph03n1x,
Our current apis are graphql-apis only
It’s great.
The only problem we are facing is - how to make mssql work!!!
One possible option is to downgrade everything to
ecto-2which doesn’t feel rightAnd I’m unable to make adapter work with
ecto-3andecto-sqlAny example implementation or reference about
ecto-sqlandmssqlortdswould help a lot.Fl4m3Ph03n1x
We don’t use mssql here nor ecto, so I am afraid I can’t be of much help. I did find a couple of articles that may help you out:
If this still doesn’t help, I recommend you create an issue in the github projects and ask the authors for some guidance or examples.
Reading the test files usually helps as well:
https://github.com/findmypast-oss/mssqlex/blob/master/test/mssqlex/query_test.exs