All Questions
Tagged with postgresql javascript
2,658
questions
-2
votes
0
answers
19
views
What language would you reccommend for building a UI to access and manipulate large SQL databases? (Why? Benefits/Drawbacks?)) [closed]
I'm fairly new to coding and have been learning and building a personal archival database using SQL over the past few months. However, I would also like to develop a simple (at first) UI to use for ...
0
votes
0
answers
13
views
How to Upsert Nested Relations in Prisma, using connectOrCreate? connectOrCreate doesn't update deeply nested relation
I'm working on an application using Prisma ORM with a schema that includes Profile, Contact, and SocialMedia models. I need to perform an update operation on a Profile, which should also handle ...
1
vote
0
answers
24
views
Byte64 image text not rendering in localhost development environment when setting as image source (React)
I am working on a website where I am getting images from a database. The images are stored as "bytea" variables in a Postgres SQL database. As from all I've researched on stackoverflow and ...
0
votes
1
answer
38
views
Why do I have to include another key to save db entities linked to another entity?
I am building a NestJS RESTful API for a library. I have a Book entity and a Category entity. Each book has a category.
Book entity
@Entity()
export class Book {
@PrimaryGeneratedColumn()
id: ...
1
vote
2
answers
45
views
Where to save hashed passwords for user login? [closed]
I am designing a website for my company that will have a user log in page that will lead to a customized dashboard. I am currently, using PostgreSQL to store information in the back end of this ...
0
votes
0
answers
18
views
How can i optimize my checkForConsistency function?
I have been given a task to optimize a function. I have done the following things to enhance the code like
Saving state of processedIds in case of failure and continuing from there
Fetching necessary ...
0
votes
0
answers
32
views
Postgresql DB in Next.js WebApp ~ Requests take too much time
I'm currently trying to make a webapp using Vercel's postgresql data storage. However when I'm fetching my database since my backend the request takes too much time.
When I use the vercel tools in the ...
0
votes
0
answers
32
views
I get a Cannot POST /login error when i'm not sending a POST request to the /login endpoint
I'm building a web application where users can register and login using Node.js, Express, and a PostgreSQL database. However, I'm encountering an issue with my frontend and backend communication. When ...
0
votes
0
answers
24
views
Why does postgres sort records by last modification? [duplicate]
I'm developing an application using NestJS, TypeORM, and PostgreSQL.
I've noticed that all my queries are being sorted by the last modification date. I would like to have all my queries sorted by id ...
0
votes
0
answers
16
views
Problem with SmartBrain App - Failed to load resource: the server responded with a status of 404 (Not Found)
I'm trying to solve an issue I've been having with my SmartBrain app. I completed the ZTM Web Developer course and completed the app but then had problems using it later on. I keep getting a "...
2
votes
2
answers
79
views
Alternative to \p{Lo} Unicode Class in PostgreSQL Regex
I encountered a problem when working with regular expressions in PostgreSQL. It turns out that PostgreSQL has no support for the \p{Lo} class, which corresponds to the "Letter, Other" ...
0
votes
1
answer
41
views
having trouble in displaying user enteries from a database table onto a HTML table using springboot java application
this is my user entity class
package com.example.hardware_inventory.model;
public class User {
private Long userId;
private String username;
private String passwordHash;
private ...
0
votes
0
answers
47
views
What is an optimal way to create unique human readable values in postgres?
I have an orders table. For simplicity sake, I'll just include the columns that matters.
id
number
uuid1
ABC123
uuid2
DEF456
The number column is unique but it is not auto-generated by the ...
0
votes
0
answers
27
views
Correct way to access database when working with multiple JS files
JavaScript and PostgreSQL.
class User {
constructor(username, password, company_id, acclevel) {
this.username = username;
this.company_id = company_id;
this.acclevel = acclevel;
this....
0
votes
0
answers
21
views
Supabase (PostgreSQL) brain teaser
I have a 3 tables:
services - info about services (id, title)
city - info about city (id, city_name)
service_city - map multiple cities to services (service_id, city_id)
and I need functionality to ...