How can I setup prisma to use an external database...
# prisma-whats-newe
eli
02/02/2018, 1:20 AMHow can I setup prisma to use an external database, like aurora?
👍 1
n
Nick Luger
02/02/2018, 7:04 AMI started looking in the src code for production ymls, but found only a dev setup, that references the internal database setup in a docker container. I also hope to use it with RDS/Aurora - i mean running the DB dockerized in production is not a serious option. @nilan wrote me, that i would be actually be supposed to host the DB on my own while i can leverage Prisma Cloud, so i assume it is possible to point it to the external DB!
m
max
02/02/2018, 9:52 AM@Nick Luger " i mean running the DB dockerized in production is not a serious option" why is it not a serious option?
n
Nick Luger
02/02/2018, 9:54 AMNick Luger
02/02/2018, 9:55 AMNick Luger
02/02/2018, 9:56 AMAlso we are talking about DB and Prisma being bundled into one multi-container docker application. How does this work if i would run multiple instances of Prisma?
Nick Luger
02/02/2018, 9:58 AMFor example i run 6 instances of Prisma and want 4 read replicas of my MySQL DB.
Nick Luger
02/02/2018, 10:17 AMWhat's your opinion on that @max? Do you need to run a dedicated Prisma instance or Prisma cloud with your own DB?
m
max
02/02/2018, 10:24 AMI've been posting on the forum as meep. So you've seen my post here: https://www.graph.cool/forum/t/advice-on-best-practise-deploying-production-graphql-yoga-server-w-prisma-on-the-public-cluster/2348/11I've never used docker or setup a db before. 6 years ago I used to be a java dev working on proprietary encryption management systems (military grade). And I only got back into programming (React, JS, Typescript, GraphQL
max
02/02/2018, 10:25 AMand now Prisma within the last year. I was hoping graphcool would mean I wouldn't need to host my own db. So at the moment waiting for prisma cloud t come out and I can pair that with apex/up + AWS lambda to host my graphql-yoga server
max
02/02/2018, 10:25 AM@Nick Luger
max
02/02/2018, 10:28 AMI was going to use the prisma cloud for everything (prisma + db). I'm realizing now (a little too late) that relying on a start-up is tricky
max
02/02/2018, 10:28 AMshould have used a batteries-included framework like django
max
02/02/2018, 10:29 AMelse I if I really needed to I guess I could migrate my graphql-yoga server and use a different db. It'll just be a lot of learning. Maybe use Aurora
max
02/02/2018, 10:31 AM@Nick Luger did you see rohanray's post regarding memory usage of his prisma docker container on digital ocean. Keeps maxing out memory
n
Nick Luger
02/02/2018, 10:31 AMI'm writing a longer answer, one moment 😂
n
nilan
02/02/2018, 10:32 AMjust a quick comment before I have a closer look, it's really difficult to keep track of all the different discussions 🙂 I would prefer to keep one discussion in one place, and I suggest to use the forum thread @max linked above. I think this is a super interesting topic and appreciate all your input!
n
Nick Luger
02/02/2018, 10:34 AMOk, as @nilan suggested, i will write a response to this in the post, @max!
n
nilan
02/02/2018, 10:34 AMn
Nick Luger
02/02/2018, 10:41 AMThank you @max 😁max for porting the thread was just doing the same !
m
max
02/02/2018, 10:41 AM@nilan @Nick Luger I've updated the thread with our comments 🙂
max
02/02/2018, 10:41 AMoh
n
Nick Luger
02/02/2018, 10:41 AMGreat!
n
nilan
02/02/2018, 10:45 AMthanks, will chime in later today 🙌
n
Nick Luger
02/02/2018, 11:25 AMDear @max, posted you a response in the forum
m
max
02/02/2018, 12:15 PM@Nick Luger good post. Just replied
l
lawjolla
02/02/2018, 4:10 PM@Nick Luger and @max great posts and discussion. I have the same 4 options, though I've already done 3 -- hand-wrung a GraphQL server on Elixir with Absinthe. That experience brought me here. Please keep the dialog going
m
max
02/02/2018, 4:11 PM@lawjolla how did you find creating a GraphQL server on Elixir with Absinthe?
max
02/02/2018, 4:12 PMthe other idea I'm thinking through is putting a
graphql-yogagraphcool-frameworkl
lawjolla
02/02/2018, 4:15 PMA mixed bag. Ben and Bruce (Absinthe creators) are about as smart, hands on, and helpful as anyone in OSS. I think Elixir is mostly brilliant (lack of explicit imports and overuse of metaprogramming / macros drove me nuts). The pain came through the tie in to Ecto, Elixir's blessed ORM (though they don't call it that for snotty functional programming reasons 🙂). As ORMs go, it's good -- even great -- I just don't like ORMs. My other issues were the extreme amount of boilerplate, endless db migrations, and slow GraphQL development (it's just two guys, can't expect much). That said, most of those last three reasons are present in every GraphQL landscape
lawjolla
02/02/2018, 4:16 PMSince Absinthe is not fully featured yet, I realized that my entire business would depend on two guys developing in their free time. Not a great spot. So for all of those reasons, I went hunting
lawjolla
02/02/2018, 4:22 PM@max you could do that, though it would be painful to go through that effort, essentially duplicating Graphcool's work, only to see Prisma (likely) smooth the bugs out
m
max
02/02/2018, 4:35 PMthanks for the detailed answer. Yeah I hear that the amount of boilerplate in graphql is often quite significant. This is where prisma is fantastic so fingers crossed they can stablise it and get prisma cloud released
4 Views