Questions tagged [database]
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data is typically organized to model aspects of reality in a way that supports processes requiring information. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.
database
195,323
questions
-1
votes
0
answers
23
views
Problems Saving Two data's to database -python [closed]
They want to separate the data into GST and Non-GST categories. So, I wrote an if-else condition. If 'Non-GST' is selected, the data is saved to the 'nongst_invoice_data' table in the database. ...
0
votes
0
answers
9
views
FME 2023.1.2 Forgot to check overwrite option as a result the data is duplicate
I wanted to convert my geodatabase into a geopackage using FME. I wanted to overwrite my data unfortunately I forgot to tick the overwrite option. As a result all my data are duplicate. Is there any ...
0
votes
0
answers
22
views
Return 403 forbidden in production env
I have issue when try to perform the api in production environment, but it works it my staging environment. This is my code for the api
import prisma from '../../../prisma/db';
export default async ...
-1
votes
1
answer
19
views
Issue with Changing @Table Annotation to "users" in JPA Entity Class Using H2 Database
I'm encountering an issue with my Java application where changing the @Table name in my entity class causes the application to fail during tests and runtime. Here are the details:
Originally, my ...
0
votes
1
answer
22
views
How to return JSON objects without explicit aliasing in postgresql
If I have two tables and I join them, can I return one of the values a JSON object, without having to specify all the fields?
For example, the following works:
SELECT u.*,
json_build_object(
'name', ...
-2
votes
0
answers
18
views
How do I implement friendships between users in cloud firestore? [closed]
I'm using Node.js. I currently have a collection with users and I want to model friendships between them. The frontend should be able to query all the friends of a user with the profile picture and ...
0
votes
1
answer
63
views
How to store row-position in a database?
I am looking to emulate a feature in Excel/Google Sheets where there is a table of data, but someone may move a row up or down. Here is an example of the interaction:
My first thought as to how to ...
0
votes
0
answers
18
views
SQL Server CTE improves query performance due to larger memory grant? [migrated]
I have a large table (20M+) which has a clustered index on COBID.
When I run this query:
SELECT *
FROM dbo.mytable
WHERE COBId = 20240723
AND TradeID = '123456'
it completes in around 10 seconds.
...
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 ...
-2
votes
0
answers
39
views
is there a way to store unschematised datas in sql database [closed]
mysql : 5.6 java : 11
Am in need of an mechanism to store unschematised data in my db. the case is as follows.
Objective :
To get all user from a 3rd party app and store it in db.
Problem facing :
...
0
votes
1
answer
10
views
Getting "phantom" rows that are duplicates but with different timestamps
I am inserting data into QuestDB using the Go client. I have enabled auto-flushing and I am using the http transport, so retries are automatic in the case of network errors or timeouts, which is ...
0
votes
0
answers
24
views
PostgreSQL not using index on materialized view
I've got a materialized view which has 2 columns (patient_id BIGINT, department_ids TEXT[]).
It is a handy precomputed dataset used to filter patients who have received care in a hospital department ...
0
votes
1
answer
11
views
Failed to connect to PieCloudDB using Navicat
I'm trying out PieCloudDB Database and now I want to connect PieCloudDB using Navicat, but it got stuck and connection failed. I used general connection mode, I think the problem might be with ...
0
votes
0
answers
35
views
db2 procedure inconsistent?
currently facing a very strange problem. when i try the following, i get some rows returned, as expected:
call "clm".MY_PROCEDURE('M00894761','','M_OM','BP_00000858_OM','0','...
-1
votes
0
answers
35
views
Can't access data from sqlite db with js
I'm trying js from the first time and want to make a website, I need to get data from a users database to verify them but i can't figure out how
const sqlite3 = require('sqlite3').verbose();
var sql;
...