Sharif

Hey Guys,

I think I missed last year but it's hard to put these lists together with 4 boys in grade school. I'm gonna try to do this and keep it updated but we are doing virtual learning this year and I'm working from home. If you see some updates or new deals you want added to the list post them and I'll try me best to update it on the Google Doc. Happy holidays!

https://docs.google.com/document/d/19M5_hpboin3xqMQ8eULSbA83Id86MC3utcdAkcx7yts/edit?usp=sharing

Yes I looked at that one as well seems pretty cool and like you stated has more space. My Son currently built an Ncase M1 and I fell in love with the quality of the case so opted to buy it, its on the way as we speak.

Oh the NR200? I like the look of that case and I've seen some great 30 series builds in that on. Seems like a great case

It doesn't matter. The CPU consumes under 200 watts, which is under 20A (12v x 20A = 240 watts) ... so no matter which one you end up using, it won't make any difference.
 
 

The xps isn't just gonna flat out die on you after a year. But if you want I could give you much cheaper alternatives that will be just as good for your needs and have better battery life as well what you are doing can be done on a lot less of specs.

it's probably an upgrade for mine ...

The Logitech G604 Lightspeed Wireless Gaming Mouse is on sale right now, for $60 CAD, this can't be beat, also, it's ships from and sold by Amazon.ca, not 3rd party.
EXPIRED at Amazon
https://www.amazon.ca/dp/B07QN369XX/
Sold out on Logitech store ;
https://www.logitechg.com/en-ca/products/gaming-mice/g604-lightspeed-wireless-gaming-mouse.910-005622.html
 
 
Still available at Memory Express ;
https://www.memoryexpress.com/Products/MX78832
 
Still available at BestBuy ;
https://www.bestbuy.ca/en-ca/product/logitech-g604-lightspeed-16000-dpi-bluetooth-hero-sensor-gaming-mouse-black/13891228
 
Still available at CanadaCompters ;
https://www.canadacomputers.com/product_info.php?cPath=21_279_275&item_id=140467
 
 

Some Walmart locations in Canada have the 16GB SanDisk microSD card for $3.
 
https://www.walmart.ca/en/ip/6000187323657 (says "sold in store only")
 
Though, you can use shoptrack to see if the Walmart near you have it in stock ;
 
https://stocktrack.ca/?s=wm&upc=61965911602

Canada is different then America. There are somethings you can't buy in Canada that you can buy in the USA, and many things are much cheaper in USA then in Canada. Many people who live close to the border will quite often cross the border to fill up on gas, to buy 4 new tires, to get work done, to buy laptops, to buy smokes and booze. Used to be way back when it was no big deal to cross the border, then Sept 11 happened and they tightened up the border.
 
In many respects to, small town living is a whole different life style then big city living. St Johns Newfoundland has a population of 110,000 people. Big cities like GTA are multiple millions. Small towns would have one Walmart if your lucky enough to be graced by the Walton family. Source electronics is the usual place for electronics in small towns. Same goes for a Bestbuy, you'd be lucky to be graced by BB to have a store within 40 minutes, but at 110k people, is like a small town with one Waltons, one BB.
 
 
 

You need to remember that you are in a low population area of the country, so prices in stores will differ then say Toronto, Vancouver and big cities.
 
Also remember that sometimes you can't buy from certain world retailers online. Like Walmart.com for example, you need to use Walmart.ca because there are different items on each websites, different shipping protocols. You can get around that buy getting a forwarding service where Walmart.com will ship to say a PO box located inside the United States and the owner of the store doing PO Boxes will reship to you in Canada which adds more cost.
 
Newegg.com vs Newegg.ca might be the same.
 
Back in the day, we'd stand in lineups outside the store at 4am, then it became standing in line at 10pm the previous day. I remember those days well. Its too bad the big electronics stores dont rent out stadiums anymore for sales, online took that over.
 
 
 

Most likely you will just find "no stock" on the items that are on sale.

