Category "database"

How does my list become ObservedList? Problem with replit db

I have a problem with making discord bot on repl.it, my list is 'ObservedList' and i dont know what to do with this, when I watch some tutorials its always just

MariaDB Import maximum key length

We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with Ph

SQL Server not listening on IP address even if TCP/IP is enabled

I am trying to set up MS SQL Server Express 2019 to listen on TCP/IP and connect to it through IP address instead of shared memory. I am currently connecting th

Why is the database of the webapp in the book "Head First Python 2nd Edition" not working as it should?

I'm currently studying Python by reading the book "Head First Python 2nd Edition" and it is really helpful and well-written, but I think it is a little anachron

Why the name of trucks are same in 2nd and 3rd record of company data retrieval?

My data in database: My objective is to retrieve all data of company collection (MongoDB) data from the database. The company collection holds one or many truc

Database relationship between a match and its players

I'm trying to design a database that would save matches and players in a 3v3 game. So far my models look like this : class Player(models.Model): user = mode

Backup/Restore a dockerized PostgreSQL database

I'm trying to backup/restore a PostgreSQL database as is explained on the Docker website, but the data is not restored. The volumes used by the database image

How to fix dbWriteTable error "unable to find an inherited method for function 'dbWriterTable' for signature...?"

I want to insert data in MySQL from a dataframe in R. I managed to connect without problems from R to MySQL using dbConnect, however when I try to insert my dat

Room Database Table is still empty after inserting new data

I've just finished this tutorial for my app. But my problem is that even after I insert the data, my database is still empty. I checked that by viewing it in a

How to fix dbWriteTable error "unable to find an inherited method for function 'dbWriterTable' for signature...?"

I want to insert data in MySQL from a dataframe in R. I managed to connect without problems from R to MySQL using dbConnect, however when I try to insert my dat

ARRAY_AGG() grouped by another column's values

Here's my table like below p_no type name value ------------------------ 1 A Tomy 1 1 A Nick 2 1 B Tomy 3 1 B Nick 4 1

What is the difference between MySQL and NoSQL Database?

I have been asked this question in several interviews and I am looking for answers in the terms of how do we choose between MySQL database and NoSQL database fo

Can't save data to database from input form - Laravel 8

it's me again. I have a problem saving data to the database from the input form that I made. Here is my web route: Route::get('/admin/data-karyawan', [BasicKary

Not able to create sharded collection

I have a mongodb Cluster with one config node(replication),one query node , and one shard node(with replication). I tried to create sharded collection but it is

Aerospike vs. SeaweedFS?

Aerospike is a (mostly commercial) distributed key value NoSQL database. SeaweedFS is a (open source) distributed file system that is based on Facebook’s

How to update record with the same data of existing record

How to update record many columns with the same data of existing record in the same table . For Example : id name m_value 1 moh 1000 2 jo 0

How Do I Seed My Database in the setupBeforeClass Method in a Laravel 4 Unit Test?

I have a Laravel 4 test class with some tests for which I want to seed my database before running the tests. Using the setup() function to reseed for each test

django makemigrations and migrate on heroku server don't create tables

Python Version 2.7 Django Version 1.9.7 I have created a Django app on heroku. I can't get the heroku server to migrate properly. In the past I have done all

The network path was not found

I'm running my code and getting this error. But what does it mean? The network path was not found Description: An unhandled exception occurred during the

PDOException SQLSTATE[HY000] [2002] No such file or directory

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as php artisan migrate