Category "database"

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

What are the rules for collection names in SOLR?

What is the naming ruleset for collections that should be followed, or in other words what are the inacceptable characters for a collection name? (for example,

app.post('\pageNameOrCanBeAnyRandomName')?

I have a page called createEmployee.js which includes 2 functions (fetchData and createNewEmployee) ... see below: const fetchData = async() => { c

Set and get Image in objectbox

I want to set and get image from local storage, but I have no idea how to do this.

Python sqlite3.OperationalError: no such table:

I am trying to store data about pupils at a school. I've done a few tables before, such as one for passwords and Teachers which I will later bring together in o

Other Categories