Category "database"

MVVM: ViewModel logic needs info from database, but how to wait for the data?

I am new to MVVM and am trying to figure out how to organize my app. I made a simplified login app to help figure things out. I separated the app into layers: A

What is the difference between mongod and Service of mongodb run in windows services

Recently I started learning Mongodb. After the installation I ran the > mongo command and without starting the daemon ie the mongod and even without starting

SQL Error [1064] [42000]: You have an error in your SQL syntax while running query

While I am trying to select a table on a MySQL data base, I am getting the following error: SQL Error [1064] [42000]: You have an error in your SQL syntax; chec

DJS Cannot read properties of null (reading 'premium')

In my code, before it does anything I have it check if there is data and if there isnt then make a new mongodb collection but when running the command and there

Update column "total price" in orders table using other columns (pizza_price*pizza_amount) in different tables?

This is relational diagram of database I created: I need to insert total price in Orders.Total_Price column by multiplying the Pizza.Pizza_Price value with Ord

how to pass asc desc as params in python psycopg2 raw sql execution?

i have a sample query template to accept dynamic parameters to execute: ps_conn = psycopg2.connect(...) ps_cursor = ps_conn.cursor() ps_cursor.execute(''' S

NPM TypeORM - "Error: Duplicate migrations" after modifying/deleting migration file

I previously add a column to an existing table using, npm run migration:generate <filename>. However, I later realized that I misspelled the column name s

MySQL/PHP - Web Based Game -User specific inventory table or 1 giant table? Another option?

So im making a web based game similar to Torn City, where there could potentially be millions of users. My issue is regarding user inventories. I started out cr

How Do I Uploading Data Externally in Explainerdashboard

I am trying to upload external data into the dashboard using explainer.set_x_row_func() and explainer.set_y_func(). Does anyone know how to do this? Below is ho

Liquibase exclude any changesets without a label

Is it possible to prevent changesets without a label from being deployed? We want to deploy our changesets based on feature/ticket using liquibase labels. Howev

java.lang.module.ResolutionException: Modules persistence.api and java.persistence export package javax.persistence.spi to module sqlite.dialect

I'm trying to build my first jpa hibernate projekt, but unfortunally i come across this error here: Error occurred during initialization of boot layer java.lang

MySQL single table with hourly, daily, monthly values, or separate tables?

When working with data values, should I create a single table storing the hourly values, and also the aggregated daily/monthly values, or should I create separa

Issues with Angular/Firebase data

I'm sort of new to Angular and I'm working on a small project for an internship. I created the front-end and sending data into the database, but now I'm having

How to match a node with over n relationships using neo4j's Cypher Query Language?

A node of a Round in a game is connected to Answer nodes. (:Round)<-[:IN_ROUND]-(:Answer) It is expected every Round to have 5 or fewer Answers related to it

How to create ERD from Heroku PostgreSQL database?

I would like to create ERD from my Heroku PostgreSQL database? How can I generate ERD? Is there any external tool that will help with this? Can you use Dbeaver

How to create ERD from Heroku PostgreSQL database?

I would like to create ERD from my Heroku PostgreSQL database? How can I generate ERD? Is there any external tool that will help with this? Can you use Dbeaver

Manage unique fields insertion with hibernate

I'm working on a JAVA project and need to insert an entity in my DB using Hibernate but the fields need to be inserted only once. I have this ProjectEntity clas

How to get the total byte size of schemas & databases in Snowflake

I love how the SHOW TABLES query return the rows and the bytes for each table listed, but unfortunately, that's not the case for the SHOW SCHEMAS query. What's

Properly parsing mixed codepage strings?

I have this weird state that my db got into. Basically, some text is in mixed mode. windows-1252 and miscoded utf-8. Here's a sample: "donc d'être transpa

how to install oracle database express on mac m1

I want to Install Oracle Database Express on macbook m1 but it only supports linux and windows, I downloaded Sql developer but I m unable to download Oracle dat