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,220
questions
-1
votes
1
answer
17
views
How can I Dynamically and Permanently add texts and images in my Website from Database?
I am working on a website where users can add paragraphs to a page. I can retrieve the texts as string from the user and store it in my database.
I was thinking of using appendChild() but any change ...
-1
votes
0
answers
12
views
MongoDB database connecting to MongoDB compass error
2283904:error:10000438:SSL routines:OPENSSL_internal:TLSV1_ALERT_INTERNAL_ERROR:....\third_party\boringssl\src\ssl\tls_record.cc:592:SSL alert number 80
I have tried to connect my mongoDB data with ...
0
votes
0
answers
21
views
Why is my data from SQLite importing incorrectly into R?
The data I am having trouble importing from sqlite are in four columns:
PeakAwy_L
PeakAwy_R
PeakTwd_L
PeakTwd_R
I have the following R code to pull in those columns into R:
data_raw <- query_tbl(...
0
votes
0
answers
17
views
C# Plugin Database Connection
in the Autocad Plugin I wrote in C#, I can use the x, y axis and last field information entered by the user.
I want to save to SqLite database.
I would be very happy if you could help me on how to do ...
0
votes
0
answers
19
views
Seeding data when it has relationship
so i need to create foreach entity its own seed class.
the problem becomes when the is some hierarchy of entities, like one entity has a relation with another, second has relation with third and so on....
-3
votes
0
answers
15
views
Moving data to LIVE USB is it safe? [closed]
I have a LIVE USB that has Kali Linux on it.
I would like to ask, is it safe if I move my data such as photos, videos, etc. into the USB? thank you, hopefully someone can answer this question.
I have ...
0
votes
0
answers
22
views
Converting basic update logic from a table to a view in Snowflake
I'm working on converting something that's currently in a table in snowflake into a view. One of the big issues I've run into is that the code I was provided to build the table uses the SQL UPDATE ...
0
votes
0
answers
24
views
Caching a tableresult in psql for further queries
I was wondering if my thoughtprocess is somewhat reasonable or if there is a better way and what tooling to use.
Setting: I got a filter with fuzzy search and everything, this is the most "...
-1
votes
1
answer
41
views
how to convert an sql view to table
I have a view and its taking longer time to execute so i need to write simple query to rather than view.
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `...
0
votes
1
answer
26
views
How to use the right index to optimize a database to get rid of unwanted hash matches?
lately we have been learning about database managind through microsoft sql server management studio and were learning of how to use the index function to optimize a consult and data management, and a ...
-1
votes
1
answer
27
views
how to subtract by one from a database variable [closed]
This is my code where I try to subtract the variable.
I need to reduce the 'espacios' variable by one, of the specific company selected when sending the form and update it in the database
<?php
...
-1
votes
0
answers
20
views
How to recover a dropped table in mysql without backup [closed]
I mistakenly dropped a table in my database why trying to copy a table from one database to another using these queries
DROP TABLE IF EXISTS school.studentclasses;
CREATE TABLE school.studentclasses ...
0
votes
0
answers
15
views
How to install and use Sling Data to extract data from a database?
I am new to using Sling Data and need some help with the installation process and extracting data from a database. Here is what I have done so far:
1. Installation:
I have downloaded the Sling Data ...
-1
votes
0
answers
8
views
Database Entity Relationships with loops. How to implement
Consider the following ED. An Item can have a 1 or 0 Stores. A Store has many positions. An Item has 1 or 0 Positions. As you can see, It's a bit of a potential loop. Also I have to police the fact ...
0
votes
0
answers
7
views
CouchDB change the name of an admin role
How can I change the server admin role name in CouchDB to a different name? So for example instead of '_admin' I would like it to be 'server_admin'.