I need to insert data into new table person_department using recursion. My tables for now: person id group_id 800 10 805 21 department id name group_id parent_id 1 ABC 10 5 2 TY 11 5 5 OOO null 9 6…
I cannot get prefix search to work on a scalar field. I can however get infix search to work which suggests that my field is not properly tokenized. ENV: Standalone Milvus 2.4.8 on Ubuntu 22.04 Here is my schema: {…
I need help with the DB query builder. I tried to check if such a relationship already exists but got an error saying Call to undefined method IlluminateDatabaseQueryBuilder::has() $startDate = Carbon::today()->format('Y-m-dT00:00:00'); $endDate = Carbon::today()->format('Y-m-dT23:59:59'); if (request('start_date') && request('end_date')) { $startDate…
I have a table race_racer that contains time serialized logs for each racer in a race. I am trying to select the lastest record for a given racer in x number of races prior to a date. Basically selecting their…
I need to make a python script using a query and params formatted as a list of dicts to use the execute function on the engine object. The script that I have been trying only returns -1: db_type = "mssql+pyodbc"…
I have a PostgreSQL query that aggregates data from multiple tables and generates a report. Currently it works perfectly fine and it is quite simple. Here is the query I'm using: SELECT a.name AS account_name, c.name AS campaign_name, ad.name AS…
I have two Postgres tables as shown below, primary key is id: table1: id | name ---------- 1 | Bob 3 | Steven table2: id | name ---------- 2 | John 3 | Jack I would like to combine these…
Table 1: Name Address Height Weight X. y z. p G. H. I J Q W. E. R Table 2: Name Income Tax X. y z A B C Trying compare the rows between the two tables and get the…
Edit: pipelining in redis script is used to execute commands in batches, it doesnt connect to the remote server for each operation I use connectionpool for Redis to maximize the network delays Edit2: I wouldnt use Redis Search because it…
I have a question about migrations in Laravel. Is it possible to handle foreign keys with a simple if statement? Specifically, I want to ensure that if a foreign key already exists, it should not be migrated again. Is there…