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 are typically organized to model aspects of reality in a way that supports processes requiring information.Use this tag if you have questions about ...

0
votes
0answers
4 views

Server-Syncing DB App, Questions on Primary Keys, Multiple Tables, and Saving Storage Space

I plan on making an app that can optionally store data-entries on a mysql central server (cloud) and use that server as a way to backup your data-entries or to sync data-entries between different ...
0
votes
0answers
2 views

While sending one image file from JSP to JSP page, how can I read it?

I have used the code shown below in JSP file to take input files in png, jpeg and jpg format.Citizenship: <input type="file" name="citizen" value="Citizenship" accept="image/png, image/jpeg, ...
0
votes
0answers
19 views

Get error: ORA-38824 during “create or replace” command

I have similar issue - when i try execute (compile package) "CREATE OR REPLACE" at a package body (just changes PLSQL code) then i have error:Error: ORA-38824: Команда CREATE OR REPLACE не может ...
0
votes
0answers
8 views

what is the relationship between these two entities (inventory tables,product)

1. an invoice is written by one salesrep but a salesrep writes many invoices2. a vendor sells many products but a product is bought from one vendor3. an invoice has one or many products and a ...
0
votes
0answers
16 views

Existing relational table to Adjacency List

I am trying to create a Parent-child relationship (Adjacency List) from the existing relational table (PostgreSQL).Here is the existing relational sample data+---------+-----------+-----------+----...
0
votes
0answers
7 views

Database normalization - to Decompose it into BCNF and find the canonical cover for F

I am trying to figure out the canonical cover for F of the table below and decompose it to BCNF. - Attribute of bookBook ID Title ISBN Publish Date Publisher ID Publisher Name Book score Author ID ...
-1
votes
0answers
21 views

MySQL store efficient way to store a lot [duplicate]

I am doing a php project where people can react on posts (give a comment). In my last project I did this and stored all the reactions in 1 table (from a the posts). Now I see that this can be a very ...
0
votes
0answers
6 views

SOA 12.1.3 database adapter to process 25k records overnight

Seeking your expert advice on the best approach to handle the below scenario.I am using 12.1.3 version SOA suite.I have a BPEL process which is scheduled to run on a daily basis. In that my ...
-1
votes
1answer
11 views

SQLSTATE[42S02]: Base table or view not found: 1146 Table - YII2

i'm using Yii2.I have done a major upgrade of my database during dev phase, and i just put on the prod server the new code. I also dropped the old database, and i installed a fresh dump of the new ...
-2
votes
0answers
46 views

Why the alert box doesn't show after I click button?

Can somebody help me regarding to my PHP and jQuery. My problem is there is no alert box show after I click save button. I put echo on my php code which is "Insert Successfully" and used jQuery to ...
0
votes
0answers
2 views

How to apply the reactively JS filtered rows to download the data

My problem is to filter a handy table out of a database. I managed to tidy the DB and the user can filter the columns interactively (not in the example code). Then the user can choose the columns, ...
0
votes
0answers
6 views

Firestore: How to Store Data on User and Global Levels with Calculations?

I was wondering what the best way to store data in firestore on a user and global level is so that all of the information is easily retrievable and can be calculated. For instance, lets say you are ...
0
votes
1answer
20 views

Data table that is searchable, filterable, sortable, orderable, exportable, server-side [on hold]

For work, I need a framework/library/plugin or set of tools that would provide a data table with the following features:SearchableFilterableSortableOrderableExportable (xls, csv, ..)Server-side ...
0
votes
0answers
7 views

pymongo - mongodb+srv “dnspython must be installed” error

I am trying to connect MongoDB from Atlas But I encountered "dnspython must be installed error".My mongo uri (mockup): mongodb+src://abc:123@something.something.com/admin?retryWrites=TrueMy ...
1
vote
1answer
10 views

Maintaining only predefined limited number of entries in objectbox

