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,270
questions
0
votes
0
answers
34
views
unsure how to resolve sqlx error : "error with configuration: no driver found for URL scheme "postgres""
I'm following along zero to production book and I've reached the point where I'm supposed to create a database connection with sqlx and Docker. I've been following all the steps in order to establish ...
-1
votes
0
answers
26
views
How do i treat a large number of excel files like a database? [closed]
I'm facing a situation where I have to deal with 20+ excel files daily with each one being similar to a "table" in a database but the timeframe of each is different (some are daily snapshots ...
0
votes
0
answers
23
views
Database does not exist docker image Npgsql.PostgresException (0x80004005): 3D000: database "CatalogDb" does not exist
I am trying to connect to postgres database running on docker container from visual studio, I am sure the DB exists and here is the logs:
docker ps:
docker ps
CONTAINER ID IMAGE COMMAND ...
-2
votes
1
answer
41
views
How does Tinder gives me only new profiles? [Database design]
I have probably swiped 10k profiles either left or right.
If I open the app tomorrow I will get 10 profiles I have never seen.
How can these profile be queried efficiently?
For sure an SQL query of ...
0
votes
1
answer
7
views
How does PieCloudDB detect if there is a deadlock?
I would like to know if PieCloudDB Database has a deadlock detection mechanism. What parameter settings can be used to turn on the deadlock detection function? Or what views can I use to check the ...
0
votes
2
answers
51
views
SQL Query - Ignore row if data is null for multiple rows on single condition
I have a below table
cid
step
cr_time
120
S02
08-JUL-24 09.35.19.000 AM
120
S03
08-JUL-24 01.35.19.000 PM
120
S04
09-JUL-24 02.35.19.000 PM
121
S02
09-JUL-24 07.35.19.000 AM
121
S03
09-JUL-24 02....
-4
votes
0
answers
24
views
symmetry fitting problem with target file
I am constructing a dataset with 6 columns and 6700 rows. This data is obtained from photon dose conversion coefficients that were extracted from various Monte Carlo simulations in different studies. ...
-1
votes
0
answers
47
views
How to create optional properties in C#? [closed]
I want to create somewhat of a notebook app, where I can store different notes in a database, I'm using Entity Framework for the context. I have 2 different note types, one with input field and one ...
-2
votes
0
answers
25
views
How to insert script code in php code in script code again [duplicate]
hello Can some one solve my bizzare code, I wrote code then I put a php code inside function variable, and in that function I adding again code inside php,
it means Script code in php code in script ...
-2
votes
0
answers
25
views
Database design for audio content streaming application [closed]
I have this task to design a database schema for a simple audio content streaming application, and I have questions about what would be the best way to store relations between tracks and playlists.
I ...
0
votes
1
answer
7
views
How to extract JSON array in PieCloudDB
I am new to JSON, in my PieCloudDB Database there is a json column as follows(example data):
{"A001": ["123","124","125"],"A002": ["234",&...
0
votes
0
answers
18
views
Spring cloud data flow cannot find driver class at startup
I'm trying to up spring cloud data flow in my local. By default SCDF use h2 as primary database to store meta information. In my cloud-task-batch application all the properties related to database are ...
0
votes
1
answer
20
views
Can I do a replication from cluster A to cluster B? [closed]
How are they ?
A question, can I do a replication from cluster A to cluster B in Cassandra in docker?
I have been looking for information about it but the only thing I have managed to do is replicate ...
-1
votes
1
answer
15
views
Network configuration error occurs when deploying PieCloudDB on Ubuntu
I recently tried to deploy PieCloudDB Database Community Edition 2.14 on a single-node cluster using ubuntu server 20.04, but an error related to network configuration occurred during the installation ...
-3
votes
0
answers
25
views
Installing Staging on my domain and database prefix issue
I’m encountering a problem while installing Staging on the site web. The error message is as follows:
"Could not determine the database prefix for my domain"
This indicates that the database ...