'No Stupid Questions' (NSQ) Internet & Technology Edition

  • 🐕 I am attempting to get the site runnning as fast as possible. If you are experiencing slow page load times, please report it.
I think I can get a cheap i3 mini pc and install it there. Thank you!
This is a good option, I sperged about these in other threads and have two myself. Lenovo, Dell and HP all do these USFF models. They are about the size of a book and because they are business machines the second hand market is flooded with them.
lenovo-thinkcentre-m715q-tiny-refresh-gallery-01-jpg.1759867
 
It can be, yes, depending on how you use it.

Is it really just you who's going to be accessing these things? If so, why not just get some physical media to back stuff up? An external hard drive that stores 2TB can probably be had for under $150 nowadays, and if you get two of different brands and replace the older one every couple years, you should be pretty well insulated from failure, particularly if you aren't accessing the drives that often.
A few reasons really..

I do keep some externals laying around and I have 20TB in a PC where I keep some backups, but the drives heat up the room a lot

Plus I also like to have the ability to just get up and leave if I need to without losing any data, I got IRC chat logs and stuff from dead friends and I'd hate to lose em
 
  • Feels
Reactions: Smaug's Smokey Hole
Always follow the 3-2-1 rule when it comes to backups
Some other backup rules I've encountered are:
3-2-1-1-0 is the same as 3-2-1 but with an additional “Air Gapped” backup and adding a check process to ensure all backups have zero errors. I've seen some companies use 4-3-2 meaning; you have 4 copies of your data, stored across three locations (Onsite as source, onsite with the MSP and one in the cloud), with two of these being offsite. but MSPs are gay and you should never use them.
I've told the story before but when I was working with stuff I encountered an office that had tape backup and a solid scheme. The receptionist took the old tape from the server room and put in a new tape at the end of the day and took the tape home with her. In case of fire. They had a tape for every work day, labeled monday through friday, and it backed everything up at night. For a small company that was admirable.

Then one day they had a problem and I showed up, took a look at things and then had to tell them that according to the logs the tape backup software had crashed a couple of years ago. It might seem like highway robbery but they should WANT to pay me for at least one hour every month to kick the tires even if everything is fine, that way I won't have to face situations where I work many hours and earn way more money because that is annoying...
 
This might be a total noob question, but I'm currently trying to learn SQL/MySQL dialect and have run into a query I cannot quite figure out. I have two tables: "products" which has columns "product_id" (1 ,2, 3, ...) and "category" (A, B, C, ...) features and a table called "similarity" which has rows "product_id_1", "product_id_2", and "similarity". The latter is essentially a similarity matrix between each two products. How can I find the number of product id's that have less than N related products of category A with some specific similarity score?

Previously I have mainly worked with databases using a programming language's API. If I wanted to go that route, I would first query all product id's, then for each id query something like

Code:
select * from similarity inner join products on if(product_id_1='?1',product_id_2,product_id_1)=products.product_id where similarity = '?2' and category= '?3';

for an individual id which gives me a result of (product_id_1, product_id_2, similarity, product_id, category) for that specific category and similarity from which I can simply count the number of returned rows and check if the condition is true or not. However, this approach doesn't seem very efficient because I have to query for every single id separately which itself probably takes pretty long time if the dataset is not a toy example and should the query requirements change, I would need to query for each id again. For this reason, how can I query in MySQL over all id's simultaneously and have it return me the count of products which evaluate to true for the abovementioned criteria?
 
Does anyone use Windows VPS's in the cloud? I'm wondering if there are any benefits to having to pay extra money per month to license Windows, as opposed to running linux or *bsd, it doesn't seem to make a lot of sense to me, i must be missing something
 
Does anyone use Windows VPS's in the cloud? I'm wondering if there are any benefits to having to pay extra money per month to license Windows, as opposed to running linux or *bsd, it doesn't seem to make a lot of sense to me, i must be missing something
no it's windows so it's shit and idk why you'd willingly use it because it's less stable than Linux too. the only people that do are probably big corporations that have a MS stack
I get weird deja vu I swear this exact question came up here a whole ago
 
  • Like
Reactions: Full Race Replay
This might be a total noob question, but I'm currently trying to learn SQL/MySQL dialect and have run into a query I cannot quite figure out. I have two tables: "products" which has columns "product_id" (1 ,2, 3, ...) and "category" (A, B, C, ...) features and a table called "similarity" which has rows "product_id_1", "product_id_2", and "similarity". The latter is essentially a similarity matrix between each two products. How can I find the number of product id's that have less than N related products of category A with some specific similarity score?

Previously I have mainly worked with databases using a programming language's API. If I wanted to go that route, I would first query all product id's, then for each id query something like

Code:
select * from similarity inner join products on if(product_id_1='?1',product_id_2,product_id_1)=products.product_id where similarity = '?2' and category= '?3';

