Random snippets of all sorts of code, mixed with a selection of help and advice.
How to pin a label to the right edge of chart (like Horizontal Ray text alignment)?
18 March 2026 @ 3:36 am
I want to draw a horizontal line at a fixed price (e.g. 5000) with a text label that always stays pinned to the RIGHT edge of the visible chart — exactly like the built-in "Horizontal Ray" drawing tool with Text Alignment = Right.
I've tried:
- label.new() with bar_index of last bar → label moves with last candle, not screen edge
- chart.right_visible_bar_time with xloc.bar_time → only updates on new bar, not on scroll
Is there any way to achieve this in Pine Script v5? Or is this behavior
exclusive to Drawing objects and not available in indicator API?
Example of what I want: https://ibb.co/twj2N9SB
Filtering rows across multiple columns
18 March 2026 @ 3:18 am
I have a spreadsheet for trading cards. I am trying to filter out all the cards that have 0. The spreadsheet is set up to have a column for regular, holo, reverse holo, and promo holo. It is possible in some sets to have say card number 25/76 have a regular, a holo, and a reverse holo all with the same card number. I need the sheet to filter out cards that have blanks in all 4 columns, but stay if there is even 1 in ANY column. When I filter out 'greater than 0' on the first column, any row that has greater than 0 in any other column but blank in the first one will dissapear. Then the filter for the second column doesn't work.
I need to be able to keep 55, 59, 60, and 68 on the screen after filtering. All advice is greatly appreciated.
I need to be able to keep 55, 59, 60, and 68 on the screen after filtering. All advice is greatly appreciated.cross compile aarch64 cannot locate libgpiod in sysroot
18 March 2026 @ 2:26 am
I am cross compiling using Eclipse on amd64 Ubuntu 20.04 Host with target rpi4 aarch64 running Debian12 (bookworm)
I am using cross-compiler from sourceforge: cross-gcc-12.2.0-pi_64.tar.gz
For sysroot I have copied the rpi4 root file system of /usr and /lib to a directory on host called rfs_pi4 and then ran sysroot-realtivelinks.py to fix any relative links.
For the cross complie I have included path to: rfs_piz4, rfs_piz4/lib, rfs_piz4/usr/lib
I get the error:
"ld: cannot find -lgpiod: no such file or directory"
Before copying over the rfs I ran on the rpi4: $ sudo apt install libgpiod-dev
The specific file 'libgpiod.so' is located in /usr/lib/aarch64-linux-gnu/
I have added a symbolic link in /usr/lib/ to point to the file in the above directory, but the linker still cannot find it.
In suggestions on what would cause the problem?
looking for guidance in learning aws
18 March 2026 @ 1:59 am
Seeking Guidance: The Road to AWS Mastery
"Hello everyone! I am currently embarking on a journey to become a proficient AWS Developer, but the sheer scale of the ecosystem is a bit overwhelming. While I understand the basics of cloud computing, I am looking for a structured, comprehensive roadmap that covers the essentials—from core infrastructure to advanced serverless architectures.
Specifically, I’m aiming to master the 'Big Three' services (EC2, S3, and RDS) before diving deeper into AWS Lambda, DynamoDB, and IAM security protocols. My goal for 2026 is not just to pass a certification exam, such as the Solutions Architect or Developer Associate, but to gain the hands-on technical skills required to build and deploy scalable, production-ready applications.
If anyone has recommendations for high-quality resources, project-based tutorials, or a step
flutter ios white screen after background
18 March 2026 @ 1:59 am
iOS white/black screen after long background (Impeller, 3.38.9). Details & repro: https://github.com/flutter/flutter/issues/183814 Would appreciate a look from the team.
Problems parsing the package [closed]
18 March 2026 @ 1:45 am
Want to try to open up a file I have downloaded which is an APK file it tells me there's problems parsing the package what does this mean?
I have an Android cloud phone
stat_summary text location relative to each boxplot in ggplot
18 March 2026 @ 1:29 am
I want to create a two group boxplots using ggplot2 with texts for mean and sd located close to the minimum value of each boxplot. In this case, I used this code:
mean_sd <- function(y, bottom_limit = max(df$Score) * 1.15) {
return(data.frame(
y = 0.95 * bottom_limit,
label = paste(
"M =", round(mean(y), 2), "\n",
"SD =", round(sd(y), 2), "\n"
)))
}
ggplot(data.boxplot, aes(x = Component, y = Score, fill = Label)) +
geom_boxplot(outliers = FALSE) +
scale_fill_manual(values = c("#FF5F1F", "#1FC0FF")) +
stat_summary(fun.data = mean_sd, geom = "text", vjust = -1, position = position_dodge(width = 1)) +
theme_classic()
But I kept receiving result with the text with the same location/place for all boxplots.
As a result, the mean and sd collapse with the
As a result, the mean and sd collapse with the How to get Tkinter and Pygame windows to run at the same time?
17 March 2026 @ 11:50 pm
I've looked up on Internet but what I found doesn't really apply to my problem specifically
I'm trying to make a game. There's a menu, made with Tkinter, with a "Start" button that closes this window and opens a Pygame window to run the actual game. When the game ends I'd like the Pygame window to stay open while a Tkinter window with a "Back to menu" button opens. Pressing this button would close the two windows and reopen the menu window. To run simultaneously a Pygame and a Tkinter loop, I'm using the multiprocess module
I've written a code to achieve this, but I keep getting this error when clicking "Back to menu" :
XIO: fatal IO error 22 (Invalid argument) on X server ":0"
after 415 requests (415 known processed) with 24 events remaining.
I've come up with a (very ugly) minimal reproductible example (the "game" ends when we click the cross of the Pygame window) :
Update query used the wrong table in the from statement
17 March 2026 @ 9:05 pm
I accidently ran an incorrect and incomplete query on production as shown in the following.
#TempDiff is a temp table with 2 columns as shown below. There are one or many [Pallet Contents] for each products. Each SKU is distinct in #TempDiff, exists in the products table and exist exactly one Pallet Content that P2CLocation = 1. There are also other products that are not under #TempDiff.
My question is, is there a way I can see what this query updated?
There are only 69 rows in #TempDiff, but 60k rows are updated... Based on my observation, all [pallet contents] that are not null are deducted by 3 after this query somehow. 3 is indeed one of the diff value in #tempDiff, but it is the second (inserted) row, not first.
This server's version is SQL Server 2017, with compatibility level 100.
I t
How to detect buildings from satellite imagery using QGIS Plugins? (over time, small area)
17 March 2026 @ 8:23 pm
I want to detect buildings from several georeferenced raster images (satellite images and orthophotos) from the 1950s to 2010 (= black and white as well as colour) and vectorize them in order to compare years and building development (demolition, new constructions, etc.) as part of an historical, qualitative project on one single neighborhood. So far I have been working with the QGIS plugins mapflow and orfeo/otb. I am not very happy with the mapflow results and even less happier with orfeo/OTB (segmentation and object based classification). My computer is struggling with bigger tasks such as mean shift segmentation in OTB/orfeo. Does anyone have an idea how to detect buildings from older raster imagery, preferably with an open source plugin to QGIS (but other recommendation are also welcome)?