v0.0.9-alpha

🎉 Happy Chinese Lunar New Year!

BREAKING CHANGE: PostgreSQL Integration, Faster Search, and More! 🚀

I've been hard at work improving Odoo Expert, and I'm thrilled to announce some major enhancements in this release:

🗃️ Switched from Supabase to PostgreSQL

• Odoo Expert now uses a PostgreSQL database directly for improved performance and flexibility
• I removed Supabase dependencies, simplifying the setup process
• PostgreSQL connection details are now configured via environment variables

🔍 Optimized Search with pgvector

• I leveraged the powerful pgvector extension for PostgreSQL to enable fast vector similarity search
• Optimized indexes were created on the odoo_docs table for snappy querying
• I implemented a search_odoo_docs function to efficiently find relevant documentation chunks

🏗️ Refactored Database Service

• I introduced a new DatabaseService class to manage all database interactions
• Connection pooling is now utilized for improved efficiency and scalability
• Retry logic was added to handle transient database connection issues gracefully

🩹 More Robust Error Handling

• I improved error handling throughout the codebase to provide more informative messages
• Logging of errors and stack traces was enhanced for easier debugging

🐳 Docker Compose Enhancements

• The docker-compose.yml file was updated to include the PostgreSQL service
• Health checks were added to ensure services are ready before starting the application
• I automated the initialization of the database schema on container startup

I'm excited about these improvements and believe they will make Odoo Expert even more powerful and reliable. Thank you for your continued support and feedback!

What's Changed

• ♻️ Replace supabase with pgvector by @MFYDev in #3

New Contributors

• @MFYDev made their first contribution in #3

Full Changelog: v0.0.8-alpha...v0.0.9-alpha