I am trying to connect Snowflake to Matillion ETL using key-pair authentication. I'm facing the error 'Default Database must not be empty'. We have given a defa
I frequently swap between different apps which use Docker, some of which are microservices that need to both be operational so I can't simply kill all of my con
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
I have a class that extends AbstractMongoEventListener and overrides onAfterSave and onAfterDelete. The onAfterDelete does not trigger for some reason. The onAf
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
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