gapless | Standalone Apple Push Notification Service with Connection | Notification library

I use sqlite and have two tables. First contains a gapless series of dates (table datelist below) and a the second has dates and values (table: valuelist). Second table has gaps in the date series. As result i want to have a gapless timeseries with values. If for a given day there is no value in valuelist i assume the last value <> NULL before that day is the best approx.

With my SQL I could produce the table below. The SQL is on larger tables (10^4) and potentially larger gaps (~100) understandably not performant.

A coalesce of lag(value, 100), ..., lag(value, 1) is at least not elegant. (Dont know if it even works)

Question: Is there a more performant (and elegant) way to write this in SQLite? In other SQL-Slangs there ist an IGNORE NULLS in window functions. SQLites doesnt seem to have them. The FILTER part for Window Functions also dosent work - lag is not aggregate function. Can't use max() or so - the values are not ordered.

I am working on a div with some links and a footer and I have some issues.

For some reason there is a white gap between both sections. I used inspect and it appears to be a margin block that is hidden? I added margin-bottom/top: 0;, but it didn't work. Is there any way to remove it so that there is a gapless transition from the links section to the footer?

Moreover, the question words link in the links section is meant to be in the second column (and I coded it so as you can see), but it appears in the first column and I'm not sure why.

Thanks a lot for your help!

I am trying to generate qrcode in flutter. I need to add three key-values in the same. So, when i scan it, i can get the relevant information.

This is first time i am working on qrcode scanning thing. So, i don't have idea about it.

Here is the code.

I am using Python sounddevice library to record audio, but I can't seem to eliminate ~0.25 to ~0.5 second gaps between what should be consecutive audio files. I think this is because the file writing takes up time, so I learned to use Multiprocessing and Queues to separate out the file writing but it hasn't helped. The most confusing thing is that the logs suggest that the iterations in Main()'s loop are near gapless (only 1-5 milliseconds) but mysteriously the audio_capture function is taking longer than expected even tho nothing else significant is being done. I tried to reduce the script as much as possible for this post. My research has all pointed to this threading/multiprocessing approach, so I am flummoxed.

Background: 3.7 on Raspbian Buster I am dividing the data into segments so that the files are not too big and I imagine programming tasks must deal with this challenge. I also have 4 other subprocesses doing various things after.

Log: The audio_capture part should only take 10:00

I have the following QR image which I would like to convert to .png . There's a similar post on stackoverflow from a couple years ago however, it uses a button to click & get the image which I cannot have in my app. Here is my code that draws the QR. Any help to convert to .png so I can add to my pdf is appreciated.

I am using the qr_flutter library to generate a qr code but I need to save as an image on the cell phone. For now I only have this:

I have implemented an image streaming player with tcp socket in flutter.

c++ server from which flutter socket gets image data sends images.
size of images is about 200KB ~ 1MB.

In Flutter, I'm trying to maintain 4 frames per sec.
Both of sockets in C++(server) and Dart(client) can deal with that amount of data.
However, when I display those data through Image.memory(data) widget, it flickered.
(The reason of the flicker is, first as I think, that n+1th data gets in during nth data is being rendered by Image widget. Second, the size of image is so big that app cannot render images without blank. )
So I want to implement double buffering.

Now, My Flutter app gets data and send it to multiple streams alternately.
Then multiple stream builders in Stack widget get those data and display by Image.memory() widget.
The flicker has been reduced considerably, but it is still flickering.

Even, It is not a real double buffering method.
The order of widgets in stack cannot be changed without rendering again.

Is there any way or plug-ins?

Thank you.

UPDATE
There is a way to make it be not flickering. gapless playback option.

QUESTION

Hi, I am creating a simple navigation site, and would like to know how to change / add a class to one of the li elements of the inline toc, on the right, to style it with css

My page so far.

https://startech-enterprises.github.io/docs/data-integration-and-etl/branches-and-loops-local.html

The page behaviour I'd like to achieve: https://docs.microsoft.com/en-us/dotnet/csharp/tutorials/intro-to-csharp/branches-and-loops-local

(if you scroll up and down the main page, you will see the styling of the right side toc element change)

The same behaviour can be seen here: https://startech-enterprises.github.io/minimal-mistakes/docs/quick-start-guide/ (see right hand side toc change as you scroll up and down the page)

I've tried to study the JavaScript behind this pages, but it's difficult to make sense of, and the scripts look overly complicated.

Any ideas?

Thanks,

Sachin

NOTE - QUESTION HAS BEEN ANSWERED AND CODE in link above UPDATED, based on answers given below

CODE USED

The CSS I have so far:

I have a carousel which only shows when a user opens my accordion menu.

I am using v-show to hide the carousel until it's opened. However, it doesn't render the carousel correctly unless I resize the browser window, the first slide shows but to click through the other slides don't show up.

Web inspect shows on load the translate: transform() empty for slides until the browser window is resized.

I think this is something to do with v-show and how it renders in the DOM, I have seen people using .$nextTick or .$watch to fix similar issues but I don't understand them enough to apply them to my code.

Is there a way for me to solve this issue using v-show with .nextTick() or .watch()?