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,220
questions
-3
votes
1
answer
15
views
What it the R function to remove a couple of empty columns from a csv file
So I am working on this:
a screen shot of a csv file
and I am trying to delete the last 4 columns, what code should I use? I have it open on Rstudio and running R.
I tried doing
Df$column <- NULL
...
-1
votes
0
answers
7
views
Recover lost database during mariadb migration
I recently tried to install mediawiki, which had me install mariadb. I already have mysql installed and i ran the following command to install mariadb along with some other packages, taken from the ...
0
votes
1
answer
9
views
Update Onprem oracle table from aws glue python shell using oracledb
I have a usecase that needs to update an onprem table using the aws glue python shell.
Please note i want to use python-oracledb in thick mode
I have installed the oracledb
I dba has set up a jdbc ...
0
votes
0
answers
21
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
18
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
15
views
Multiple filter between date and category on a subform in MS access >> Type mismatch 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 "Type mismatch". I try a lot, but ...
0
votes
0
answers
8
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
13
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 ...