
Fechado
Publicado
Pago na entrega
Objective: Develop a standalone PostgreSQL database (chat_and_billing) and a Python/Node.js service layer on a Google Cloud e2-standard-4 (16GB RAM) environment. The system must prioritize context accuracy and semantic recall over token cost, utilizing pgvector and deep-context retrieval strategies. The service layer acts as the "intelligence hub" or middleware between the chat application and the (LLM) The system is multi-user. Use a REST API for message ingestion. Check for a single 'active' status in the Subscriptions table before allowing the RAG retrieval to execute. 1. Database Schema (PostgreSQL 17+ & pgvector) The freelancer will provide a .sql initialization script for: Table: Users id, email, stripe_customer_id, created_at. Table: Conversations id, user_id (FK), title, created_at. Table: Messages (Deep Memory) id, conversation_id (FK). role (Enum: 'User', 'Assistant'). content (Text, Not Null). embedding (Vector 1536) — Note: Index using HNSW (Hierarchical Navigable Small World) for high-speed, high-accuracy retrieval. timestamp (Timestamp). 2. Advanced Retrieval Requirements (Effectiveness Focus) The freelancer must implement a "Hybrid Context Engine" rather than a simple "Last 10" query: Full Thread Continuity: The logic must retrieve the entire active conversation history (up to 10k+ tokens) to ensure the LLM never loses the current thread's flow. Cross-Conversation Semantic Recall: Implement a query that searches the Messages table for the top 20 most semantically relevant snippets across all of that user's historical conversations (excluding the current one). Parent-Context Retrieval: If a relevant memory snippet is found, the system must automatically fetch the 2 messages preceding and 2 messages following it to provide the LLM with full context. Metadata Filtering: Enable filtering by date ranges and conversation titles so the LLM can resolve queries like "What did we discuss in the Genesis Study last January?" 3. Stripe Billing Integration Stripe UI will be integrated from this database you would be creating. The system is multi-user. Use a REST API for message ingestion. Check for a single 'active' status in the Subscriptions table before allowing the RAG retrieval to execute. Table: Subscriptions (Tracks status, plan_tier, and current_period_end). Webhook Handler: Provide logic for Stripe webhooks ([login to view URL]) to ensure the user’s "Pro" or "Unlimited" status is verified before executing deep-memory queries. 4. Deliverables (No Server Access Required) Full SQL Script: Schema creation, pgvector extension, and HNSW indexing for the embedding column. Context Assembly Logic: A service-layer function (Python/Node.js) that: Fetches 100% of the current chat thread. Performs a vector search for related past memories. Combines them into a single "Context Block" for the LLM. CRUD API Endpoints: Standard functions for creating conversations and appending messages. 5. Hardware Context for Freelancer Target Machine: Google Cloud e2-standard-4 (16GB RAM, 100GB SSD). Optimization: Ensure the PostgreSQL configuration is optimized for shared_buffers = 4GB and work_mem = 64MB to handle high-dimensional vector math in RAM. Phases: Phase 1: Database Schema & Setup (Deliverable: [login to view URL] file) The freelancer will provide a single, commented SQL script to set up the dedicated database on a PostgreSQL 17+ instance. Database Name: chat_and_billing Required Schema & Indexes: Table Name Column Name Data Type/Constraint Notes/Indexes Users id SERIAL PRIMARY KEY email VARCHAR(255) UNIQUE NOT NULL stripe_customer_id VARCHAR(255) UNIQUE Crucial for Stripe mapping Conversations id SERIAL PRIMARY KEY user_id INT REFERENCES Users(id) ON DELETE CASCADE Index on user_id title VARCHAR(255) Messages id SERIAL PRIMARY KEY conversation_id INT REFERENCES Conversations(id) ON DELETE CASCADE Index on conversation_id role VARCHAR(50) CHECK (...) ('User' or 'Assistant') content TEXT NOT NULL embedding Vector(1536) Required: Must create HNSW index for high performance. Subscriptions id SERIAL PRIMARY KEY user_id INT REFERENCES Users(id) ON DELETE CASCADE stripe_subscription_id VARCHAR(255) UNIQUE status VARCHAR(50) e.g., 'active', 'canceled' plan_tier VARCHAR(50) e.g., 'Pro', 'Basic' SQL Requirements: Include CREATE EXTENSION IF NOT EXISTS vector; Define the HNSW index creation for the [login to view URL] column: CREATE INDEX ON Messages USING HNSW(embedding vector_cosine_ops); Phase 2: Functional Logic & Service Layer (Deliverable: Documented Python/Node.js Logic Outline) The freelancer will provide clear pseudocode or a complete code module showing how to interact with the database using the specified advanced retrieval strategies. Required Functions/Modules: save_message(user_id, conversation_id, role, content, embedding): Handles message insertion and ensures the corresponding user and conversation exist. Implements Recursive Character Splitting for very long user inputs before generating embeddings. retrieve_context(user_id, conversation_id, current_query_embedding): Goal: Max Effectiveness. This function assembles the full context payload for the LLM. A. Current Thread Continuity: Fetches all messages belonging to the current conversation_id. B. Cross-Conversation Semantic Search: Executes a pgvector search against other conversations for the user's top 20 relevant snippets (using cosine similarity). C. Parent Document Retrieval: Logic to pull the 2 messages before and after each relevant snippet found in Step B. D. Reranking: Logic outline for using a Reranker API to select the final 10 most valuable snippets. handle_stripe_webhook(event_type, payload): Logic to process Stripe webhooks ([login to view URL], [login to view URL]) and update the Users and Subscriptions tables accurately. check_user_access(user_id): A simple function that checks the Subscriptions table status to verify a user is 'active' before granting access to premium RAG features. Phase 3: Environment & Constraints The freelancer must design the logic assuming the following target environment. No server access will be provided. Platform: Google Cloud Compute Engine Hardware: e2-standard-4 VM (16 GB RAM, 4 vCPUs, 100 GB SSD Persistent Disk) Database: PostgreSQL 17+ with pgvector extension enabled. Goal: Optimize SQL for performance on the 16 GB RAM limit (e.g., using HNSW indexes ensures vector operations leverage this RAM efficiently). Acceptance Criteria Project success is defined by: A complete, runnable SQL script ([login to view URL]). Clear code or pseudocode that demonstrates all required logic points in Phase 2. Confirmation that the retrieval logic prioritizes the full current conversation history over arbitrary limits like "last 10 messages". Code: Table: Conversations id (Primary Key) user_id (Foreign Key to your User table) title (e.g., "Genesis Study - Jan 18") created_at Table: Messages id conversation_id (Foreign Key) role (User or Assistant) content (The text) timestamp
ID do Projeto: 40165235
110 propostas
Projeto remoto
Ativo há 24 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
110 freelancers estão ofertando em média $142 USD for esse trabalho

