web applications – Serving large file (dozens of GB) to client from a server-side query to the Azure SQL database?

I have an SQL database in Azure that is ~4.5 TB / 150 million rows worth of data. Users will need to query this database for large sets of data. Right now, I am having users submit their requests through a web application hosted on an Azure VM.

How can I serve the rows pulled from the Azure SQL database directly to the user? It seems slow for the server to have to stream the data from Azure SQL, and then for the client to have to stream that from the VM.

I wish the user could directly query the Azure SQL db from the client side, but the problem is that the user’s request has to be preprocessed and manipulated against a reference set of over a gigabyte of data; the request to the SQL db needs to happen server-side. Any help appreciated!

Why do preview images in camera LCDs, phone screens, and editing applications appear darker, or with more saturated colors?

For many years now, I’ve noticed that cameras of different sorts and image editing program display a preview image of different colors from the final image, while it’s loading the final image. I’ve noticed this on several different models of android phones, as the photo app was loading the image I had taken; I’ve also noticed this on the LCD screen on DSLR cameras, including Pentax and Nikon models, and also in Lightroom, which the the main desktop photo editing program I use.

After all this time, it’s bugged me– why is this so? Usually the preview images appears to have “better” or more saturated colors– it seems to be the “human-friendly” version that phones deliver to consumers who want good-looking images over color accuracy.

Here are some screenshots from Lightroom CC. Notice that the first image, you’ll see the loading... text pop-up over the image, and at a glance, the image seems to skew bluer. The second screenshot has the image completely loaded, and it doesn’t have as much blue as the preview loading image.

These are freshly imported NEF images from my Nikon, so I don’t suspect any sort of jpeg progressive rendering.

Loading

Loaded

What is going on here?

web applications – Which is the correct way to configure Azure CDN for public web sites with particular attention to SEO

something is not clear using Azure CDN.
I explain step by step what I have done since my website has been created. Call my website www.mypublicwebsite.com. So:

  1. I created a web app on Azure. The website has the following url: https://mypublicwebsite.azurewebsites.net;
  2. I created a custom domain www.mypublicwebsite.com
  3. I redirected all the request from https://mypublicwebsite.azurewebsites.net to www.mypublicwebsite.com. So I solved the problem of duplicated contents for crawlers.

Everything is fine. Then, I decided to create CDN, according the documentation. Here the confusion starts.

  1. I created the CDN profile
  2. I created the endpoint. The endpoint has a new url https://mypublicwebsite.azureedge.net
  3. I deleted the custom domain from web app;
  4. I created the custom domain in cdn profile.

So the current state is this:

enter image description here

This situation is really problematic for SEO!! It cannot be the correct configuration. My contents are triplicated.
I partially solved the situation:

  1. I redirected all the request from https://mypublicwebsite.azureedge.net to www.mypublicwebsite.com. So I solved the problem of duplicated content for crawlers.

But crawler (and perhaps users?) can still navigate the origin web site. I have been looking for different solutions:

I am honestly starting thinking this is not the correct way to manage cdn. And what if I would also add Front Door? I would have another url again: https://mypublicwebsite.azurefd.net… I think I have not understood something.

Any idea?

Thank you

applications – Software to generate and display OLED burn-in offset map as watermark over display?

Have a Galaxy S8+ with signs of burn-in – not serious but white screens are looking a little pink in regions.
Searching for fixes to burn-in only comes up with programs to flex the pixels which I don’t believe can do anything. What I would like to find if it exists is a way to display a semi-transparent watermark over the entire screen in order to boost the blue and green pixels in the burnt regions to even out the display – the image could be either traced by user on the effected screen, or generated from a photo taken by a second camera..

Is there either an existing app on the market to do this or a way of doing it by hand with some type of hackery?

applications – how do i avoid app from minimizing when option menu icon selected

i tried this code, but app minimize when option menu selected, what wrong with startActivity

i have added about, help in menu option, menu is opening, but when i click on option to go other activity, my app minimize

switch (item.getItemId()) {
case http://R.id.about:
startActivity(new Intent(this, About.class));
return true;
case http://R.id.help:
startActivity(new Intent(this, Help.class));
return true;
default:
return super.onOptionsItemSelected(item);
}

applications – Apps go portrait and then landscape unexpectedly

When I updated my Motorola Moto G9 Plus to Android 10, when going landscape watching videos or playing videogames (after some minutes, repeatedly) go portrait and after 1 to 3 seconds return to landscape, I thought was just my phone, but my wife’s phone (Motorola Moto G8 Plus) also have this glitch/bug

How can I fix that?

THIS WAS NOT HAPPENING WITH ANDROID 9

Has Canada started allowing TRV Applications for Visit Visas?

I got refused for Canadian visas around 2019, grounds I had no travel history. So recently I have visited some countries and I have come back home. Is this the right time to apply? I have visited 2 East African nations (Rwanda and Ethiopia) and some West African nations as well, was thinking of Visiting the UAE any time sooner.

I am from Nigeria.

applications – Printer server set up through router

I’ve got an Epson L220 series printer and connected it to my Huawei EG8145V5 router using my printer’s usb, I can print wirelessly from my laptop without any problem, but when it’s different in android, I tried Epson iprint and other printing apps and all of them doesn’t support my printer except from Let's print droid as I manage to connect my printer to my android the only problem is it print random characters instead of printing the actual document.
Is there an app the would let me print wirelessly using a usb printer that is connected to a router?