Questions tagged [database]
A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.
357
questions with no upvoted or accepted answers
0
votes
1
answer
34
views
Understanding Secondary Log Hard Disk Impact on Write Speed and Data Integrity After Power Outage
I've recently come across the notion that a secondary log hard disk can be employed to enhance write operation speed in a database system. I find this concept intriguing but am struggling to grasp the ...
0
votes
1
answer
99
views
How to move MySQL 8 files to external drive on Mac
I just installed MySQL 8.2 on my Mac. It stores data in /usr/local/mysql/data/ by default, where _mysql user and _mysql group owns the directory. I created a new data directory in the root of the ...
0
votes
0
answers
113
views
Is it possible to use codespaces + local mysql server?
I'm using a local mysql server alongside a spring boot application, it's easy to configure the MySQL server in the application properties file:
spring.datasource.username=blablabla
spring.datasource....
0
votes
0
answers
44
views
SSL Connection to mysql database using OCI Data integration REQUIRE X509 flag
I have a data integration requirement to connect and retrieve data from mysql database using SSL,the user am using to connect is created is with REQUIRE X509 flag so in the connection i need to ...
0
votes
1
answer
557
views
Creating custom data validation lists from formula
I am creating a quick database involving multiple vendors from multiple countries. On 1 worksheet (titled 'Vendors List'), there is a list of countries, vendors, Vendor codes and Territory codes. On ...
0
votes
0
answers
33
views
R can't connect to Druid cluster only on rstudio-server
I'm running these lines to get R connected to a Apache Druid cluster:
> library("RJDBC")
> conn_string = "jdbc:avatica:remote:url=http://<broker_url>:8082/druid/v2/sql/...
0
votes
0
answers
28
views
How to control Dropbox app usage in an enterprise environment?
We have a use case for using DB's app and I would like to lock the app use down to only allow it to use or store data to a specific DB account.
0
votes
1
answer
54
views
Is it possible to have bidirectional relationships in Microsoft Access?
I have a database including two tables for suppliers and people:
the suppliers table has a look up column where one can select the people relevant to that supplier from the people table. and there is ...
0
votes
0
answers
76
views
I need simple key-value or SQL DB with master-master replication
I'm creating self-hosted DNS-service, that can be run by any user on it's servers. The purpose is to parent-control of the available websites and block adverstments and phishing sites by publicly ...
0
votes
0
answers
165
views
Toad -- seeing windows side by side
I'd like to see the SQL editor in TOAD allow one to see windows side by side (as NotePad ++ allows with "move to other view", for example.) My purpose would be to look at to different (but ...
0
votes
1
answer
123
views
Create a "Scrollable Table" in Excel
I want to create a table like the one attached where people can enter data on the white fields like normal, but when they press the arrows on the week to change what week they are viewing it changes ...
0
votes
0
answers
52
views
Query for Employees with Laptops Only
I'm using a MySQL database and trying to figure a query upon 2 tables:
Employee table where the status needs to be active
Asset table where the status needs to also be active
The asset table ...
0
votes
0
answers
21
views
How best to manage a long list of work-items for service by Linux threads
I have a list of about 100,000 small problems to be solved in my cluster of Xubuntu machines. Each takes a couple of minutes on a single thread. More problems -- somewhat smaller -- will be produced ...
0
votes
1
answer
462
views
MongoDB replicaset on docker swarm
I try to create a MongoDB replicaset in docker swarm services.
So far so good. The problem im facing is, when a container stops or is moved to a other docker host, the cluster breaks and i cant ...
0
votes
0
answers
2k
views
What is the easiest way to migrate data from one Cosmos DB to another?
What is the easiest way to migrate data from one Cosmos DB to another?
I accidentally deleted all the databases in one Cosmos DB account. So, I asked the Azure support to restore the Cosmos DB account ...
0
votes
0
answers
146
views
How to "intelligently" delete backup files based on their creation time?
Every >= 24 hours, my system makes a full backup of the (PostgreSQL) database and puts the resulting file into a dir of files such as:
MyLifeDatabase 2022-12-01 12;00;00.pg_dump
MyLifeDatabase 2022-...
0
votes
0
answers
481
views
Using my computer as MySQL database and access with Xamarin.forms app
I have developed an app from Xamarin. forms (C#) and I want to use my own computer to host a MySQL database. I have forwarded my port on my router as well but the database can only be accessed when my ...
0
votes
0
answers
73
views
Gathering data from raw data table with multiple criteria
I am coming up empty handed trying to formulate a string to pull specific training data from a huge list.
Raw Data has over 4800 rows
Column A has over 70 Unique Names
Column B has over 74 Unique ...
0
votes
1
answer
440
views
Importing a large .dump file into Postgres Database (Win 10)
I'm running into a problem where I want to import a really, really large .dump file (530gb) into a postgres database inside a docker.
This is the commmand I'm running inside Powershell:
cat .\dbexport....
0
votes
0
answers
518
views
Install Microsoft SQL Server on Pop!_OS
I am trying to install Microsoft SQL Server on the latest Pop!_OS 22.04 LTS (jammy) but receiving following errors:
sudo apt-get install mssql-server
Reading package lists... Done
Building dependency ...
0
votes
0
answers
1k
views
How to fix "Warning : Unprotected Private Key File" on Windows 10
I am attempting to do a simple connection to a SSH server using OpenSSH for Windows using a private key, and it shows this.
I can't permit pem file and I keep getting this error message "Warning ...
0
votes
1
answer
68
views
locate fails to find files from a custom database file
I am attempting to create a database index of a USB-drive using updatedb. I am using locate and updatedb version 0.26, on Linux Mint 20.3 using kernel 5.14.0-1042.
On the root directory of the USB ...
0
votes
0
answers
48
views
How to specify the year (in spreadsheet)?
Not a native English speaker, and newbie in this forum. If anything is not clear, please let me know. Thanks
I have a data collection that has records of different cities in different years.
Data ...
0
votes
0
answers
2k
views
How to read/fetch data from Oracle SQL database using PowerShell Core?
I have been researching on this for a couple of days but have been going in circles here.
I need to write a script that fetches the data from Oracle db and do something with the data. In my script I ...
0
votes
1
answer
175
views
Joining MySQL table
in my database there are 2 tables : posts, room
Posts tables include ID and Title columns and includes many rooms and hotels titles and IDs.
In the room table there are 3 columns : room_id, hotel_id ...
0
votes
2
answers
462
views
Populate multiple cells based on selection from data in other sheet
I have this data regarding postal products with prices based on weight range.
I want to be able in another sheet to insert a postal product from a dropdown, e.g. "PS" then specify a weight ...
0
votes
0
answers
285
views
How to start in SpyHunter 5 scan offline?
currently I collect good tools to remove malware in sad case of getting infected despite live-protection from AV.
Now I'm interested in SpyHunter 5. Despite being aware of program suspicious past I ...
0
votes
1
answer
79
views
Pull data from 17+ tabs into a master sheet within the same workbook
I have a workbook with a MASTER sheet. This master sheet has columns A:P with different information needed in each cell. (House IDs are down Column A)
I have 17 tabs (all named by their HOUSE ID -ex ...
0
votes
0
answers
145
views
Gitbucket self-Hosting on Nginx MYSQL configuration doesn't work
I'm configuring my own self hosted (on Nginx) gitbucket repository and my MYSQL configuration does not work as expected here under GITBUCKET_HOME/database.conf :
db {
url = "jdbc:mysql://...
0
votes
0
answers
20
views
Access database advice
I'm new to access so this might sound stupid.
I have few thousands csv files, each one containing few hundred rows of transactions data for an item. Each csv file is a different item.
I want to use MS ...
0
votes
2
answers
78
views
How to aggregate text-data from a given date
I am creating an excel database to 1) track hours and 2) track event types. In Sheet1, I enter the individual events on a given date and the minutes spent. My goal is to get Sheet2 to consolidate.
...
0
votes
1
answer
115
views
I need help designing this query. I can't use a JOIN statement. One column is referenced in two different contexts
I am working in Microsoft Access because this is what my professor wants. I've designed a University database. I have a Student table with a Department code for the student's major (FK to DCode in ...
0
votes
0
answers
17
views
Link and get specific data from another workbook
So I have a workbook named dwg data.xls that contains a table with the following columns:
DWG No | S1 | S2
And I have another workbook named report template.xls that contains a report template.
In ...
0
votes
0
answers
63
views
Combining sets of columns without duplicates but while filling in blanks
So, suppose I have some data:
First name
Last name
Position
John
Orangeman
Kathy
Coolidge
Captain
Eric
Smarty
Sidekick
And then another 3 columns of related data:
First name
Last name
Position
...
0
votes
1
answer
332
views
Is it possible to exclude a line of code from a Visual Studio 2019 code analysis warning (sr0014)?
I am using Visual Studio 2019 and Azure SQL Database Instance.
I have a lot of stored procedures that follow the same pattern. A warning is raised on the build for each stored procedure where data ...
0
votes
1
answer
3k
views
How do I arrange data with the similar values in one of the columns together in Excel?
I have an Excel table with 4 columns - name of the company, website, area, and description. How do I group the companies from the same area (column 3 in my case) together?
For example, this is what I ...
0
votes
1
answer
33
views
On Access, How do I Query like if 3 or more fields are 'True' then show the record?
Is there a way to run a query to show records that have 3 or more check box fields selected?
0
votes
0
answers
75
views
MSSql Database randomly not answering
We have a 32 Bit production machine that has MS SQL 2014 installed. 32 Bit is forced by twincat 2 running on it, (not compatible with 64 bit), thus the available ram is limited.
Randomly, about twice ...
0
votes
1
answer
52
views
Almost everything disabled in MS Access
I received an Access database to work with today but it is locked somehow and I'm new to this so I don't know how to unlock and customize it according to my liking.
There is no ribbon showing, only ...
0
votes
1
answer
76
views
Excel Database for Questionnaire Results
I need to make an ongoing database for a questionnaire with 12 questions. The tick box options are Certainly True, Somewhat True, Not True and Dont Know.Each of these has a value. So if you select ...
0
votes
0
answers
102
views
Secure database connection from public IP
We have an Android App and a website that requires connection to local database.
Working Scenario is
Online Website (.net) is in one dedicated virtual server with public ip.
Then we have another ...
0
votes
0
answers
398
views
Can't connect to postgres database
Im trying to connect to a DB with Postgres JDBC, both machines are linux
the firewall, selinux, iptables are down on both machines
I can connect to the DB, (on my personal windows computer) with
...
0
votes
1
answer
4k
views
How to create draw.io database diagram in Confluence from Excel?
I have a a list of fields in Excel which are the fields/columns of a table in my database.
I want to convert this into a database diagram (ERD) in Confluence using draw.io. But I can't seem to be able ...
0
votes
1
answer
69
views
CRA_Xcrms_ProcessRequest - what does it mean? or what process is this?
the Public Service Development Agency is going to give me access to database (Information about an individual in an electronic database). They contacted me and said that in the near future, they will ...
0
votes
0
answers
383
views
moving multiple files to different directory on FTP webserver
So i have this webserver with a folder of approx. 7000+ files/images/documents.
I want to move around 2000 specific images to a different folder.
I think i can use SQL to get the image names from ...
0
votes
0
answers
34
views
Sorting an excel column with numbers and keep track of cell indices
So, this is my problem, I have two excel columns like :
1 // 0.5
2 // 3.3
3 // 1.2
I would like to sort the second column in ascending(or descending) order, and also change the first column as ...
0
votes
1
answer
74
views
Including information from one database into another - MS Access
I have created a new table in MS Access which, for my purposes here, I'll call Table A. It contains a ton of information that staff need to enter for each company or individual. The forms are time ...
0
votes
0
answers
88
views
Local database and GitHub -- How do I check in?
I have a personal project I'm working on. I want to be able to go back and forth between my desktop and laptop via GitHub. The problem is, I can't figure out how to check in my "local" ...
0
votes
1
answer
339
views
Access deleted several records when data type changed. How to find which ones caused the errors?
I'm trying to work with an old Access database. It has a column formatted as Short Text that I need to change to numerical data.
To attempt to change the data type, I opened the Design View and ...
0
votes
0
answers
75
views
Is it possible to create a local data source (DSN) to my development MSSQL LocalDB instance?
A project using a legacy code library works in terms of DSN name, user, password - not an approach I'm very familiar with as a developer used to DB connection strings.
For testing, I have a LocalDB ...