Storing MongoDB Collection Name in Variable
I am attempting to store the name of a MongoDB collection in a variable and refer to that in a query. If I specify the name of the collection without quotes, my query runs, but if I place the name…
PostgreSQL. Getting data from another table
I'm trying to get data from "users" table into 'user_id' and 'profile_fullname' rows from "profiles" table. For example if a row has an id of 1 in the "users" table, then the 'user_id' should also be 1. Same with the…
Add new field based on the value of the existing field – MongoDB Aggregate
This is my MongoDB aggregate result based on the below aggregate query. { "count": 1, "fields": { "accountCode": "17G00011", "accountName": "GST input Receivable" }, "amount": 94.5 } { "amount": -619.5, "count": 1, "fields": { "accountCode": "21C00005", "accountName": "Cyberview Technologies" }…
Postgresql – Ensure Deletion of Rows Before Insertion Using CTEs
I am using CTE to check database rows, delete rows by filtering and finally to insert row into the database. Below is the go function to Insert a row: func (vm VoteModel) Insert(vote *Vote) error { ctx, cancel := context.WithTimeout(context.Background(),…
Asp.net – Discover an web application's APIs
I have to implement a routine/library to discover an application's APIs then list them in a database. I don't know where to start and I can't find anything really helpful in internet. All I can do is display the API…
Mysql – Should I convert timestamps in the database or service layer in a spring boot application?
I have a question about data performance time value is stored as long in my spring boot application. When I retrieve multiple data, I convert the time using Date_Format FROM_UNIXTIME like below @Query("SELECT new today.feeling.dto.response.emotion.EmotionMonthlyReportQuery(" + "s.id, " + "s.studentId,…
Laravel – How do i copy a project with database into my computer?
Connection error default connection me and a friend are making a project for college and he just sent me the final thing so i can show it in my computer but when i want to run the MIGRATE command that…
Ubuntu – What's the correct postgres url when hosting Supabase with Coolify?
Can't figure out what is the correct postgres url when hosting with Coolify. Everything is up and running. I have only changed the service name to db and kong domain to https://mywebsite.com:8000 Coolify is hosted on ubuntu vps_1 and through…
MySQL Sorting Using MAX() For GROUP BY Is Returning Malformed Data
Okay, I'm absolutely flummoxed trying to understand what's going on here. Everywhere I'm reading it is suggested to use MAX()/MIN() on a data column with a GROUP BY in order to get the highest/lowest value for each group of data.…
Update data with laravel
The problem arises when I use the "save" method to save the data, as it returns as undefined, this is the code : public function profile() { return view('profile.edit', ['user' => Auth::user()]); } public function update(Request $request) { $request->validate([ 'fullName'…