You've probably seen the pretty remarkable 4K LED projector build on Matt Perks' DIY Perks channel. The relevant points here are:
the cooling system used was a PC CPU air cooler and fans the cost of materials was only about $200 overall performance was comparable to or better than a commericial $2000 4K projector ... except in regard to brightness, where the DIY projector was held back by using only a 100W LED So, what about a more powerful LED? Perks argues that it's not worth it:
But of course extreme cooling doesn't have to be practical to make for a fun video. In fact it seems it might even be pretty straightforward—just mount the LED on the waterblock of a high-power-dissipation AIO—if it weren't for the extra heat from the LCD rather than the LED. (I suppose you might try blowing air onto the rear of the LCD and/or putting an air-cooled or water-cooled copper "picture-frame" around its edges. Maybe replacing the phone LCD with a much larger LCD from an old 4K laptop could help by reducing the heat per cm2, though I suppose the display area might overwhelm even a large format lens.)
 
Obviously the video could either be done independently by LTT or as a collaboration if Perks is interested (as @Sharif pretty much suggested previously). DIY Perks has enough subs and views that attracting some of those eyeballs might be of meaningful value to LTT.
 
 

Basically hit or miss, kinda excited to have a desktop again, it's interesting how quickly laptop hardware turns into performance of yesteryear so quickly 

I consider ryzen2 gud’nuff myself. It’s not the speediest thing on the planet but it’s by no means slow.  I am a bit worried about how relevant Turing will remain though.

on classifieds! I know its a steal...I went and checked it out and its basically brand new and a few cycles of battery on it...lottery i guess

My memory of previous Black Fridays is the deep discounts are for 2019 inventory.  I’d expect sales on Turing GPUs and ryzen2 and 9th gen.  Everything else would be “I dunno” 