Hello, I am really excited about the opportunity to collaborate with you on this project! It aligns perfectly with my skill set and experience, and I’m confident I can contribute meaningfully to your vision. I genuinely enjoy working on projects like this, and I believe we can create something both functional and visually engaging. Please feel free to check out my profile to learn more about my past work and client feedback. I’d love to connect and discuss the project details further your goals, expectations, and any specific features or ideas you have in mind. The more I understand your vision, the better I can bring it to life. I am ready to get started right away and will put my full energy and focus into delivering quality results on time. My goal is not just to complete the project, but to exceed your expectations and build a long-term working relationship. Looking forward to hearing from you soon! With regards! Nikhil
$250 USD em 7 dias
6,9
6,9

Hello, With a wealth of experience in database development, I'm confident in my ability to deliver the exact PostgreSQL system you need for your High-Fidelity RAG Memory & Stripe Integration project. Not only can I create the necessary database schema and indexes, but I can also optimize the PostgreSQL configuration for your specific hardware context on Google Cloud's e2-standard-4 instance with 16GB RAM and 100GB SSD. In addition to these technical skills, my team at Our Software values both accuracy and user experience. We fully understand the project's key objective is prioritizing context accuracy and semantic recall. Therefore, we are prepared to utilize effective strategies like pgvector and deep-context retrieval to enhance your PostgreSQL database's performance. Moreover, I have a solid knowledge of Python/Node.js that you require for your service layer on Google Cloud environment. Not only can I provide efficient CRUD API Endpoints for creating conversations and appending messages as the deliverables demand, but I can also develop a service-layer function that retrieves the entire active conversation history with a hybrid context engine for optimum system performance. With my skills and creative problem-solving abilities, I am confident that I can successfully meet all aspects of this project's requirements to ensure seamless chat message storage and retrieval while integrating with Stripe billing system effectively. Thanks!
$130 USD em 2 dias
6,2
6,2

