Re: Things I hate about TV shows Community Center Geeks' Lounge by KomalBhatt You know, there are few things more frustrating than getting interested in a TV show only to find it falling short of expectations. From the overly predictable plotlines to the underdeveloped characters, there's a huge list. But what really get irritated by is when the dialogue feels forced, like the writers are trying too hard to be clever or … Re: Things I hate about TV shows Community Center Geeks' Lounge by Dani That's my point, though. Gone are the days when a show would break for a summer and the next season would start up again in the fall. Re: Things I hate about TV shows Community Center Geeks' Lounge by Reverend Jim >Gone are the days That's pretty much the case for everything. I remember when TV sucked all through summer vacation and I couldn't wait for the end of September for the new seasons to start. Of course it was bittersweet because September also meant back to school. I'll mention a few more things that may have been mentioned before but I … Paris Olympics Chatbot- Get Ticket Information Using Chat-GPT and LangChain Programming Computer Science by usmanmalik57 I was searching for Paris Olympics ticket prices for tennis games recently. The official website directs you to a [PDF document](https://tickets.paris2024.org/obj/media/FR-Paris2024/ticket-prices.pdf) containing ticket prices and venues for all the games. However, I found the PDF document to be very hard to navigate. To make things easier, I … Paris Olympics Ticket Information Chatbot with Memory Using LangChain Programming Computer Science by usmanmalik57 In my previous article, I explained how I developed a simple chatbot using LangChain and Chat-GPT that can answer queries related to Paris Olympics ticket prices. However, one major drawback with that chatbot is that it can only generate a single response based on user queries. It can not answer follow-up questions. In short, the chatbot has no … Re: Trying to animate sprite using DirectX9 Programming Software Development by Pavel_11 Hello, it is unneccessarily to use right movex or leftmovex , because it is to much variables. You should to use one variable movex to make it with minus or plus sign in your update function; by pressing left or right keys; because the one thing which is changable is a picture; I mean in global sense; variables like leftx, right x should be one… Re: Things I hate about TV shows Community Center Geeks' Lounge by Dani Currently the thing I hate most about TV shows is how much time elapses between seasons. I feel like I've been waiting for season 2 of Severance on AppleTV for *forever*! (It's been over 2 years already since season 1 debuted.) Speaking of that, is there ever going to be a second season for Squid Game? I can't imagine that Netflix wouldn’t invest … Re: Things I hate about TV shows Community Center Geeks' Lounge by Reverend Jim Fer sher. You pretty much have to watch the previous season again before you start the next one. I'm still waiting for season 2 of The Old Man (Jeff Bridges, John Lithgow). At my age sometimes I lose the thread if two weeks goes by between episodes. Sometimes I'll wait until the end of a season before I watch any of it. I especially hate it when a … Re: Things I hate about TV shows Community Center Geeks' Lounge by pritaeas > is there ever going to be a second season for Squid Game Yes, already announced, available soon. Improve HAVING BY performance Programming Databases by Dani What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes. Re: Improve HAVING BY performance Programming Databases by Dani Everything there is very generic and, dare I say, robotic, and doesn't really answer my question as to if any MySQL experts out there have come up with any creative tips they'd like to share from their own experience. I would have been much more interested in what your friend had to say from his firsthand experience than what ChatGPT has to say.… Re: i don´t understand this syntax error when using OpenCV Programming Databases by Audun Thanks. That sorted it. Now, I have a new problem.. I tried the two variations of quotation marks, without the backslash, and got this: >>> %Run 'open cv - tot.py' Traceback (most recent call last): File "C:\Users\Audun Nilsen\open cv - tot.py", line 8 image = cv2.imread("C:\Users\Audun Nilsen\Pictures\… Htaccess Problem Url Friendly Programming Web Development by Adolfo_1 I have problem with this htaccess in STATIC URL RewriteEngine On RewriteRule ^readlex/(.*)$/?$ readlex.php?slug=$1 [NC,L] **DINAMIC URL** work fine only with defined CONSTANT: Example <a href="<?php echo BASE_URL.READ_LEX ?>Le-mura-di-Lucca">Lucca</a> Result = localhost/mysite/… 7 NLP Tasks to Perform for Free in Python with Mistral 7b LLM Programming Computer Science by usmanmalik57 In the rapidly evolving field of Natural Language Processing (NLP), open-source large language models (LLMs) are becoming increasingly popular as they are free to use. Among these, the [Mistral](https://docs.mistral.ai/models/) family of models stands out as a state-of-the-art model that is freely accessible to the public. Comparable in … Re: Improve HAVING BY performance Programming Databases by Reverend Jim I'm not very familiar with HAVING but my understanding is that it is used to filter results after a GROUP operation so I can't imagine that indexes would improve performance other than on the original SELECT. Using WHERE would return rows based on one or more criteria, and would benefit from indexing, but HAVING, as I understand, is performed after… Re: Improve HAVING BY performance Programming Databases by Dani Yes, that's true. But for those instances where we are left in circumstances where we have to perform HAVING on large tables, is there *anything* we can take into consideration for performance? Even if we must do large table scans, are there any tips in the most efficient way of doing them? Re: Improve HAVING BY performance Programming Databases by pritaeas Perhaps a smarter someone on this forum can help you look at the execution plan of your query and suggest some improvements. Re: Improve HAVING BY performance Programming Databases by Reverend Jim I have a friend who spent the better part of a career doing SQL. I wrote up your question and sent it off to him. Just for sh!ts and giggles, he decided to feed it to ChatGPT first. He said that what he got back was what he would have written if he spent a lot of time researching. Here is what ChatGPT said... >Yes, you're correct that … Re: Improve HAVING BY performance Programming Databases by Reverend Jim Clearly you missed the part where my friend said, it's the same answer he would have given. In other words, the answer generated by ChatGPT was vetted by an expert. I do not understand your response in this case. If I were to post a code project here, and that project happened to contain a ChatGPT generated function, would that be a no-no in … Re: Improve HAVING BY performance Programming Databases by Reverend Jim If I had taken the ChatGPT reply, reworded, then posted it, would that have been OK? Or would that be plagiarism? What if I posted my reworded version AND credited it as a rewording of a ChatGPT generated answer? Then that just makes me look like an idiot. Where is the line? Re: Improve HAVING BY performance Programming Databases by Reverend Jim >see if you can convert it to a WHERE clause I made a foolish assumption that the HAVING was something that depended on the GROUPing and thus could not be converted to w WHERE. As for my expert, I also assumed that if he could have been more specific he would have been. That would have required more info on your specific situation. May I … Re: Improve HAVING BY performance Programming Databases by Dani > Clearly you missed the part where my friend said, it's the same answer he would have given. No, you didn't say it's the same answer he would have given. You said it's what he would have written *if he spent a lot of time researching.* There's a big difference between asking an industry expert for their personal opinion based on their own … Re: Improve HAVING BY performance Programming Databases by Dani I'll give you another example. I've been going to the doctor a lot lately. After each appointment, there is a long form summary of everything that was said, test results, interpretation of the test results, and next steps, all generally typed up by a medical student or resident. At the bottom it has my doctor's signature saying something along … Re: Improve HAVING BY performance Programming Databases by Reverend Jim I asked someone who is an acknowledged expert (not just by me). He agreed with the generated answer. If I had instead written him that advice, letting him believe it was mine, he would have given the same response. In other words, it was most definitely not simply AI generated garbage. If I asked ChatGPT and my doctor what to do for a particular… Re: Improve HAVING BY performance Programming Databases by Dani What your expert friend would have written, had he been a forum member here, is different than what the AI wrote. Even if the overall sentiment is the same, the actual typed words coming from a human are different than those coming from an AI. While he *agreed* with the generated answer, it's not what he would have answered himself upon being … Re: Improve HAVING BY performance Programming Databases by Dani > Now you are just splitting hairs I don't think so, but let's just agree to disagree. Re: Improve HAVING BY performance Programming Databases by AndreRet And so the queen bee has spoken again, no matter the input or consideration from others. IMHO Reverend Jim were not out of line here, merely posted a scenario which could have helped... I truly saw/hoped for a turn around on the site but it seems to be governed by a "my way or the highway" mindset. Through some years I have really tried … Re: Improve HAVING BY performance Programming Databases by Dani I see it very differently than you see it. I consider Jim a real world friend of mine, as is his son, Adam, who I had actually invited to my wedding. I didn't bash Jim with my moderator nor admin nor forum owner hat on. He contributed a post where I disagree with his viewpoint. He disagrees with mine. We had a public debate about it. I took … Re: Improve HAVING BY performance Programming Databases by Reverend Jim >We "bashed" viewpoints, and never each other As it should be. I wish this applied to the real world on a broader scale (we all know who I am talking about). >I would hope that's the way Jim took it too Absolutely. Dani is a respected friend and I always appreciate her viewpoint whether I agree or disagree with it. And I … What would you like to see in a business directory? Programming Web Development by FarrisFahad Hello webmasters, I am currently building a template that I am going to sell on different websites like Codester and CodeGrape. I want to build a business directory. Here is what I have come up with ... 1. users can register and add listings. 2. admin can create categories for users to select from. 3. admin can create sub categories if …