/sqt/ - Stupid Questions Thread

>>what's a good piece of tech for under $100 on Amazon?
chinkshit true wireless earbuds, like the AWEI T8

Ridgeyard-Distiller-Purifier-Dental-Stainless

VIVOSUN-Inline-Control-Australia-Charcoal

Otherwise:

Coolshittobuy
awesomestufftobuy
wierdstufftobuy
thisiswhyimbroke
etc....

Is there a messaging app for android that works with all the popular messaging services? Like, you compose a message to someone, and if your phone knows they've got multiple apps installed you can select "send via mms/signal/telegram/whatsapp/messenger/silence/whatever"?

why the FUCK do javascript "fullstack" developer make so much money? i'm literally looking at 100k-120k job advertisments

windirstat, run it.

What's the best way to play old 4:3 (especially ones with fixed 800x600 resolution) games without a CRT (I don't have room for one of those bulky things right now). I'm on windows 7 so most of them work with the backwards compatibility. Using fullscreen on a 1080p screen will tear the fuck out of them though.
I thought about emulating them with virtualbox and using 800x600 resolution internally then simply upscaling the virtual box window, this usually works but fuck emulating Direct3D games with Virtualbox. Are there programs to uspcale single windows efficiently? Any ideas?
Pic related is what I'm trying to play.

Attached: syberia.png (800x600, 942K)

Because surveillance gathered data is just worth that much. What I don't understand is how in the world the advertisers expect to make the money they spend on ads back from products.
Besides, that's like 30k in a more reasonably sized city that you won't die of dehydration walking from one end of to the other.

What is something to watch out for when upgrading RAM?
Let's suppose I have 2 sticks (2x8, 3200hz), can I buy, let's say, the same 2 ram pack and just add them to make 32GB RAM or what?

They still make 4:3 flat panel monitors. They even have HDMI input now.

yo, im using puppy linux xenial and i'm fucking tired of the screen tearing whenever I play a game or even watch a video, is there a way to update my integrated gpu's drivers?
i'm using an hp stream 11 laptop. thanks

What's the best torrent client?

deluge

I learned the basics of: javascript, python

What are some good books to read for intermediate stuff? What types of stuff do you learn after the basics?

Attached: Screenshot_2019-07-30_18-13-35.png (220x177, 72K)

fleksy

learn angular, react, and node and you are set until the next fad framework comes out

I'd like to send something like this:

`nc 127.0.0.1 8080 $(ifconfig iwm0 | grep "inet ")` using ksh.

What am I doing wrong?

You should specify your OS or losers will push for _their_ OS' best torrent client.

What is a good local file duplicate searcher/deleter?
I need to check and clean my memes folders but I need a deep searcher because it won't do if it checks only by name.
Is there such a tool?

Attached: Best-Duplicate-Files-Finder-And-Remover-Software-compressor.jpg (900x600, 91K)

I want to delete all children from a tree structure in sql using a common table expression, but I can't seem to get it working. Here is what my table looks like right now, it's simply two foreign keys referring to the same table. This is the reply table

| parent_id | child_id |
|--------------|-------------|
| 1 | 60 |
| 2 | 70 |
| 70 | 80 |

And the post table looks like this
| id | text |
|---------|---------------------- |
| 1 | "blah blah" |
| 2 | "the quick brown fox |
| 70 | "more text" |
The reply table refers to the post table id

To use this, I currently select the children of a root node. So for example, if the root node was 1, then I would retrieve posts 60. And if the root node was 2, then I would retrieve 70 and 80. I would get 80 because it's a child of 70, and 70 is a child of 2.

To do this, I use this query:
WITH recursive cte (parent_id, child_id, text) AS
(
SELECT reply.parent_id,
child_id,
post.text
FROM reply
INNER JOIN post
ON reply.child_id = post.id
WHERE parent_id = ?
UNION ALL
SELECT p.parent_id,
p.child_id,
post.text
FROM reply p
INNER JOIN post
ON p.child_id = post.id
INNER JOIN cte
ON p.parent_id = cte.child_id )
SELECT *
FROM cte

Win 10 ltsc
I've been using transmission and deluge before but just finished a fresh build and want to see if theres anything better.

