I'm working on analyzing some data. I have a way of doing this in excel, but it's slow and too much manual work. I'd like to find a more effective way to find what I'm looking for. Here's the scenario:…
I am creating a table in Postgresql, this DDL is the result of a script that I am making to compare bancos. CREATE TABLE projeto_modelo.exemplo_fk1 ( id SERIAL NOT NULL, nome varchar(30) NOT NULL, criado_em timestamp NOT NULL, id_exmp_fk2 int4…
I am trying to deploy OpenProject 14 on Azure but using Azure Postgres Felxible Database server. But I get the below error, looks like our Azure tenant is FIPS complaint and below is the error message it is throwing. Any…
I am working in Postgresql and am trying to find what table a specific word is in. For example, I am trying to find out what table the word "banana" is in. The database is agriculture and schema is fruit.…
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,…