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.

Filter by
Sorted by
Tagged with
1 vote
0 answers
19 views

Backup Signal Desktop chats

I'd like to have a portable version of the Signal Messenger (packed like all the apps from portableapps.com or any other similar site) in order to be able to just copy a folder to an external hard ...
user avatar
  • 1,380
0 votes
0 answers
10 views

Different collation between master database and application database [migrated]

I just installed SQL Server 2019. Unfortunately I didn't notice the collation while installing. Following are the collations: SELECT name, collation_name FROM sys.databases name collation_name ...
user avatar
0 votes
0 answers
11 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 ...
user avatar
  • 13
0 votes
0 answers
18 views

why I cant install the Oracle database (21c,19c etc) . I have met all the following requirements

I have jdk11,oracle sql developer and oracle virtualbox downloaded. Why I cant install the Oracle database(21c,19c etc). I have met all the following requirements: have the Windows 11 pro edition. ...
user avatar
0 votes
1 answer
18 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 ...
user avatar
  • 1
0 votes
2 answers
35 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 ...
user avatar
  • 101
0 votes
0 answers
14 views

How to remove datasource from PowerBI Gateway

I have already deleted the PowerBI datasource cluster but when I try to refresh, the gateway is still asking for credentials to a gateway that doesn't exist and pointing to a server that has been ...
user avatar
0 votes
0 answers
18 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 ...
user avatar
1 vote
0 answers
28 views

Use Microsoft Excel to import and refresh data from only some columns of a CSV

I have a CSV that's 100+ MB, so it takes a long time to load. In Microsoft Excel for Mac Version 16, I'd like to use the "Get data" or a similar functionality to load data from that CSV into ...
user avatar
0 votes
0 answers
12 views

Formatting issues with Database field into Word document

Is there a way to prevent the carriage return that appears at the beginning of a field imported into a Word document using the Database field? Or is there a switch or another type of field that will ...
user avatar
  • 1
0 votes
1 answer
24 views

Convert from table to matrix format with Excel 2010

I would like to convert this data from table to matrix format where the names in the dest column become columns and the number values corresponds to the total but the origin column stands still origin ...
user avatar
0 votes
0 answers
26 views

Found a very large zip file with (HSQL?) database inside, what is it?

I found a very, VERY, large file on my computer. FileName.7z, which is around 12.9 GB in size. Inside the file are 5 files: ParserCommand.class ParserDDL.class ParserDML.class ParserDQL$CompileContext....
user avatar
2 votes
1 answer
28 views

Is there a way to configure Thunderbird with malicious IP DB to flag incoming mails as spam?

I checked a spam mail source and noticed it could come from a malicious server. I saw there are some malicious IP DB like AbuseIPDB collecting such IPs. Is there a way to let Thunderbird check the IPs ...
user avatar
  • 233
0 votes
0 answers
18 views

Is total MySQL memory usage scaled by innodb_buffer_pool_instances?

I seem to remember reading somewhere that: Total InnoDB pool usage = innodb_buffer_pool_size * innodb_buffer_pool_instances but I can't find the original reference. Is this true? or true for certain ...
user avatar
  • 317
0 votes
1 answer
64 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 ...
user avatar
0 votes
0 answers
12 views

Make a mongodb instance running on localhost available on public port on remote server

I am running a mongodb instance on on localhost on protected_server which is not accessible from the outside and I want to make my database accessible on the 27017 port of open_server. I tried ssh -R ...
user avatar
  • 133
0 votes
0 answers
119 views

Cannot install PostgreSQL 14 because it failed to start database server

I try to install the PostgreSQL 14 in my windows 10 laptop. But it shows the "Problem Running post-install step" when the cluster initialization start. The eror message image What I have ...
user avatar
1 vote
0 answers
31 views

How to make sure of user's privacy in my app? [closed]

I want to develop an app where I want to give user's at most privacy to their data. I need a database and server to run my app. Are there any instances of AWS/GCP not being trustworthy regarding user ...
user avatar
1 vote
2 answers
310 views

Install MySQL on Debian 11

I wanted to install MySQL with sudo apt mysql-server but it is obsolete, so use sudo apt default-mysql-server, I installed by default MariaDB. I didn’t try another package installer, I’m new to Linux. ...
user avatar
  • 11
0 votes
0 answers
14 views

Local database to replace spreadsheets; copy-paste towards database from spreadsheet

I'm doing some scientific research for which I characterize many samples. Currently, I've been using spreadsheets (Libreoffice) to store my stuff, but as I get more and more data it becomes ...
user avatar
0 votes
1 answer
31 views

Excel 365 - Dynamically importing data into excel from a Database

I have a spreadsheet with 40k rows or so which is added onto every week. Each row has an Employee ID, Employee’s Shift Number and Hours worked column (see attached image for sample data). Sample data ...
user avatar
3 votes
3 answers
190 views

How to unroll a row in Excel, to have a better view for editing?

Let's say we have an Excel spreadsheet like this: Is there an easy way, ideally built-in in Excel, to "unroll a row" to be able to: have a better view of all the data in this row have an ...
user avatar
  • 1,696
