Development of a Basic Electronic Pharmaceutical Health Record System in Python (Streamlit + SQLite + LGPD Compliance)
Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted1 hour ago
Development of a Basic Electronic Pharmaceutical Health Record System in Python (Streamlit + SQLite + LGPD Compliance)
I am looking for a Python developer to create a simple, straightforward, and functional web-based Electronic Pharmaceutical Health Record (EHR) system for use in a clinical practice.
The system must run via a local/browser-based interface (using Streamlit) and utilize an encrypted SQLite database to ensure compliance with the LGPD (Brazil’s General Data Protection Law).
System Functional Requirements:
1. Authentication (Login) Screen:
- A simple login screen for the healthcare professional, featuring secure password hashing (using bcrypt).
- Basic session locking/timeout functionality.
2. Patient Registration and Search:
- Registration form: Full name, CPF (Brazilian tax ID), date of birth, phone number, and notes/allergies.
- Quick search for registered patients by name or CPF, with the ability to view their history of previous consultations.
3. Clinical Progress Note Module (S.O.A.P.):
- A consultation form structured according to the four components of the SOAP method:
* Subjective (S): Patient’s account, complaints, and treatment adherence.
* Objective (O): Vital signs, blood glucose, blood pressure, test results, and current medications.
* Assessment (A): Analysis of drug-related problems (DRPs) and pharmacotherapeutic needs.
* Plan (P): Proposed actions, goals, and patient guidance.
- A button to save the consultation record, linked to the patient’s profile.
4. PDF Document Generation (via Base64):
- Generation of three pre-formatted PDF document templates:
* Pharmaceutical Prescription
* Laboratory Test Request
* Referral / Clinical Intervention Letter
- All documents must be generated in-memory and converted for direct download in the browser (using Data URI/Base64 encoding) with the help of libraries such as FPDF2 or ReportLab. - Automatically generate a header containing the professional's fixed information (Name, CRF [professional registration number], and Address), with space for a signature in the footer.
5. Security and LGPD (Data at Rest):
- Storage in a local SQLite database.
- Sensitive patient data and SOAP medical records must be encrypted at rest (using SQLCipher or by encrypting sensitive fields via the `cryptography/Fernet` library in Python).
Deliverables:
- Clean, well-commented, and organized Python source code.
- A `requirements.txt` file listing all dependencies.
- Simple instructions for local installation and execution (a `.bat` or `.sh` script to launch Streamlit with a single click).
Required Technology Stack:
- Language: Python 3.10+
- Web Interface: Streamlit
- Database: SQLite + Encryption (SQLCipher or `cryptography` library)
- PDF Generation: FPDF2 or ReportLab (output encoded in Base64)
Budget and Timeline Information:
- Engagement Type: Fixed Price (Closed-scope project)
- Proposed Budget: $ 200.00
- Estimated Timeline: 7 days
I am looking for a Python developer to create a simple, straightforward, and functional web-based Electronic Pharmaceutical Health Record (EHR) system for use in a clinical practice.
The system must run via a local/browser-based interface (using Streamlit) and utilize an encrypted SQLite database to ensure compliance with the LGPD (Brazil’s General Data Protection Law).
System Functional Requirements:
1. Authentication (Login) Screen:
- A simple login screen for the healthcare professional, featuring secure password hashing (using bcrypt).
- Basic session locking/timeout functionality.
2. Patient Registration and Search:
- Registration form: Full name, CPF (Brazilian tax ID), date of birth, phone number, and notes/allergies.
- Quick search for registered patients by name or CPF, with the ability to view their history of previous consultations.
3. Clinical Progress Note Module (S.O.A.P.):
- A consultation form structured according to the four components of the SOAP method:
* Subjective (S): Patient’s account, complaints, and treatment adherence.
* Objective (O): Vital signs, blood glucose, blood pressure, test results, and current medications.
* Assessment (A): Analysis of drug-related problems (DRPs) and pharmacotherapeutic needs.
* Plan (P): Proposed actions, goals, and patient guidance.
- A button to save the consultation record, linked to the patient’s profile.
4. PDF Document Generation (via Base64):
- Generation of three pre-formatted PDF document templates:
* Pharmaceutical Prescription
* Laboratory Test Request
* Referral / Clinical Intervention Letter
- All documents must be generated in-memory and converted for direct download in the browser (using Data URI/Base64 encoding) with the help of libraries such as FPDF2 or ReportLab. - Automatically generate a header containing the professional's fixed information (Name, CRF [professional registration number], and Address), with space for a signature in the footer.
5. Security and LGPD (Data at Rest):
- Storage in a local SQLite database.
- Sensitive patient data and SOAP medical records must be encrypted at rest (using SQLCipher or by encrypting sensitive fields via the `cryptography/Fernet` library in Python).
Deliverables:
- Clean, well-commented, and organized Python source code.
- A `requirements.txt` file listing all dependencies.
- Simple instructions for local installation and execution (a `.bat` or `.sh` script to launch Streamlit with a single click).
Required Technology Stack:
- Language: Python 3.10+
- Web Interface: Streamlit
- Database: SQLite + Encryption (SQLCipher or `cryptography` library)
- PDF Generation: FPDF2 or ReportLab (output encoded in Base64)
Budget and Timeline Information:
- Engagement Type: Fixed Price (Closed-scope project)
- Proposed Budget: $ 200.00
- Estimated Timeline: 7 days
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.