Architectural Revolution in Dolibarr ERP
Complete transformation of Dolibarr from a traditional PHP system to a pure client/server model where all business logic resides in PostgreSQL through triggers and functions, converting PHP into a simple presentation client.
Pure Client/Server Model
ALL logic in PostgreSQL, PHP as dumb client
Zero MySQL Compatibility
PostgreSQL exclusive system, no compromises
100% Test Coverage
1,477 unit tests + rigorous comparative tests
Architectural Transformation
β Original Dolibarr
- Business logic scattered in PHP
- Validations in application code
- Calculations performed in PHP
- Code generation in application
- MySQL/PostgreSQL compatibility
- Inconsistencies between installations
β Client/Server Model
- Logic centralized in PostgreSQL
- Automatic validations by triggers
- Calculations guaranteed in the DB
- Codes generated automatically
- Optimized exclusive PostgreSQL
- Consistency always guaranteed
Migrated Modules
Societe
CompletedThird party management with automatic validations, unique codes and synchronization.
Product
CompletedProducts and services with automatic price and history management.
User
CompletedUsers with unique login/email validations and permission management.
Banque
CompletedBank accounts with automatic IBAN/BIC validations and complete transaction management.
Tax
CompletedLocal taxes with automatic calculations and validations.
Propale
CompletedQuotes with automatic reference generation and calculations.
Categories
CompletedCategories with hierarchical management and automatic relationships.
Don
CompletedDonations with personal data validations and state flow.
Contact
CompletedContacts with automatic synchronization and dependency validations.
Commande
CompletedOrders with automatic reference generation and total calculations.
Facture
CompletedInvoices with automatic reference generation, total calculations and recurring billing.
Stock
CompletedStock management with automatic movements and inventory control.
Bookkeeping
CompletedDouble-entry bookkeeping with automatic entries and validations.
ExpenseReport
CompletedExpense reports with automatic validations and total calculations.
FournisseurCommande
CompletedSupplier orders with automatic state and reference management.
Expeditions
CompletedShipments with stock control and shipping tracking.
Contracts
CompletedContracts and subscriptions with automatic date and state management.
Partnership
CompletedPartnership management with simple state control.
Interventions
CompletedInterventions with state management, lines and time tracking.
Tickets
CompletedTicket system with complex flows, categories and notifications.
SupplierProposal
CompletedSupplier proposals with complex price management.
Receptions
CompletedReceptions with stock movements and batch tracking.
MassEmails
CompletedMass emails with target selection and delivery tracking.
Members
CompletedMembers with types, subscriptions and complex state management.
Holiday
CompletedHoliday management with approval flows and balance calculations.
Salaries
CompletedSalaries with payroll calculations and bank integration.
Recruitment
CompletedRecruitment with positions, candidacies and evaluation process.
HRM
CompletedHRM with evaluations, skill management and job definitions.
Attendance
CompletedAttendance with time tracking, validations and reports.
Projects
CompletedProjects with tasks, resource management and progress tracking.
Events
CompletedEvents and agenda with calendar integration and reminders.
Resources
CompletedResource management with reservations and availability.
EventOrganization
CompletedEvent organization with conference and attendee management.
ProductBatch
CompletedProduct batches with traceability and expiry management.
ProductVariants
CompletedProduct variants with attributes and dynamic combinations.
BOM
CompletedBills of materials with hierarchical structure and calculated costs.
MRP
CompletedResource planning with manufacturing and production orders.
Workstation
CompletedWorkstations with capacity and resource planning.
Margins
CompletedMargins with automatic profitability calculations and analysis.
Loan
CompletedLoans with payment schedule and interest calculation.
BankTransfer
CompletedBank transfers and direct debits with batch management.
SimpleAccounting
CompletedSimple accounting with basic reports and invoice integration.
Incoterms
CompletedInternational trade terms with automatic validations.
TakePOS
CompletedPoint of sale with cash management, tickets and cash closures.
Cron
CompletedScheduled tasks with automatic execution and status logs.
DirectDebit
CompletedDirect debits completed as part of the Bank module.
Quick Navigation
Overview
Project objectives, architecture and metrics
Methodology
Step-by-step process and testing strategy
Migrated Modules
Complete detail of each transformed module
Source Code
PostgreSQL functions and implemented tests
Patterns and Lessons
Reusable patterns and common errors
New Migrations
50 advanced business logic migrations completed
Technical Knowledge
Discoveries and advanced PostgreSQL techniques
Installation
Complete guide and administration commands