Category "database"

How to have AWS RDS synchronous read replication?

For AWS RDS there are 2 way to create a "clone" of your DB : 1/ Read replica : Create a read replica, data is asynchronous, meaning there's a little delay 2/ Mu

laravel database error when I try to convert an string to datetime

I'm on Laravel project that I didn't start, my problem is when I try to do an insert on laravel. I need to insert a datetime, on Y-m-d h:i:s.v format but when i

Query to filter a table where a field can be a number or left empty

I created a form with 3 textboxes & a search button. Also a query that is setup to take the criteria in the textboxes & filter the results of a table wi

MySQL format number with unknown number of decimal places

In MySQL, I only want to add thousand separator in the number like 1234.23234, 242343.345345464, 232423.22 and format to "1,234.23234", "242,343.345345464", "23

Creating procedure that add value when it doesn't exist (Syntax error)

I'm trying to create a procedure that add a value that doesn't exist but I'm currently getting a syntax error. I don't know how to correct the error. Any help w

How to connect to Azure SQL Database through a VM jump host using DBEaver?

What I have: Azure SQL Database on private virtual network Jump host - Whitelisted Azure VM that can connect to the Azure SQL Database Local machine --PuTTY--&g

Saving html code to a database if the font family has double quotes?

I do a simple text editor. With the javascript select option I add font-family to innline-style and change the font-family style. After that I need to ajax-save

How to merge multiple tables in postgreSQL (using wildcard)

There are 163 tables, and I want to add two columns in all. And columns should be added from the front. Please tell me how to do it on postgreSQL This is a tabl

How to insert multiple rows in Visual FoxPro?

I'm using Visual FoxPro on my Classic ASP website, and I want to achieve the SQL syntax below to FoxPro version 6. INSERT into users (id, name) VALUES (1, 'jo

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?