We have a table where we want to divide the data in train, test and split. It should split like per type top 20% data in validation, next 20% data in test and remaining 60% in train. For example, we…
How can I improve the performance of the query bellow? Currently for a set of 110k entries in the products table and ~ 1.8 million ids returned by the union all selection, the whole query will take about 8 seconds…
I have tables variable and variable_variable. The last one holds 2 columns: variable_id_from variable_id_from Look at the schema below: If variable_variable has row with values {variable_id_from = 1, variable_id_to = 2}, it means that variable with id = 1 references…
Simplifying a bit. I have the following data structure: | id | name | traversal_ids[] | | -------- | -------------- |-----------------| | 1 | container1 | {1} | | 2 | container2 | {2} | | 3 | subcontainer1 |…
From table rows in my PostgreSQL 12.8 database, I am trying to remove an object from an array, but instead it is deleting whole array of objects from the table. settings column holds below array of objects: [ { "id":…
Let’s say I want to show a list of companies, and also a first/random employee of that company. I could do something like: SELECT company.id, company.name, MIN(person.id) AS employee_person_id, MIN(person.name) AS employee_person_name FROM company LEFT OUTER JOIN person ON (person.company_id…
Trying to create a controller in order to add an instance of a class to a SQL database However, I keep getting a 415 error whenever I try to do. The error specifically shows the following -> Unhandled exception rendering…
Hello I have a DB Query like following select amount, date, denominations, user, time, branch from deposits; Now i see my database started growing up 500k +. Now if i add indexes to these columns in select query will the…
I write a renting software but I dont get any further... I have a table like this: car_id date_from date_to When anyone want to rent with this dates: DATE_FROM: 2023-09-09 DATE_TO: 2023-09-15 Now I have to check all dates in…
I am trying to set season ranges for specific dates coming from my DTBL_SCHOOL_DATES table. Below is my logic which works based on the year and its region to set the season per a given range. CASE WHEN RTRIM(dtbl_school_dates.local_school_year) =…