As the CEO of Web Crest, a celebrated team of 10 experts in AI and automation, I bring forth impeccable skills in API development, Node.js, NoSQL Couch, Mongo, Python to cater to your needs. With a decade-long experience in delivering top-tier AI solutions and digital branding, we have a proven track record with a 98% project completion rate. Our client-centric approach ensures transparent communication and tailored solutions. In line with your requirements for this project, I have deep hands-on knowledge of PostgreSQL 17+, pgvector, and utilizing pgvector & deep-context retrieval strategies for exceptional results. Handling your hardware context specifically targeting Google Cloud e2-standard-4 with optimized PostgreSQL configuration (shared_buffers = 4GB & work_mem = 64MB) is part of our expertise to ensure everything functions smoothly. Furthermore, ApiController in Node.js or Python would efficiently manage Stripe Billing Integration using relevant webhooks. Creating an advanced Hybrid Context Engine that retrieves entire active conversation history with multiple other complex queries is something we excel at. Lastly, the Sql script and the full schema setup will be handled single-handedly as needed. My team's goal is to provide you with high-fidelity memory storage and advanced query abilities; we're ready to leverage our skills to guarantee optimal results for your project.
$100 USD em 3 dias
6,5
6,5

Hi there,Good morning I am Talha. I have read you project details i saw you need help with Python, Database Development, Cloud Computing, Node.js, PostgreSQL, Elasticsearch, Stripe, NoSQL Couch & Mongo, API Development and Database Management I am pleased to present my proposal, highlighting our extensive experience and proven track record in delivering exceptional results. Our portfolio of success will showcase past projects that demonstrate our ability to meet and exceed client expectations. Glowing testimonials from satisfied clients will attest to our professionalism, dedication, and the quality of our work Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Thanks Regards. Talha Ramzan
$30 USD em 12 dias
5,5
5,5

Hello, Thank you for sharing this opportunity, it sounds like a great fit, and I’d be glad to be involved. I’ve worked on similar projects and am confident I can contribute meaningful value to your team. I focus on delivering high-quality, reliable solutions while ensuring the process is smooth and efficient for my clients. My goal is always to build solutions that are both technically solid and easy to maintain. You’re welcome to review my profile to see examples of my previous work. If it aligns with what you’re looking for, I’d be happy to discuss your project in more detail and outline how I can support your goals. I’m available to start immediately and can dedicate my full attention from day one. Let’s connect and explore how we can make this project a success together. Looking forward to your response. With Regards! Abhishek Saini
$250 USD em 7 dias
5,5
5,5

I have over 5 years of experience in web development, with expertise in Node.js, React, PHP, Excel automation, and accounting software. I am confident in developing a PostgreSQL database and Python/Node.js service layer on a Google Cloud environment. I will prioritize context accuracy and semantic recall using pgvector and deep-context strategies, ensuring efficient message retrieval and chat application interactions. My previous projects align with the advanced retrieval and billing integration requirements, making me the ideal candidate for this job. Let me handle the database setup, service logic, and hardware optimization to deliver outstanding results on time and within budget.
$116 USD em 7 dias
5,6
5,6

