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
82
questions
0
votes
0
answers
9
views
MSAccess - TransferDatabase command not transferring data
I am trying to transfer the data and table structure from one database to another.
My database kept bloating so I moved my linked tables to a separate database and I'm attempting to pull them into a ...
0
votes
1
answer
7
views
Get notified about changes on QuestDB Table
What's the best way to get notified about changes to my QuestDB tables? I've searched the docs but all I can find are references to QuestDB being the destination of Change Data Capture. What I want is ...
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 ...
-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 ...
0
votes
0
answers
17
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 ...
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 ...
-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
21
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
45
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 ...