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 through node.js. import…
I have a model with QR codes that has a field called type. This field can have two values: 1 (Plate) or 2 (Sticker). I could simply create an enumeration of these types as an array in the model and…
I have two tables: table_a and table_b. Size-wise, table_b is much bigger than table_a. There are fields(names) that are present in both the tables. The goal is to find the names (or the number of names when using count): that…
I am running a database connection to mongoDB using mongoose(v 8.6.2) in next.js and it keeps throwing an error of .connect not being a function, this is my database.js file import mongoose from 'mongoose'; let isConnected = false; // track…
I have a query similar to: select * from combined where valid_rating is null order by FIND_IN_SET(provider, (select provider from combined where valid_rating is null group by provider order by count(1) desc) ) Basically, I am trying to order by…
I've been trying to model a relationship in Laravel between a ShapeContainer entity and different shapes with unique properties, but a common Shape interface (with getArea and getPerimeter methods). I've read up on the examples in the laravel documentation (posts,…
I'm new to postgreSQL and I'm trying to delete a row from a table and then also delete the relevant data from another table and then the linking table; Im trying to learn while doing so im pretty sure what…
I have a Postgres table that has numerous columns which frequently show up in the where clause of select queries. The table has been indexed accordingly, with indexes on all of these columns (mostly single-column indexes, but with some composite…
I have a very simple two-table set in Postgre 16.0: CREATE TABLE fk_table ( fk_id INT PRIMARY KEY , fk_name VARCHAR(50) ); CREATE TABLE main_table ( id INT PRIMARY KEY , date TIMESTAMP , fk INT REFERENCES fk_table(fk_id) --, tens…
Issue: Unable to Connect to MongoDB with TLS and Authentication MongoDB Setup: I’m running MongoDB on a Docker container, and I’ve enabled TLS/SSL and role-based access control (RBAC) with internal authentication. Here’s an outline of my setup: MongoDB Version: 6.x…