collegeimprovements
MSSQL support for ecto-3
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.
Most Liked
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.
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 
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Enabling companies to succeed by building software people love.
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
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
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.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
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!"