This project is about building a new Ai Assistant in Web App leveraging the power of Azure SQL Database, Ai Search Vector Index, Microsoft Fabric and Azure Web Apps. The Project uses a Custom Identity Database where users provide preferences over Books Genres.The system takes the preferences and creates embeddings in Azure OpenAI alongside with a Books Dataset and combines the preferences with the Books Dataset, for an interactive AI Experience. The Users can ask for recommendations, request specific details about Genres and Ratings and also interact in a normal chat converstation about literature with the AI Assistant, powered from OpenAI latest models.
- React Web Application: The frontend of our identity system is a user-friendly React web application. It includes:
- Sign Up and Sign In Features: Allows users to register and log into the system, providing a seamless authentication experience.
- User Dashboard: After logging in, users access a dashboard, where they can interact with Azure OpenAI for recommendations, ratings and genres and literature and books!
- API Endpoint: The backend is structured as an API endpoint handling the Sign Up and Login processes. It involves:
- Integration with Azure SQL Database: Our code interacts with Azure SQL Database to perform operations like inserting data and verifying user credentials.
- Azure AI Search Vector Index & Azure OpenAI Embeddings: Creates and configures Azure Ai Search Indexes with Vector Profiles and creates embeddings with Azure OpenAI.
- Relevant Queries: The system uses SQL queries to manage user data efficiently.
- Docker Containers: Both the frontend and backend components are containerized using Docker, ensuring consistency across different development and production environments.
- Azure Container Registry: The Docker images are pushed to Azure Container Registry, from where they are managed and deployed.
- Deployment on Azure Web Apps: The Docker images are then pulled and hosted on Azure Web Apps, providing a scalable and managed hosting environment.
- AI Powered recommendations Assistant
- Managed cloud-based SQL database for secure and scalable data handling.
- User-friendly React-based frontend interface for registration and login.
- Secure backend API for handling authentication processes.
- Docker containerization for consistent deployment and scalability.
- Integration with Azure services for robust and reliable application performance.
This Identity System project demonstrates a seamless integration of modern web technologies with Azure's cloud services. It showcases how Azure SQL and Azure Web Apps can be utilized to build and deploy a secure and scalable user authentication system, complete with a front-end user interface and a back-end API service.
Follow the Blog for Detailed Instructions: For step-by-step guidance, visit Azure AI Search: Nativity in Microsoft Fabric.
Additional help for the Identity : step-by-step guidance, visit Custom Identity Database with Azure SQL and Web Apps.
Contributions are welcome! If you have suggestions or improvements, feel free to fork the repository, make your changes, and submit a pull request.
We encourage contributions! If you have ideas on how to improve this application or want to report a bug, please feel free to open an issue or submit a pull request.
