How do we know when an android version is going phase out and not maintain anymore in the near future?

From the security bulletin I can know that which version of Android is not being supported by Android anymore.

For example I can tell that Android version 7.1.1 and 7.2.1 are not being supported around 4th Nov 2019, by referring to the 4th Nov 2019 bulletin.

enter image description here

Questions:

1) Are there any ways to get the precise dates when Android 7.1.1 or 7.2.1 are deprecated?

2) Or are there any official announcement to get the date for Android 8.0 or 8.1 being deprecated beforehand? So we can plan accordingly to stop supporting that version for security reasons.

3) In wikipedia, old versions means it’s unmaintained. But how to get this information from the official docs?
enter image description here

photoshop – How to change the background and maintain a realistic effect?

I can see that you have 3 main problems:

The background is VERY blue, and it's not like I imagine the scene would seem to the eye, because you know that the white balance between the images is very different .

Perspective and setting – the subjects are very close to the camera and the camera is at eye level. The background image looks like it was taken from 2000 feet. Your subjects are standing, so it would make sense that there is something for them in the background image, for example a balcony overlooking a mountain scene.

Lighting angle – to have a natural look, the light source of both images must come from the same direction.

Your main problem is the choice of the background image.

unit – Maintain user interface position with aspect ratio adjuster and anchor preset is set to stretch

So I have a text user interface using aspect ratio with the width control height of the aspect mode and I have set the anchor preset to stretch it to the top.

To make it easier to understand, I want my text to stretch upward only when the height of the screen is increased, and at the same time, using the aspect ratio adjustment As an aspect, I want my text to keep the width and the aspect ratio by stretching the width when the height is increased. And don't worry about the size of the screen height larger than the size of the screen width because I have a separate user interface for portrait.

When I apply both the preset anchor stretch and the aspect ratio adjuster, the user interface can no longer maintain its position if the height of the screen is increased. So my question here is simple, how can I keep my user interface in the view of my camera while using aspect ratio and the anchor preset is set to stretch? , if possible, can this be done using the built-in unit? (without writing the script)

Here is a screenshot below to show my problem:

(ps: ignore the error, there is no correlation with this problem)

Before changing the screen height:
Before changing the screen size

After changing the screen height:
After changing the height of the screen

How to maintain a table in dynamic programming?

How would you start to create a dynamic programming table that can prove that a language exists in P?

In case, you answer a quiz which has k questions. For i = 1 ,. . . , k, the question i is worth pi ∈ N points, will take ti ∈ N minutes to complete and will require if ∈ N pieces of scratch paper.

Let POSSIBLE-SCORE = {〈k; p1, …, pk; t1, …, tk; s1 …, sk; 1P; 1T; 1S〉 | You can answer at least P question points in T minutes using at most S pieces of scrap paper}. Show that POSSIBLE-SCORE ∈ P.

file conversion – How to convert .wav to .mp3 and maintain iTunes presence?

I have a bunch of .wav files (from synchronized CDs) that I would like to convert to .mp3 files in order to save space. I found this link that works to batch convert .wav to .mp3, but unfortunately iTunes does not automatically recognize new .mp3 files.

I would like to know if there is a way to batch convert .wav files to .mp3 files and that iTunes will maintain its metadata for these files. (Of course, all of this could have been avoided by syncing the CDs in .mp3 format first. Oops.)

FLAC to iTunes also seems to be useful, but I'm dealing with .wav files and I should convert them all to FLAC files before using this tool, and I don't know how to do it without losing metadata.

Thank you!

.htaccess – how to pass variables with htaccess to maintain the language of the site

I have a little problem. I have a website translated into multiple languages ​​let's say I want to do it:

www.ejemplo.com (web in Spanish)

www.ejemplo.com/en (web in English)

The problem is that when I want to access any part of the web menu in the English version, it sends me to the Spanish version, I wanted it to redirect to the English version via htaccess so not to touch the url. I don't know how to pass the variable, I tried the following statement without success:

RewriteRule ^en/(.*)$ index.php?lang=en&var=$1 (QSA,L)

Thanks in advance.

postgresql – How to structure the SQL data model to maintain data integrity

