I'm trying to divide two count using where conditions (SELECT COUNT([Main_Status]) FROM [V_Incidents_Combined] WHERE [Main_Status] = N'open') / (...

I have a column in postgresql that is a text data type. But it really holds always 4 kind of values, these are: EOS,EOS in 6 months,EOS in 12 months, ...

ERROR: test_task_check_success (tasks.tests.TaskCheckTestCase.test_task_check_success) Traceback (most recent call last): File "C:\Users\gns03\OneDriv...

I want to set up a microservice architecture that includes services with a variety of technologies(C++, Golang, PHP, ...). The duty of one of the serv...

I have a 4D vector: std::array I want to check if all it's components are inside the value range: 0.0f How do I check if any of the vector components...

This is not asking about structure padding/packing, which refers to any unnamed bytes inserted into structures for alignment purposes. I have this fun...

I'm using react-query to fetch, and post data from my database on supabase. I created a hook for adding a record using react-query: export function us...

For instance, I have this JSON inject { "insert": "2023-12-08T09:49:00" } It is String I have sent this query here db.example.find({ "insert" : { ...

I would like to create a list object to contain specific ID numbers ? How to write the code below more efficient ? many thanks in advance. #"Added Con...

In a PostgreSQL table "private_notion", I have a JSONB column "record_map" that may or may not contain nested objects, E.g. { "blocks": { "7a9ab...

When Laravel Eloquent calls a relation property that indicates the original model of the relation destination from a certain model, it issues a re-que...

I need an SQL Server query that will list the select rows from the first table and list the related records from the second table on the same row as t...

I am trying to add a column in a SQL query to use as an alternative ID. The data has this format: UserID | Value --------------- 1 | 23 2 | ...

I am making a password vault gui app using tkiner. I am trying to add a function that lets me edit and update any specific line in the gui. What I mea...

I'm using node-pg and I've decided to refactor some code that would first make a select query to see if a record exists and then make a second query t...

I am creating a questionnaire app and I am thinking of using the Realtime Database, and I understand that they use JSON with the following format: 1st...

I try to understand where to store password salts. Every question here doesn't help me to understand where to store them. Should it be saved into the ...

I have data which has the parameter "{IsFolder}" with curly brackets. I need to filter based on that parameter with ODATA. How can I achieve that? "Is...

I have a dataframe like this: ind,l1,l2 = [0,1,0],[1,1,0],[0,0,1] df = pd.DataFrame([ind,l1,l2],columns=[['C1','C2','C3']]) df.index=[['A','C','E']] ...

I have a query (weather data) that results in multiple sub-tables. For example, the initial raw query looks like this: Column1 Column2 Columns3-12...

I have a table with these columns: event_time (date) event_data (json) player_account char() I'm trying to get all three fields from my query and grou...

Scenario I have this code (simplified): var query = _context.Products .Where(x => x.IsActive) .Select(x => new...

I'm currently working on a project that involves AVX512 instructions and I have a question regarding the performance differences between _mm512_load_s...

I have a csv file which is stored in azure data lake and I want to move it to azure SQL database table. Now my problem is the table has 2 extra colum...

I run this string with result: run sql select telephonenumber, keypadenteredalternateidentifier, n.dnorpattern, userid from enduser, numplan as n wher...