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,184
questions
-1
votes
1
answer
11
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
11
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 ...
0
votes
0
answers
34
views
What is wrong with my GET and PUT test commands?
For my CRUD in Django the POST and DELETE tests are working:
curl -X POST http://localhost:8000/user/ -H "Content-Type: application/json" -d "{\"username\": \"john_doe\&...
0
votes
0
answers
13
views
Codeigniter - I'm having an issue with the dropdown it’s not populating the dropdown as expected, and I’m not sure what the exact problem is
When I tried to print the data, it is being printed correctly. However, I'm having trouble with the view file it’s not populating the dropdown as expected. If anyone knows what might be wrong, please ...
0
votes
0
answers
6
views
DataNucleus for RDBMS Setup Issue: Meta-Data Not Enhanced or Multiple Persistence API JARs in CLASSPATH
What is the correct way to use Datanucleus for RDBMS (Database)?
My project setup is throwing this error:
SEVERE: Found Meta-Data for class org.example.core.project.model.Project but this class is ...
0
votes
0
answers
14
views
Is Reverse lookup of Country to IP ranges supported in Maxmind databases?
I understood the way to query a country name by passing an IP address. But I'm also looking to get ip ranges by passing the country code. my question is, is this possible with the Maxmind database?
I ...
-1
votes
0
answers
19
views
Designing a MongoDB Schema for Efficiently Managing and Querying Ordered Sequential Values
I have a mongoDB collection findings which contains the following documents
{
name: "finding1",
group: "group1"
},
{
name: "finding2",
group: "group1"
},...
-4
votes
0
answers
32
views
How create and use online database for python application? [closed]
How can I create an online database for my python application to get data from, send data to, and update data from?
Example 1: When the user logs in, the application sends the entered username to the ...
1
vote
0
answers
6
views
GPS Map Camera app with automatic upload to database
I want to an app that has features available in GPS Map Camera app (gpsmapcamera.com).
I want to an app that has features available in GPS Map Camera app (gpsmapcamera.com). Apart from that, once the ...
0
votes
0
answers
7
views
How to display a highly-zoomable, time-series spectrogram on the web [closed]
I have a large amount of 3D (time, freq, intensity), time-series spectrogram data that spans well over a week of data. I want to create a timeline of this data (likely using React) where I can keep ...
0
votes
1
answer
22
views
LENGTH of ARRAY [42883]: ERROR: function array_length(text[]) does not exist
ON PostgreSQL 9.6.10 (Red Hat 4.8.5-28), 64-bit
select string_to_array('file.name.pdf', '.')
{file,nome,pdf}
select array_length(string_to_array('file.nome.pdf', '.'))
[42883]: ERROR: function ...
0
votes
0
answers
16
views
How To Insert query in Flutter with PostgreSQL new package? postgres: ^3.2.1
How To Insert query in Flutter with PostgreSQL new package? postgres: ^3.2.1
all the other documentation are old, deprecated and not working anymore, could you someone please help on this..?
How to ...
-1
votes
0
answers
39
views
` java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/supermarketdb [closed]
I've been trying to set up my own REST API for a school project. I decided to use Apache Derby as a database and I want to connect it with my web service, but apparently, I always get this error ...
-1
votes
0
answers
24
views
How can I get a separated row instead of a CSV concated group?
I have the following query:
SELECT GROUP_CONCAT(p.name) AS names
FROM cte t
LEFT JOIN products p
ON p.tag_id = t.id
GROUP BY t.orig_id
HAVING SUM(t.id = 6) > 0;
It returns something like this:
...
0
votes
0
answers
18
views
Read one table write to another data race SQL solution
I'm currently learning about database transactions, isolation levels, and SQL in general. I've thought up a problem which involves a potential data race and can't seem to figure out the solution ...