Newest Questions
24,168,097 questions
0
votes
0
answers
5
views
GridDB SQL query slow when filtering by timestamp range is an index required?
I’m experimenting with GridDB and testing some SQL queries on a time-series dataset. I noticed that queries filtering by timestamp range become slow as the dataset grows.
Here is a simplified example.
...
0
votes
0
answers
3
views
Terra `ifel()` gives inconsistent pixels with multiple condition logic
I am attempting to design the sample space for a forest monitoring project using a battery of biometric, physiographic, and remotely sensed raster datasets, namely canopy height derived from digital ...
- 941
Best practices
0
votes
5
replies
15
views
SQL better prompts to get better data
I need assistance understanding prompts for SQL to get better at it. I know SELECT, WHERE, and FROM are the basics. There are more advanced ways to writing a prompt for SQL to get better data ...
Advice
0
votes
2
replies
11
views
Rust: How to println!() the numerical value of an enum variant?
enum Pets {
Cat = 0,
Dog,
Hamster,
GuineaPig,
Ferret
}
fn main() {
let my_pet = Pets::Cat;
println!("{}", my_pet);
}
Is there a way to make this code print the ...
0
votes
0
answers
5
views
How to correctly offload task to another asio executor which is possibly distinct execution context?
I use boost::asio with its awaitable<T> a lot and sometimes my coroutine code end up with following logic:
Read something asynchronously from, say, socket OR asynchronously wait on some timer,
...
- 356
0
votes
0
answers
14
views
Getting error "unable to get local issuer certificate" in GitExtensions Only
So, I have read the following two related questions:
Unable to resolve unable to get local issuer certificate using git on windows
Configure git to accept a particular self signed server certificate
I'...
- 1,724
0
votes
0
answers
15
views
How to have a debug window that shows geometry and is fully responsible?
I have a project that manipulates geometry, and although I can step through the code and see the values, it's quite hard to verify everything without looking at the geometries that are being used/...
- 86.8k
0
votes
1
answer
8
views
SwiftUI iOS26+ Transition or Animation after TextField value entered
I have a small View sample where I was trying to animate some error code when a value outside of a specific range is entered. I tried both animating it and using a transition but the error text just ...
- 17
-2
votes
0
answers
35
views
Reducing latency (≈3s) in FastAPI + LangGraph + OpenAI voice assistant for Twilio speech calls
I built a voice-based AI App using:
Twilio Voice (speech input)
FastAPI
LangGraph
OpenAI GPT model with tools
API for tools
The system works well, but response latency is ~3 seconds after the ...
- 9
Best practices
0
votes
5
replies
28
views
global variables between modules/files and functions
I understand that best practice for global variables between modules is as mentionned doc python, but I don't understand how to make those variables modifyable from within a function.
Here I declare ...
- 2,620
1
vote
0
answers
34
views
Why doesn't this look-behind assertion with a predefined regular expression work as expected?
Why do the third and fourth substitutions produce different results?
#!/usr/bin/env raku
use v6.d;
my $str;
my regex myregex1 { <[\d;]>+ };
$str = "abc3def0ghi";
$str.=subst( / <?...
- 25.5k
Best practices
0
votes
1
replies
17
views
Aggregate multiple columns by the sum of next column
I want to create a data matrix in matlab, aggregating/grouping data of two columns and by the sum of a third column.
For example given the next data matrix x:
game=[1;2;3;1;2;3;1];
Money=[0 ;5; 6; 0; ...
- 31
Advice
0
votes
2
replies
26
views
Is it considered an anti-pattern to use nested static classes for service commands and responses?
I am structuring the command and response models for my service layer. Currently, putting all models into a single, flat folder (like /commands or /responses) is becoming hard to manage due to the ...
- 13
-1
votes
1
answer
24
views
Supabase error: must be owner of sequence refresh_tokens_id_seq
I'm trying to reset my Supabase auth.users table for my Jest testing environment, but I'm getting this error when I run the following code:
await db.query(`TRUNCATE TABLE auth.users RESTART IDENTITY ...
- 5,173
2
votes
0
answers
40
views
Excel Comparing a Date - possible format error
I have a SUMIFS formula where one of the criteria is to compare to a date. If the formula compares like this, it works:
=SUMIFS(Payroll[Check Amount],
Payroll[Method], "D",
...
- 47
