Category "database"

Set mongoose schema with changing fields

I want to make a mongoose schema that will append timeseries data. I got the idea for that model after reading this (https://www.mongodb.com/blog/post/schema-de

Which relation in MongoDB is better?

For my whole projects I have relationed my multiple collection as this. User model Name:string, email:string, password:string, vehicles:[{ "vehicleId", "vehi

Prefered results

I am trying to list all DEPARTMENT_IDs with PRODUCT_IDs, first where PRODUCT_COST_STATUS = 1 but there are also data with where PRODUCT_COST_STATUS = 0. I prefe

Question - What is the pearson correlation between average dew point and average temperature? my code:

This is my Code * corr_matrix = np.corrcoef(data['Average dewpoint (°F)']data['Average temperature(°F)']) corr = "corr = " + str(round(corr_matrix[1][0]

Create new productpage when new database entry

How can I create a new page when I enter a new product in my database, or hide the parameter inside a normal /.../ ? In this example I will sell Sandles with th

How should I design my application to handle large amounts of data?

I am building an application for building sports betting models. Basically users can create their own criteria and backtest their models across historical data.

How to connect database to data files in Azure Blob?

This resource states that a Azure SQL database may be attached to a database by using the following command: WITH IDENTITY='SHARED ACCESS SIGNATURE', SECRET =

How do I get a data from one table to another but with calculations?

I have two tables: "Customer" and "Order". The "Customer" table has an attribute called noOfPurchases, and the "Order" table has an attribute called quantity. H

I don't know why the columns swapped in JTable

This question may seem silly to you, but pls help me. My program works, but slighty incorrect. In the image1 you can see the location of the data in the databas

Model create() method is executed twice SOMETIMES and creates duplicated entry for 1:1 relation

I am making a Laravel 5.7 system which has tons of code and models, but the ones in problem are: Order - first created Transport (1:1 Order) - afterwards create

delete a table form a database using laravel command

i need to delete a database table using laravel artisan command . not like this command php artisan migrate:rollback --step=5 i need to create like this route o

Is it possible to use Google drive for shareable data in android apps?

I want to create a simple shareable shoppinglist android app and I wonder, if there's a possibility to use Google drive as "db". Technically it should work righ

How to bring data frame into single column from multiple columns in python

I have data format in these multiple columns. So I want to bring all 4 columns of data into a single column. YEAR Month pcp1 pcp2 pcp3 pcp4 1984

Is it possible to write a comment after a ';' in an SQL query?

In this code: SELECT * FROM Customers ORDER BY CustomerName ASC; -- some comment If a comment is not part of the query/code, why can't I write it after the ';'

How to use multiple databases in Django with an empty 'default'?

I'm trying to make a multiple database project in Django. But I'm having problems to properly migrate my models to the appropriate database. I'm using the 'Writ

How to create the file format in Snowflake?

I have below sample csv data with column delimiter as "|" and row delimiter is "|\n". I am receiving below error. How can I create the File Format? Key|DimType|

Milvus standalone is not real standalone version

Milvus2.0 has a stand-alone version called milvus-standalone. But this version, in addition to milvus itself, also includes two third-party components, minIO an

Flutter objectbox initialization

How can i initialize properly the instance of my DatabaseProvider? I'm struggling with it. I found solutions but everyone of them initialize objectbox in the wi

Why doesn't the AWS studio doesn't show up the "one to many" modal relationship?

There are 3 modals in the aws-amplify studio. They are as follows: It was quite straight-forward to add the relationship for the Video modal. But for the User

why does it keep giving me errors?

SQL table: CREATE TABLE Application ( App_ID number(5), Child_Name varchar2(15) CONSTRAINT pk_Application_App_ID PRIMARY KEY, Child_Weigh