I am designing a DB schema for a meal planning application. Each meal plan consists of blocks (2 months of diet, 2 months of bulking), each block of meals for the day, each meal of the day of foods. I…
create table phone_log(phone_number CHAR(20) NOT NULL, area_code CHAR(10)); INSERT INTO phone_log(phone_number) VALUES ('310-430-9201'); INSERT INTO phone_log(phone_number) VALUES ('917-829-2876'); INSERT INTO phone_log(phone_number) VALUES ('424-917-1055') How do I insert the area code of each phone number using the SUBSTRING FUNCTION for each…
I have read this AWS blog post: https://aws.amazon.com/blogs/database/part-2-scaling-dynamodb-how-partitions-hot-keys-and-split-for-heat-impact-performance/ I am trying to reproduce the DynamoDB partition split. My setup is the following: 1 DynamoDB table on-demand containing big items with the same partition key for all I am running this…
I created an online store website on React. Now, the data is loaded from a local .json file. I also need to create an admin panel so that the site administrator can add/change/delete cards and data himself. How can this…
When I am executing other funcitons like find, add in database then they are running perfectly fine , but when I am updating the database entry then I am getting this error , I am using mongodb atlas, can someone…
What I'm doing is checking every Input tag if its empty or not, if not empty call the function, Im just wondering if there is a better way to do this $firstname = $this->request->getPost('firstname'); $lastname = $this->request->getPost('lastname'); $middlename = $this->request->getPost('middlename');…
I'm trying to come up with a good database design for this use case I have a table called expenses as follows id category_id item_id Problem item_id column wouldn't make sense if the expenses category is i.e. "Rent" It would…
I can't execute sql query, that has to rename the table to the same name as type, that already exists. I have not found any rules or comments about the same name for different things in postgres. CREATE TYPE ratings.processed_sport_bet…
Why is it not secure to connect a mobile app to a MongoDB database directly? I've been looking into creating an application with dotnet MAUI and using MongoDB as the database. I've seen in several threads online that it's a…
Since i've thousands of articles the bulk edit is impossible. It will require too much time and with 999 articles a time WordPress will already crash. So i thought about using a simple db query but i'm not sure how…