All Questions
1,383 questions
2
votes
0
answers
79
views
How can I efficiently process large PostgreSQL datasets in Node.js without high memory overhead?
I have a Node.js application that interacts with a PostgreSQL database containing millions of users. For a specific feature, I need to fetch around 100,000 users based on a criterion (for example, ...
- 1,091
0
votes
3
answers
70
views
getting NaN value some times and some times not
I get NaN value when I try to show the value of (item.total_amount,item.price,item.addtional_price) in ejs page but when I debug the variables some time I get the value and some time not!!
this is the ...
0
votes
2
answers
74
views
SequelizeModule — autoLoadModels / [Nest] ERROR SequelizeModule Unable to connect to the database. Retrying
I'm learning Nest.js, I'm trying to connect via SequelizeModule to my local postgres database, but I keep getting this error
Error when starting start:dev
[20:41:14] Starting compilation in watch mode....
- 3
0
votes
0
answers
19
views
typeorm trying to delete relation table data when there is no change
I have project entity which has systemInstances. And systemInstance have a manytomany child and parent relation. When I try to update Project entity with same systemInstances, typeorm giving this ...
- 92
0
votes
1
answer
125
views
Unable to order based on joined table with Many to Many relationship
I'm trying to order a set of paged results based on the existence of many to many relationship. I can write a query by hand that does this, but I'm trying to figure out how to do this the sequelize ...
- 1,978
0
votes
1
answer
775
views
No Overload Matches This Call with drizzle-orm and Postgres
I'm working with drizzle-orm to insert data into a PostgreSQL database using Node.js. However, I'm running into the following TypeScript error when trying to insert a post with an authorId that ...
- 90
0
votes
1
answer
107
views
Knexjs pooling - set session variables for a connection
I'm working on a nodejs server using Knex.js to connect to a postgres DB.
On some of the tables I've set some RLS policies based on the current session values (app.user_id and app.tenant_id) to ...
- 138
2
votes
1
answer
96
views
timestamp Vs timestamptz in database postgres
While creating backend of the systems i always store time in UTC that is when client side send any date time, i restrict to only accept UTC date time, the client side convert his local date time into ...
- 687
0
votes
2
answers
416
views
PSQL connection to Node.js issue
So I am able to connect to my psql database through the command prompt using the prompt (psql -h localhost -p 5432 -U postgres -d Luxe-Hotel) and putting in the password but I am unable to connect ...
0
votes
2
answers
814
views
Prisma migration error: "type "serial" does not exist" despite using PostgreSQL 15
I'm trying to run a migration in my Prisma project, but I'm encountering the error "type "serial" does not exist", even though I'm using PostgreSQL 15.8, which should support this ...
- 1,714
1
vote
1
answer
57
views
Fields being overwritten in parent
I have the following query:
await prisma.$kysely
.selectFrom('Product')
.selectAll()
.innerJoin('BrandSupplier', 'Product.brandSupplierId', 'BrandSupplier.id')
.where(({ or, eb, and }) ...
- 2,425
0
votes
1
answer
180
views
'pg' package TypeError: Cannot read properties of undefined (reading 'then')
When I try to run then function on it, it will return this error
TypeError: Cannot read properties of undefined (reading 'then')
at Object.\<anonymous\> (/app/src/index.js:52:2)
at Module.\...
0
votes
0
answers
39
views
Socket.io events in React.js and Node.js not being triggered
I'm building a chat application in React js and Node js. The events that I have written in React.js and Node.js do not seem to be triggered. I can login and see data in both the browser and the ...
-1
votes
1
answer
30
views
Error Selecting data in Postgres using node
This is my get function
const navigate = useNavigate();
const [userData,setUserData] = useState({});
useEffect(()=>{
if(Cookies.get('auth') !== 'AUTHENTICATED'){
...
0
votes
0
answers
129
views
Postgres copy to STDOUT hangs indefinetly
I have a script that runs COPY on postgres to STDOUT. This stream is consumed by nodejs into a readable. This readable is passed to pipeline which writes to a csv file locally. I am using nodePG and ...
- 39