Wikipedia:Reference desk/Computing
of the Wikipedia reference desk.
Main page: Help searching Wikipedia
How can I get my question answered?
- Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
- Post your question to only one section, providing a short header that gives the topic of your question.
- Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
- Don't post personal contact information – it will be removed. Any answers will be provided here.
- Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
- Note:
- We don't answer (and may remove) questions that require medical diagnosis or legal advice.
- We don't answer requests for opinions, predictions or debate.
- We don't do your homework for you, though we'll help you past the stuck point.
- We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.
How do I answer a question?
Main page: Wikipedia:Reference desk/Guidelines
- The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.
June 9
Google Chrome autofill suggestions
Hello!
Can someone tell me where are the Google Chrome omnibox autofill/autocomplete suggestions stored as a database file in Windows?
I thought they would be on C:\Users\user\AppData\Local\Google\Chrome\User Data\Default\Shortcuts but after deleting some entries from there for testing purposes I quickly noticed those words still showed up as suggestions on the omnibox with the little clock on the left side of them suggesting they still lived somewhere on a specific file. - Klein Muçi (talk) 22:25, 9 June 2022 (UTC)
- It's stored in "%LOCALAPPDATA%\Google\Chrome\User Data\Default\Web Data", you can open it with an SQLite browser/opener. Look under the 'autofill' table. WhoAteMyButter (📨talk│📝contribs) 23:02, 9 June 2022 (UTC)
- @WhoAteMyButter, I did but it is not. :/ I find none of the current suggestions I get in the omnibox in there. - Klein Muçi (talk) 23:24, 9 June 2022 (UTC)
- They might not be stored. If they are, they might be in a cache somewhere else. Autofill suggestions could be extrapolated from your history. WhoAteMyButter (📨talk│📝contribs) 23:33, 9 June 2022 (UTC)
- @WhoAteMyButter, maybe they get extrapolated from the history of other devices using the same Google Chrome account somehow? I'm sure they are not extrapolated from the history on the current device as that was the first thing I looked upon - made sure to clear the correlated browsing data from the in-browser application and from the db itself using SQLite browser. - Klein Muçi (talk) 23:38, 9 June 2022 (UTC)
- I must say though that I've set the history on the current device to not synchronize with the other devices (even though the opposite is true - the other devices are being synchronized with the history of the said device). - Klein Muçi (talk) 23:40, 9 June 2022 (UTC)
- @WhoAteMyButter, maybe they get extrapolated from the history of other devices using the same Google Chrome account somehow? I'm sure they are not extrapolated from the history on the current device as that was the first thing I looked upon - made sure to clear the correlated browsing data from the in-browser application and from the db itself using SQLite browser. - Klein Muçi (talk) 23:38, 9 June 2022 (UTC)
- They might not be stored. If they are, they might be in a cache somewhere else. Autofill suggestions could be extrapolated from your history. WhoAteMyButter (📨talk│📝contribs) 23:33, 9 June 2022 (UTC)
- @WhoAteMyButter, I did but it is not. :/ I find none of the current suggestions I get in the omnibox in there. - Klein Muçi (talk) 23:24, 9 June 2022 (UTC)
June 14
Sending an email from Gmail to Yahoo
Why don't Yahoo-recipients see the sender's Gmail profile picture, even though Gmail recipients do see it? Can the sender/recipient do something, for the recipient to see it? 147.236.152.145 (talk) 08:55, 14 June 2022 (UTC)
- From Google's documentation: "Your name and profile picture can be viewed by other people who use Google services where your main Google Account profile is shown, including when you communicate or share content." Yahoo is not a Google service. 12.116.29.106 (talk) 11:49, 14 June 2022 (UTC)
- The picture is not included in the email sent by Gmail to Yahoo! Mail (or any other email services), and Google has not given Yahoo! Mail access to its database of Google account profiles. --Lambiam 12:04, 14 June 2022 (UTC)
Split/Explode calculations in SQL
In programming, it is common to split or explode a complex value into multiple values, perform an operation on those values, and recombine them into the original complex format. For example, if I have the value "8,12,4", I can double each number with some pseudocode like: newval=implode(',',explode(',',oldval)*2);. I explode/split the old value by commas, multiply the resulting numbers by 2, and implode/concatenate the updated values with commas. I want to know what search term could be used to find practices like this in SQL. Using the example above, I might have a field with a value like "8,12,4" and I want it to become "16,24,8". I'm not looking to solve this one specific problem. I'm looking for search terms that would lead to examples and explanations of splitting or exploding a varchar into parts, performing an operation on those parts, and then recombining those parts. 12.116.29.106 (talk) 16:19, 14 June 2022 (UTC)
- I searched for "SQL vector multiplication" and found a page where somebody is doing matrix multiplication in SQL. I don't know enough about SQL to be certain that this is useful to you, but anyway the term "vector" (for "complex value") is worth trying. (Come to think of it, wasn't this kind of mathematics, on objects containing multiple values, a significant motivation for the development of relation databases in the first place?) ... I get the impression that you have the specific problem of treating multiple values as one, and packing and unpacking them, which that link probably doesn't address. So I tried "split varchar string", and here's a couple of Stack Overflow questions which may be relevant: [1] [2] - they mention SUBSTR, among other functions. Card Zero (talk) 16:52, 14 June 2022 (UTC)
- I do not know if that term applies within the SQL ecosystem, but across the Python/Matlab/etc. scientific calculation world, that is called "vectorized code" or "array programming". Here’s an exam sheet with easy-to-understand examples. TigraanClick here for my talk page ("private" contact) 17:09, 14 June 2022 (UTC)
- What with the unpacking and packing, this is essentially unfold–map–fold, which is also related to the MapReduce paradigm. Like Tigraan, I don't know if such terminology has gained any currency in the SQL world. --Lambiam 19:11, 14 June 2022 (UTC)
June 15
June 16
Questions about use of Whatsapp
I have two questions. 1) How can I transfer whatsapp chat history data to new phone without uploading to Google drive. I tried sending the file of today's date in Whatsapp>Databases from old phone to new phone using Xender and placed it in same ___location but this method isn't working for some reason. How to do? 2) I want a specific tool for whatsapp. When someone sends me series of messages. I want to selectively mark some of them as read. Something like Mark as done So that next time I read my chat history I know which things are still left. One simplest way of doing this is to use reactions. I can simply use 👍🏻(thumbs up) reaction to do this. But by doing this the sender gets notified which I don't want as it feels weird, if I react to someone's 2 month old message. Is there some tool I can use. -- 2409:4043:209C:B221:3990:F39E:91CC:C03E (talk) 06:29, 16 June 2022 (UTC)