Hello, I’m excited about the opportunity to develop the chat_and_billing system on PostgreSQL, leveraging advanced retrieval strategies and ensuring smooth integration with Stripe for billing. With experience in Python, Node.js, and cloud computing, I can build the full backend architecture, including database schema, efficient vector-based retrieval, and seamless API integration. I’ll work closely with you to ensure the system’s ability to track user subscriptions via Stripe, while providing real-time, semantic memory retrieval for enhanced AI interactions. My goal is to ensure the database and service layer are scalable and optimized for high performance in the Google Cloud environment, with a focus on context accuracy and seamless user experience. Let’s discuss the timeline and next steps to bring this project to life! Best regards, Juan
$140 USD em 1 dia
5,6
5,6

⚠️You are not looking for a coder. You are looking for someone who can build this properly. That is exactly why your project stood out.⚠️ Your goal to build a standalone PostgreSQL database leveraging pgvector and deep-context retrieval for a multi-user chat and billing system on a Google Cloud e2-standard-4 instance indicates a focus on scalable, contextually precise, and semantic-rich interactions. This requires a hybrid context engine that integrates full conversation continuity, cross-thread semantic recall, and metadata filtering in a seamless, efficient service layer. At DigitaSyndicate, a UK-based digital systems agency, we build precision-engineered automation, modern web platforms, and AI-driven systems designed for performance and long-term scalability. Our expertise with pgvector, HNSW indexing, and REST API middleware aligns perfectly with your demands for accurate context assembly and Stripe billing integration on PostgreSQL 17+. Having delivered complex vector search and subscription-verified RAG systems, I am positioned to craft your schema and service logic. Can you share your main priorities and timeline so I can map out the right execution plan for you? Casper M. Project Lead | DigitaSyndicate Precision-Built Digital Systems.
$200 USD em 14 dias
5,4
5,4

Hello, I understand you’re looking to develop a PostgreSQL database along with a Python/Node.js service on Google Cloud, focusing on advanced memory recall and Stripe integration. This project is intricate, but I have successfully completed similar tasks that required high-accuracy context management and deep memory retrieval. In a previous project, I designed a database solution with pgvector that handled complex query requirements similar to yours, ensuring seamless semantic interaction. The outcome? A high-performance application that delivered contextually relevant data with quick response times. ✅My Plan: - Provide a detailed .sql script to set up your database schema, including HNSW indexing. - Develop a service layer in Python/Node.js to manage chat and retrieval logic. - Implement advanced retrieval strategies for full conversation continuity and cross-conversation recall. - Ensure Stripe integration is smooth and reliable. Best regards, Hongqiang Chen
$230 USD em 2 dias
5,0
5,0

Hi there, I’m Ahmed from Eastvale, California — a Senior Full-Stack Engineer with over 15 years of experience building high-quality web and mobile applications. After reviewing your job posting, I’m confident that my background and skill set make me an excellent fit for your project — High-Fidelity RAG Memory & Stripe Integration (PostgreSQL/2026 Standards) -- 2 . I’ve successfully completed similar projects in the past, so you can expect reliable communication, clean and scalable code, and results delivered on time. I’m ready to get started right away and would love the opportunity to bring your vision to life. Looking forward to working with you. Best regards, Ahmed Hassan
$120 USD em 2 dias
5,0
5,0

Dear Mary C., I am a skilled freelancer with expertise in Python, Node.js, PostgreSQL, and database development. I have successfully completed projects involving cloud computing, NoSQL databases, and API development. I have reviewed your requirements for developing a high-fidelity PostgreSQL database with Stripe integration on Google Cloud. My approach involves creating a robust database schema, implementing advanced retrieval strategies for context accuracy, and integrating seamless Stripe billing functionalities. I will ensure efficient query processing and reliable webhook handling for user subscriptions. I guarantee timely delivery of a fully functional system and will maintain clear communication throughout the project. I am excited about the opportunity to discuss your project further and provide a tailored solution. Looking forward to collaborating with you. Best regards,
$30 USD em 7 dias
5,2
5,2

