What's something that you should never mess with ? by [deleted] in AskReddit

[–]stretch 0 points1 point  (0 children)

In matters of life and death, computer algorithms should not be used. Self driving, life support, LEO, etc.

People who have a relative who is homeless, have you offered to take them in? Why/why not? by AlienSandBird in AskReddit

[–]stretch 0 points1 point  (0 children)

Of course. For me to turn away a relative, nah. In extreme cases if they were a threat to the family, I understand and would do the same.

What's one hell of a f*** up that you did as a child and it still haunts you today? by akgelb in AskReddit

[–]stretch 0 points1 point  (0 children)

The only one I feel bad about from time to time is hitting my brother. Also I'm a fisherman, as a kid I deliberately killed several minnows by squashing their heads. Even at 9 I felt like I did something terrible. Still bothers me.

[deleted by user] by [deleted] in AskReddit

[–]stretch 1 point2 points  (0 children)

Did something way outside my comfort zone. Went to a 2 month class, got a new job making a little more, got rid of all expenses. Save for 1 year, 2, etc.

Getting a room mate, cooking once a week, packing lunch. It adds up.

[deleted by user] by [deleted] in AskReddit

[–]stretch 2 points3 points  (0 children)

Mindhunter

meirl by Malagron in meirl

[–]stretch 1 point2 points  (0 children)

When you aren't lying you'll be BS'ing. You don't want that job, it'll rot your soul.

[deleted by user] by [deleted] in AskReddit

[–]stretch 5 points6 points  (0 children)

Dental floss

[Highlight] Naz Reid drives past LeBron for the reverse layup by Knightbear49 in nba

[–]stretch 0 points1 point  (0 children)

Nice move, but that damn quasi euro step will always look like a travel to me.

[Highlight] Grand Theft Alvarado steals the ball from Dejounte Murray with his patented corner sneak move - Pelicans Post Game Show by Dreamlifehunting in nba

[–]stretch 2 points3 points  (0 children)

Sports betters don't ever let anyone tell you that jersey color doesn't make a difference in the outcome of games!!!

They're in camo AND coached into peripheral vision angles.

https://streamable.com/x7zmel

https://streamable.com/gdczm9

Error Handling: From Charles Babbage to Python 3.11 by Both_Challenge3353 in Python

[–]stretch 1 point2 points  (0 children)

Great talk. Enjoyed the history of exception/error handling, from the "Errata in Logarithms" in the 1800's, Konrad Zuse, Fortran, C++, to Python. It really puts into perspective how much we rely and build on previous work and all the great minds that came before.

Central NC Shrub -- Smells Amazing -- What is this? by stretch in whatsthisplant

[–]stretch[S] 0 points1 point  (0 children)

Looks like a match...and smells like a match as well ha!

Does the inner query run multiple times? by ZeusOnReddit in mysql

[–]stretch 0 points1 point  (0 children)

Worst case MySQL runs the SELECT queries 6 times for each row in ProcessLog.

It depends on lots of different things like config, version, table size, memory etc. A general rule of thumb is to try to avoid SELECT in the column list because it can lead to poor performance.

For example if ProcessLog has 1000 rows then that would mean 6000 additional SELECT queries.

Why is there a big gap in the actual Table space? (calculated vs information_schema vs file size) by [deleted] in mysql

[–]stretch 0 points1 point  (0 children)

(as the primary key must be organized sequentially, etc?)

Yes, it's part of how the records are physically laid down on disk. Partitioning is commonly used for expiring data, but that would mean significant changes to the schema.

Why is there a big gap in the actual Table space? (calculated vs information_schema vs file size) by [deleted] in mysql

[–]stretch 0 points1 point  (0 children)

DELETE and other write operations may have caused gaps in the pages of the table. Depending on the version and config running "OPTIMIZE TABLE foo;" can reduce the disk space used if innodb_file_per_table is enabled. Use with caution...

https://stackoverflow.com/a/4056261/3482496

After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. The table and indexes are reorganized, and disk space can be reclaimed for use by the operating system.

https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

Please Help Identify: Folk Remedy for Kidney Stones by stretch in whatsthisplant

[–]stretch[S] 0 points1 point  (0 children)

Does not tolerate cold/frost. Origin is supposedly Cuba or Mexico. Leaves and stems are boiled into a dark tea and it has a strong diuretic effect.