I'm new to postgreSQL and I'm trying to delete a row from a table and then also delete the relevant data from another table and then the linking table; Im trying to learn while doing so im pretty sure what…
I have a Postgres table that has numerous columns which frequently show up in the where clause of select queries. The table has been indexed accordingly, with indexes on all of these columns (mostly single-column indexes, but with some composite…
I have a very simple two-table set in Postgre 16.0: CREATE TABLE fk_table ( fk_id INT PRIMARY KEY , fk_name VARCHAR(50) ); CREATE TABLE main_table ( id INT PRIMARY KEY , date TIMESTAMP , fk INT REFERENCES fk_table(fk_id) --, tens…
Issue: Unable to Connect to MongoDB with TLS and Authentication MongoDB Setup: I’m running MongoDB on a Docker container, and I’ve enabled TLS/SSL and role-based access control (RBAC) with internal authentication. Here’s an outline of my setup: MongoDB Version: 6.x…
I have created a search with Laravel 11 that is in a controller and has a join to another table. However, with the join some of the results do not show . This is my controller: public function search(Request $request){…
I have a dilemma, I'm able to delete item from database collection carts, I figured out the reason I have to reload the cart to get update on cart, this is because item is being removed from database but not…
I’m facing a cache invalidation problem in Redis, particularly with relational data. For example, I have a User object: { "id": 1, "name": "John" } And a UserClass object: { "user_id": 1, "class_id": 3 } I have an API that…
I am trying to add partitioning to a table in my database. Here is an example: CREATE TABLE IF NOT EXISTS myBd.test_table ( id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT NOT NULL ) PARTITION BY hash (id);…
The actual form : <div class="form-input"> <label for=""><?php esc_html_e( 'NAME', 'daily-attendance' ); ?></label> <input type="text" required readonly value="<?php echo esc_attr( $current_user->display_name ); ?>"> </div> <div class="form-input"> <label for=""><?php esc_html_e( 'DATE', 'daily-attendance' ); ?></label> <input type="text" required readonly value="<?php echo esc_attr(…
iam trying to connect my flutter app to a node server the flutter application has a registration screen that accepts username,password and email from users and it should be reflected to mongodb using the node server im getting this error…