Category "database"

How to populate options of h:selectOneMenu from database?

I am creating a web application, where you have to read a list of objects / entities from a DB and populate it in a JSF <h:selectOneMenu>. I am unable to

Are there any Datastructure and Database feature that could handle tag of tags?

I want to categorize data to search for content that can be tagged. However I want a tag to have relationship with other tag too and so it could be searched for

nodejs oracledb performance diff by the way of binding params

I wonder if there is a performance difference between below cases. nodejs oracledb lib - express server connection code - 1 query, 1 connection whenever I send

How to handle data in development, staging and production databases?

If you have a local database, Staging/UAT database, Production database 1)Say 10 developers have the database script to generate the database (I'm using liquiba

What is the difference between "rest/sql" and "rest/sqlutc" in TDengine's RESTful API

TDengine support RESTful apis, they are like "rest/sql", "rest/sqlt" and "rest/sqlutc". I know that "rest/sqlt" return timestamp as long. But I dont know what i

sql connection to populate table condenses rows

I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get

sql connection to populate table condenses rows

I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet get

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