Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
4 views

Oracle 10g Database Locking Session Issue [migrated]

I have a problem with locking and not timing out in one of my Oracle databases. This session locks occur on certain transactions that come from Oracle Forms users. For instance, when some user ...
1
vote
0answers
9 views

How does the back end and front end get built separately but the final product uses both still?

I'm a front-end mainly trying to learn back-end now. The language people when i try and research building an app using both front and back end is confusing to me and feels like something is missing. ...
0
votes
0answers
3 views

Getting unfamiliar error when using terminal command to update database [migrated]

I'm a bit in over my head when it comes to using and managing large databases. I run a small startup that uses a PostGres SQL and PGAdmin to administer and query the database, which is housed on ...
0
votes
0answers
3 views

Odoo “openerp” migration from 10.0 to 11.0 [on hold]

dears i'm using migration for odoo 10.0 to 11.0 USING OPENUPGRADE from OCA while validating in last step it gives error copying database CMS to CMS_migrated... Traceback (most recent call last): ...
-1
votes
1answer
31 views

Is excel good for data storage and analysis?

About a year ago I decided to store some personal information in excel file (weight, daily step count, blood pressure, books read, tasks completed, ...). Every row is one day and it's getting ...
0
votes
0answers
11 views

Export Keycloak User Data from MySQL Server

I am using Keycloak MySQL Database for user authentication. I am planning to stop using Keycloak and use some PHP framework authentication, but all my user related data is in the Keycloak Database. Is ...
-2
votes
0answers
14 views

How to create a local private sql server that is inaccessible to the public?

I am trying to build a software ( either in C-Sharp or Java ) and I have a bunch of messages ( proprierty stuff) and I am trying to save all this information in a database, so everything can be ...
0
votes
0answers
8 views

How do I retrieve orphaned Cloud SQL backups in Google Cloud?

A CLOUDSQL instance was deleted from our project but the backups are still in the Cloud. These are automated backups and not accessible through Cloud Storage. I have done the following based on this ...
0
votes
0answers
6 views

Getting “java.sql.SQLException: Values not bound to statement” exception [migrated]

I recently upgraded from sqlite-jdbc-3.7.2.jar to sqlite-jdbc-3.26.0.jar. I observed that the insert query in my code are failing with “java.sql.SQLException: Values not bound to statement” exception. ...
0
votes
0answers
23 views

I want to use regex extract on google data studio to take only the last 7 numbers form Event action

I tried open new field using the regex regex extract (event action,\d{2}.d{4}) but the data studio can't really read it. I need the regex to return only the marked section. Then I will need to change ...
0
votes
0answers
5 views

Biometric System Device [closed]

currently im working government. Right now we kinda have some problem with our device and btw i'm not the one who charge on that field but i want to try to help them if it is possible, btw im working ...
0
votes
0answers
7 views

Log operations with timestamp and user