Hello! I can help you build the PostgreSQL database and service layer for your RAG memory and Stripe integration project. Here’s the plan: Phase 1: Database Schema Setup - Provide an SQL script to create the Users, Conversations, Messages, and Subscriptions tables with proper relationships and indexes (including pgvector for embedding and HNSW for fast retrieval). Phase 2: Functional Logic - Implement functions like save_message() to handle message insertion and embedding. - Develop the retrieve_context() function to assemble full conversation context, perform semantic search, and retrieve relevant past messages. - Integrate Stripe webhooks to manage subscriptions and verify access before executing deep-memory queries. Phase 3: Optimization - Optimize PostgreSQL for efficient vector operations, ensuring smooth performance on Google Cloud's e2-standard-4 instance with 16GB RAM. Deliverables: - SQL script for schema and indexes. - Python/Node.js functions for message handling, context retrieval, and Stripe integration. - Clear documentation with pseudocode or code and setup instructions. I have experience with PostgreSQL, AI memory systems, and Stripe integration and can deliver within your timeline. Warm regards, Yulius Mayoru
$50 USD em 2 dias
5,2
5,2

Hello, We understand your need for a robust, standalone PostgreSQL database integrated with context-driven retrieval strategies and Stripe billing capabilities, all deployed on a Google Cloud environment. Our expertise aligns perfectly with your project requirements, particularly in implementing deep memory mechanisms and hybrid context engines critical to maintaining conversation continuity. At A2 Design, we have successfully developed scalable solutions across various industries, such as MadPaws, where we built an on-demand marketplace ensuring seamless user experiences, and TutorTime, a platform that enhances educational interactions through smart matching and real-time communication features. Each project showcases our ability to handle complex data interactions and deliver optimized solutions. We are excited to explore how we can bring your vision to fruition. Let’s connect to discuss the next steps!
$100 USD em 1 dia
4,8
4,8

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$240 USD em 3 dias
5,6
5,6

Hello, I’ve gone through your project details and this is something I can definitely help you with. I have over 10 years of experience in mobile and web app development, focusing on SQL databases, Python, and Node.js. My approach emphasizes clean architecture and scalability, ensuring the system meets both your functional and performance requirements. I’ll develop a PostgreSQL database with a robust schema for the chat and billing system, ensuring it supports advanced retrieval strategies using pgvector and HNSW indexing for high-speed performance. Additionally, integrating Stripe for billing and verifying subscription status before RAG retrieval is crucial for seamless user experience. Here is my portfolio: https://www.freelancer.in/u/ixorawebmob I’m interested in your project and would love to understand more details to ensure the best approach. Could you clarify: 1️⃣ Do you need this for a specific deployment or just the development? 2️⃣ Are there any existing systems that need to be integrated? 3️⃣ What is your timeline for delivery? 4️⃣ Are there any specific user insights or analytics you are looking for from this integration? Let’s discuss over chat! Regards, Arpit Jaiswal
$155 USD em 5 dias
4,8
4,8

Hi there, I'm thrilled to propose my expertise for your High-Fidelity RAG Memory & Stripe Integration project. With extensive experience in PostgreSQL database development and Python/Node.js services, I aim to craft a robust system prioritizing context accuracy and semantic recall. I will meticulously design the database schema, implement advanced retrieval strategies, integrate Stripe billing, and deliver optimized SQL scripts and service-layer functions in line with your hardware requirements. What's the best way to proceed with setting up a discussion?
$100 USD em 2 dias
4,6
4,6

⭐️⭐️⭐️⭐️⭐️ Hello! I am excited about the opportunity to develop your PostgreSQL database (chat_and_billing) along with the Python/Node.js service layer. With extensive experience in PostgreSQL, pgvector, and REST API design, I’m confident in delivering a robust and scalable solution tailored to your requirements. My approach will ensure that context accuracy and semantic recall are prioritized, utilizing advanced retrieval strategies to maintain conversation continuity. I will provide a detailed SQL script for the database schema, ensuring optimal configuration for your Google Cloud environment. I am committed to client satisfaction and will keep you updated throughout the process. My focus will be on creating a seamless user experience, especially with the Stripe billing integration. Let’s discuss your project further to ensure I fully understand your vision and how I can bring it to life! Best, Abudulhamid
$100 USD em 1 dia
4,7
4,7