However, what I really want to do is delete the results from the cte. Apparently you can only use the SELECT statement after it though, so I need to somehow move the results from the cte into another table and delete the original replies from there. Has anyone done this before?

This is what I tried before (it doesn't work)
(
SELECT reply.parent_id,
child_id,
post.text
FROM reply
INNER JOIN post
ON reply.child_id = post.id
WHERE parent_id = ?
UNION ALL
SELECT p.parent_id,
p.child_id,
post.text
FROM reply p
INNER JOIN post
ON p.child_id = post.id
INNER JOIN cte
ON p.parent_id = cte.child_id )
DELETE a
FROM reply a
INNER JOIN cte b
ON a.parent_id = b.parent_id
AND a.child_id = b.child_id

As you can see, I just want to delete the results from the cte from the original reply table

I use VisiPics but it's not 100% accurate, don't know if it respects your privacy either

Do you guys learn multiple technologies at the same time or invest months in only 1 then the next one, like if you wanted to learn Linux, C and HTML/CSS to an >intermediate level, how would you do it.

Attached: 0AEByGz.jpg (1112x2048, 311K)

Anybody here uses the app tachiyomi? What's one way I can access the hidden tags on e-hentai

Bump

Attached: 1528369850553.jpg (540x393, 17K)

pls help , i really need it.
i have an intel celeron N2840 in case that matters

is there an extension for chrome that adds a downloads downdrop menu similar to firefox's?

How do you bulk view on archive again?

pip3 fails on both tkinter and wxwidgets. works for pyqt5.

what is happening? repo needs updating or something?

Learn Linux while learning the others. C and CSS/HTML have nothing in common so you can go back and forth.

Will changing my PC's mac adress cause harm to it?

Where the hell can I pirate Windows 10 to install on my new rig?

It's been years since I actually pirated something

the piracy subreddit has some links to some guides that currently work and seem to work safely, at least on my VM.

Check the OP.
Download windows 10 2019 LTSC.
Download KMS_VL_ALL to activate it.
Install all updates manually or expect it to take a huge amount of time.
Disable defender, updates and telemetry in group policy.

Does anyone have experience with recovering data from CDs? It's worked for some of my discs, but a lot of them are detected as blank even though I know I put stuff on them. When I try to run a recovery program on them, all it finds is 2048 bytes.

Did you try Recuva or Testdisk?

Hey guise. Venezuelan poorfag so please be gentle.
So I have a Celeron G1820 I got many years ago. Brand new with its stock cooler. I think I can get an i5-4590 for a good price, but the CPU alone. Do I need to upgrade the stock cooler as well? Since I think the i5 has a wattage of 84 or something while this Celeron is 54 and the cooler is actually small.

The intel stock heatsink used in Haswell was the same for Celeron and the highest end I5.

You don't pirate Win10, you download an installer ISO from mydigitallife and pirate the activation.

Also yes since a decent cooler is $30 but not sure if its a good idea since what life is like down there.

Have in mind you have to get new thermal paste and isopropyl alcohol to remove the old paste to reuse your current heatsink.

I used photorec, which came with testdisk.

Is buying graphics cards used/refurbished/openbox a terrible idea?

Running a prime95 torture test on my 9700kf, which one of these readings is right for fuck sake?

Attached: 1533807151771.jpg (980x782, 185K)

Yeah I still have some thermal paste left. I was just wondering if the i5 would overheat using the stock cooler I got with the Celeron.

Microsoft literally gives you the official ISO for free on their website, you just need to make a bootable USB drive with it using Rufus, and then go to mydigitallife and get microsoft toolkit to activate it.
yes, nowadays you'd likely be getting something that's been abused to hell and back for mining

How did yall study for the Comptia A+? Just finished Mike Meyers giant fucking 1600 page book and I am still not doing amazing on practice tests.

Is using markdown to make HTML webpages a good practice/idea?
I just want to make a very basic html page, that I can easily update/make massive changes to if needed, consisting only of text (but including titles, headings, links, italics, etc).
I was thinking about using markdown to edit and create all the actual content of the websites and then just converting to html once I have the "site" completed in markdown.
Is this a bad practice? Is this inefficient? Will this cause problems?
Are there any disadvantages associated with this?

Is there any way to force chromium to use multiple row tabs?

>94°C
Time to get a bigger heatsink m8.
Which one are you usng currently?

Your CPU sensor.
Right now you are running it at 90-94°C which is somewhat insane.

Increase your heatsink fan speeds.
Repaste with proper paste.
add more intake fans to your case.

corsair h150i with maxed out fans, the temps never go above 75c in anything other than prime95 though in which my cpu can't maintain a 5ghz all cores unless I set the vcore to 1.370v (I get fatal errors or crashes) which sucks. I'm using noctua nt-h1 paste by the way and I've already reapplied it once so it should be fine, in that department anyway.

ITX build?

How in the absolute fuck do i send an array in a raw json body of an API call?

I am trying to perform a GET call with an array and it works in postman but not in axios. i did every kind of call i could think of.

Not even close

Attached: 1564539978942.png (2800x2100, 3.43M)

Then get rid of the H150i and get a NH-D15 if you want good temperatures.
Watercooling sucks in general, its loud and expensive and pointless if you have an ATX build, the fact you are trying to cool a housefire tier CPU doesn't help either.

But again, the cooler is fine, temps are great during extended max loads, the issue is prime95 even with an avx offset of 3 the tests won't succeed if I want to keep 4.7-5ghz all cores unless I skyrocket the vcore to 1.370.

Shit, I didn't see this thread. Reposting from another thread which I will delete shortly:

I'm looking for a little advice on data storage. With tumblr banning porn, then emuparadise, nyaa, and exhentai dying and now Microsoft saying Win10 will be their last OS while making sure you can't install Win7 on new equipment, I feel like the internet as I knew it is probably on its last legs. I don't suspect even Jow Forums has too much time left anymore.

In any case, with the web looking like it's going to be turned into a Disneyland version of itself soon enough and everything cool or interesting getting made soft illegal, I decided I wanted to create a backup of everything I can get my hands on that means anything to me. Thing is, after so many horror stories of HDDs dying I thought I'd get an external SSD since I hear they're way more resilient, but what I'm using right now is an old ass Latitude E6410 and most of the SSDs that pop up on amazon are USB 3.1. The ones that aren't are these BUSlinks that seem sketchy to me. Does anyone have any suggestions on what would be best to go with or any ideas where I can go to research this some more?

Attached: little faggot.jpg (480x360, 14K)

Prime95 is not exactly a realistic load since its forcing your CPU in every way possible something that is rare, as long you can keep it under 80°C when you are something intensive for a long time your cooling is enough, if it cant keep your CPU under 80°C then its not good enough.

External HDDs are worse than normal SSDs
External SSDs are just cheap DRAMless SSDs.

Buy/Build a NAS and get multiple WD Reds and start making frequent backups.

>External HDDs are worse than normal SSDs
Than normal HDDs*

If you get a Seagate drive expect it to literally blow in pieces, example: youtube.com/watch?v=6b0JcNqkZrk

>as long you can keep it under 80°C
I'll keep my previous 5.1.ghz 1.315v then since it never went above 85c and I think that's fine enough.
The cpu failing prime95 tests will keep bugging me for the rest of my days though.

Bro, with the deepest respect and gratitude for your help, you might as well be speaking chinese right now. I don't know what a NAS is, I'm a normalfag and a bit of a brainle ton top of that. You saying 'multiple WD Reds' makes me think it's some cumbersome rig. I'm using a fucking E6410 right now, man, and moving around a lot. I'd like to get something like an external HDD, which I have experience using, and just drop everything I cherish into it then unplug it and put it away somewhere with the confidence if the web goes up in flames my stuff isn't going anywhere. I don't think all my stuff is going to be more than one or two terabytes, and I've got too much shit going on to make frequent backups.

>NAS
A box where you put hardrives in that you connect to your local network so you can use it from any PC.
Well it depends how much you want to store, less than one TB, multiple TBs? more than 15TB?

>seagate meme
2009 says hi!

2019 says hi too, seagate drives have always been shit, the only decent ones are the Ironwolf series and those still suck.

I'd say one or two TBs. I mean it's mostly going to be doujins.

The easiest solution for you would be get a good SSD(860 EVO) and a good HDD (3.5" WD Blue) with a cheap enclosure/adapter and copy your stuff there and leave the backups in your home if you ever needed them.

The real solution would be somewhat expensive and not exactly mobile.

I'm currently using 5 2tb seagate drives, I've had them for years, why the fuck is everyone always saying they're shit?

I've never used an enclosure/adapter and the fact that the 860 EVO is an internal makes me nervous, but if you say it's the easiest solution I can give it a shot. Like I said, I don't know shit. Can I get a link to the kind of enclosure/adapter that would work on it and my laptop? What size should I expect all of this to be in the end? Is it just a matter of putting the SSD into the enclosure/adapter and then it'll work like an external? I don't intend to have it hooked up all the time like I said, I just want to download stuff from the internet to it, then unplug it and keep it somewhere safe.

Noobfag here being completely lost with a dumb question. I just upgraded and built a new pc - the interesting stuff is a new threadripper 2950X for CGI work stuff and a gigabyte x399 designare EX mobo (I kept my previous HDDs tho). The thing is, I didn't know that ryzen CPUs only support windows 10 and the only storage stuff I put are my old HDDs with w7 on it. After multiple boots where windows crashed right at the logo screen, I learned about the w7 thing and wanted to upgrade to w10. Here are the dumb questions:1/ can I upgrade to w10 from the bios by booting in USB? (at the moment I can't do anything else than going into the bios) 2/ Is the w7 installed in one of my HDD will be a problem for the w10 update or the USB boot? 3/ Is my case a lost cause? I'm completely clueless and, as stated, I can't do anything right now with this computer

External HDDs are just low quality/refurbished HDDs with a enclosure, you can buy your own enclosure and just trow a HDD or SSD inside.
They work through USB 2.0 or 3.0.

You put the HDD/SSD inside the case and then you can connect it to your PC to transfer stuff.
Its just a matter of creating a copy of your stuff somewhere else just in case your current storage fails, also a copy of that copy because one copy is never enough.

A example of a enclosure:
amazon.com/UGREEN-External-Enclosure-Adapter-Housing/dp/B06XWRRMYX/

And one for 3.5" drives.
amazon.com/AmazonBasics-3-5-inches-SATA-Drive-Enclosure/dp/B01MZC303G/

Thanks user. Is 130 bucks a good price for the EVO you mentioned? Also, is 3.1 usb backwards compatible with USB 2.0 and 1.0? I'll still get this instead of an external SSD if it is if you think it's more reliable.

The only reason it is more reliable than a HDD is because it wont break on its own if you will move it around since it has no moving parts so it cant be damaged from a drop and moving it around like a HDD can.
Yes, but you will be limited to USB 2.0 speeds (25MB/s).

860 EVO is the gold standard when it comes to SSDs, you can cheap out and get a SU800 but up to you.

Why do I I suddenly got slapped by a year old ban? Log shows that the ban started in November 2018 and ended on February 2019 but why i got banned now?

I'm thinking of getting the 2TB one but it's so ding dang fucking expensive.

when over clocking a gpu, whats the difference between increasing the power limit and incresing the core voltage? trying to overclock an rx 470. would i be better off increasing the power target instead of voltages? which option will let me keep the card thr most cold as possible?(dont mean downclocking).

With AMD isn't the big thing undervolt and overclock?

Why is there not a 16-core 64-bit 2.5GHz RISC-V thread on Jow Forums?

why is this psoted in so many of my threads? just make a new thread

voltage =/= power. you can push more power and less voltage

show pic

>just make a new thread
I cant, Jow Forums doesnt like my ISP for some dumb reason

How can I update my GPU driver on Puppy Linux?

>ryzen CPUs only support windows 10
no, you need to inject w7 drivers (clean install). since your doing 3d work, if any is blender you should be doing it on gnu linux. new mobo = new install usually

which drives? post sku

write it up, ill post it

Lads what's the best internet security I can get?

commonsense2019. hold off cause 2020 dev previews nearly out

Got a question. My old man is always having problems figuring out how to do shit on his Windows 10 laptop. How can I set it up so I can remote into it at any time and control the desktop?

You can buy a 1TB SSD and a 2TB HDD for cheaper, you will just have to carry more and be a bit more.

>Power limit
Your GPU can draw more power at the same voltage allowing you to overclock more if you hit your GPU power limit(Usually 120-150W)
>Voltage
More voltage, higher clock limits.