playhouse | One possible way of implementing a DCI architecture

I'm still having trouble with Flutter's approach to laying out widgets. There's this 'whitespace' that I would remove or cover (see red arrows). How would I extend the 'image' up to the menu bar?

As you can see in the code below, I'm using a Stack widget. I don't know what is making the 'whitespace' between the Stack widget and the appbar?? Possibly, it's due to the Crop widget (a third-party package). I'll look into that now, but decided to post this question anyway.

Please, would you look at the attached screenshot and tell me where that band of off-white is coming from?? (red arrow.) I want the rounded container to display text right down to the bottom of the screen--any text-overflow will simply be scrolled by the SingleChildScrollView widget, but the container just gets thinner and thinner while that block of grey just stays there??

Been working in Flutter since March of 2018, and Flutter's layout widgets are still a mystery!

Here is the code:

I am new in peewee and I am very confused about migration. I tried the examples in the official documentation, and I got the results as follows:

I'm using the Online Retail dataset from the UCI Machine Learning Repository in pandas, and I'm setting a multi-index consisting in CustomerID as first level, and InvoiceNo as second level. Here's the code:

I am using peewee and a mariadb database in a script, the script looks at a db table and is submitting data from that query into ThreadPoolExecutor. The worker itself needs to query the database aswell. After all futures are finished, the script start at the beginning again.

When I am using a single connection everything works, but as my worker job is mostly network IO, I feel that a single connection for all worker thread will become the bottleneck.

If I change to database pooling, I can monitor that connection are increasing until I get an error "too many open connections" from peewee. Connections are never closed themselves. This fits to peewee's documentation

However I have no idea how manually open and close the db-connection from inside my worker function.

I tried making the database variable in models.py global then I could access that object in my worker, but observing all open connection on my db made me realise .close()/.open() had no effect in this case.

I also pasted everything into a single file, I was still not able to open/close connection manually.

The documentation is giving only examples on how to use a pool with different webframeworks.

My app simplified

Is there a way to play 360 video with Three js coming from m3u8 file?

I found a similar question here but no answer: https://github.com/mrdoob/three.js/issues/8216

https://threejs.org/examples/webgl_video_panorama_equirectangular.html

I have used the code from thee website for playing 360 video and this work fine when normal mp4 video url is used but when I try to include m3u8 then it fails with error.MEDIA_ERR_SRC_NOT_SUPPORTED:

I have a very simple setup, a model and api file in a pipenv flask environment. I'm currently using peewee and been facing an issue with getting all results from a datatable. I've done this before in python and works fine however not sure what in Flask I'm doing wrong. Here is my model

i have a list with indexes like this:

how do I make the selection with .in_ if it is integer? When I try to insert an integer, I get an error My column is array and integer.