I am having hard times visualizing my sqlite database , i am using react native under expo with drizzle ORM to manage a sqlite database locally , the issues is that when i run all the setup commands it says…
I'm new to node.js and MongoDB. Installed all packages as says in a YouTube tutorial. I tried a lot to connect **MongoDB **with node.js. but, there is no error messages and not connected. I have downloaded **Mongo Shell ** also.…
I'm revisiting an old question from 16 years ago about PostgreSQL HASH indexes vs B-TREEs. At the time, it seemed like HASH indexes were far less efficient than B-TREEs in terms of both space and time and the consensus was…
I'm writing a solution for a DataLemur SQL question and I almost had it right but there is one row missing. I have written this query myself: WITH CTE AS ( SELECT user_id, transaction_date, DENSE_RANK() OVER (PARTITION BY user_id order…
As the title describes I want to have a zero-or-one to zero-or-one relationship. For example, let's say we have two tables Calls and Files. A call might have an attached file on it, and vice versa. But I have a…
I have a table that stores data about events with id, start_timestamp (timestamp with time zone), end_timestamp (timestamp with time zone) and duration (in seconds): create table my_table( id bigint generated by default as identity primary key , start_timestamp timestamptz…
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.…