for an individual id which gives me a result of (product_id_1, product_id_2, similarity, product_id, category) for that specific category and similarity from which I can simply count the number of returned rows and check if the condition is true or not. However, this approach doesn't seem very efficient because I have to query for every single id separately which itself probably takes pretty long time if the dataset is not a toy example and should the query requirements change, I would need to query for each id again. For this reason, how can I query in MySQL over all id's simultaneously and have it return me the count of products which evaluate to true for the abovementioned criteria?
It's kind of hard to envision exactly what you have and what you're looking for, but just going by my understanding of it, something like this might work:

SQL:
SELECT products.product_id, COUNT(similarity.*) AS similar_count
FROM products
INNER JOIN similarity ON (similarity.product_id_1 = products.product_id OR similarity.product_id_2 = similarity.product_id) AND similarity < {minimum similarity score}
WHERE product.category = 'A'
HAVING similar_count < {N}

This is assuming that similarity doesn't have denormalized data such as rows for both (product_id_1 = 1, product_id_2 = 2) and (product_id_1 = 2, product_id_2 = 1).

If that doesn't help, build up an example on SQL Fiddle for us.
 
I've been fooling around with GPG here and LARPing as someone who actually checks the signatures on the software they download. How does anyone do this in practice? Half the signing keys for things I use are just named "John Smith (jsmith@gmail)" and you're just supposed to remember on your own that John Smith is the lead developer for the software you're using. What am I missing here? Do people just keep "cheat sheets" in parallel with their key management program?
None of the programs I've tried have any sort of "nickname" feature to let you tag the keys somehow.
 
Not sure if this is the right topic to post in, but I'm sure this can border on being considered a stupid question:

I've been learning the Win32 API w/C++ during my free time at the start of this year. I've gotten to the point where I can draw pixels to a screen, parse a bitmap file into a custom data structure and draw that to the screen, and have completed a couple of simple game projects (BlackJack, Snake, & Pong).

A couple of days ago, I picked up Microsoft Windows Internals 4th edition from a local thrift store for 3 bucks. I was wondering if reading this book - and specifically, this version - advisable to improve as a computer programmer.? Is it too OS-specific; or are there general principles I can carry over to other platforms? The most I've done with the Kernel is utilize it to parse the percentage of CPU usage my program is utilizing.
 
A couple of days ago, I picked up Microsoft Windows Internals 4th edition from a local thrift store for 3 bucks. I was wondering if reading this book - and specifically, this version - advisable to improve as a computer programmer.? Is it too OS-specific
I think that book is more for if you need to dig into a particular part of Win32 "special topics" for a program you're writing. For a "next level" book that is Windows-oriented but also highly educational in general I would recommend Jeffrey Richter's "Windows via C/C++", or even the previous edition "Programming Applications for Microsoft Windows".
 
  • Like
Reactions: Full Race Replay
Idea how to remove the Activate Windows watermark? My previous laptop had the free Windows 10 installation, and I'd be damned if I pay MS 300$ for a barely functioning OS
 
  • Feels
Reactions: Dork Of Ages
Idea how to remove the Activate Windows watermark? My previous laptop had the free Windows 10 installation, and I'd be damned if I pay MS 300$ for a barely functioning OS
Old keys on laptops/prebuilt machines/office machines will work, you can buy a junker laptop for almost nothing off ebay just for the key (as a bonus you'll have a backup computer or a fun project to mess around with). I don't know how far back you can go though, I've tested it with an old windows 7 machine and the key activated/upgrade to windows 10. I'm not sure an XP key will work, probably not.
 
I see those listings but it seems they will ship to me rather than mail a key. There are site like buy-keys but I'm not sure they won't steal my credit card information.
I have used this site multiple times. If you are worried about them stealing your credit card info, just get a $25 visa gift card or use Paypal.
 
  • Thunk-Provoking
Reactions: Dork Of Ages
I see those listings but it seems they will ship to me rather than mail a key. There are site like buy-keys but I'm not sure they won't steal my credit card information.

I have used this site multiple times. If you are worried about them stealing your credit card info, just get a $25 visa gift card or use Paypal.
BuyKeyNow also takes PayPal. Key arrived via e-mail to my proton account and worked (for another 'Farmer) without a hitch.
 
I've tested it with an old windows 7 machine and the key activated/upgrade to windows 10. I'm not sure an XP key will work, probably not.
Manufacturer specific Windows 7 keys will work for retail Win10. Windows 8 keys, maybe not. It's a bit weird, they really want every Win7 user to easily go to Win10 no matter what key it came from. Wonder why. When did they start their data harversting plan on users, was it after Win7?
 
Idea how to remove the Activate Windows watermark? My previous laptop had the free Windows 10 installation, and I'd be damned if I pay MS 300$ for a barely functioning OS
I hate to ever recommend Reddit for anything, but the Piracy subreddit has some useful resources specific to Windows. Also I highly recommend the LTSC branch of Windows 10. If you are willing to do a fresh install, it is the closest to a Windows 7 experience you can get these days.
 
Idea how to remove the Activate Windows watermark? My previous laptop had the free Windows 10 installation, and I'd be damned if I pay MS 300$ for a barely functioning OS
Never used this but it's been recommended here before
 
Never used this but it's been recommended here before
I've used it. 👍
 
Back