search

wallabag / wallabag

wallabag is a self hostable application for saving web pages: Save and classify articles. Read them later. Freely.
https://wallabag.org
MIT License
9.91k stars 756 forks source link

Pocket import fails for some articles throwing DB exception #3331

Closed harshil93 closed 6 years ago

harshil93 commented 6 years ago

Issue details

{
  "entry": {
    "authors": {
      "40201274": {
        "author_id": "40201274",
        "item_id": "1203758669",
        "name": "RossMcSauce",
        "url": "https://www.reddit.com/user/RossMcSauce"
      }
    },
    "excerpt": "Hey /r/engineering! I hope this is far enough removed from school that it's ok here. Whenever I find myself without company for lunch/or dinner, I try to watch a video that'll teach me something.  Today I watched this 20 minute explanation of mechanical watch movements: https://www.youtube.",
    "favorite": "0",
    "given_title": "",
    "given_url": "https://www.reddit.com/comments/473yo2",
    "has_image": "0",
    "has_video": "0",
    "is_article": "1",
    "is_index": "0",
    "item_id": "1203758669",
    "resolved_id": "1203758669",
    "resolved_title": "[General] What's the best <30 minute video you've ever seen that explains an engineering technology or concept?",
    "resolved_url": "https://www.reddit.com/comments/473yo2",
    "sort_id": 187,
    "status": "0",
    "time_added": "1456251613",
    "time_favorited": "0",
    "time_read": "0",
    "time_updated": "1456251621",
    "userId": 1,
    "word_count": "2488"
  },
  "exception": "[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'INSERT INTO `wallabag_entry` (uid, title, url, is_archived, is_starred, content, created_at, updated_at, mimetype, language, reading_time, domain_name, preview_picture, is_public, http_status, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [null, \"[General] What's the best <30 minute video you've ever seen that explains an engineering technology or concept?\", \"https:\\/\\/www.reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/general_whats_the_best_30_minute_video_youve_ever\\/\", 0, 0, \"<div class=\\\"md\\\"><h6>What is <a href=\\\"https:\\/\\/www.reddit.com\\/r\\/engineering\\\">\\/r\\/engineering<\\/a> for?<\\/h6>\\n<p>1) Sharing information, knowledge, experience related to the principles and practice of all types of engineering: civil, structural, mechanical, electrical, aerospace, chemical, computer, environmental, etc.<\\/p>\\n<p>2) Questions about current engineering projects you are working on, how to interpret codes and standards, and industry practice are all encouraged. Engineers should help each other to make the world a safer and better place.<\\/p>\\n<p>3) Images related to engineering are accepted <em>provided they are relevant to engineering<\\/em>. Completed projects, destructive test results, and unique machinery and hardware are all acceptable and encouraged. Lead-in comments are encouraged to provide context to the readers.<\\/p>\\n<h6>Rules<\\/h6>\\n<p>1) Questions related to school aren't allowed, try <a href=\\\"https:\\/\\/www.reddit.com\\/r\\/EngineeringStudents\\\">\\/r\\/EngineeringStudents<\\/a>.<\\/p>\\n<p>2) Questions about 'how something works' aren't allowed, try <a href=\\\"https:\\/\\/www.reddit.com\\/r\\/AskEngineers\\\">\\/r\\/AskEngineers<\\/a>.<\\/p>\\n<p>3) Questions about major selection, careers, salaries, resumes, and office politics should be posted in the GENERAL threads that are posted daily. Job postings\\/wanted ads should be placed in the weekly <a href=\\\"http:\\/\\/www.reddit.com\\/r\\/engineering\\/search?q=job+Mega-Thread&amp;restrict_sr=on&amp;sort=new&amp;t=all\\\"><strong>CAREERS<\\/strong><\\/a> thread. Do not post these topics outside of those threads. <strong>The general rule of thumb is this: if your question does not involve the<\\/strong> <strong><em>principles and practice<\\/em><\\/strong> <strong>of engineering, it belongs in the daily <a href=\\\"https:\\/\\/www.reddit.com\\/r\\/engineering\\/comments\\/5i7zyo\\/the_end_of_the_biweekly_advice_megathreads_and\\/\\\">GENERAL<\\/a> threads.<\\/strong><\\/p>\\n<p>4) No self-promotion or blog-spam of any kind.<\\/p>\\n<p>5) No memes or image macros.<\\/p>\\n<p>6) No low-effort posts. This includes jokes, puns, etc.<\\/p>\\n<p>7) Keep discussion civil. Overly insulting or crass comments will be removed, multiple violations will lead to ban.<\\/p>\\n<p>8) No sensationalised titles.<\\/p>\\n<p>9) Posts about 9\\/11 are blacklisted. <a href=\\\"https:\\/\\/www.reddit.com\\/r\\/engineering\\/comments\\/51ykr8\\/european_physical_society_15_years_later_on_the\\/d7fwbtk\\\">Why?<\\/a><\\/p>\\n<h6>Kickstarter \\/ Crowdfunding<\\/h6>\\n<p>You are allowed a <strong>single<\\/strong> post provided it is relevant to engineering and you are active in the comments to answer any questions. Your post MUST be submitted as a <a href=\\\"http:\\/\\/www.reddit.com\\/r\\/engineering\\/submit?selftext=true\\\">self-post<\\/a>.<\\/p>\\n<h6>Need to Interview an Engineer?<\\/h6>\\n<p>Pick an engineer from the list of volunteers below and send him or her a PM indicating that you would like to conduct an interview:<\\/p>\\n<ul><li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/ArtificialSpark\\\">\\/u\\/ArtificialSpark<\\/a>: Consulting (EE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/caffinate\\\">\\/u\\/caffinate<\\/a>: Power Electronics (Prof)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/capitalmonks\\\">\\/u\\/capitalmonks<\\/a> Electrical Power Systems (EE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/careercatalysis\\\">\\/u\\/careercatalysis<\\/a>: Refining (CHE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/c0d3M0nk3y\\\">\\/u\\/c0d3M0nk3y<\\/a>: Video Games (CS)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/cr4zy3ng1n33r\\\">\\/u\\/cr4zy3ng1n33r<\\/a>: Broadcast (EE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/CyaNBlu3\\\">\\/u\\/CyaNBlu3<\\/a>: Bioengineering (ME)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/DoorGuote\\\">\\/u\\/DoorGuote<\\/a>: Stormwater (PE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Dunengel\\\">\\/u\\/Dunengel<\\/a>: Geotechnical<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Gohanto\\\">\\/u\\/Gohanto<\\/a>: Acoustics<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/HaggardAvatar\\\">\\/u\\/HaggardAvatar<\\/a>: Thermodynamics (ME)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/hydro_wonk\\\">\\/u\\/hydro_wonk<\\/a>: Hydrologist (PE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/ingeniero_war\\\">\\/u\\/ingeniero_war<\\/a>: Industrial Automation (ME)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/internationengineer\\\">\\/u\\/internationengineer<\\/a>: MEP Design (ME)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/injuredtoad\\\">\\/u\\/injuredtoad<\\/a>: Oil Refining (ME)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/kv-2\\\">\\/u\\/kv-2<\\/a>: Steel Industry (MGT)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/legofarley\\\">\\/u\\/legofarley<\\/a>: Structural (PE\\/SE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/meerkatmreow\\\">\\/u\\/meerkatmreow<\\/a>: Fluids (AE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Miketheguy\\\">\\/u\\/Miketheguy<\\/a>: Software Engineer<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Nadrius\\\">\\/u\\/Nadrius<\\/a>: Wastewater\\/Civil (CE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Notagiant2199\\\">\\/u\\/Notagiant2199<\\/a>: Biofuels (CHE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Obbz\\\">\\/u\\/Obbz<\\/a> Consulting: (EE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/raoulduke25\\\">\\/u\\/raoulduke25<\\/a>: Structural (PE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Real_MikeCleary\\\">\\/u\\/Real_MikeCleary<\\/a>: Upstream Oil\\/Gas (PetE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Red8600\\\">\\/u\\/Red8600<\\/a>: Controls<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Saryu\\\">\\/u\\/Saryu<\\/a>: IP Video Distribution (EE\\/SE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/SmashAndCAD\\\">\\/u\\/SmashAndCAD<\\/a>: Aircraft Design (AE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/theaeroengineer\\\">\\/u\\/theaeroengineer<\\/a>: Aircraft Design (AE)<br \\/><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/Tyrinnus\\\">\\/u\\/Tyrinnus<\\/a>: Chemical (CHE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/whats_hot_DJroomba\\\">\\/u\\/whats_hot_DJroomba<\\/a>: Structural (PE)<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/u\\/zubin147\\\">\\/u\\/zubin147<\\/a>: Industrial<\\/li>\\n<\\/ul><h6>Reporting Posts<\\/h6>\\n<p>Anything that looks like it violates the rules, <strong>please report it<\\/strong>.<\\/p>\\n<hr \\/><p><strong>Directory of Useful Subreddits<\\/strong><\\/p>\\n<h6>Engineering Fields<\\/h6>\\n<ul><li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/Aerospace\\\">Aerospace<\\/a>: Aerospace<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/AskEngineers\\\">AskEngineers<\\/a>: Non-school Q&amp;A<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/AskElectronics\\\">AskElectronics<\\/a>: CE\\/EE Q&amp;A<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/bioengineering\\\">BioEngineering<\\/a>: Biological<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/biotech\\\">Biotech<\\/a>: Biotechnology<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/chemicalengineering\\\">Chem E<\\/a>: Chemical<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/civilengineering\\\">Civil Engineering<\\/a>: Civil<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/construction\\\">Construction<\\/a>: Construction<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/ECE\\\">ECE<\\/a>: General EE &amp; CE discussion<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/electricalengineering\\\">EE<\\/a>: Electrical<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/EngineeringStudents\\\">EngineeringStudents<\\/a>: For wee engineerlings<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/Manufacturing\\\">Manufacturing<\\/a>: Manufacturing Industry<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/materials\\\">Materials<\\/a>: Materials Engineering<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/mechanicalengineering\\\">Mech E<\\/a>: Mechanical Engineering<\\/li>\\n<\\/ul><h6>Engineering Topics<\\/h6>\\n<ul><li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/CAD\\\">CAD<\\/a>: Computer Aided Design<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/cfd\\\">CFD<\\/a>: Fluid Dynamics<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/FEA\\\">FEA<\\/a>: Finite Element Analysis<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/PLC\\\">PLC<\\/a>: Programmable Logic Controllers<\\/li>\\n<\\/ul><h6>General Science<\\/h6>\\n<ul><li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/askscience\\\">AskScience<\\/a>: No-nonsense science Q&amp;A<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/biology\\\">Biology<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/chemistry\\/\\\">Chemistry<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/coding\\\">Coding<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/ComputerScience\\\">Computer Science<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/electronics\\\">Electronics<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/lectures\\\">Lectures<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/math\\/\\\">Math<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/physics\\/\\\">Physics<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/programming\\\">Programming<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/science\\\">Science<\\/a><\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/FluidMechanics\\\">Fluid Mechanics<\\/a><\\/li>\\n<\\/ul><h6>Textbooks<\\/h6>\\n<ul><li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/csbooks\\\">CSBooks<\\/a>: Computer Science<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/eebooks\\\">EEBooks<\\/a>: Electrical Engineering<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/mathbooks\\/\\\">MathBooks<\\/a>: Mathematics<\\/li>\\n<li><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/physicsbooks\\\">PhysicsBooks<\\/a>: Physics<\\/li>\\n<\\/ul><h6>Other Links<\\/h6>\\n<ul><li><p><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/ECEComponentExchange\\\">ECEComponentExchange<\\/a>: Parts swap  <\\/p><\\/li>\\n<li><p><a href=\\\"http:\\/\\/www.eng-tips.com\\/\\\">Eng-Tips<\\/a>: Q&amp;A for various fields<\\/p><\\/li>\\n<\\/ul><\\/div><div class=\\\"md\\\"><p>Hey <a href=\\\"https:\\/\\/www.reddit.com\\/r\\/engineering\\\">\\/r\\/engineering<\\/a>! I hope this is far enough removed from school that it's ok here. Whenever I find myself without company for lunch\\/or dinner, I try to watch a video that'll teach me something.<\\/p>\\n<p>Today I watched this 20 minute explanation of mechanical watch movements: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=508-rmdY4jQ\\\">https:\\/\\/www.youtube.com\\/watch?v=508-rmdY4jQ<\\/a>\\nIt's a tad dated, but otherwise very good. I learned a lot, and got some insight into creative uses for gears and springs.<\\/p>\\n<p>What are some videos like this you'd recommend to the avid learner? I'd especially be interested in automotive videos. I want to put together a simple transmission in Solidworks.<\\/p>\\n<p>Thanks<\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=yYAw79386WI\\\">how a differential works<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Came here to post this. Definitely a perfect example and well explained <\\/p>\\n<\\/div><div class=\\\"md\\\"><p>My wife made the mistake of asking me what a differential is. Made her watch this. She's incredibly intelligent, but not so mechanically inclined. She even understood after this video.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>If I ever get thrust back in time I'll be sure to meet up with Archimedes and tell him what I know maybe speed up this whole party a few hundred years.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Wow that was neat. Like I told another poster, the old videos do seem to be a lot better haha. This is very on topic for me. Much appreciated!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>This is part of a series Chevy did in the '30s and all the videos do a great job explaining various parts.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>do you have a link to the rest of them? <\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"http:\\/\\/www.youtube.com\\/playlist?list=PLW0fh8Yrkjei6LLeVedW7ZZXC3AivB5VN\\\" rel=\\\"nofollow\\\">Link<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>thanks!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>There's some missing from there, as well as ones not part of the series.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>I like how it turns into an advertisement. I need dat low center drive. <\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Feynman's explanation as to why trains don't use differentials is pretty excellent as well<\\/p>\\n<\\/div><div class=\\\"md\\\"><blockquote>\\n<p>Feynman's explanation to everything ever<\\/p>\\n<\\/blockquote>\\n<p>FTFY haha <\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=y7h4OtFDnYE\\\" rel=\\\"nofollow\\\">Came to post this<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>This is by far my absolute favorite Engineering video. Differentials are fascinating!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>This<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>May not be overly technical, but anything by The Engineer Guy on YouTube is really well done.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Is he the guy that did the video on the mechanical Fourier transform mechanism? <\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=NAsM30MAHLg\\\">Yep. Link for the lazy<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Wow, that looks amazing!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>That is amazing! Oh my god! I heard of the machine before and I only thought it could do synthesis.<\\/p>\\n<p>I never knew it could do inverse Fourier transforms!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>The trick is, a DFT and its inverse, the synthesis, are the same thing.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Hahaha I just realized that. Thats amazing. Any machine that could do a DFT, can do the inverse as well because its almost exactly the same thing (isn't there just so coefficient scaling involved?)<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Holy shit that is amazing!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Nothing wrong with that! I pay my professors to teach me technical stuff, I just want something easily digestible so I can begin tackling more advanced texts. Thanks!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>applied science talks about lcd displays<\\/p>\\n<p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=d4QFNWBSZYg\\\">https:\\/\\/www.youtube.com\\/watch?v=d4QFNWBSZYg<\\/a><\\/p>\\n<p>and then just go ahead and watch everything else by applied science<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>I love that channel. Not many people out there that can hold my attention for over 21 minutes while talking about cleaning supplies.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Honestly though. Young people like myself are bombarded with so much input that it's very hard to focus on something stripped down like a quiet lecture from a bored-looking professor in an uncomfortable classroom.<\\/p>\\n<p>The world could use more teachers like this guy.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=DD2dtAqJcJ4\\\">Analog battleship firing computer!<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>The only correct answer is the Turbo Encabulator. And that video is only 3 minutes long.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Very informational!  <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=Ac7G7xOG2Ag\\\">Link for lazy<\\/a> <\\/p>\\n<\\/div><div class=\\\"md\\\"><p>The hell...waa this a troll video? Weren those words even real? The fuck does it do?!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>It generates dank memes from way back in the fifties...<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Yeah they really break it down in layman's terms but still go into plenty of detail.  Great video.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=PHe0bXAIuk0\\\">How the Economic Machine Works<\\/a> by Ray Dalio, CEO of Bridgewater Associates (one of the most competitive hedge funds within the industry - they equate their hiring process to the BUD\\/S of Finance).<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>[deleted]<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Scott Manley is seriously the best. Astronomy and orbital mechanics, and then KSP and Elite videos for when you want to take a break. :) <\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/user\\/szyzyg\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/user\\/szyzyg<\\/a> This guy?<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Yup!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Any particular video you could recommend?<\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=ffrN0CVSIm4\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=ffrN0CVSIm4<\\/a><\\/p>\\n<p>This is one of the first videos of his that I watched, and it's the one that convinced me to get Elite: Dangerous.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>I was going to come in here and ask \\\"Does Scott Manley playing KSP count?\\\"<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Videos in this thread: <a href=\\\"http:\\/\\/subtletv.com\\/_r473yo2?feature=playlist\\\">Watch Playlist \\u25b6<\\/a><\\/p>\\n<table><thead><tr><th>VIDEO<\\/th>\\n<th>COMMENT<\\/th>\\n<\\/tr><\\/thead><tbody><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=yYAw79386WI\\\">Around The Corner (1937) How Differential Steering Works<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a3ell?context=10#d0a3ell\\\">76<\\/a> - how a differential works<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=d4QFNWBSZYg\\\">Building a liquid crystal display (LCD)<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a29yb?context=10#d0a29yb\\\">10<\\/a> - applied science talks about lcd displays    and then just go ahead and watch everything else by applied science<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=NAsM30MAHLg\\\">(1\\/4) Intro\\/History: Introducing a 100-year-old mechanical computer<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a8p0n?context=10#d0a8p0n\\\">6<\\/a> - Yep. Link for the lazy<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=DD2dtAqJcJ4\\\">Basic Mechanisms In Fire Control Computers: Shafts, Gears, Cams... 1953 US Navy Training Film<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a5hk1?context=10#d0a5hk1\\\">6<\\/a> - Analog battleship firing computer!<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=PHe0bXAIuk0\\\">How The Economic Machine Works by Ray Dalio<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a9mqv?context=10#d0a9mqv\\\">5<\\/a> - How the Economic Machine Works by Ray Dalio, CEO of Bridgewater Associates (one of the most competitive hedge funds within the industry - they equate their hiring process to the BUD\\/S of Finance).<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=RB91Sm-kGJ8\\\">Tower Crane Assembly with Climber Demo<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a3308?context=10#d0a3308\\\">3<\\/a> - Building a tower crane<\\/td>\\n<\\/tr><tr><td>(1) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=aFvj6RQOLtM\\\">Car Transmissions &amp; Synchromesh: \\\"Spinning Levers\\\" 1936 Chevrolet Auto Mechanics 10min<\\/a> (2) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=AlpvyWAA8a0\\\">Power Steering: \\\"Hydraulic Steering Principles of Operation\\\" 1955 US Army Auto Mechanics<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0adnnf?context=10#d0adnnf\\\">2<\\/a> - (1936: \\\"spinning levers\\\" -- how a transmission works, by Chevrolet)[]  The GM video of similar vintage about differentials linked elsewhere on this thread is also amazing.  Military videos from the 30s-60s are also excellent; they w...<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=OpLU__bhu2w\\\">The 10,000 Domino Computer<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0acdxw?context=10#d0acdxw\\\">2<\\/a> - The World's Slowest Computer (made of dominoes)<\\/td>\\n<\\/tr><tr><td>(1) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=wCu9W9xNwtI\\\">Manual Transmission, How it works ?<\\/a> (2) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=SB34I33Bqrg\\\">3D printed transmission<\\/a> (3) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=1QJlL0zNdMA\\\">Putting 1140 hp to the Ground - \\/Inside Koenigsegg<\\/a> (4) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=JGbsgpp2YJQ\\\">The Basic Parts of an Automatic Transmission (Part 1)<\\/a> (5) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=vOo3TLgL0kM\\\">Manual Transmission Operation<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a9p1d?context=10#d0a9p1d\\\">2<\\/a> - Check these out:   Animation of how a transmission works:   3D printed transmission:    Koenigsegg transmission:   Eric the car guy showing the basic parts of a transmission:   This video is really good and so are the other videos on this channel:   ...<\\/td>\\n<\\/tr><tr><td>(1) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=LWH5bfpivSU\\\">Bored of lame tool reviews? Meet DeWalt's 12 Amp Grinder part A<\\/a> (2) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=VTzKIs19eZE\\\">How To Make An Electrical Arc Furnace<\\/a> (3) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=17jymDn0W6U\\\">The Known Universe by AMNH<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a7ym6?context=10#d0a7ym6\\\">2<\\/a> - I like this guy's tool reviews:   And this a fun one on how to make a mini arc furnace:   This is probably my favorite, Size of the Known Universe:<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=OpL0joqJmqY\\\">DC MOTORS AND GENERATORS<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a668n?context=10#d0a668n\\\">2<\\/a> - It is just slightly longer than 30 minutes but I was always fond of DC Motors and Generators (). I think there's a reasonable argument here where you could even say this video even covers two topics which would put each one under the time.<\\/td>\\n<\\/tr><tr><td>(1) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=0rHUDWjR5gg\\\">Introduction to Astronomy: Crash Course Astronomy #1<\\/a> (2) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=B8Y146v8HxE\\\">How To Make A Clock In The Home Machine Shop - Part 1 - Making The Clock Frames<\\/a> (3) <a href=\\\"https:\\/\\/youtube.com\\/watch?v=xMP_AfiNlX4\\\">Building Prototypes Dan Gelbart  part 1 of 18  Introduction<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0aa8qe?context=10#d0aa8qe\\\">1<\\/a> - Sorry if something doesn't come thru...I'm on mobile. Well, this is something I really enjoy. I sometimes question if I just watch them to feel like I'm learning something, or if I actually am learning the concepts. Either way...<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=WdEWzqsfeHM\\\">Helicopter Physics Series Intro - #1 Smarter Every Day 45<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0a9vnx?context=10#d0a9vnx\\\">1<\\/a> - Does a series of &lt;30 minute videos count?  SmarterEveryDay's series on helicopter mechanics is fascinating.<\\/td>\\n<\\/tr><tr><td><a href=\\\"https:\\/\\/youtube.com\\/watch?v=Ac7G7xOG2Ag\\\">\\\"Turbo Encabulator\\\" the Original<\\/a><\\/td>\\n<td><a href=\\\"https:\\/\\/reddit.com\\/r\\/engineering\\/comments\\/473yo2\\/_\\/d0agtqv?context=10#d0agtqv\\\">1<\\/a> - Link for lazy<\\/td>\\n<\\/tr><\\/tbody><\\/table><p>I'm a bot working hard to help Redditors find related videos to watch.<\\/p>\\n<hr \\/><p><a href=\\\"http:\\/\\/subtletv.com\\/_r473yo2?feature=playlist&amp;ftrlnk=1\\\">Play All<\\/a> | <a href=\\\"https:\\/\\/np.reddit.com\\/r\\/SubtleTV\\/wiki\\/mentioned_videos\\\">Info<\\/a> | <a href=\\\"https:\\/\\/chrome.google.com\\/webstore\\/detail\\/mentioned-videos-for-redd\\/fiimkmdalmgffhibfdjnhljpnigcmohf\\\">Chrome Extension<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>It is just slightly longer than 30 minutes but I was always fond of DC Motors and Generators (<a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=OpL0joqJmqY\\\">https:\\/\\/www.youtube.com\\/watch?v=OpL0joqJmqY<\\/a>). I think there's a reasonable argument here where you could even say this video even covers two topics which would put each one under the time.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"http:\\/\\/web.mit.edu\\/hml\\/ncfmf.html\\\">The series of Fluid Mechanics films linked here<\\/a> are excellent.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Check these out: <\\/p>\\n<p>Animation of how a transmission works: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=wCu9W9xNwtI\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=wCu9W9xNwtI<\\/a><\\/p>\\n<p>3D printed transmission: \\n<a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=SB34I33Bqrg\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=SB34I33Bqrg<\\/a><\\/p>\\n<p>Koenigsegg transmission: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=1QJlL0zNdMA\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=1QJlL0zNdMA<\\/a><\\/p>\\n<p>Eric the car guy showing the basic parts of a transmission: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=JGbsgpp2YJQ\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=JGbsgpp2YJQ<\\/a><\\/p>\\n<p>This video is really good and so are the other videos on this channel: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=vOo3TLgL0kM\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=vOo3TLgL0kM<\\/a><\\/p>\\n<p>And lastly: <a href=\\\"https:\\/\\/www.youtube.com\\/playlist?list=PL7B5B6479699EB204\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/playlist?list=PL7B5B6479699EB204<\\/a><\\/p>\\n<p>I only posted these because I've personally watched millions of automotive videos and read that you want to model a transmission in solid works. Im really curious to see what others have to post<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Threads like this make my day, thanks everyone for the links \\ud83d\\udc4d<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Jason Fenske has awesome explanation of a ton of automotive concepts under the channel EngineeringExplained: \\n<a href=\\\"https:\\/\\/www.youtube.com\\/user\\/EngineeringExplained\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/user\\/EngineeringExplained<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=RB91Sm-kGJ8\\\">Building a tower crane<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=OpLU__bhu2w\\\">The World's Slowest Computer (made of dominoes)<\\/a>  <\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Amazing. The most interesting result is that they highlighted problems you also have when building electronic circuits.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>I like this guy's tool reviews: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=LWH5bfpivSU\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=LWH5bfpivSU<\\/a><\\/p>\\n<p>And this a fun one on how to make a mini arc furnace: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=VTzKIs19eZE\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=VTzKIs19eZE<\\/a><\\/p>\\n<p>This is probably my favorite, Size of the Known Universe: <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=17jymDn0W6U\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=17jymDn0W6U<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Does a series of &lt;30 minute videos count?  <a href=\\\"https:\\/\\/youtu.be\\/WdEWzqsfeHM\\\" rel=\\\"nofollow\\\">SmarterEveryDay's series on helicopter mechanics<\\/a> is fascinating.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Of course! I like video series as you can adjust for how much time you have at any given moment.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Sorry if something doesn't come thru...I'm on mobile. Well, this is something I really enjoy. I sometimes question if I just watch them to feel like I'm learning something, or if I actually am learning the concepts. Either way, I spend a lot of time watching sciency type YouTube videos. <\\/p>\\n<p>As someone earlier mentioned, probably the most \\\"engineering style thing\\\" is EngineerGuy, so I won't link it, but that's the first thing I thought of, so check that out pronto, especially some of their older vids. Some broader things; I just finished CrashCourse Astronomy, where I learned a surprising amount about space and things in the universe. <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=0rHUDWjR5gg\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=0rHUDWjR5gg<\\/a><\\/p>\\n<p>I'll mention PBS Spacetime because it's a great channel, but for someone like me that has never taken quantum mechanics, it can be a bit hard to connect it to the real world. I watch it as kind of a romp, just for fun. <\\/p>\\n<p>There's a channel called Clickspring where the guy teaches you a whole bunch of stuff about machining, in the process of making a large wheel skeleton clock. Kind of like the Bob Ross of machining - real relaxing stuff.  <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=B8Y146v8HxE\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=B8Y146v8HxE<\\/a><\\/p>\\n<p>This one's cheating a bit because some of the videos are over a half hour, but the Prototyping series by Dan Gelbart really has a lot of gems for engineers working in R&amp;D - getting prototypes out quickly and efficiently. Stuff they really should focus more on in school. I highly recommend it. \\n<a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=xMP_AfiNlX4\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=xMP_AfiNlX4<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.reddit.com\\/r\\/HowToOldSchool\\/\\\" rel=\\\"nofollow\\\">\\/r\\/HowToOldSchool\\/<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Wow guys thank you so much! I didn't expect such a wealth of responses. Now I've got more than I know what to do with haha. <\\/p>\\n<p>I've found that learning how a broad range of technology functions really helps me be more creative when working on projects in any specific field. This should help me out. Thanks!<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>(1936: \\\"spinning levers\\\" -- how a transmission works, by Chevrolet)[<a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=aFvj6RQOLtM\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/watch?v=aFvj6RQOLtM<\\/a>]<\\/p>\\n<p>The GM video of similar vintage about differentials linked elsewhere on this thread is also amazing.<\\/p>\\n<p>Military videos from the 30s-60s are also excellent; they were designed to turn farm boys into mechanics, technicians, and combat engineers overnight.  <a href=\\\"https:\\/\\/www.youtube.com\\/watch?v=AlpvyWAA8a0\\\" rel=\\\"nofollow\\\">Here is one on how hydraulic power steering works<\\/a><\\/p>\\n<\\/div><div class=\\\"md\\\"><p>most videos that explain an engineering concept for longer than 30 minutes aren't worth watching.  That said <a href=\\\"https:\\/\\/www.reddit.com\\/u\\/compstomper\\\" rel=\\\"nofollow\\\">\\/u\\/compstomper<\\/a> is right, that's the best one I've seen.  There is a similar one for watch movements, but it's a bit harder to find.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>I have a 16mm film from Allis-Chalmers produced in the 1940s that explains how a torque converter functions. It uses water wheels and garden hoses and eventually becomes a sales pitch for one of their excavators equipped with it. I'd love to put it up but professional conversion costs money. <\\/p>\\n<p>Another shows how 4-cycle diesel engines function, and goes on to explain the benefits of 2-cycle diesels as they were making their debut in the 1940s as well.  It's done well. Simple but informative. <\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Honestly I've been surprised how much better the \\\"older\\\" videos can be. Maybe it's the focus on content and lack of jargon? Those are some cool pieces of engineering history you've got! How'd something like that find its way into your hands?<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>An local Allis-Chalmers construction equipment dealer (Borchert-Ingersoll) was tossing them in the dumpster in the late 80s and my dad happened to be there and picked them out.  <\\/p>\\n<p>Dumpster Dive for the win.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Any of the royal institute lectures on YouTube are great. <\\/p>\\n<\\/div><div class=\\\"md\\\"><p>Do you have a list of some of the videos you have watched in the past?<\\/p>\\n<\\/div><div class=\\\"md\\\"><p>No I don't, I'm afraid. Honestly for a while I was textbook-based. It's only in the last six months I've really tried to up my learning game. It looks like the posters here should have enough videos to keep us both occupied though.<\\/p>\\n<\\/div><div class=\\\"md\\\"><p><a href=\\\"https:\\/\\/www.youtube.com\\/user\\/engineerguyvideo\\\" rel=\\\"nofollow\\\">https:\\/\\/www.youtube.com\\/user\\/engineerguyvideo<\\/a> \\nThe engineer guy explains many different concepts in a very simple and interesting way. The coffee maker video is a personal favorite<\\/p>\\n<\\/div>\", \"2016-02-23 18:20:13\", \"2017-08-25 15:12:43\", \"text\\/html\", \"en\", 14, \"www.reddit.com\", \"https:\\/\\/i.redditmedia.com\\/p8e7ciVbkTT9t-V3afpuZElrW73xxARnurROiWb-eLY.jpg?w=320&s=c42d96675b0629628e24d062e40faad5\", null, 200, 1]:PDOStatement.php:91)": SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xF0\\x9F\\x91\\x8D</...' for column 'content' at row 1 at /var/www/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"}
}

Just try adding this url to wallabag: https://www.reddit.com/r/engineering/comments/473yo2/general_whats_the_best_30_minute_video_youve_ever/

Environment

j0k3r commented 6 years ago

This should be the same problem at least from that issue: https://github.com/wallabag/wallabag/issues/3282

If it's not let me know and we'll re-open the issue.