Category "database"

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

TimescaleDB high disk space usage despite compression activated

I have a TimescaleDB database running on Docker (which is running on Ubuntu). As you can guess, I store a lot of time-series data in it and to save disk space I

Unable to scan a Azure SQL Database in Azure Purview

I am unable to connect a my Azure SQL Database to Purview. I have already followed the steps described in all the documentation. I keep getting the following er

Best way to update Database with List where items have been deleted

I'm working on a recipe Webapp with Asp.NET 6.0 and Razor pages. There are three database tables : recipe, ingredient and food. Each Recipe has a Name, Preperat

Aerospike filter expression on boolean fields not working

I've written the following Aerospike filter in Java. Both Field1 and Field2 are booleans. For some reason, the "filterByField.ValidBoth" condition does not yiel

Generate sales report using MySql and Php

I m looking for advices in report generating per client, per product, per salesman, in a given period, using mysql and php. I m currently working on an applicat