If I want to work with a date attribute as part of my model, would you suggest just storing it as a string or store it as a DateTime (I don’t need the time part)

Hy guys. I have run the followings command:

npm i --save-dev prisma

npm i @Prisma/client

. But still have 2.15 version. Why can this happen?

hello, is there any way to customize the location of the migrations directory?

i dont see any CLI options for it but wondering if it's an undocumented feature?

Hey all, tomorrow at 6 PM CET we are hosting our open mic Advanced TypeScript Trickery meetup. typescript The link to the Zoom call will be shared tomorrow, so RSVP here. Hoping to see you there! 🤗

anyone have tips on getting started writing unit tests that involve prisma? ideally with jest

Anyone have a decent approach to omit certain fields from Prisma/Express?

Hi all! 👋 We recently released two new video guides which are relevant to topics from the 2.16 release. Create Many The first is regarding the new

createMany

method. The video will walk you through how to use it in the context of database seeding: Prisma CLI The second is about the package name change for the Prisma CLI. As you may have seen, you should install the CLI using the package of

prisma

going forward. This video explains the details:

I just noticed a patch release v2.16.1 https://github.com/prisma/prisma/releases/tag/2.16.1 This fixes a problem some users are having with certain Docker, MariaDB, MySQL or SQL Server configurations, preventing Prisma to connect with localhost. A recent Docker update caused a regression related to IPv6 and name resolution.

👋 Hey! New to the slack, love Prisma. I’m using Prisma Migrate to maintain our database migrations. Has anyone done a migration to move a foreign key from one side of a 1-1 relationship to the other model? Ideally this is straightforward, but it looks like I’d have to do a manual migration which is pretty tricky

Hi! Is it possible to see raw prisma queries that are being run against the db?

I'm using the go client

For some reason this query is failing with

time out of range

Is there some way to update an optional DateTime to

now()

? Can't use

@updatedAt

since there's nothing else to update. Currently I'm setting it to

new Date()

but that comes from the client which might be not in sync with the server's time.

Hey all, In 15 minutes we’ll be hosting a live stream on load testing as part of a series on Prisma in production.

If I had a model that had relationship (1-m)... is there a way to query count of M and if I am one of those? I guess what is the most efficient way to deal with the following problem? I have a

Post

that has relationship to many

Likes

- When retrieving many posts... what is the most efficient way to see how many likes its got and if you are on of those likes. Seems like you would need several queries? Does anyone have an example of the most performant way to do this?

guys i was doing the tutorial and find this, i think the correct is 'apollo-server'. I dont know where to report

Just found this beautiful write-up by Reed Barber on freeCodeCamp about Building a YouTube Clone with React (+ Prisma handling the data layer) : https://www.freecodecamp.org/news/build-youtube-with-react/

👋 I just launched my new premium SaaS product boilerplate, Bedrock! 🎉https://bedrock.mxstbr.com It comes with Prisma prisma dark & Nexus nexus in combination with TypeScript typescript, GraphQL Codegen graphql and urql already preconfigured to perfection, so I figured y'all would enjoy it 😉 If you have any questions about it, feel free to ping me here — I'm around!

Are nested selects supported/planned? I can include the relation and filter it on the client, but a 'select as' would be nicer.

Hello everyone. Is it possible to instruct the prisma CLI to generate TS string enums instead of string unions types for enums?

Hey guys, is it possible to run a prisma migration and pass the database URL as a cli argument?

ERROR: Error parsing connection string: Conversion error: Invalid JDBC token in ... `sqlserver://SQLAM11,4411;database=MDD_Test;user=app_user;password=Xx/Xx/Xx' I get this error when running: npx prisma introspect I do NOT get this error when running: npx prisma generate schema.prisma: generator client {   provider        = "prisma-client-js"   previewFeatures = ["microsoftSqlServer", "nativeTypes"] } datasource db {   provider = "sqlserver"   url      = env("DATABASE_URL")   }

I tried pushing my nextJs site to vercel and it failed with some error saying: Error: @prisma/client did not initialize yet. Please run "prisma generate" and try to import it again. Is this not somehow done automatically, or how to do I make vercel do it? it also said check out this url, which wasn't too helpful: https://github.com/prisma/prisma-client-js/issues/390

Hi. I'm about to migrate one app from prisma 1 to prisma 2. As I have failed to recreate production prisma server with database on my localhost to do a test migration, I will try a different approach. I have currently three services on prisma server. Postgres schemas in one dbs (just like Prisma 1 generated it) •

app_1/prod

(The one we are migrating along with the one below) •

app_1/dev

(yes, im usually developing the app while accesing the remote prisma server, not localhost prisma) •

app_2/prod

(This one will probably stay forever on Prisma1) My idea is to do the migration on

app_1/dev

and if everything goes smooth, do the same on

app_1/prod

My questions: Is this a good approach, or should i try once more to recreate the prisma server on localhost? And the most important question: While doing migration work on the

app_1/dev

schema, will the other schemas in db be affected by it? Will anything collide? What about the

management

schema? Anything to worry here while doing the migration in that way? Thanks!

👋

👋 Hey quick question on using Prisma with nextjs. I see a lot of examples using the PrismaClient directly in getServerSideProps. I am wondering how this is secure since getServerSideProps is sometime ran on the client side. Doesnt this mean our DB is exposed on the frontend?

Hello guys. I am looking for some solution to add cache to the backend. I am using nexus with prisma. I found that my queries are quite heavy and with 500+ concurrent requests response time is more than 10 seconds. Any way I can add redis cache or memcache? Cannot find any solutions

Hey all. It would by great to pick anyone's brain who has managed to successfully implement Prisma1 and extended it to support GraphQL unions and interfaces?