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 designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.

-1
votes
0answers
7 views

How should be the design of a scalable backend including database

I was wondering if I could look into a good design or design principle to follow while you develop your backend. I know this is a general question and rules might differ for different technologies. ...
-2
votes
1answer
31 views

how to select from sql?

I have a sql statment in my app (basic4android) which is: <i>"SELECT * FROM `TempCodes` WHERE `Code` ='" & TempCode & "'"</i> after running this and sending to php file i get ...
-1
votes
1answer
12 views

Require a user to select at least one HTML checkbox

<input type="checkbox" name="category" value="Restorative"><label for="">Restorative</label> <br> <input type="checkbox" name="category" value="Esthetics"><label for=...
0
votes
1answer
34 views

How to create Student Subject with prerequisite Database

i am trying to create a database for subject prerequisite this is my current table. "student" ----------------------- |studentID | FullName | ----------------------- |1234 | John | |1235 ...
0
votes
0answers
3 views

twaitforsqldata component in talend

I need to add context variable as the value of twaitforsqldata component in talend Right now if I enter any number like 1 or 2 it works but when I enter the context variable it doesn't. and I need to ...
0
votes
0answers
14 views

Rails 5.2+: Retrieving a resource and attributes from parent record 4 associations away

I'm trying to figure out how to optimize this SQL query to avoid n+1 situations. I have some associations setup like this: a has_many b b has_many c c has_many d d has_many e I'm returning a ...
0
votes
1answer
33 views

Retrieving data from a many-to-many relationship in a recipes database

