Random snippets of all sorts of code, mixed with a selection of help and advice.
Review in Progress > Community Management API
8 June 2026 @ 1:04 am
I got directed here from the linkedin support team to ask this question. I need to use the Community Management API. I answered the verification questions and it says Review in Progress however it's been like that since May 17th. It's been over 20 days and I don't see any update to use the API. can someone from the LinkedIn team look into it?
Deciding between SQLite and PostgreSQL for small project [closed]
8 June 2026 @ 12:15 am
For context, I’m currently trying to build a small project that uses Python, Flask and SQLAlchemy that users will be able to download from GitHub and run on their local machines. The eventual goal is to turn it into a web app that users can access using a website.
I’ve seen people here and on other platforms say that for locally hosted applications where it’s just one user, something like SQLite is better, and that for platforms hosted on other platforms that receive traffic from multiple users, PostgreSQL is better.
Since I’m trying to work on the version that’s smaller in scale(i.e., upload to GitHub), using SQLite seems like the better option, and then focus on PostgreSQL later. I’m still relatively new to databases and web dev, so my knowledge here is limited.
I appreciate you taking the time to respond!
Does AI help people learn faster, or just help them skip learning?
7 June 2026 @ 11:18 pm
AI tools are now widely used for learning, coding, research, and problem-solving. Many people say AI helps them learn faster by providing instant explanations and examples. Others argue that AI makes it easier to skip the learning process and rely on generated answers.
In your experience, does AI actually improve learning, or does it encourage people to bypass fundamental understanding?
How to handle license revocation for App Store plugins when refunds are processed via PayPal directly?
7 June 2026 @ 11:15 pm
I am a developer with an AutoLISP application on the Autodesk App Store. My app uses the Autodesk Entitlement API to verify user subscriptions during startup.
The Workflow: When a user purchases my app, they are directed to a PayPal subscription flow (outside of the Autodesk App Store checkout). Once paid, my app performs an HTTP request to the Entitlement API to confirm the entitlement and grants access.
The Problem: If a user requests a refund and I process it via PayPal, is the Autodesk Entitlement API unaware of this transaction? Will the API continue to return isValid: true for the remainder of the original subscription period, even though the user has been refunded. Is so, what would be the process to notify Autodesk to get the App removed from the user profile?
!Bash PS1 containing Sixels
7 June 2026 @ 10:03 pm
PS1 has either $(cat arch_prompt.sixels) or $(chafa arch_prompt.png) so I get that garbled mess. Sed doesn't work. The image gets garbled and doesn't work if it's removed, but as you see the small logo appears nevertheless. It is unusable because bash tries to run the sixels as a command.
Edit:
forgot to add that the PS1 declaration is as follows:
PS1="$(chafa -f sixels ~/arch_prompt.png)$(ansi --no-restore --color=82)\u$(ansi --no-restore --color=255)@$(ansi --no-restore --color=202)\h $(ansi --no-restore --color=199)\W $(ansi --no-restore --color=20)$ [\e[0m]"
or alternatively with cat ~/arch_prompt.sixelsAdding asterisk to row in tbl_summary table (R)
7 June 2026 @ 8:04 pm
I want to add an asterisk to a column name based on if the percent of missing data is > 10%. For example, in this table with 3 variables, I want to have the characteristic column show: "Age", "Result*" and "Group*".
df <- data.frame(
Age = c(1:90, rep(NA, 10)), # 10% Missing
Result = c(1:80, rep(NA, 20)), # 20% Missing
Group = sample(c("A", "B", NA), 100, replace=TRUE) # Missingness varies
)
I am using the wonderful gtsummary package in R and the tbl_summary function. So far, I am able to calculate the percent missing data with add_n, but I cannot seem to get the next part to work. Would appreciate any suggestions!
library(gtsummary)
table <- tbl_summary(df) |>
add_n("{p_miss}")
table |>
modify_table_styling(columns = label, rows = row_type == "label", label = ifelse(n > 10, paste0(label, "*"), labe
Nested structs not compiling [closed]
7 June 2026 @ 5:57 pm
I wanted to get some practice with OOP (big codebases work best by having things grouped the way you expect them!)
But I can't seem to get nested structs working.
"Error: invalid use of struct"
why...? I've seen someone doing something similar to this, and it worked for them.
So what am I doing wrong?
why...? I've seen someone doing something similar to this, and it worked for them.
So what am I doing wrong?Items no longer rendering in template on mac OS
7 June 2026 @ 3:02 pm
After upgrading from Angular release 21.2.14 to 21.2.15 and now v22. I have an issue on my MacOS with items not rendering
in template I have :
@for(product of products; track product.id_product) { ... }
In the ts I have :
.subscribe(
res => {
this.products = [...res];
}
)
poducts is returning data and not rendering in the template
It's working again when reverting to:
Angular CLI : 21.2.12
Angular : 21.2.14
Node.js : 24.16.0
Package Manager : npm 11.13.0
Operating System : darwin arm64
I have no issue on the production server
Optimizing imaging in WPF application
7 June 2026 @ 2:12 pm
Briefly about the question:
How to reach same performance with images like explorer, FastStone Image Viewer since they allocate not so much memory unlike my app.
About the project
It's WPF C# image gallery app with their grouping feature. It has visual extension which probably affects performance in my case - WPF UI by Lepo. User can paste images from several sources: user's desk and paste images from clipboard. Images stored as .png file.
The problem
Application itself works fine for me, but it eats tons of memory. I've loaded 1,5k unique images taking ~1,6gb memory in total on the desk. But as for RAM in run-time, app consumes it up to 7gb. That's the case when i load all images.
What did i do
I've tried to reduce images thumbnail quality, which helped but not a lot. I've even tried to get into interop level and get images thumbnails nativel
Why is `as.logical()` much faster than `logical(0)`?
7 June 2026 @ 9:06 am
as.logical() returns a logical(0):
as.logical()
#> logical(0)
but I’m surprised to see that logical(0) is much slower than as.logical(). Why is that? This is also the case for the other as.*() functions:
bench::mark(as.logical(), logical(0), iterations = 1e5)
#> # A tibble: 2 × 6
#> expression min median `itr/sec` mem_alloc `gc/sec`
#> <bch:expr> <bch:tm> <bch:tm> <dbl> <bch:byt> <dbl>
#> 1 as.logical() 48.1ns 76ns 8467061. 0B 0
#> 2 logical(0) 468ns 571ns 1541503. 0B 30.8
bench::mark(as.character(), character(0), iterations = 1e5)
#> # A tibble: 2 × 6
#> expression min median `itr/sec` mem_alloc `gc/sec`
#> <bch:expr> <bch:tm> <bch:tm>