Thank you very much as this was straight forward and well understood. So the superbase extension you used was for postgres db, are there other extensions for other databases like MySQL etc? Thank you and you just gained a sub 🎉
@@232techtalk Thank you! I’m not aware of popular extensions for other databases but I’ve seen a few GitHub repos attempting to build one but I’ve not really tried them to be able to recommend Btw it’s not a Supabase extension, it’s a Postgres extension, so you do not need Supabase. You just need Postgres DB instance: github.com/pgvector/pgvector
Thank you for the explanation. I'm new to SQL and have a question. I want to upload a file and ensure that each uploaded file is assigned a unique file ID, which will be associated with all the rows in that file's table. How can I achieve this?
There are a couple ways to achieve this, the straightforward way would be to use an autogenerated primary key column For example: CREATE TABLE file( id INT AUTO_INCREMENT PRIMARY KEY, file_path VARCHAR(255), ); So the Id in this case would be the unique file Id (primary keys are always unique), and file_path could maybe be a path to the file on s3 or whatever bucket. So basically anytime you insert a row into this table, a unique Id for that particular row is autogenerated by your SQL database. Hope that answers your question?
Have ANY questions? Drop them below ⬇️ ⬇️⬇️
One of the best videos on RAG implementation so far.
Clean implementation that's simple and easy to understand.
Thank you! Glad it was helpful 🙏🏾
Thank you for your video example and sources. I understood how to create a global recommendation for products.
That’s great to hear!
Thank you very much as this was straight forward and well understood. So the superbase extension you used was for postgres db, are there other extensions for other databases like MySQL etc? Thank you and you just gained a sub 🎉
@@232techtalk Thank you! I’m not aware of popular extensions for other databases but I’ve seen a few GitHub repos attempting to build one but I’ve not really tried them to be able to recommend
Btw it’s not a Supabase extension, it’s a Postgres extension, so you do not need Supabase. You just need Postgres DB instance:
github.com/pgvector/pgvector
This is great, thanks for sharing
Thank you!
Thanks for the video
You’re welcome!
Thank you for the explanation. I'm new to SQL and have a question. I want to upload a file and ensure that each uploaded file is assigned a unique file ID, which will be associated with all the rows in that file's table. How can I achieve this?
There are a couple ways to achieve this, the straightforward way would be to use an autogenerated primary key column
For example:
CREATE TABLE file(
id INT AUTO_INCREMENT PRIMARY KEY,
file_path VARCHAR(255),
);
So the Id in this case would be the unique file Id (primary keys are always unique), and file_path could maybe be a path to the file on s3 or whatever bucket. So basically anytime you insert a row into this table, a unique Id for that particular row is autogenerated by your SQL database.
Hope that answers your question?
@@thefisola it does, thanks for your time👐