Context

I am building a private chef reservation service where you can reserve a chef to prepare a personalized menu. I'm having trouble creating an SQL db schema that accurately represents the domain while preserving data integrity.

Requirements

  • Customers create a Booking by selecting a Chef and one Menu and choose it MenuItems they want for everyone MenuCourse
  • A Chef defines a set of MenuItem that a customer can choose to create their Booking
  • A Menu is a collection of MenuCourses. (ex. A Menu called "Tasting Menu" is a 6-course meal, where each MenuCourse costs between $ 10-20).
  • A Chef should be able to associate their MenuItems with many Menus and MenuCourses.
  • A customer Booking must contain the Chef the client selected with the Menu (and the MenuItems) which will be served. Booking the price is determined by the Menu and MenuCourse selections (an appetizer costs less than an appetizer)

In my current data model, I have the following problems that I don't know how to solve:

  • it is possible to create a Booking with Chef "A", but then a BookingMenuItem which refers to a MenuItem with Chef "B" (every BookingMenuItem for a Booking should belong to the same Chef)
  • a Booking refers to a particular Menu (which i need for the price, the price is based on Menu and MenuCourse) however BookingMenuItem for that Booking could refer to a whole different Menu or MenuCourse

Is it possible to redesign my database schema to solve the integrity issues that i have? Or do I just need to implement these checks at the application level. Thank you!

ERD

migration – How to maintain SEO ranking when migrating from a webapp to a CMS

I have a Node.js webapp with high end SEO which has about ten pages (example.com/blog) which contain static content. I want to move the application part to a subdomain (app.example.com) and replace the existing parent domain with a CMS where my client can easily write content.

For static pages, I can keep the exact same URL structure (example.com/blog). Apart from that, what steps should I take to maintain the SEO ranking?

After creating the first list with the choice fields, I cannot search for these fields – how can I maintain the integrity of the data and still link it?

Battery exchange network

The Stack Exchange network includes 175 question and answer communities, including Stack Overflow, the largest and most reliable online community for developers who want to learn, share knowledge and develop their careers.

Visit Stack Exchange

sql – Maintain logical order in a messaging environment

My setting is as follows (please assume these points are completely immutable, some for good reasons, some: "just because"):

  • In a super scalable microservice environment, I receive messages
  • These messages have a Logical order (a time stamp they bring with them)
  • Messages are entered into a messaging system
  • Neither the technical order messages (the order of publication in the system) cannot be guaranteed nor its uniqueness (messages can be delivered multiple times)
  • Consumers consume messages in a very parallel fashion
  • At the end of message processing, most of them will be stored in an SQL database
  • No strict consistency constraints apply (possible consistency can be applied)
  • Using Kafka to order other event streaming platforms is too expensive due to its total cost of ownership

The central problem I face is therefore:
What to do if an old message is processed after a new one.

Here is a simple example, let's say the following messages are processed in this order:

{
  objectId: '4711'
  logicalOrder: 2
  content: "World"
}
{
  objectId: '4711'
  logicalOrder: 1
  content: "Hello"
}

Ultimately the field content will be written to the database. So if I don't do anything special, the result will be wrong:

+----------+---------+
| objectId | content |
+----------+---------+
|     4711 | Hello   |
+----------+---------+

Now the first thing that comes to my mind is to add the logic command as a column, then there are two approaches.

  1. Addition of everything that is processed at the table (while retaining the possibility of easily inserting records in batches)
  2. Check if something newer (according to logicOrder) is in the table and write to the table only if there is no new dataset in the table

In the first case, we will end up with this:

+----------+---------+--------------+
| objectId | content | logicalOrder |
+----------+---------+--------------+
|     4711 | World   |            2 |
|     4711 | Hello   |            1 |
+----------+---------+--------------+

Now here are the questions:

  • What do you think is the best performer in an SQL environment? Take the audit overhead before writing on the table or
  • using a fancy sql PARTITION BY statement to always select the entries with the highest logicalOrder evertime data are read (perhaps some cleanup will also be required to free up storage and restore performance).
  • Do you have similar problems?
  • How did you solve them?