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.
843
questions
0
votes
0
answers
9
views
Mongoose embeded document relation [closed]
user schema
product schema
I want populate user.cart with product.stock data. How I can do it?
-1
votes
0
answers
16
views
Which databases are best suited for very frequent write and read operations? [closed]
I have around 1000 IoT devices from which data flows through kafka and I finally update the device metric in postgreSQL. The device metric is a frequently changing data (device maybe be in-transit, ...
0
votes
1
answer
36
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 ...
- 1
0
votes
0
answers
16
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
1
answer
77
views
Power Query: Why do Text Filters Remove null Values?
Problem Statement
I am using Power Query in Excel for Microsoft 365.
I have found cases where applying a text filter to a column matches null values. This results in undesired removal of rows. I have ...
- 1,065
0
votes
0
answers
23
views
How to control Dropbox app usage in an enterprise evironment
We have a usecase 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
28
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 ...
- 546
2
votes
1
answer
260
views
Power Query Editor: Why are null Values Matching on an Inner Join?
I am using Power Query Editor in Excel for Microsoft 365.
Table A has a column ID that holds a unique identifier. This identifier is usually numeric, but it sometimes contains text. Given this, I've ...
- 1,065
0
votes
0
answers
30
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 ...
- 101
1
vote
2
answers
36
views
Power Query Editor: Strip Leading Zeroes from Numeric Values Stored as Text
I am using Power Query Editor in Excel for Microsoft 365.
Table A has a column ID that holds a unique identifier. This identifier is usually numeric, but it sometimes contains text. Given this, I've ...
- 1,065
0
votes
1
answer
17
views
Reformatting table in Excel - Can PivotTables cut it?
Suppose I have a table in an Excel worksheet which looks like this:
Day
TimeOfDay
Color
Foo
1
Morning
Green
450
1
Morning
Blue
682
1
Evening
Green
253
1
Evening
Blue
413
2
Morning
Green
150
2
...
- 8,824
1
vote
1
answer
88
views
Excel (Microsoft 365): INNER JOIN of Two Tables within Same Workbook
I am using Excel (Microsoft 365) and have two identically-structured tables, each in its own worksheet. These two worksheets are in the same workbook. The first worksheet and the table it holds are ...
- 1,065
1
vote
0
answers
23
views
Libreoffice base design of Time-Table for College [closed]
I am supposed to work on THE Time-Table of my college which people have been doing manually so far. A college time-table is a mapping of a faculty to the class, day of the week, period of the day and ...
- 11
0
votes
0
answers
36
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 ...
- 223
0
votes
1
answer
33
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 ...
user1800262
0
votes
0
answers
32
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 ...
- 201
3
votes
1
answer
3k
views
Postgres docker error "data directory "/var/lib/postgresql/data" has wrong ownership"
I am trying to start a postgres container using docker
I have tried using multiple versions of postgres docker images
I have tried using volumes as mentioned here
tried setting POSTGRES_USER ...
- 70
0
votes
1
answer
31
views
Apache Ignite - Automatic Cluster Snapshot Create / Restore Procedure
When trying the Apache Ignite cluster snapshot procedure (snapshot create, restore), the restore operation is not successful.
Before the restore procedure, we have destroyed the cache which we want to ...
0
votes
0
answers
19
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 ...
- 173
1
vote
0
answers
74
views
influxDB v1.8 : InfluxQL : Continous Query in a bash script
I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
- 11
0
votes
1
answer
143
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 ...
- 265
0
votes
0
answers
65
views
Postgresql Connection Timedout
i have postgresql 12.14 installed (on an azure VM) and trying to connect to it remotely but connection timesout with below error
i have allowed incoming connections in both /etc/postgresql/12/main/...
Faheem Sultan
1
vote
1
answer
65
views
How to extract database from WhereIsIt catalog software and save that database as an excel or text file?
can anyone knows how to extract database from WhereIsIt catalog software and save that database as an excel or text file?
- 816
1
vote
0
answers
183
views
Is there any way to pg_upgrade PostgreSQL 12 to 15 over network?
My situation is a little bit complicated.
I have an older version of PostgreSQL 12.9 installed on an older Centos Stream 8 machine. There are about five custom databases created under the roof, say ...
- 149
0
votes
1
answer
23
views
What does number mean next to artist name in on-line music databases?
I am using MusicBrainz, Discogs and freedb through Mp3tag application for Windows for clearing up my .mp3 files library using these on-line databases as tags sources. Sometimes (approx. 3-5% of all ...
- 10.9k
5
votes
0
answers
249
views
Optimizing Firefox I/O regarding storage-sync-v2.sqlite-wal file (storage-sync-v2.sqlite database write ahead log file)
In my experience, Firefox creates a storage-sync-v2.sqlite database in each of its profile folders. This appears to happen even if profile syncing is disabled (and has never been enabled).
What's odd ...
3
votes
2
answers
753
views
How to flush Firefox storage SQLite database files to eliminate large SQLITE-WAL files?
I've noticed that the WAL (Write Ahead Log) files (*.sqlite-wal) associated with the SQLite databases (*.sqlite) used by the Firefox web browser often get quite large. They literally can get over 150 ...
1
vote
0
answers
25
views
How would I keep a live database directory atomically synchronized with other local disks on Windows 10?
I run PostgreSQL 14.1 on Windows 10 (Pro). The computer has multiple internal storage disks. The PostgreSQL "data directory" is set to C:\whatever\PGDB.
I do make full backups daily, but ...
- 11
0
votes
1
answer
217
views
How to recover Postgresql databases from an older version
I was running for many years Davical on a Debian server (Debian version 11.6 at the moment) to have access to my calendar from many different devices. That application uses PostgreSQL to store its ...
- 111
0
votes
0
answers
858
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 ...
- 155
1
vote
0
answers
291
views
Azure database for postgresql: change the owner of a table without using the super user
I'm working on a PostgreSQL v10 Database created in Azure. This database has several users including:
myuser: user used by a web application. Has limited powers;
myadmin: admin user created by azure ...
- 355
0
votes
0
answers
72
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-...
- 1
0
votes
1
answer
35
views
How can I copy a larger number of cells into a smaller number of cells that are already feeding a graph?
I have two 10-cell columns that currently feed a graph (one for the x-axis, the other for the y-axis). I have now doubled the discretization of my dataset, so instead of the original 10 data points, I ...
0
votes
1
answer
29
views
Combining Rows in Excel for which a Specified Subset of Columns are Equal
I have an Excel sheet laid out as follows:
Software Name
Software Version
Is on host1?
Is on host2?
Is on host3?
app1
1.0
Yes
app1
1.0
Yes
app1
1.1
Yes
app2
3.7.8
Yes
For every row above, ...
- 1,065
0
votes
0
answers
22
views
PostgreSQL - privileges for all tables in database
I have such problem in PostgreSQL 12.
There is a database testdb with many tables in several schemas.
There are four users user1, user2, user3, user4.
I have to grant only SELECT and INSERT privileges ...
1
vote
1
answer
278
views
Why can't I connect to my MariaDB server from my mac, but I can connect from a Docker container on the same machine?
I have set up a MariaDB server on db.bestalbumsintheuniverse.com, port 6612. I have the following situation from the command line on my local laptop (macOS):
$ mysql -h db.bestalbumsintheuniverse.com -...
- 111
0
votes
0
answers
26
views
Microsoft Excel cant access the Microsoft Access database if a network path is used
We have this Excel spreadsheet that has a connection to an Microsoft Access database. The Excel sheet and Access database are located in the same folder on a VM but that folder is a shared folder that ...
- 280
0
votes
1
answer
244
views
Create a mysql database backup on a daily basis and keep only last N copies
A common issue for administrators. I have a database that I want to make a daily backup. Also, I want to keep only last week n copies.
Do you have any recommendations based on essential linux commands?...
- 131
0
votes
1
answer
45
views
count values and embed note
I have a database (Grade 7) that consists of test items/questions and a different database (item data) that includes individual students and whether they got the item correct or not (1=correct, 0=...
0
votes
0
answers
354
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 ...
- 1
1
vote
2
answers
666
views
MariaDB --tc-heuristic-recover in Docker container
I have a MariaDB database in a docker container for my home automation (homeassistant). For some reason it stopped working and I get this error in the docker system logs:
221001 12:27:03 mysqld_safe ...
- 21
0
votes
0
answers
147
views
Does it make sense to use the local entries (Unix domain socket) of pg_hba.conf in Windows?
I have a rather simple question.
As stated in the pg_hba.conf file in the postgres data directory:
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database ...
- 141
0
votes
0
answers
22
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
17
views
Creating a workbook based database-calculations-display system in Excel
I'm trying to make an Excel based modular reporting system so that each sections can be modified without messing up everyone else's reports.
INPUT / Facts table: I have a database that is currently ...
1
vote
1
answer
749
views
Connecting to a Postgres database, hosted within a Windows Subsystem for Linux, from a separate device
I have two devices:
HOST: a Windows device, on which I have installed a Windows Subsystem for Linux.
CLIENT: a Linux device.
I have then taken the following steps.
I have installed Postgres within ...
- 111
0
votes
1
answer
258
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....
- 145
0
votes
1
answer
316
views
Why are my Database Diagrams now blank after upgrading to SSMS 18.12.1
I upgraded SSMS this morning to 18.12.1, but when I open my database diagrams all of them are displayed as blank pages.
How do I fix this?
- 1
0
votes
0
answers
428
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 ...
- 111
0
votes
2
answers
51
views
Pull out ID and Info of my customers (bulk)
I need to pull out from the table (main data tab) - in bulk (more than one customer ID) - and all the related info associated with their orders:
For example: Customers 2245, 6987 & 123
The final ...
0
votes
0
answers
769
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 ...
- 1