chrome for android – Chome flag “Overscroll history navigation” by default

I have casually found this feature without having enabled anything in

chrome://flags.

Suddenly the option has disappeared.

Why this behaviour? I don’t understand why the feature was enabled, and I can’t see why it suddenly has disabled (I’ve found Default mode checked in flags section).

chrome for android – “Overscroll history navigation” by default

I have casually found this feature without having enabled anything in

chrome://flags.

Suddenly the option has disappeared.

Why this behaviour? I don’t understand why the feature was enabled, and I can’t see why it suddenly has disabled (I’ve found Default mode checked in flags section).

web app – Should a Notification Center have an infinite history or should it allow the user to close them?

I’m working on a Notification Center (in a web application) and I can’t find any information about the notifications history.

So I don’t know what is the best behaviour to apply for my notification center.

Example: Facebook and Pinterest have an infinite history.

  • Should I keep all the notifications in history, in which context?
  • Should I allow the user to close the notifications, in which context?

For more context, I’m working on a Financial Application for Advisors.
So there is no “Messages notifications”, the notifications we’ll find in the Notification Center will be more like “There are new alternatives available in your comparison #1”. The notification will redirect the user to the source.

Here’s my sources for the notifications:

postgresql – check history along with dates for queries in Postgres

I am running PostgreSQL on my Linux terminal and If we do select pg_backend_pid(); it gives pid for specific session.

Below gives us only the last query executed

select pid,
       usename as username,
       datname as database_name,
       query,
       application_name,
       backend_start,
       state,
       state_change
from pg_stat_activity
where pid = 'your-pid';

but looks like this s gives us all the history of query but not with dates. can we get dates along with them

and if we do save output to a filename where does it gets stored on Linux server?

s filename

Kindly suggest if there are more specific way, actually I am looking for the queries executed on particular date.

browser – Browsing history archive

I am looking for an application to address two problems:

  1. Search through content I have previously seen on the internet
  2. Save all pages for offline use

Is there a way to save the pages my browser has loaded and displayed? I know it’s possible to view page titles in my history in various browsers, but I want to archive the pages themselves, and make the content searchable.

I appreciate that this will be several Gigabytes per month, but that’s really not a problem. I also understand that a lot of content is dynamic, ex.: facebook, so it’s tricky to save. I also know that I can “Save Page As”, but I’d like it to work automatically.

browser – How to clear the Android file chooser history?

When using many different Android apps, a native file chooser appears to allow the user to select a file to process.

For example, in the well-regarded Privacy Browser web browser, visiting the VirusTotal website and then pressing the Choose file button on that site will invoke this file chooser GUI.

I noticed, on Samsung Android Nougat devices, many of the files listed in the Downloads folder were deleted over a year ago, but are still being presented as current options by the file chooser.

How can one clear the history of this native file chooser?

When clearing it, are there any undesirable side-effects?

magento2.3 – Stock Moment (History) Report

Are there any off-the-shelf solutions for generating a Stock Moment (History) Report for all products, in M2.3CE? In other words, a Stock Tracker.

For example

Date        Qty    Stock    Reason
01/01/2020  -2     50       Sale (012345)
01/01/2020  -1     49       Sale (012346)
02/01/2020   1     50       Credit Memo (014343)
05/01/2020   10    60       Adjustment (bob_admin)

History of applications that used microphone in Windows 10

Is there a way by which I can see a full list of applications that used the microphone and when each accessed the microphone? I am aware of the list in Settings -> Privacy -> Microphone; however, that list is incomplete and only shows the most recent time a particular application accessed the microphone. Thank you!

Chrome: history -> reload N tabs, can we make chrome actually reload some or all the tabs?

Chrome has the option to reload a set of N tabs (where N is a positive integer like 60), but I find that it doesn’t actually reload the tabs until you click on a tab, and then only it may attempt to reload that tab. How can we make it actually reload (go out to the web sites indicated by the URLs and actually request the content again) all or a selected subset of the tabs, when we go to History -> Reload N tabs?

Database design for product purchase history

Say I run a store that sells products of some sort. A product has typical attributes, most importantly price. When a customer makes a purchase, an invoice which references one or more products is generated.

Question: If the staff of the store updates the product, we may not be able to figure out how much a customer paid for a particular item because that product’s price has been updated. How do I handle this use case? Three options I can think of:

  1. Add a version column to the products table. When making a change, insert a new row and increment the version number, instead of updating. When I reference a product from an purchase, I reference a specific version of the product so I always know how much a product cost at the time of purchase.

The problem I see with this is that, ignoring performance and ever-increasing need for storage, whenever I need to update a price (or other product attribute), I need to update all foreign key references to that item. In my database I may have a dozen such tables, most of which do not need ‘historical’ information like past prices.

  1. Create a separate product_history table, with the columns of the product table plus additional version and change_time columns with all previous versions. When updating the product table, I will save the previous version to the history table. Purchases, and any other table that needs historical information will reference rows in product_history, not product.

  2. Add a version column to the products which is incremented every update. When there is a purchase, copy the product to a purchase_product table. The purchases table will reference purchase_product, not product. I would only keep one row per version of a product, so there is no worry of the table exploding in size when a lot of people buy the same item.

3 seems slightly better 2 because I only keep versions of products that I actually need (not for every single change of the product price). However, that means I won’t be able to run analytics on when a product was NOT selling because (say) the price was too high…

Or, is there a more obvious solution?