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,181
questions
0
votes
0
answers
4
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
9
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
13
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
5
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
19
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
12
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
31
views
` java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/supermarketdb
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 ...
0
votes
0
answers
21
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
14
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 ...
0
votes
0
answers
9
views
How to get raw json or other data for onecall ticket
I am trying to get the data that populates the ticket here: https://ia.itic.occinc.com/iarecApp/ticketSearchAndStatusView.jsp?enc=%2B%2FG1BMVDAKGJSwm2QiSowfk5NrkGvXR9ZW9t6AwXqmv0wkQXl%2FZjXxhBxVIJbBZH
...
0
votes
1
answer
17
views
How to do Join on composite key with postgREST?
I am struggling to find the right syntax to perform a (nested) join on on composite foreign keys.
For example, my tables are
CREATE TABLE post (id TEXT PRIMARY KEY, userId TEXT REFERENCES user(id), ...
0
votes
0
answers
11
views
Optimized way to handle user graded items?
I'm working on website that allows users to grade items, e.g. books. The grade should be displayed on the book page, but also on the collective page containing all books. The grades should be possible ...
-1
votes
1
answer
32
views
"Microservices Using Database Per Service" pattern in practice
I am working on a project where I would like to use this pattern. I have read for days, but I am still not sure how to implement this pattern properly and keep the multiple DBs in sync.
Let's suppose ...