Does prisma have the “cloud” feature still? That it also sets up Heroku?

Inspect all queries going to the database with

Prisma Query Inspector

, formatted for enhanced readability and accompanied by all params and time each query took. Soon there will be a feature that allows you to copy a full query with it's params ready to execute. npm :`npm install prisma-query-inspector --save-dev` yarn:

yarn add prisma-query-inspector --dev

Make sure to follow the steps in the README. Repo: https://github.com/omar-dulaimi/prisma-query-inspector

For React users out there -- published a pretty minimalistic package. expose JSX.IntrinsicElement Props for consumption/conditional consumption/forwarding for dynamic use globally (could use the props with state, memoization, context, and/or lifecycle methods too); https://www.npmjs.com/package/unwrap-react

An original dev joke our team coined today during the meeting, hope you like it 😄 https://twitter.com/WaspLang/status/1509183709173460993

Congrats on mongodb!

Hi guys! how can I remove this array and make it like a json object?

hello

help Error: Unknown binaryTarget debian-openssl-3.0.x and no custom binaries were provided on Ubuntu 22.04

@prisma/engines/migration-engine-debian-openssl-1.0.x --version

I have been suffering for 3 days with your invention, who will explain to me what the library has to do with OS and openssl, how they are connected and why you cannot give a specific answer what to do ???? Do you think I will wait 3 years until you fix the code, although what kind of code it finally has nothing to do with what general place the library for openssl

For people who use Joi for validation, you're going to love this! I built a new Prisma generator that allows you to automatically generate full Joi schemas from your Prisma schema! It also updates every time you run

npx prisma generate

So it's really useful, and gonna save you a lot of time when building APIs and other stuff. Check it out here:

<https://www.npmjs.com/package/prisma-joi-generator>

Now we(Prisma community) have generators for Joi, Yup and even Class Validator! I have just published the last one a few minutes ago. You can check them out here: https://github.com/omar-dulaimi/prisma-joi-generator https://github.com/omar-dulaimi/prisma-yup-generator https://github.com/omar-dulaimi/prisma-class-validator-generator

Hey I'm not sure if this is the right channel, but I'm kind of looking for suggestions around the ci/cd for deploying prisma.

Prisma is a utility, it requires the same special deployment requirement as express would 🤔

ubuntu 22.04

Error: Unknown binaryTarget debian-openssl-3.0.x and no custom binaries were pro vided

Hey guys, could someone help me to understand how to write unit tests for functions which use

prisma.$transaction

? I created a question on StackOverflow. Update Maybe I'm doing wrong by trying to mock intermediate

Promises

and would be better to mock

prisma.$transaction

itself. What do you think?

A use-case was brought to my attention by @Richard Ku He wanted a tool to do the opposite of what https://github.com/valentinpalkovic/prisma-json-schema-generator does So, I have built it and just released it minutes ago! You can check it out here: https://github.com/omar-dulaimi/json-to-prisma-schema-convertor Of course, as I mentioned, it only converts whatever that is available in the json schema; so some attributes have to be manually entered like

@relaion

for example, In addition to the datasource and client blocks. As a side note, if you think the Prisma ecosystem is missing something, please let me know, maybe I or we can work on it together 😁.

Hi, does someone have a problem with returning decimal data from the database? It returns string as value in json instead of number 😞

This message was deleted.

Do you know any open-source projects using Prisma?

Been using prisma in a real project this past week.. I'm loving how simple the dev experience is.. great work prisma team :)

I have a model with these 2 properties. When doing

prisma.create

on this model do I need to provide both

createdBy

and

owner

or either of them?

hi I was wondering if anyone knew how to do a groupby on a relation's field? (a table join and then a groupby on a field in the joined table) Or do I have to use a queryRaw to achieve this?

Hi, building a real estate application. I faced a situation where we have the table Homes and Facilities. The facilities will be a fixed set of rows like Kitchen, Pool and etc. And every home can have one or as many of the facilities. Would this be a many to many relationship? (edited)

Hey guys, I’ve got a situation where I want/need to order on fields which are located in a one-to-many relation. Now I’ve read most of the resources concerning Prisma’s current state on this topic, references: https://github.com/prisma/prisma/issues/5008#issuecomment-768444693 https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#sort-by-relation One-to-Many For one-to-many relationships, you can order by the relation from one side: ✅ Order posts by their author’s nam ⛔ Order authors by their post’s title

model Author {
  id Int @id
  name String
  posts Post[]
}

model Post {
  id Int @id
  title String
  author Author
}
prisma.post.findMany({
  orderBy: [{
    author: {
      name: 'asc'
    }
  }]
})

So my problem (looking at the above example from the github issue) is that I actually DO want to order the authors on the post’s titles. And I was wondering in what ways I could achieve besides just using raw queries, which I obv. want to avoid.. Any help or advice is welcome! prisma green💌

This message was deleted.

Hello all, I would like to announce that I have just released

Prisma Zod Generator

You can find it here: https://github.com/omar-dulaimi/prisma-zod-generator It's different from the existing

zod-prisma

generator in that it generates full CRUD schemas; not just models schemas. So, it will be really useful to use in your API validations. Zod is an awesome new validation library in case you don't know, I think you're going to like it!

Hey everyone! For those who want type-safety across the whole stack, without the need to manually generate types, you should check tRPC. It works with React, Next.js, etc. To make things simpler for Prisma users, I built a generator that handles generating fully implemented routers with all their zod schemas for you. you can check out the generator here: https://github.com/omar-dulaimi/prisma-trpc-generator This is something really cool, and I'm proud I managed to build it!