I have APP1 and APP2 using the same Database, both applications access the DB with the same user (let's call it postgres) and every end-user does login in both APP1 and APP2 with his own different ...
0
votes
1answer
16 views

MSSQL database physical design: RAID or spreading filegroups across different physical drives? [closed]

I'm going to build a Microsoft SQL server database which could end up being more than 40 TB in size. Which of the blow physical designs of the server will result in better performance1 and db ...
0
votes
0answers
17 views

Can't Login to OrientDB Databse because of parameter conflict

I have a OrientDB Server Version 2.1.5 running on my local Windows 10 64Bit PC. And on it a Database called "Metriken". Everything worked fine and I logged in via Studio (Webbrowser). But since today ...
0
votes
1answer
6 views

Is there a way to export a MS Access query or report without showing duplicated cells?

I'm working on a MS Access 2016 database that contains information about a collection of recipe books. I have a few tables for different types of data that are linked to each other using many-to-one ...
0
votes
0answers
5 views

How to Restrict INSERT operations on table for DB2? [migrated]

I have a table OAUTH20_TOKEN_CACHE for which I have restricted INSERT operations by running below command. db2 REVOKE INSERT ON HVD121.OAUTH20_TOKEN_CACHE FROM USER HVD121 This could be seen ...
0
votes
0answers
3 views

How do I get SQL Server Management Studio to find a .bak file to restore? [migrated]

I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see. I ...
0
votes
0answers
8 views

HDFS “-appendToFile” corrupts last line of file

In a nutshell, here's my example code. file1 = CSV delimited file, say, 1000 rows file2 = CSV delimited file, say, 3000 rows file3 = CSV delimited file, say, 10000 rows hdfs dfs -put file1 /home/...
0
votes
0answers
9 views

ERR_PROTECTED ERROR: nsfsem2.c/ln In IBM Domino [migrated]

My customer has been getting a series of errors at the Domino console, "ERR_PROTECTED". The Domino version is 8.5.3FP6 HF1020. The error is causing Domino to think that the database files are read-...
0
votes
1answer
42 views

Connecting to database on Amazon Elastic Beanstalk

I have written java web application (using jsp and servlet) and deployed it on elastic beanstalk server while it use database to collect Username and Password of Users'. On the other hand I have ...
0
votes
1answer
11 views

Citrix unable to start session in Firefox Quantum

In order to access the database service DBoD it is necessary to create a session through Citrix Receiver. But in Firefox this is no longer possible. Is this because "Citrix Receiver" was replaced by "...
0
votes
0answers
11 views

Failed Jetpack Update Destroyed My Wordpress Website [migrated]

All was not lost, fortunately, but because I had an old copy of the website and database and used a local server I was able to determine the culprit behind the loss of all my recent changes. I was ...
0
votes
0answers
13 views

SQLAlchemy not connecting (first time user)

I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need ...
0
votes
1answer
45 views

How to move values from one column to another based on matching values from other columns

Example of what I'm trying to do: Hopefully the attached image helps you understand what I'm going for. I have 2 massive Excel files, one with names & income in the column next to them and ...
0
votes
0answers
44 views

MySQL Server 8.0. my.ini file editing. To prevent MySQL Server from connecting to Internet

I want to install MySQL Server 8.0 on my desktop computer. The operating system is Windows 10 Home. I want to prevent MySQL Server from connecting to the Internet. I assume that MySQL Server is ...
3
votes
1answer
288 views

MS Access - Grouped query based on MAX field

I am trying to build a SQL Query that takes the following data: +-------------+--------+---------+---------+--------+ | Primary Key | ID | Version | Class | Fruit? | +-------------+--------+----...
0
votes
0answers
18 views

How to create readonly table from raw data

If I have a large table of data, essentially like a database, can I create another sheet or range that is a filtered subset of the full dataset? If so, will it stay up to date when the main table ...
0
votes
1answer
31 views

Terminating a SLURM zombie job

I have encountered the following problem during a first hard shutdown of the department cluster I am in charge of. The system is running SLURM 17.11 and using MariaDB/SQL to store accounting data. To ...
-1
votes
0answers
40 views

Excel Athletics Data

I've been trying to do a report which summarizes all my athletics records in a way that shows my season bests and personal bests. Questions: How can I select data and filter it in a way that selects ...
0
votes
0answers
51 views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
0
votes
1answer
84 views

Store, sort, and filter for multiple values in same column

I use an Excel table to manage a large database containing metadata of files along the following lines: Context Activities File Folder --------------------------------------------...
-1
votes
0answers
28 views

Solr, how does the indexing work?

Ok, so I'm trying to upload some data onto my Solr server via WebUI and update. Let's say that I'm uploading 5k lines of CSV data, which would be 5MB in a txt file. With 6 fields it takes about an ...
0
votes
1answer
24 views

IPSec database location

Internet Protocol Security (IPSec) has two database: Security Policy Database (SPD) and Security Association Database (SAD) I want to know where are these database located? Do they exist on both ...
0
votes
0answers
17 views

Linking tables in MS SQL databases

This is more a question to get some suggestions of software. I hope it is OK to ask it here. Say I have a MS SQL-database from a source system that I want to migrate to another MS SQL-server. When ...
-2
votes
1answer
39 views

How to increment a list of values with a button

I am trying to manage a list of students in an excel database. I am trying to create a button that will increment the semester column by 1 when clicked. I have tried using an active-x button and a ...
0
votes
0answers
17 views

Docker - One database server per service?

I'm planning to run multiple web-services on my home-server using docker and docker-compose. Some of them require a database and I was just wondering if it makes more sense to create one big docker-...
1
vote
1answer
29 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
0
votes
0answers
16 views

Multi-threaded concurrent INSERT on SQLite3 DB

The SQLite3 documentation seems to clearly indicate multiple concurrent threads can read from the same SQLite3 database at the same time, but it is not so clear about writes. Can I write (INSERT/...
2
votes
1answer
54 views

Database server for web browser [closed]

What is the most used database server for web browsers such as Chrome, Firefox, Opera, or Safari? Maybe I don't understand web browsers, but I am assuming they must have a database server the same way ...
0
votes
1answer
1k views

Problems connecting using MongoDB Compass

I'm trying to see the contents of a collection using MongoDB Compass. I have username/password authentication set up. I can log in successfully but can't see any documents in the collection. Instead, ...
0
votes
0answers
67 views

How to improve PostgreSQL database backup script - used with crontab

There are about 15 databases to backup on a daily basis. Password is set for the postgres user. pg_dumpall is executed at the beginning of the script for a complete backup. pg_dump is ran in the same ...
0
votes
1answer
28 views

How do you insert weekends into data only containing weekday dates?

I have 2 year daily closing prices for Bitcoin, from 1st August 2016 to 31st July 2018. Bitcoin can be traded 7 days a week so this data includes the dates of weekends: I want to add more data sets, ...
-1
votes
1answer
66 views

Better to use 1 or multiple database tables? [closed]

I am experimenting with databases (using Access currently, as i have it through work). To get acquainted, I am making a database to log catches on my fishing trips. There are several "categories" of ...
0
votes
1answer
189 views

WSUS WID Database recovery

My WSUS server, a Hyper-V VM running on a Window Server 2012 R2 Host, after a host power failure and later boot-up, showing error: Application: 3414 Source: MSSQL$MICROSOFT##WID An error occurred ...
0
votes
1answer
37 views

Is it possible to decrypt a file without knowing password only an encrypted string?

I am stuck at a point, here I have encryptionkeys.db(i don't know the use of a file). The folder name is also encrypted(coded) I know the folder name(decrypted), with this I just want to get the ...
0
votes
0answers
144 views

Batch file is not importing data into the datadbase

I'm trying to connect to orientdb, then restore values into the particular database, using this batch file: cd C:\All_Projects\orientdb-community-2.2.34\bin start console.bat , CONNECT PLOCAL:../...
0
votes
0answers
56 views

Sql server on ubuntu doesn't respnod

I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app ...
0
votes
0answers
144 views

Visualizing Packet Captures in Grafana

What is the best way to import a pcap into Grafana? Is there a particular data source or process that should be followed?
0
votes
1answer
25 views

Copy data from one sheet's cell to multiple cells in another sheet

I have this database where I store sales. I can find particular sales by filtering. I would like to have a button that then regenerates the sales as "receipts" in another sheet. This is my code for ...
0
votes
1answer
62 views

Use Notepad++ to convert file content format

So, I have a really huge database with the records that I export to a file and within this file the data records are in this format: date of registration;username;email:hashed password Examples 24-...