Retrieval Augmented Generation with Hugging Face Models in LangChain Programming Computer Science by usmanmalik57 In my [previous articles](https://www.daniweb.com/programming/computer-science/tutorials/541732/paris-olympics-ticket-information-chatbot-with-memory-using-langchain), I explained how to develop customized chatbots using Retrieval Augmented Generation (RAG) approach in [LangChain](https://www.langchain.com/). However, I used proprietary models such… 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 … Question Answering with YouTube Videos Using RAG in LangChain Programming Computer Science by usmanmalik57 In previous articles, I explained how to use natural language to interact with [PDF documents](https://www.daniweb.com/programming/computer-science/tutorials/541732/paris-olympics-ticket-information-chatbot-with-memory-using-langchain) and [SQL databases](https://www.daniweb.com/programming/computer-science/tutorials/541771/using-natural-language-… Re: Improve HAVING BY performance Programming Databases by Biiim > I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do SELECT sum(points) AS total FROM ... HAVING total > 10. Is that what you were getting at? Kind of, MariaDB is a fork of MySQL from around 2009 or something like that, MySQL 5.* and the creator continued developing MariaDB and Oracle took … Re: Improve HAVING BY performance Programming Databases by Dani > I know that in my experience, OR's are very bad for speed you can get away with a few but they can get very bad when they stop the whole query making use of one of the main indexes, you can actually speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of that, but it totally makes sense!! > … Re: Improve HAVING BY performance Programming Databases by Dani I'm too exhausted for an in depth explanation right now but 90% of web development is optimizing for performance. The average DaniWeb page takes anywhere from 80ms up to 250ms to load the HTML (when dealing with low network latency), depending on the type of page, so shaving 50ms off of that is a huge win. Re: Improve HAVING BY performance Programming Databases by Dani > Point #2 would apply if the improvement was noticible but I doubt anyone could seriously comment, "I think this page rendered 50ms faster than it used to", especially considering all the other things that affect timing, for example, the current loading on my ISP servers, anything else running on my computer or home network, etc. … Re: Improve HAVING BY performance Programming Databases by Biiim > INSERT INTO electronics.products(ProductID, ProductName, Price) VALUES ('1','capacitors', 2.50), ('2','resistors', 4.50), ('3','rectifiers', 7.50), ('4','diodes', 10.00), ('5','ICs', 25.00), ... ('50000','...', ...); I don't see any mention of an index on it & your benchmark indicates you don't have one: ALTER TABLE `… Re: sequential file save read option button Programming Software Development by rproffitt 1. With so few having VB6 now, you need to move to a current release. Help will be hard to find. 2. I can't load up your project. Few others can so by not posting the relevant code in the clear with your assessment, you see the issue? 3. VB6, while I coded very large projects long ago, "It's Dead Jim." That is, you're on a deserted … Re: How to Code a Load More Button? Digital Media Digital Marketing Search Engine Strategies by MarkMarketer Creating a "Load More" button is a common feature when it comes to handling large data sets. The idea is to load a small amount of data initially and then load more data as the user requests it. This can be done with a combination of HTML, CSS, and JavaScript. This guide will take you through creating a simple "Load More" … Re: How to Code a Load More Button? Digital Media Digital Marketing Search Engine Strategies by Dani Hello there! Firstly, so sorry for taking so long to respond to this thread. I was actually away at an SEO conference (I'm going to write a post about it in the next handful of days, and, yes, I'm mildly feeling a bit better). That being said, what you're asking for is definitely doable, because we are doing the exact thing here at DaniWeb. … How to Code a Load More Button? Digital Media Digital Marketing Search Engine Strategies by FarrisFahad I want to write an SEO load more button that Google crawls and click on. I have read somewhere in the documents that Google will only click on anchor tags with href value. My current website loads content using a button and I have noticed after changing some, not load more, links Google started to index my website. Is there a best practice … Retrieval Augmented Generation (RAG) with Google Gemma From HuggingFace Programming Computer Science by usmanmalik57 In a previous article, I explained [how to fine-tune Google's Gemma model for text classification](https://www.daniweb.com/programming/computer-science/tutorials/541544/fine-tuning-google-gemma-model-for-text-classification-in-python). In this article, I will explain how you can improve performance of a pretrained large language model (LLM) using … Re: DomContentLoaded vs jQuery Ready fn Programming Web Development by jkon Of course I agree with toneewa and pritaeas but because it is an intresting topic I thought to share some thoughts to it. Given the fact that I load jQuery (in one minified file that contains also every JavaScript that this part of the app requires) I load it dynamically after DOMContentLoaded or onLoad in older browsers. e.g.: var … AI-powered Code Reviews: The Future of Collaborative Development Programming by SEO_935 AI-powered code reviews are bringing about a revolution in the way developers collaborate, enabling more efficient, accurate, and thorough evaluations of code prior to its integration into the central project repository. This transformation is made possible by leveraging machine learning and artificial intelligence to automate and enhance different… How Do I address ERROR: access violation writing 0x0000000000005140, Programming Web Development by A_957 The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation exception that occurred within my application. This type of error apparently usually points to a problem where the code attempted to write to a protected … 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 … DomContentLoaded vs jQuery Ready fn Programming Web Development by Dani I think that I understand the difference between: document.addEventListener('DOMContentLoaded', callback_fn); and: window.addEventListener('load', (event) => { ... }); However, as a jQuery user, what is the difference between DOMContentLoaded and the jQuery ready fn? Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Dani Hello, Google Search Console is showing that vidceo is not the main content of the page, because I don't see any video on [this page](https://www.kupisi.mk/product/index.php?mainCategory=%D0%B7%D0%B0-%D0%B4%D0%BE%D0%BC%D0%B0&productName=%D1%83%D0%BD%D0%B8%D0%B2%D0%B5%D1%80%D0%B7%D0%B0%D0%BB%D0%BD%D0%BE-%D0%BF%D0%B0%D0%BC%D0%B5%D1%82%D0%BD%D0… Re: how convert cur images to image? Programming Software Development by Reverend Jim Why not just load it into paint.exe then save as whatever format you want? Or you could download [ffmpeg](https://ffmpeg.org/) (free) and do ffmpeg -i myfile.ico myfile.jpg (or whatever format you want) ffmpeg can also be used to convert video between any formats. Also subtitle files. ffmpeg is a portable app (no installation required)… 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: Htaccess Problem Url Friendly Programming Web Development by Dani I suppose I’m not properly understanding your question. Do you mean when you go to the URL in your browser localhost/mysite/readlex.php?slug=Le-mura-di-Lucca it doesn’t load, but when you go to the rewritten URL it works fine? Re: Htaccess Problem Url Friendly Programming Web Development by Adolfo_1 NO! I meant that URL loads but not friendly I have to put these STATIC URLs inside the text retrieved from the database as I cannot insert php strings. Example from database example that htaccess makes unfriendly : <em><a href="../read-lex.php?slug=Provvedimento-di-sospensione-Trib-Cagliari">Vedi &nbsp;SENTENZA&… Re: Fine-Tuning OpenAI Whisper Model for Audio Classification in PyTorch Programming Computer Science by habi_2 how to use the best_model.pt Re: SiteShow -- Create a slideshow of web pages Programming Web Development by PROSYS_1 wow.. its working fine... very useful for me to complete my task.. thanks Re: Overcoming the Top 5 Email Marketing Challenges in 2023 Digital Media Digital Marketing by bessieexum To overcome the main email marketing challenges in 2023, focus on improving inbox placement, increasing engagement, effective data management and creating distinct content to cut through the noise - including new trends such as AI and data privacy considerations. Success comes through crafting personalized and relevant messages while adhering to … Re: How Do I address ERROR: access violation writing 0x0000000000005140, Programming Web Development by rproffitt Python shouldn't create such an error. Reference https://www.reddit.com/r/learnpython/comments/kv83hc/error_code_exception_access_violation_writing_0x0/ I can't duplicate your issue but if this was mine I'd place a logging command in my python script at each step so I could nail down which line of code threw the error. Tutorial on that at … Re: How Do I address ERROR: access violation writing 0x0000000000005140, Programming Web Development by Dani I don't have any python experience, sadly, but I am super awesome at jQuery. Once you solve this server-side problem at hand, if you find yourself with the jQ side of things not working, please don't hesitate to post. Re: DomContentLoaded vs jQuery Ready fn Programming Web Development by toneewa jQuery's ready() works asynchronously, even if the DOM is already ready, which keeps your code running consistently. jQuery simulates the non-existent DOMContentLoaded event on obsolete browsers like Internet Explorer, using deferred execution, that fires later than the real event in other browsers, making sure it doesn't run too early. … Re: DomContentLoaded vs jQuery Ready fn Programming Web Development by pritaeas > However, as a jQuery user, what is the difference between DOMContentLoaded and the jQuery ready fn? No difference really, although some sources state that the ready function might fire "a little" later (because it is wrapper code).