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,298
questions
0
votes
1
answer
62
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\&...
1
vote
0
answers
26
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
9
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
16
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 ...
-2
votes
0
answers
27
views
Designing a MongoDB Schema for Efficiently Managing and Querying Ordered Sequential Values [closed]
I have a mongoDB collection findings which contains the following documents
{
name: "finding1",
group: "group1"
},
{
name: "finding2",
group: "group1"
},...
1
vote
0
answers
10
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
8
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
26
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
20
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
55
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
1
answer
41
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
21
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
11
views
How to get raw json or other data for onecall ticket [closed]
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
27
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
1
answer
20
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 ...