All Questions
Tagged with postgresql javascript
2,649 questions
-2
votes
1
answer
27
views
Express variable not passing to POST route [closed]
I cannot get the delete functionality to work in a to do list app because my JavaScript file is not recognizing the variable (from postgres DB) I’m passing from my Express file.
Full description
I am ...
0
votes
1
answer
55
views
Can't add trigger on insert in auth.Users in Supabase
I tried to create a trigger on auth.users to add information to a public table, but for some reason, it caused issues during registration. I get the following error:
AuthApiError: Database error ...
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
-1
votes
2
answers
234
views
Which Database JavaScript Client that works alongside Drizzle ORM is better for pooling, pg, postgres or node-postgres? [closed]
I'm working on a JavaScript/TypeScript backend project using drizzle and PostgreSQL where I came across pooling for the first time. I found there are several ways to integrate pooling with drizzle ORM ...
- 175
0
votes
0
answers
30
views
invalid byte sequence for encoding "UTF8": 0x00
this is the PostgreSQL 15 table define:
CREATE TABLE public.tex_sync (
id int8 GENERATED ALWAYS AS IDENTITY( INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 NO CYCLE) NOT ...
- 39.5k
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
2
answers
49
views
Supabase search with "or" in nextjs project typescript
In this code, search.column is an array of column names, and search.value is the search term.
The goal is to search for records where any of the specified columns contain the search term (case-...
- 1
-1
votes
1
answer
137
views
Connecting to Postgres database using javascript
Apologies if this is a bad question but I've been troubleshooting for a while now and don't understand where the issue lies.
I have a db.js file that is meant to login and connect to my local postgres ...
- 21
0
votes
0
answers
55
views
Update join effect not visible in first run of select
I have this very strange behavior using pglite (PostgreSQL version 16) in Firefox, where I run an UPDATE JOIN, and then a SELECT which the first time around doesn't reflect the change made by the ...
- 10.6k
0
votes
0
answers
36
views
Deno PostgresError: received unencrypted data after SSL request
import { Client } from "jsr:@bartlomieju/postgres";
import "jsr:@std/dotenv/load";
const client = new Client({
user: Deno.env.get("POSTGRES_USER"),
database: Deno.env....
- 121
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
2
answers
435
views
TypeError: client.query is not a function
Hi I was trying to do a next js project and i got this error while trying to connect database.
I am using neon database.
app/provider.js
"use client";
import React, { useEffect } from "...
- 19
0
votes
0
answers
22
views
Properly setup mocking for pg-promose in express.js for supertests
I am using pg-promose inside its own module to initialise a connection to DB and then use that connection in my route modules or anywhere else its imported.
import pgPromise from 'pg-promise'
let ...
- 2,347
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