Category "database"

Can't store Files in public folder in Laravel 8

i'm trying to store pdf, txt... in DB but i get this error: Method Illuminate\Validation\Validator::validateCsv,txt,xlx,xls,pdf does not exist. but when i add r

Dplyr summarize "sum" function works correctly only for subset not the larger dataset in R

I have a dataset where I sampled abundance of 4 species across 12 months, 6 sites (5 replicates within a site). I am trying to calculate various summary stats (

knex migration - 'ER_INVALID_DEFAULT: Invalid default value for 'timestamp'

I have a knex chema migration to create a table, with the line - exports.up = async function(knex) { return knex.schema.createTable("newTable", table => { ta

knex migration - 'ER_INVALID_DEFAULT: Invalid default value for 'timestamp'

I have a knex chema migration to create a table, with the line - exports.up = async function(knex) { return knex.schema.createTable("newTable", table => { ta

Digitalocean basic droplet for wordpress website showing database error every now and then

I have created a basic 5$ droplet with digital ocean to host a wordpress website. After installing the wordpress as soon a i login to the dashboard and start wo

Giveaway Bot with buttons discord.py

Hi this is my giveaway bot command, currently, I am using reactions in it but I want to replace it with buttons like someone clicks on the button then participa

Is it possible to know the size of a variable that is being created while the function is running?

I am very new to R and I was exploring a function in a library that download data from a server and leaves the data as dataframe. The data are stored in a varia

How can I make my database auto update a column when the date in another column reaches the current date?

I have created a asp net core web application that implements an online system of borrowing books from a library. I have created a table with the following stru

Redirect wordpress website to another site

I moved my wordpress website with updraftpluse backup plugin to another domain and now when I open new domain website redircet to Previous domain. what can I do

Pre-define the number of rows in mysql

I am making a cinema booking system for my dbms project. for the bookings table , I only want a certain number of inserts in a table to be possible. How can i a

Bloom Filters with the Kirsch Mitzenmacher optimization

I have recently started playing around with Bloom Filters, and I have a use case in which this calculator suggests to use 15 different and unrelated hash functi

Is the logic and the implementation of this query correct?

So i have a table that logs users using certain apps. It has the fields below id time app user server type (can be IN or OUT) So a user starts using a certain

Django many-to-many relations

I'm trying to create a web app in which users can participate in some groups (every user can be part of multiple groups), and I want to be able to make both que

Learning MySQL with PopSQL and wanted to carry on with a tutorial but I cant connect to my database. Error 1049 No connection

I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show

Initializing an hyperarray parameter agent attribute from a database

I am similar problem to this Initializing an array agent attribute from a database but Im having a problem as it brings back the whole row of data and not only

print multiple return from void to multiple textboxes in c#

i'm trying to build a question-solving module, so i want to randomly print the "correct answer" data i got from the database, i use a void to get the data, i wa

Sorting and getting position or row nth number of sqlite database for Android studio

I have this table of students public void onCreate(SQLiteDatabase db) { String createTableStatement= "CREATE TABLE " + STUDENT_TABLES + " (" + ID_COL + "

Improve insert performance for a C# application into SQL database

I need to improve the performance of my insert in my C# application. I first go out and get data from a view. Then I go through a FOREACH loop to insert into a

JSON Database doesn't work correctly as per REST technique

I created a JSON server and this is the data that I'm using. However, when I'm trying to query the examlist and relate it to the students (i'd like to receive t

ngIf display button if a field has certain value in Database

I need to have a button (by ngIf) when a field in Db has certain value, Any Idea? Do I need store procedure and.. Thanks