Category "database"

AfterDeleteEvent from AbstractMongoEventListener is not being triggered when entry is deleted from MongoDb

I have a class that extends AbstractMongoEventListener and overrides onAfterSave and onAfterDelete. The onAfterDelete does not trigger for some reason. The onAf

How can I reduce the number of database queries for a one to many association in Strawberry GraphQL and FastAPI?

I'm developing a python GraphQL API server using FastAPI and Strawberry, and I'm implementing this feature: I have two entities, User and Order, which have a on

Connect database table to StringGrid with LiveBindings via code

I want to use LiveBindings to connect a database table to a StringGrid, but I don't want to use the LiveBindings Designer, I want to do it manually via code. Th

MySQL under XAMPP won't start on MacOS - throwing "no such process"

I'm on MacOS (Catalina right now) but the issue has been there for the last couple of years. XAMPP works great and then all of sudden I can't start MySQL. Only

PopSQL is stuck at the startup and keeps loading, what should I do?

keeps loading what should I do?

Strapi giving me DB errors in production, even though I'm using correct credentials

EDIT: I found a file at /config/database.js which is used to connect to sqlite in development. When I change the client name from sqlite to postgres, that's whe

No Data encryption option for Azure Database for PostgreSQL

Based on this documentation of Azure, there should be a Data encryption option under Security. But I don't see any option of Security. Is there a way to enable

How i can get list valid prefix mobile phone from all country, including operator name?

I need to save into database list of prefix valid sms mobile phone number including operator name from "ALL COUNTRY". For example: PREFIX: +62812 COUNTRY: INDON

Cannot boot Chainlink: opening db: failed to open db:

When I "chainlink node start", I get the error: "Cannot boot Chainlink: opening db: failed to open db: failed to connect to host=/private/tmp user=myname databa

How to fix Call to undefined method App\Models\TableName::factory?

I have created a seeder that populates data in Laravel but was having a BadMethodCallException Call to undefined method App\Models\Project::factory(). Why is th

psycopg2.errors.InsufficientPrivilege: permission denied for relation django_migrations

What my settings.py for DB looks like: ALLOWED_HOSTS = ['*'] DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2',

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