34,562 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
110
views
Why does my 2D Vector of C strings not output the element at the given index? [duplicate]
Technically its a vector<vector<vector<const char *>>> but I'm using it as a vector<vector<cstrings>>
I have been stuck at this issue for weeks and I do not understand it....
-1
votes
0
answers
20
views
GUID v4 vs GUID v7 as SQL Server PK [migrated]
I've heard a lot that UUID v7 is performing much better in databases, when using it as primary key, due to the nature of how B-tree works. We have a huge problem with current implementation of PK as ...
Advice
1
vote
6
replies
101
views
How do I get specific values from specific keys in dictionary?
I have made a dictionary and a list of dictionaries but I am not sure how to get specific data from the different forms. I tried using '.startswith('7') but always gives me an error. I want to get the ...
0
votes
0
answers
36
views
PostgreSQL / TimeScaleDB issue after reimporting a huge set of data [migrated]
I have a PostgresQL 17 DB with a quite simple table (no outer relations) but with a lot of data (around > 446 000 000 records) storing some events on a day basis representing more than 2 years of ...
1
vote
2
answers
87
views
Index array without assigning it to parameter
I have to split a string and use a part of it for further processing. So the idea is:
string='aaa-bbb-ccc-ddd'
parts=(${(@s:-:)string})
print -- $parts[3]
# ccc
I would like to refactor the second ...
-1
votes
0
answers
100
views
Which index is useful on like clause? [duplicate]
SELECT o
FROM Order o
WHERE o.customerEmail LIKE %:emailPart%
are there any RDBMS (PostgreSQL) index type which can improve performance of the query above? (i.e. which index can help on like clause?)
0
votes
0
answers
173
views
How to use index in simple select
Table has index on name column:
CREATE TABLE firma2.klient
(
kood character(12) primary key,
nimi character(100),
...
);
CREATE INDEX IF NOT EXISTS ...
3
votes
1
answer
114
views
Trying to populate a list from another sheet by a single reference number
I am working on a handy reference sheet for my DnD Games, that includes 10 pre-planned encounters of varying difficulty that I want to reference on an Initiative Sheet by referencing the Encounter ...
1
vote
1
answer
67
views
AWS Glue Script Scanning Entire Table Despite Date Filter
I have written a small Glue script that fetches some data between two dates, but I found that it scans the entire table instead of just the data within the specified time range. I also tried creating ...
Best practices
0
votes
3
replies
106
views
How to access specific, indexed elements of a Pandas Dataframe for math?
What is the right/pythonic way to do math on a few indexed elements in a Pandas Dataframe?
I tried a few ways but they seem awkward and confusing:
df = pd.DataFrame({'x': [1, 2, 3, 4, 5, 6, 7, 9, ]})
...
1
vote
1
answer
97
views
Slow TimescaleDB lookup on indexed column (event_key) without a time filter
I'm using a self-hosted TimescaleDB instance to store logs. I have a hypertable logs that is partitioned by the timestamp column.
I need to perform a fast lookup query based on the event_key column, ...
Advice
1
vote
1
replies
43
views
Why do B-tree disk optimizations work when the OS controls physical disk layout?
I understand the standard explanation for why B-trees are used in databases: they minimize disk seeks by packing many keys into each node, keeping the tree shallow (3-4 levels), and enabling efficient ...
Advice
0
votes
6
replies
102
views
Why MariaDB doesn't use newly added index?
MariaDB version is 10.4.34.
The query looks like:
SELECT bet.*
FROM Bet bet
WHERE bet.placed >= '2025-10-29T00:00:00'
AND bet.placed <= '2025-10-29T23:59:59'
AND EXISTS (
SELECT 1 FROM ...
Advice
0
votes
1
replies
37
views
Why search "vsc" in windows start menu can find out Visual Studio Code?
Windows 10 22H2.
Ask this question because at the same time, type ame can't find out Adobe Media Encoder.
and I don't see vsc.exe defined in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\...
2
votes
2
answers
61
views
Trouble Faceting on Text Field Terms in Facet Queries
I'm trying to use faceting to look at the terms that were indexed into a field, realizing this is a bit atypical, but I'm using it as a debugging tool. The problem is I'm not seeing any faceted terms....