mind | A productive mind has an empty stack | State Container library

I have spent some hours playing with Electron and I have observed that it consistently takes more than 2.5 seconds to draw a trivial html file to the screen. The timeline is roughly as follows:

• 60 ms: app ready event is triggered; we create a window using new BrowserWindow()
• 170 ms: a blank window appears on the screen
• 2800 ms: the window shows the specified HTML

I have set up a repository with my code, which is derived from Electron's quick start docs.

Regarding my machine, I am running Windows 10 on a ThinkPad T460 from 2016 with a SSD and enough memory.

Shipping an application that shows a blank window for so long upon startup is a no-go for me. I assume most people developing Electron apps think similarly. Hence my first question: am I doing something wrong? Or is this the expected loading time for a trivial Electron app?

Assuming this is normal behavior, what is the common way to deal with this problem? Some ideas come to mind:

1. Asking Electron to show a splash screen: unless there is specific built-in functionality for this, it seems like a no-go, since the splash screen itself would be shown only after 2.5 seconds.
2. Hide the app's window until it is rendered (using the ready-to-show event), so no blank window is shown. This isn't ideal, since it means that the user doesn't get any feedback whatsoever that the application is actually loading.
3. Create a wrapper application (using native code) that displays a splash screen, launches electron and hides itself once the electron window is shown. Kind of defeats the purpose of using Electron in the first place, because you end up writing native code and adding accidental complexity.
4. Setting the background color of the window to something resembling your app, as suggested by the docs. This just doesn't look very well.

Given this must be a common problem, I hope standard solutions have been found by the community. I'd be glad if someone can point me in the right direction.

I have a Django class getting some order data from a PostreSQL database. I need to get the number of rows found in a query.

Trying to get the found rows count from the following query with COUNT(*):

Create a database connection pool in Django. The connection pool is connected to a PostgreSQL database by using SQLAlchemy's connection pooling with django-postgrespool2.

'psycopg2.extensions.connection' object is not callable is thrown when running the following line of code poolConnection = dbPool.connect(). Printing the dbPool object and type displays

Database helper class which creates the connection to the PostgreSQL database and creates the connection pool:

I am writing a camera app. So when the user goes to the camera page they are provided with the option to grant camera permissions or not. I am saving their decision in variable const [hasPermission, setHasPermission] = useState(null); My current use effect function:

I know this question has been asked many times, but I still can't figure out what to do (more below).

I'm trying to spawn a new thread using std::thread::spawn and then run an async loop inside of it.

The async function I want to run:

I am coding a program in OpenCV where I want to adjust camera position. I would like to know if there is any metric in OpenCV to measure the amount of perspectiveness in two images. How can homography be used to quantify the degree of perspectiveness in two images as follows. The method that comes to my mind is to run edge detection and compare the parallel edge sizes but that method is prone to errors.

I am trying to wrap my mind around C++ 20 concept and constraint by porting some of my old code.

Lets say i have a social media app where users can post and for each post i'm inserting a row to the posts table, and updating the user_affiliates table.

Now lets say that the user wants to see all of his/her posts what's the most efficient way to select posts that the user has posted?

This is a simplified version of my database:

I'm trying to make a server for a role-based browser game, so what I did so far:

Once 2 players join the server, a room is created, then it starts its own timeout of let's say 10 seconds, once the timeout is done, it changes its state and reruns the timeout.

I'm afraid if I have many rooms that may impact the performance, so an idea came to my mind which is, create a setInterval that tick every second, and loop through all rooms to call an update, inside the room once update called, it will check last time it updated its state vs current time, if 10 seconds passed, it updates to the new start.

I'm afraid that with setInterval every second may be worse than the first idea, or the opposite?