The dust in the heatsinks is hard to clean, especially on GPUs. Plus I have cats (one of which likes to sleep right next to the pc, because it's warm I guess).
And I'm lazy af, I just want to open the side panel and blow that shit out. The downside is that you'll have to clean your room after 😅
I'm sorry
 

You still living in 1946? 
 
Damn near every hair dryer these days has a temp slider and a fan speed slider.  Or even a no heat setting.
 
3 Heat + 2 Speed Settings + Cool Shot: Find the heat and airflow you prefer for your hair type, then use the cool shot button to lock in your gorgeous style.  
https://www.walmart.com/ip/Remington-Damage-Protection-Hair-Dryer-Purple-D3190D/34788344?wpa_bd=&wpa_pg_seller_id=F55CDC31AB754BB68FE0B39041159D63&wpa_ref_id=wpaqs:ryHyX3YBuemabeBM4POa90JHApG6C13jxrXKAeFZG3qdR3a1pUd32HLHulnPGEyAgQSJ6odAn4kKNkJmVifRIPWIWZlvc4mR4EVDmZuOHasxsSCO4U7t9XX936Hu5psfFR1pIJzx8NKRXUdcALlb8aKJMpBhvnnEctPJVUgmyXQ8IrniVxtJ7dUDUaDlaEHllNjY_3WoYkVJIUxhnI3EXQ&wpa_tag=&wpa_aux_info=&wpa_pos=4&wpa_plmt=1145x1145_T-C-IG_TI_1-6_HL-INGRID-GRID-NY&wpa_aduid=8e7d3dc8-a03c-4454-8540-389af7a04dfc&wpa_pg=search&wpa_pg_id=hair dryer&wpa_st=hair%2Bdryer&wpa_tax=1085666_3147628&wpa_bucket=__bkt__
 
 
 

So do I lol
I use a small one, very similar to this one:
Very similar result to compressed air, but I'm too lazy to take the pc in the garage to clean in. This is a good alternative, keep in mind that compressed air will always give better results
From experience, it's not powerful enough. It helps, (just make sure to set it to cold air) but it's nowhere near a blower or compressed air.

Much lower pressure? You could use a high-rpm PC fan at that point.

I think it's important to understand why the static builds up in the first place to know if it's viable for your usage, static usually builds on the hose itself due to the dust particles creating friction inside of the hose, it's the same idea as if you took a plastic ruler and rubbed it against your hair, the main worry is when you get the hose too close to the components causing a discharge which might damage your system, I doubt it's that likely to happen either way but it's not as if the air itself is holding a charge, I don't see any issue with using a VAC as a fan, though the air would be hotter than Room Temperature so you have to keep that in mind.

Still waiting for excellent deals on a 2TB drive.

Kingston A2000. The SN550 lacks a DRAM cache, which can make it slower in certain scenarios.

Probably wouldn't work because while you can trademark something that already exist for something else, it is usually only if it is completely unrelated to the "same field". IE; movie production, music production, Food business, etc... (Not exactly these specific terms, you enter some legal garble at that point)
 
The fact that there are movies of the same name and you want to make a youtube channel with that name, you are unlikely to be awarded a trademark for it since it's video content creation which could fall under the same category as movies does.
 
When it comes to branding, you really should come up with your own unique brand instead. That way when someone search for it on Google or elsewhere, they get YOU and not something completely unrelated. It's all about the SEO these days and using a pre-existing name is just asking for trouble on all sides.
 
Trademark laws can vary depending on the country so you may be better off consulting a legal expert in your region on the matter.
 
 
As an example, here's two trademarks for the word "Linus" that are approved and registered in Canada :
https://www.ic.gc.ca/app/opic-cipo/trdmrks/srch/viewTrademark?id=1498269&lang=eng&tab=reg&posNum=1&search={"selectField1"%3A"tm"%2C"textField1"%3A"Linus"%2C"category"%3A""%2C"type"%3A""%2C"status"%3A""%2C"viennaField"%3A[]%2C"searchDates"%3A[]%2C"selectMaxDoc"%3A"500"%2C"language"%3A"eng"}&length=25&start=0
 
https://www.ic.gc.ca/app/opic-cipo/trdmrks/srch/viewTrademark?id=1320858&lang=eng&tab=reg&posNum=2&search={"selectField1"%3A"tm"%2C"textField1"%3A"Linus"%2C"category"%3A""%2C"type"%3A""%2C"status"%3A""%2C"viennaField"%3A[]%2C"searchDates"%3A[]%2C"selectMaxDoc"%3A"500"%2C"language"%3A"eng"}&length=25&start=0
 
One deals in "vehicles" (with specific mentions of "bikes") and the other in medical supplies. They are both allowed to exist because they deal in different things.

In your original statement "DELETE FROM expense_sheet where oid = delete_entry.get()", delete_entry.get() is not evaluated since it is inside of the string. So you would have to concatenate whatever delete_entry.get() evaluates to with the first part of the statement: "DELETE FROM expense_sheet WHERE oid = " + str(delete_entry.get()). 
 
However, like I mentioned, this is vulnerable to SQL injection. Since delete_entry comes from an input box, someone might enter "5; DROP TABLE expense_sheet;" In which case, the SQL statement becomes "DELETE FROM expense_sheet WHERE oid = 5; DROP TABLE expense_sheet;" There goes all your data. 
 
The ? represents where you want to substitute a value into the statement. You pass in values as a tuple (delete_entry.get(),) as the second argument to execute and you can pass in as many as you want (provided you have the same number of "?" placeholders in the statement). In this case, since it is a single value, you need the trailing comma to disambiguate between it being a tuple or an expression.
(delete_entry.get(),) This is a tuple (delete_entry.get()) This is not Basically instead of sending one SQL command to the server (being the pre formatted string you were originally intending to pass in), it will first send the SQL statement template (DELETE FROM expense_sheet WHERE oid =?) to the database and then it will send the parameters and evaluate the statement. As a result, the SQL injection does not occur, even with bad input like above.