I am using Objectbox db. I have a box for storing data. I want limit the db size to 100 entries with first in first out basis.For example if we put 101th entry, then the 1st entry should be ...
0
votes
0answers
5 views

Editing the datbase data through pentaho dashboard

I have a dashboard in which there is a table retrieved from postgreSQL. There should be an edit button and if we click on the edit button it will allow us to edit the value and same should be reflect ...
0
votes
0answers
9 views

Refreshing DB Python 2.7 Visual Studio 2010 never ends

I'm trying to refresh the DB in Visual Studio 2010 for Python 2.7 and it always stops at about 30 % at "Analyzing site-packages\astropy".According to the entries("https://github.com/Microsoft/PTVS/...
-1
votes
1answer
26 views

hard to understand how to use self join and it function

This is my codding and the value insert to the table. CREATE TABLE provendor (prcode varchar (10), prvendor varchar (5),prpricing decimal (9,2));INSERT INTO provendor(prcode, prvendor,...
-1
votes
1answer
23 views

How to show child data of a userid of firebase data in my recyclerview?

I want to show this snapchat and twitter in my recycler viewString userid=mAuth.getCurrentUser().getUid();db=db.child(userid);
-1
votes
0answers
45 views

$_POST returning no value [duplicate]

Edit note: This isn't a duplicate of the link it says it's a duplicate of, I am using the form submit to call the php so it won't have already been called when the page loaded.When I check the ...
0
votes
0answers
24 views

Database schema to map Hotel Amenities from different sources into a uniform format to remove duplicates

I am creating a hotel application that fetches hotel feeds from different sources and store it to database to form a uniform structure and expose API to the mobile application. I am fetching hotels ...
-2
votes
0answers
31 views

How to get Next increment id in Room Database?

I am using Room Database for my chat app and I want to know how to get Next increment id of my primary key.In sqlite i know about it but in Room Database how to get that id, like in sqlite Max id ...
-1
votes
1answer
14 views

How we can join sqltrace.activity_trace_evmon and sqltrace.activitystmt_trace_evmon tables in db2

I am doing DB2 monitoring : Tracing SQL statements by using an activity event monitor.Data has been logged in sqltrace.activity_trace_evmon and sqltrace.activitystmt_trace_evmo tables however i ...
0
votes
1answer
21 views

Firebase Cloud + Angular6: save response from db in class property

I'm having such a hard time using the cloud storage from firebase with Angular that I end up in a dead end.I'm trying to do something simple: retrieving the data from the database and saving it in a ...
1
vote
0answers
21 views

Is it possible that MongoDB immediately writes on the disk and does not store the informations in the memory?

Under Windows 10, I am using MongoDB 4.0.0 Community Edition (standalone) installation and with the help of the Windows task scheduler I regularly run a task which updates my database by adding new ...
0
votes
0answers
6 views

How to capture on-premise database events and pass it to google cloud pub/sub for realtime sync

I am new to google cloud platform. We have requirement of syncing on-premise database in real-time to databases deployed in different regions. I know google supports pub/sub mechanism to achieve this....
2
votes
2answers
37 views

Does MySQL (5.6) always cache the entire result set for a query in memory/on disk?

I need to dump a few very large MySQL tables to csv (hosted on RDS so no SELECT INTO OUTFILE). These tables are far larger than the available memory on their server. If I execute a SELECT * FROM ...
0
votes
1answer
40 views

App crashes loading database at the first run

In my app, I'm using a service to get data from JSON and then save it in the database.when I run the app on a new device it crashes without any error!But when I comment out the code that is for ...
0
votes
0answers
10 views

Workflow E-R design

I'm designing a workflow and stuck on a problem. I would have table WORKFLOW where name would be stored. Table WORKINS would be instances of workflow definition. Then Workflow is composed with:TASK ...
0
votes
1answer
27 views

Unkown column data type when creating table

I need to create a MySQL table with following columns:id-------order_id-------service_id -------service_infobut I don't know what type of data will be stored in service_info column. It could be ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,