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,216
questions
1
vote
1
answer
6
views
Increased disk and storage with many tables
We had a single table with data for over 5K different customers. We decided to move instead to 5k tables, one per customer, as we seldom query data from multiple customers as we thought this should ...
- 4,001
-3
votes
0
answers
21
views
naming attributes: verbs and adjectives, or nouns, or what? [closed]
I am developing a website which uses a back end relational database. There are certain standards, which some people follow and some don't; some make their own standards.
Should I make the column names ...
1
vote
1
answer
6
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 ...
- 4,001
0
votes
0
answers
16
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
11
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
7
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 ...
- 67
0
votes
0
answers
12
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 ...
- 19
-1
votes
0
answers
13
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
20
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 ...
- 13
-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 ...
- 840
-1
votes
0
answers
31
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 ...
