PostgreSQL backend: business engine, API and row-level security
- Field
- Development
- Maximum volumeMaximum number of days the client allows the freelancer for this mission.
- 63 days
- Target market
- France
- Reference
- PCT-2026-10-J1PV-YZWH
Skills sought
- Authentication and authorisation
- PostgreSQL
- Automated testing
Target increased daily rate · Development
€1,700 to €2,900 excl. VAT per day
Benchmark for this role. The increased daily rate is a target written into the contract, mission by mission, paid in two stages with no guaranteed date: it is not a promise of income.
Mission brief
Context
Belgian publisher of a B2B SaaS platform for collaboration between companies and independent professionals (contracts, assignment tracking, e-invoicing). Business engine in PostgreSQL with row-level security (RLS), server functions in Deno.
Tasks
- Write the SQL migrations for new business rules, replayable on an empty database.
- Write RLS policies per role and prove every denied access with a test.
- Build Deno server functions: API endpoints, background jobs, calls to Stripe and to a Peppol access point.
- Cover each rule with Vitest and SQL tests.
Deliverables
- Merged migrations and functions, with continuous integration green.
- A rights matrix per role and per table, consistent with the RLS policies.
- A technical note per change: schema, edge cases, rollback.
Profile
Advanced PostgreSQL (RLS, functions, indexes, transactions), server-side TypeScript, Deno a plus. Fluent French, technical English.
Terms
Remote from France, working language French. The stated volume is a ceiling, with no set working hours.
What is public
The field, skills and maximum volume are public. Details are open to members of the programme concerned.
The Pacto framework
- You remain an independent company. You sign directly with the company, on the programme’s contract templates.
- Your clients pay you directly, from their account to yours. Pacto takes no commission on your missions, your invoices or your balances.
- The increased rate is a target, agreed mission by mission with each client and written into your contract. It is not a promise of income.
Apply for this mission
Details are open to members of the programme concerned.Once a member, you access the briefing, the client’s files, the Gantt chart and the Kanban board of the mission: all project management online on Pacto.
Other missions in Development
- DevelopmentPCT-2026-10-QVH1-G2CD45 dmaximumBelgium
AI-assisted web developer: features for logged-in areas
- React
- AI-assisted development with coding agents
- Token cost control
- DevelopmentPCT-2026-10-HMKX-VFXE46 dmaximumFrance
AI-assisted development: test coverage and legacy code migration
- Automated testing
- AI-assisted development with coding agents
- AI task orchestration
- DevelopmentPCT-2026-10-CZWV-6C7K62 dmaximumBelgium
React and TypeScript frontend: logged-in areas and bilingual website
- Accessibility
- Internationalisation
- React