I have a categories table. every category has some posts. I want to get categories with their last 10 posts. So I tried this: Category::query()->with(['posts' => function($q) { $q->take(10); }])->get(); The problem is instead of putting 10 posts in each…
I'm doing a dental function, I'm looking to sync data in a many-to-many relationship. I have the following: tooth - id - name cost - id - name cost_tooth - id - tooth_id - cost_id - row_number This is the…
I noticed that a query that used to be fast in legacy version of Django is now much slower in 4.0.8. There is a fairly large table with a FK 'marker' and a boolean 'flag' that has an index attached.…
I have a User Model and Country Model, and Country belongs to User. I am getting users with country using User model with "with()" method, in different controllers & methods. Users::with('country')->get(); in different controllers. I want Users::get(); It should automatically…
I've been reading through the documentation at Laravel's website but struggling to piece this all together. We have users who can be assigned to specific roles and/or teams at different times. For example, User A could be assigned to Team…
I'm trying to filter vacations by date range, but I don't know how to do it. Please help. Database: postgresql Backend: nestjs + prisma orm (4.0.0) Frontend: React The data about vacations is stored in the database in this form:…
Suppose I want to keep who follows who in a simple table that has two fields ; UserId and FollowedId and I have a simple data set like ; UserId FollowedId 1 100 2 100 3 100 4 100 5…
I've already checked the other answers for this scenario on SO,but unfortunately non of them seem to be working for me. I'm using the following dependencies: Mongoose: ^5.11.97 Typescript: ^4.7.4 I have a transactions collection which holds the trxValue property…
I have been running MongoDB (5.0.7) for a number of years with Hibernate ORM & OGM. Currently using 'org.mongodb:mongodb-driver-core:4.6.0'. (2022.04.26) Using WildFly 26.1.0.Final (Jakarta EE 8 Full) with OpenJDK 18.0.1. IntelliJ IDEA 2022.1, Gradle 7.4.2 & macOS Monterey 12.3.1. I…
I have a node.js project with prisma as ORM that connects to postgresdb. After I installed dependencies with yarn install I tried to run command npx prisma generate then I got error stating Unable to require(/node_modules/prisma/libquery_engine-debian-openssl-1.1.x.so.node) libssl.so.1.1: cannot open shared…