Currently I am working on an issue that happens on PostgreSQL server version 16 and does not happen with the 15 version (alongside Apache AGE). The issue happens when executing the OPTIONAL MATCH query which lead to a LEFT-JOIN Both…
As already known we can add more database connection in Laravel by updating app/config/database.php file in the connections array and using Schema::connection('mysql2')->... amd = DB::connection('mysql2')->select(...); to do queries. BUT, what if I want 50 databases or more, I can create…
I'm building a language learning platform, here are some tables: create table users ( id bigserial primary key, ... ) create table users_languages ( id bigserial primary key, user_id bigint not null constraint users_languages_user_id_foreign references users, level varchar(255) not null,…
I'm following the tutorial in Use containers for development#Get and run the sample application | Docker Docs. At step 6, instead of getting an empty [] JSON string, I get: curl http://localhost:8000/initdb init database curl http://localhost:8000/widget <!doctype html> <html lang=en>…
I built a woocommerce sql query to list all products with their important values. Here my query: SELECT p.ID, p.post_type as Art, p.post_title AS Produkt, p.post_excerpt AS Beschreibung, t.name AS Produzent, MAX(CASE WHEN pm1.meta_key = 'faktor' then pm1.meta_value ELSE NULL…
I have a table A, where data is a json column, and timestamp is a timestamp with timezone column: timestamp data 2023-08-29 13:00:00-04 { "a_123":{ "temp":85, "uv":5, "rain":0 }, "b_123":{ "temp":85, "uv":5, "rain":0 } } 2023-08-29 14:00:00-04 { "a_123":{ "temp":70,…
Im working on an employee management system using java and javafx. im just wondering ;in this project there's an admin part and there's an employee part. Employees will sign up and login then after logging in they enter their personal…
I have an array list of data I want to update to the inventory table. $data['items'] = DB::table('inventory_items')->select('inventory_items.*') ->join('sorder_parts', 'inventory_items.id', 'sorder_parts.inventory_id') ->where('sorder_parts.sorder_id', '=', $id) ->selectraw('inventory_items.quantity - sorder_parts.quantity AS new_quantity') ->get()->toArray(); foreach ($data as $product_item) { $reduce_quantity = InventoryItem::updateOrCreate(['id' => $product_item['items']['id']],…
I am trying to construct a SQL query that returns all the rows (id's) that have tag: 3 AND tag: 4 - in this case it is the single row for 564800, however I can't seem to figure out how…
I need to alter the Data Type of a named column (let's call them 'photo') across all the tables in a schema. For example: I have 300 tables with identical structure (except the data in each row of course). But…