Category "database"

AJAX - How can I build a notification system, that is constantly getting updated, without slowing down my website too much?

I am a beginner to web development, and I am trying to do a notification system with AJAX and jQuery. In my web application, I have a comment system where you c

does filtering queryset in django query database every time?

Imagine I have the following code: qs = Users.objects.all() list = [] for i in range(10): list.append(qs.filter(age=i)) here the filter is called 10 times

Are the tables in this ER diagram linked towards the employee table

The tables should be linked mainly towards the employee table. Is this fine? I need to make connection to employee using foreign keys. Is it good practice to h

Array in mysql or something similar

I have a question. I made this procedure, and I am curious if I can make it to return more than 1 output. Let me know if you need the tables, but the code is wo

Custom data type wtih Mockaroo

I am trying to generate mock data with Mockaroo and need a simple data type that is unfortunately not inside Mockaroo's built in available data. It is very simp

Export command not working on Client node type DB2

Im currently trying to export some data EXPORT TO result.csv of DEL SELECT * FROM "DB2BXXXD"."BTTT060" FETCH FIRST 20 ROWS ONLY from our DB2 z/OS Database serv

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