Hi Mary, I have over 5+ years of experience in both frontend and backend development. I will do the specified tasks. Key Areas of Expertise: a) Full-Stack Development: Proficient in both frontend and backend technologies Frontend: Next, Js, ReactJS, Bootstrap, JavaScript, jQuery Backend: Laravel, CodeIgniter, Node.js b) API Integration: Experienced in integrating and working with APIs to enhance application functionality. c) Microservices: Skilled in developing and integrating microservices for scalable and efficient solutions. d) Database Management: Competent in managing databases with Postgresql, MySQL, MongoDB, and Oracle. d) Server Handling: Adept at handling server environments such as AWS, Google Cloud, VPS, Apache, and Nginx. Let’s discuss how I can help achieve your project goals and add value. Lets connect in chat so that We discuss further. With Regards, Sai
$130 USD em 5 dias
4,6
4,6

⚠️ If you’re not happy, you don’t pay ⚠️ Hello, As a Senior Web Developer, I guarantee delivery excellence based on a track record of successful projects like yours. For the task of developing a PostgreSQL database (chat_and_billing) and Python/Node.js service layer on a Google Cloud e2-standard-4 environment, here's a concise outline: 1. Database Schema & Setup: - Tables: Users, Conversations, Messages (with deep memory storage using pgvector) - Key Features: HNSW indexing for high-speed retrieval efficiency - Subscriptions Table for Stripe billing integration 2. Advanced Retrieval Strategy: - Hybrid Context Engine for in-depth semantic recall - Full thread continuity, cross-conversation search, parent-context retrieval, metadata filtering 3. Deliverables: - Full SQL setup script - Context assembly logic - CRUD API endpoints One technical clarification: Are there any specific requirements for date range filtering in message retrieval? Best regards, Piyush Gupta Senior Web Developer | PostgreSQL Expert
$150 USD em 2 dias
4,4
4,4

Hello, Hi! I'm Kateryna and I want to bring my solid engineering experience, focus on data-heavy apps, and strong skills in API development, Node.js, and Python to your High-Fidelity RAG Memory & Stripe Integration Project. Over the past eight years, I've successfully built several production web platforms and blockchain systems. My deep understanding of Ethereum, L2 rollups, React and Node stacks is a perfect fit for your project's context retrieval and PostgreSQL setup needs. For Phase 1 of our project, my task will be to create the database schema for PostgreSQL 17+ using pgvector extension. My previous roles required me to design and maintain complex databases at scale which honed my skills in table design and structuring complex queries. Creating the HNSW index for the embedding column will be an effective measure that I am adept at implementing. Phase 2 of our collaboration will see me develop highly efficient and effective functional logic in Python/Node.js ensuring optimum performance given the project's high dimensional vector math requirement. Having owned delivery across a range of projects from start to finish, I can confidently assure you dependable code quality delivered on time with attention paid to CI/CD integration for maintainable codebases. With such a large dataset involved, my comprehensive understanding of Google cloud environments will allow for proper optimization of PostgreSQL configuration within availabl Thanks!
$30 USD em 2 dias
3,9
3,9

Sparta, United States
Método de pagamento verificado
Membro desde abr. 8, 2013
$10-30 USD
$30 USD
$10-30 USD
$250-750 USD
$10-80 USD
₹600-1500 INR
₹600-1500 INR
£20-250 GBP
$10-30 USD
$15-25 USD / hora
$10-30 USD
₹12500-37500 INR
₹1500-15000 INR
€3000-5000 EUR
$10-20 CAD
€18-36 EUR / hora
€30-250 EUR
₹12500-37500 INR
$2-8 USD / hora
$250-750 USD
£250-750 GBP
₹37500-75000 INR
$200-500 USD
$30-250 USD
$2-8 USD / hora