Odoo-MariaDB Custom Query Connector
Budget: $15 – $25 USD
I need a dedicated MariaDB connector that plugs seamlessly into Odoo and lets my power users run advanced SQL, not just simple SELECT statements. The connector’s sole focus is Custom Queries, so no data-migration wizards or real-time sync layers are required.
To be accepted the module must execute, through Odoo, all of the following:
• Complex joins that span multiple tables
• Stored procedures (callable with parameters)
• Aggregate functions—SUM, COUNT, GROUP BY, HAVING, and similar
Permissions and UI should be tailored for power-user profiles: enough flexibility to iterate quickly, yet shielded so regular users can’t fire off arbitrary statements.
Deliverables
• An installable Odoo module that exposes the connector
• Clear Python code that follows Odoo guidelines and uses a reliable MariaDB driver
• Inline docstrings plus a short README covering setup and sample queries
• Basic unit tests proving the three query categories above work as advertised
If you have prior experience wiring external databases into Odoo or optimizing MariaDB queries, tell me how you approached it and roughly how long this build would take you.
To be accepted the module must execute, through Odoo, all of the following:
• Complex joins that span multiple tables
• Stored procedures (callable with parameters)
• Aggregate functions—SUM, COUNT, GROUP BY, HAVING, and similar
Permissions and UI should be tailored for power-user profiles: enough flexibility to iterate quickly, yet shielded so regular users can’t fire off arbitrary statements.
Deliverables
• An installable Odoo module that exposes the connector
• Clear Python code that follows Odoo guidelines and uses a reliable MariaDB driver
• Inline docstrings plus a short README covering setup and sample queries
• Basic unit tests proving the three query categories above work as advertised
If you have prior experience wiring external databases into Odoo or optimizing MariaDB queries, tell me how you approached it and roughly how long this build would take you.