in Industry

How to integrate OpenAI GPT3 with a Databases – Crash Course

1.8k Views 40 Comments



Databases can be connected to an AI through an API. In this tutorial, I’ll show the practical uses of creating a simple connection from OpenAI to a new Database built on Singlestore.

00:00 – Introduction
01:00 – Project Plan
01:32 – Accessing Youtube API
01:59 – Connecting to the Youtube API
03:07 – Retrieving Comments from Youtubes API
04:16 – Setting up a Database on SingleStore
05:01 – Connecting to the Database via API
05:50 – Creating Database Tables and Structures
06:34 – Inserting Row to Database
07:31 – Populating Database with Youtube Comments
09:36 – Connect to OpenAI API
11:09 – Connect Database to GPT3
14:05 – Using GPT AI to Analyse and Update Database
16:29 – Conclusion

⭐ New – Teach Me OpenAI Digital Book ⭐

I’ve put together a easy to understand book with ~60 pages about OpenAI and GPT with how to get started to integrate it into projects, code examples, and much more!

SingleStore: (also today’s sponsor)
Unified data engine for transactional and analytical workloads.
https://www.singlestore.com/cloud-trial/?utm_campaign=adrian-twarog&utm_medium=video&utm_source=youtube

OpenAI:
Creator of ChatGPT, Open AI creates models like davinci, ada, and chat gpt and can be accessed via their APIs.
https://openai.com/

Learn Design for Developers!
A book I’ve created to help you improve the look of your apps and websites.
📘 Enhance UI: https://www.enhanceui.com/

Feel free to follow me on:
🐦 Twitter: https://twitter.com/intent/follow?screen_name=adrian_twarog
💬 Discord: https://discord.gg/6gmmFvxkD7
💸 Patreon: https://www.patreon.com/adriantwarog

Software & Discounts:
🚾 Webflow: https://webflow.grsm.io/adrian
🌿 Envato: https://1.envato.market/yRZjz2
🌿 Envato Elements: https://1.envato.market/LP0OJZ
🔴 Elementor: https://elementor.com/adrian/?ref=23140
✖ Editor X: https://www.editorx.com/adrian-twarog

Computer Gear:
⬛ Monitor: https://amzn.to/3f9DOQI
⌨ Keyboard: https://amzn.to/3eA5UFD
🐁 Mouse: https://amzn.to/3xVJO8l
🎤 Mic: https://amzn.to/3hgCfms
📱 Tablet: https://amzn.to/3ewt7sa
💡 Lighting: https://amzn.to/3vOZeZY
💡 Key Lighting: https://amzn.to/3f6qP2f

Camera Equipment:
📷 Camera: https://amzn.to/3uCv4J9
📸 Primary Lens: https://amzn.to/3vT6wMm
📸 Secondary Lens: https://amzn.to/3tyqWIX
🎥 Secondary Camera: https://amzn.to/3o2zCGi
🎙 Camera Mic: https://amzn.to/33tCz9l
🎞 USB to HDMI: https://amzn.to/33yW9RE

Share this:

40 Comments

  2. First time finding your channel, man you are AWESOME! Love the style, the speed and the clarity of your videos, and especially appreciate you putting this stuff on GH for us to review.. Easy sub here.

  4. Please rename your title. This is not having gpt connected to the database at all. This is just pulling data from database and then feeding it to gpt as prompts.

  7. This is a nice example that does not require Chat GPT unverified plugins.

    I wanted to play around with a 😭 and burned a bunch of time looking into all of these vector solutions, only to find out I don't even have the ability to add them

  8. The code you wrote at 15:09 is prone to SQL injection. It would actually be quite fun to see if it was possible to exploit it by combining a propt injection attack with a SQLi attack…

  12. I was thinking in this when AI appears in news because there are a lot of similar comments that chatgtp can resume in a same comment or classify in specific topic, this will evolve the way to see comments in future.

  13. I only see value in doing this database, if there were millions of comments that needed to be cached and maybe some other analysis done after on the same DB, like querying the DB to figure out which users asked the most questions. Also, while technically the DB was connected to an AI, in essence the AI was only used to process some text and set a boolean value. I think a better title would have been "How to process natural language and save the results to a DB". Thoughts?

  22. So beautiful to watch this in action.
    Every time I see use cases like this, I can't help but think how many people in the non-IT world are clueless about the impact of this technology.
    Keeps blowing my mind every day.

  35. Can you employ me to shifter all your comments and help delete the spam like comments. I have plenty of time and I have a team trained and dedicated to doing this.

    I promise you it's pocket friendly and you'll get the best value you can. Good thing is that you don't have to commit financially until after the first 30 days.

    I'm looking forward to hearing from you and working with you. Thank you.

  38. What about using GPT-3/4 to give you a response based on previous multiple responses without hallucinations from just fine-tuning, and maybe even ask some questions if needed…
    For example, User input: Which route do I take to go to the bank? Context answer 1: If you're on foot take x route, A2: Take route Y by car, Chatbot reply: How are you planning to go there, by foot or driving? and so on…
    Do you have a video on how to do this? Is it even possible?

  39. Uhm, yeah. We all need a highly scalable Enterprise level Cloud DB for our personal YouTube comments. Or, you can find a simple, free way of doing this in the same, Google eco space via something like the Google Sheets API. Oops, that won't pay the influencer bills though…