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,215
questions
-2
votes
0
answers
11
views
Database Design and naming attributes
So I was planning on developing a website which uses a back end database. On my way to pre-modelling the database, I found out there are certain standards, which some people follow and some don't, ...
0
votes
1
answer
4
views
Warning: fs.file-max limit is too low [current=1000000, recommended=1048576], after changing ulimit already
I've been using QuestDB for a while (Ubuntu, XFS filesystem), with no issues. A few days ago I updated to 8.0.2 (also tested the latest release 8.1.0), and I got two warnings: One about the max ...
0
votes
0
answers
11
views
MS Access combo box and text box control source
I have a combo box and a text box in a form. The Text box value Control Source is set to the value of combox box + 1. But if the combo box value is 0 or empty the Text Box shows #error. I even tried ...
0
votes
1
answer
5
views
How to aggregate json columns based on value in PieCloudDB
In my PieCloudDB Database I have a json column like this:
json_col
{"id": 1,"data": [{"col1": "A","col2": "B","col3": "C&...
-1
votes
0
answers
22
views
store multiple weekday values in a column as a string or create a separate table
We are creating an Employee Employment table and it should contain Employee ID, Activity Type and Activity Days. The activity type will be in a separate table and only the ID will be recorded in the ...
1
vote
1
answer
8
views
Multiple filter between date and category on a subform in MS access >> Type mismatch error
Please, anyone suggest me to solve this error, I'm new for the MS Access development. I have been getting a problem to filter subform between filter date and category. It show an error statement that &...
0
votes
0
answers
6
views
How to Properly Create the Data Architecture for a PERN Stack Application?
I'm building a web application using the PERN stack, and I'm looking for best practices on how to design the data architecture.
I just did a basic pernTODO in order to practice my postgressSQL skill a ...
0
votes
0
answers
8
views
Batch loading for Firebase in SwiftUI
Does anyone know how to fetch only like 5 posts at a time? Like when you're scrolling though the ScrollView { I want only the posts that should be seen being loaded in. I need to reduce the amount of ...
-1
votes
0
answers
12
views
What is the relation between entity integrity and key constraint?
I know the entity integrity is used to ensure that the primary key cannot be null but what is the relation between the entity integrity and key constraint
i was searching but i cannot understand the ...
0
votes
1
answer
17
views
Not able to connect to foreign server
I am getting following error on PostgreSQL:
SQL Error [08001]: ERROR: could not connect to server "regionaldb_server"
Detail: connection to server at "localhost" (127.0.0.1), ...
0
votes
1
answer
41
views
Selecting Rows By Specific Column Data in PostgreSQL
I'm trying to build a recipe finder app (PERN stack) like SuperCook but I ran into some problems with my postgres table.
Short description of the desired result. I'd like the user to select some ...
-2
votes
0
answers
17
views
MongoDB inserts super slow after indexing [closed]
I have a MongoDB collection that is almost 1 TB in size. The collection already has indexes in place for faster querying. However, when I try to add new data, the insertion process becomes extremely ...
0
votes
0
answers
9
views
Should I explicitly close Redis connections if the application crashes?
Suppose I am using some library of any language (Let's say Python) to use in a web application. So, that client has a certain number of connections. Now suppose that for some reason, the application ...
0
votes
0
answers
30
views
How to Create Triggers Between Two Databases
In my system, I have a machine on AWS with several databases. My goal is to create some triggers/scripts that continuously read from some databases and, based on the information read, generate or not ...
-1
votes
0
answers
22
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
18
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
62
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;
...
-4
votes
1
answer
36
views
Deleting item from sqlite database have error [closed]
Deleting item from sqlite database error.
CustomAdapter
public class PassAdapter extends RecyclerView.Adapter<PassViewHolder> {
Context context;
MainActivity mainActivity;
private ...