Our Work

Client Projects and Internal Tools

21 client projects across 6 industries, plus 8 internal tools we built and use daily.

29
Total Projects
6
Industries
500+
APEX Pages Built
460+
Automated Checks
Non-profit

Run a volunteer-powered organisation on systems built like production.

All non-profit work →
Data for Good Calgary

A whole volunteer operation on one Oracle platform

Intake, two CRMs, projects, e-signature, meetings, a public website and private AI, designed, built and run by DB Realm on Oracle APEX 26.1 and Oracle AI Database 26ai on OCI.

pages across two Oracle APEX apps
185
pages across two Oracle APEX apps
modules sharing one data model
11
modules sharing one data model
PL/SQL packages written for the system
24
PL/SQL packages written for the system
records searchable by meaning
2,295
records searchable by meaning
Read the case study →
Canadian Cultural Mosaic Foundation (via Data for Good Calgary)

Three hate-incident tools rebuilt as one secure Oracle platform

DB Realm moved the Canadian Cultural Mosaic Foundation's incident database and dashboards onto one Oracle APEX 26.1 application, with a public dashboard, a guided data-entry workflow and a news-monitoring review queue.

database objects migrated, 0 invalid
443
database objects migrated, 0 invalid
pages in the rebuilt application
47
pages in the rebuilt application
Canadian news feeds, checked every 6 hours
28
Canadian news feeds, checked every 6 hours
legacy pages carried over at component parity
74
legacy pages carried over at component parity
Read the case study →
Managed service providers

The operational picture across every client, in one place.

All managed service providers work →
Confidential Client

Managed Services Support Platform

A managed services provider ran Oracle Cloud Infrastructure on behalf of many client organizations, with the operational picture scattered across the OCI console, spreadsheets, a ticketing system and individual engineers' knowledge. There was no single place to answer basic questions: what does this client run, what did it cost, what is failing, what did we promise to fix. Every client review meant assembling the same data by hand, and cost attribution across shared tenancies was guesswork.

  • ✓Full billing history attributed to every client
  • ✓Complete multi-region resource inventory
  • ✓Thirteen modules live and end-to-end tested
  • ✓Ticket operations under an aging and delay model
Read the case study →
Health

Clinical data systems that clinicians and researchers rely on.

All health work →
SickKids Hospital

BrainWorks — Paediatric Clinical Registry

BrainWorks is SickKids' outcome registry for children with central-nervous-system vasculitis: a 148-page Oracle APEX application on Oracle Database 19c that clinicians and researchers rely on. It needed to stay current, take on new clinical measures without a schema change for each one, and be released safely against live clinical data.

  • ✓148-page clinical registry upgraded to APEX 23.1
  • ✓Vital signs stored as rows instead of columns
  • ✓Visit and dashboard APIs for the registry
  • ✓Schema in Liquibase; production changes by tested script
Read the case study →
Public sector & education

Reporting and operations systems for funders, universities and regulated industries.

All public sector & education work →
Alberta Law Foundation Delivered 2021–2023

Turning legal-clinic client surveys into evidence for funders

An Oracle APEX application that took raw client surveys from Alberta's legal clinics, cleaned and categorised them, and turned them into 116 charts on client outcomes, legal problems and demographics.

Oracle APEX pages
57
Oracle APEX pages
charts on outcomes, problems and demographics
116
charts on outcomes, problems and demographics
legal-problem types tracked per respondent
26
legal-problem types tracked per respondent
linked surveys: initial and follow-up
2
linked surveys: initial and follow-up
Read the case study →

Internal Tools & Automation

Tools we built and use every day to run our own operations, from security scanning to infrastructure automation.

⚡ Internal

Multi-Client Financial Activity Platform

Needed a unified platform to track credit card transactions, bank activity, invoices, expenses, and rental property finances across multiple clients with automated tax calculations.

APEX 24.2 Oracle 23c n8n
⚡ Internal

OCI Email Deliverability Monitoring

Needed to see how the OCI Email Delivery Service was performing: delivery rates, bounce rates and suppression lists across several sending domains.

APEX OCI Email SMTP
⚡ Internal

TLS Certificate Monitor

Clients needed to know about TLS certificate expiry across hundreds of endpoints before an expired certificate took a service down.

APEX TLS/SSL Security
🐍 Internal

Oracle Security Scanner

Database teams needed an automated way to assess Oracle databases against industry best practices and compliance frameworks, without buying an expensive commercial tool.

Python Oracle Security Flet GUI
🐍 Internal

Financial Tax Report Generator

Needed Canadian tax reports generated automatically: 9 worksheets covering income categorization, HST/GST calculations, expense breakdowns, and annual summaries.

Python Excel Tax Reporting
🔗 Internal

n8n Invoice Extraction Pipeline

Invoices accumulated across Google Drive folders in various PDF formats, and every one had to be typed into the financial tracking system by hand, which was slow and error-prone.

n8n Google Drive Oracle
🔧 Internal

OCI Resource Reports

Running OCI tenancies means checking compute, networking, storage and database resources all the time, and the OCI console spreads that information across many pages with no single view.

OCI Python Claude Code
🔧 Internal

OCI Certificate Manager

OCI Load Balancers require manual certificate updates, and Let's Encrypt certificates expire every 90 days, so renewals were a recurring chore and a missed one could take a service down.

OCI Let's Encrypt TLS/SSL

Talk to Us About Your Project

If your systems look like any of these, get in touch.

Start a Conversation