Category "database"

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

how to make oracle UTL_HTTP.request asynchronous?

I have a job that runs periodically , and I am not interested in the response ?? is there anyway to make the calling convention , request without waiting for t

C# - ASP.NET - Inserting Date from a calendar into a DataBase

I am trying to store the date from a calendar which the user has selected into a database. It seems to not being inserting it into the Access Database. The DB f

Difference between sparse index and dense index

I am very confused to understand the difference between sparse index and dense index. Can you explain the difference between them ?

Is there any way to get all ookla server list and store this into a data base?

i wanted to insert all available ookla servers into my data base for the speed test purpose for my android application. But i am not getting any way to find out

Cloudkit Public Database Error: "WRITE operation not permitted"

I have currently a problem with the CloudKit Public Database. Sometimes I receive an error when modifying records: Permission Failure" (10/2007); server messag

When logging in to Oracle Enterprise Manager, it is asking me for the credentials again. Why?

I'm trying to log in to: https://localhost:5500/em/login First, I entered my credentials at the bottom right area. Then, I clicked the button. After that, a po

Managing database connections in Node.js, best practices?

I'm building an Node application which will query simple and more complex (multiple joins) queries. I'm looking for suggestions on how I should manage the mySQL