0 votes
0 answers
20 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://...
user avatar
1 vote
1 answer
45 views

How to automatically diff changes from master database?

I have a problem, which I can’t get around. I thought maybe someone of you already had some similar experience/problem and would be able to help the rest of the community or share some useful ...
user avatar
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 ...
user avatar
  • 15
0 votes
2 answers
24 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. ...
user avatar
0 votes
1 answer
52 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 ...
user avatar
  • 13
0 votes
0 answers
18 views

How to remove all asset and scan info from LANsweeper database, keeping my settings?

We have an old LANsweeper (v7) installed with its database including many already non-existing assets. I would like to upgrade to the newest version (v9) and clean up its database removing all ...
user avatar
  • 1
0 votes
0 answers
16 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 ...
user avatar
  • 115
-1 votes
1 answer
77 views

ERROR dbeaver on manjaro

i downloaded dbeaver from the aur but it failed to open . it gives : " version 1.8 of JVM is not suitable for this product . Version 11 or greater is required" but in the aur there is only ...
user avatar
0 votes
0 answers
24 views

SQL Database Restore

I am having an issue with restoring a database over another database. So our setup is that we have clients, and they have a live database and a test database. Occasionally we will need to copy the ...
user avatar
  • 1
0 votes
0 answers
27 views

MariaDB: How do I load a copy of a table into RAM for frequent reading?

Colleagues, tell me how to keep a copy of the table in RAM? I have a database server on MariaDB. One of its databases contains a small table - about five fields and several dozen records. The records ...
user avatar
  • 1
1 vote
1 answer
539 views

locate command does not work on mac terminal

I'm working on Mac (Catalina, 10.15.7) and want to use the locate <...>-command. After typing locate ... it suggested me the following, which I did. WARNING: The locate database (/var/db/locate....
user avatar
  • 113
0 votes
0 answers
34 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 ...
user avatar
0 votes
1 answer
41 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 ...
user avatar
  • 111
0 votes
1 answer
43 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 ...
user avatar
  • 1
-1 votes
1 answer
208 views

What is the difference between "client-server" and „file-server“ database? [closed]

I am trying to answer a question put on the exam but cannot find answer that is precise enough. Please help to understand what are the major difference between "client-server" database such ...
user avatar
  • 123
0 votes
0 answers
27 views

Odd behaviour of shortcut

I have created a shortcut following the instructions here. https://accessexperts.com/blog/2015/02/04/how-to-open-your-ms-access-application-like-a-custom-software-application-ms-access-tutorial/ On ...
user avatar
  • 21
0 votes
1 answer
48 views

How can I save Firefox bookmarks to a file the same way it is shown in the browser?

I have a massive amount of bookmarks in my browser (Firefox) and I want to store a list of bookmarks stored in each folder in my external drive. How can I save them in a similar way as they are ...
user avatar
  • 135
0 votes
1 answer
72 views

how to execute command in console of program (i.e. various databases) through shell/bash script

I would like to have script that starts console (i.e. of database postgres or mongo) and to execute some commands that are known to work, one of solutions is file.sh --> db.EXPECTED_COLLECTION....
user avatar
  • 123
0 votes
1 answer
22 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?
user avatar
  • 1
0 votes
0 answers
222 views

KeePassXC: export CVS? Or import XLS?

KeePassXC has several import and export features. However it strikes me as odd that the command line feature (according to the manual) exports to KDB XML format: keepassxc-cli export MyDatabase.kdbx ...
user avatar
0 votes
0 answers
24 views

How to handle flyway when the db is down

This is my first time that i use flyway and i need help. In lifetime of the microservice the postgres DB can shut down. I want to know how can flyway can get connection to the db again when it is up.
user avatar
  • 1
0 votes
0 answers
37 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 ...
user avatar
0 votes
1 answer
108 views

How to return first non-blank value with LOOKUP function

I have a table: table in which I reference data from a dataset using a LOOKUP function. I can reference columns(such as new_deaths) which have the latest(non-blank) data just fine. However, for some ...
user avatar
  • 5
0 votes
1 answer
61 views

Live statistics chess960 from chess.com?

Both lichess and chess.com have the feature to play the variant chess960 live. However, only lichess has a graph showing how your live chess960 rating has changed over time. Lichess also shows other ...
user avatar
  • 73
0 votes
1 answer
34 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 ...
user avatar
1 vote
1 answer
223 views

Cannot log in to the MySQL server _After data dir changed _cent os 7

I am having centos 7 and recently i changed my data directory of mysql from /var/lib/mysql to /test/sql after the migration i am able to login from mysql server through terminal but not able to login ...
user avatar
0 votes
1 answer
36 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 ...
user avatar
  • 1
1 vote
2 answers
96 views

Auto Fill Forms For All Major Browsers

I am building a form hosted on my server. I want to save the user as many keystrokes as possible since this is form with many fields. Is there an autofill forms for other major browsers like Safari, ...
user avatar

1
2 3 4 5
17