I am attempting to create a recipes database where a user can input ingredients and it will output a list of potential recipes. I have created three tables: CREATE TABLE [dbo].[Ingredients] ( [...
0
votes
0answers
55 views

How to insert value in table by ID?

i have php code and mysql database and i have one problem, for example i have item with name Subaru with ID 1 and also Ford with ID 2 when i try to add event for Subaru it's not adding value to ID 1 ...
-1
votes
0answers
11 views

Database connection form D drive on iis

I am currently building my project in core php. In that used the mysql for the data storage. Now i have to transfer my project form test environment to the production environment. But the ...
-1
votes
0answers
11 views

Trying to do a Logistic Regression using sklearn (python)

I am trying to implement a Linear Regression model but when I try to fit it, I get an error. I used the dummies library to encode two columns 'Hight' and 'Low'. I tried to pass my Data Frame to an np....
0
votes
1answer
21 views

How to save new Django database entries to JSON?

The git repo for my Django app includes several .tsv files which contain the initial entries to populate my app's database. During app setup, these items are imported into the app's SQLite database. ...
-1
votes
5answers
54 views

Find a Primary Key and do an 1NF, 2NF, 3NF [on hold]

Grade (stu_name, stu_id, stu_pwd, fac_name, fac_id, fac_pwd, c_name, time, section, instr_id, s_id, type, score) Where each attribute is used as the follows: stu_name full name of a student ...
1
vote
1answer
26 views

Database Question with one-to-many relationship with default

I have a User table, and an Address table. The User can have many addresses, so the Address table entry has a foreign key to a User. My Question is: The user can have many addresses, but can label ...
1
vote
1answer
11 views

loopback 4 discover models from database

i have a database ready using postgresgl and i am using loopback 4 as framework and i want to create automatically my models by reading them from the database. i created a connection between loopback ...
-6
votes
0answers
28 views

I wanna make Referral Code system in my web-site! Who can explain the logic behind the Database? [duplicate]

Username John is the owner of Referral Code and when Two users have entered John's Referral code, but they saves to new to Database line how to save them at the same line, to John's line? Another ...
0
votes
3answers
39 views

Add missing members to a table from other table SQL Server

i have 2 tables: First table is [Table_Time]: Month Number Week Number ------------ ----------- 1 01 1 02 1 03 1 04 2 05 2 ...
0
votes
0answers
7 views

Android Firebase database custom username is not working? [on hold]

enter image description herei try to log in using reference data from firebase databae.But i can,t find out the problem . the button is also not working
0
votes
0answers
22 views

Python tkinter - connect images to items in listbox

I want to display in tkinter GUI different images, connected to the items in listbox, which are kept in mysql database. I have no clue how to do it. For instance if someone choose an apple i would ...
0
votes
2answers
18 views

rails migration : check existence of multiple columns

I have a company table and I want to check the existence of multiple column to remove them. class RemoveSettingsReportColumnsFromCompany < ActiveRecord::Migration[5.1] def change if ...
-1
votes
0answers
13 views

AZure database (SQL) cannot be deleted or created

We had a database called 'ABC' on Azure Pay-AS-You-Go plan We were able to Delete and re-create it successfully each day for many days. However, suddenly we are having a problem that the database ...
0
votes
1answer
10 views

How to create connection pool with mysql database which is present on remote server?

i am working on a MVC project in java. For my operation I use database many times. many times my database connection gives my error like connection is not free to use. So I want to create a connection ...
0
votes
0answers
12 views

Navigation Menu Launches Form with attached query

Working on a database, using Access 2016 with a navigation menu, the menu has links to some query based forms, but for some reason, when I launch the database, it opens the first item on the menu ...
-6
votes
1answer
31 views

Is it possible to select and display a .db or .csv file into a table in a website using php?

i'm new to web development, so we are working in a project and we have a .db file that store some data from a device, and that device keep updating the data into .db file and .csv file in our server. ...
-4
votes
1answer
32 views

How to store large amounts of data to create databases on an Android application [on hold]

I've got a large amount of data to be inserted in a database, but don't know where to put this information so the program can read it and insert in the database. I created a pseudocode where I ...
-3
votes
0answers
19 views

Laws for database owners

:) So I have a firebase database in my app, and it basically is a chat app where you can send messages and picures. I'm still new to all these databases things so I might be wrong, but I have pretty ...
0
votes
2answers
27 views

Error on creating foreign key relationship between non-primary key

I have two table CREATE TABLE `abc` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ref_id` varchar(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ref_id_UNIQUE` (`ref_id`) ) CREATE TABLE `xyz` ( `id` int(...
0
votes
0answers
12 views

Filter textarea input data

want to achieve such a function when textarea is submitted to the database, line breaks are removed (eg \n --> "bar2019"). data exported from the databased and show, the same effect as div.output (...
0
votes
0answers
11 views

Are AVL Trees any good for Databases?

AVL Trees run 20 times faster on SSD than on HDD - so in theory they may compete with B+ Trees - what do you think?
0
votes
0answers
28 views

Tracking a database over time

I have a MySQL database of groups. I am tracking "Group A, B, C..." and who is the group leader of A, B, C. How many members are apart of the group, etc. I want to be able to look at this over ...
0
votes
1answer
38 views

unable to find desired result in search filter query

I am trying from last 2 days to get desired result in query but unable to do that. Basically I am making query for a restaurant website "tag based" search filter to search in the favorite dishes. ...
1
vote
3answers
46 views

SQL to delete tables that begins with common prefix

I am looking to write a SQL query/stored procedure which would delete tables within a DB that begin with a common prefix like "table". However the names of the tables begin with the prefix following ...
0
votes
0answers
6 views

Twig template names when stored in DB?

I will use twig for a PHP project in which I need templates. They will be stored in the database using a custom LoaderInterface like in https://twig.symfony.com/doc/2.x/recipes.html#using-a-database-...
0
votes
0answers
16 views

Does uninstalling the android app will remove sqlite database, if sqlite database is locked.? [on hold]

My application database is locked and the database is not updating even the uninstall and install the application.In crash analytics i was found the exception like fallow... Caused by android....
0
votes
0answers
9 views

Joint two tables from different postgreSQL database in Codeigniter 3 [duplicate]

I have two different postgreSQL database in one server. My goal is that join two table in codeigniter 3. However they are in different database when I run my sql statement SELECT * FROM ArticlesDB....
0
votes
1answer
18 views

Excel database formula

Have more then 200k rows and want sort it via multiple criterias. COUNTIF works perfectly but at the end waiting minutes for simple changes becouse there is more then 1500 formulas. So i desided for ...
1
vote
1answer
23 views

Get Storing updated rows and previous rows as well

Let's suppose I have table as : column_1 | column_2 | column_3 | column_4 abc 12 23 34 abc 01 12 45 I am looking for query something like ...
0
votes
0answers
40 views

How can we import php mysql database into google cloud?

I have developed a game using unity3d. For user registration and login I used php and use one of the database of my website. But now I want to change database and want to use google cloud. But while I ...
0
votes
0answers
35 views

How to generate API key to access Firebase Database [on hold]

I'm developing a IoT web application with Firebase. a beginner in this field and I don't know how to describe this in detail but, I want to know how to generate unique non-expiring API key with ...
0
votes
2answers
33 views

Combining two queries with different WHERE conditions

I am trying to use sqlite3 to get results for two queries with different WHERE conditions from the same table. I can get the queries to work independently, but haven't been able to combine them. ...
1
vote
2answers
25 views

Join using 4 tables using Oracle

I have 4 tables in oracle database: student, country, province, district --------------------------------------------------------------------------- student : student_id,student_name,country_id,...
0
votes
0answers
30 views

I am checking the values of the rows of a table and try to import another values of this table to another table

What I am trying to do is check with fetch_assoc() some column of rows of table Warning. Then if those checks are correct I would like to insert into another table DataTable values of some columns of ...
-1
votes
0answers
14 views

What should I do to work my log in system

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\CWebsite\connectivity.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\CWebsite\connectivity.php on ...
0
votes
1answer
23 views

Updating many mongoDB records of a field based on a condition

I have few records in my Mongo DB. The currentStatus field has either of three statuses ("IDLE", "ACTIVE", "SHUTDOWN"). I want to update all records in the currentStatus field from "IDLE" or "ACTIVE" ...
1
vote
0answers
36 views

How to populate resulted array of Id's with $lookup

I am trying to find all reviews for a given item uploaded by a user. I want to display inside my user profile page a list of all his uploaded products and for each item want to display some reviews. ...
0
votes
0answers
4 views

Using LTREE type when the final node has ~1000 descendants, which exist under other final nodes?

Is it inappropriate to use LTREE type when the final node has ~1000 descendants, which exist under other final nodes? My data is essentially a directory tree, with the final level containing text ...
0
votes
1answer
23 views

SQL Update Statement not working but the information from row=fetch_assoc() are printed on the screen

I am looping through the rows of the database with fetch_assoc() and I am selecting two columns of it. I check the values of these two columns of each row. If they are between 2 values then I updated ...
0
votes
1answer
25 views

Query from 3 tables, lasts forever

I am using mysql-workbench 6.3 on Ubuntu 18.04. I have three tables created as follows: CREATE TABLE `prefix_random` ( `domain` varchar(500) NOT NULL, PRIMARY KEY (`domain`), UNIQUE KEY `...
0
votes
0answers
11 views

Oracle Data Access Components (ODAC) 12c installer error

I am trying to install ODAC 12c on my computer but I am getting an error. The error is: The type initializer for 'VisualStudio.Setup.Download.WebClientEngine' threw an exception.
0
votes
0answers
18 views

PHP and HTML combined file [duplicate]

I have simple HTML login form and PHP that has database connection in the same file but always got an error. I want the user to enter valid username & password then check if it's in the database ...
0
votes
0answers
17 views

How should I handle binary buffers that very dramatically in size to minimize overhead in accessing data?

I have a python application that retrieves a set of buffers, does some processing (after collecting several buffers) and then (may) save them to disk. The issue is that these binary buffers can range ...

http://mssss.yulina-kosm.ru