Data
Own it.
Trust it.
Control it.
Your drill hole data lives in a complete SQL database you own outright — not locked in a vendor's black box.
Most logging software gives you a UI
and holds your data hostage.
Blue Butterfly gives you the complete stack.
Clean data from day one
Bad data compounds. A typo in the field becomes a modeling error, a failed audit, or a flawed resource estimate. Blue Butterfly validates data as you enter it — before it gets into your database.
Invalid entries never reach your database.
Dropdown lists
Controlled vocabulary — no free-text drift on rock types or alteration codes.
Number range validation
Depth, assay, and measurement values must fall within logical ranges.
Required fields
Critical collar and interval fields can't be left blank.
Real-time error checking
Flags surface as you type, not during QAQC three weeks later.
"I used to spend a full day before every Leapfrog session cleaning the export. That doesn't happen anymore."
— Field Geologist, Junior Explorer, Western Australia
You get the complete SQL database
This isn't a logging app that talks to someone else's database. Blue Butterfly gives you the entire relational database — structured, normalized, and yours.
What this means
- Every project is a real PostgreSQL-compatible relational database
- Schema is open, documented, and follows standard conventions
- Query directly with any SQL client — psql, DBeaver, TablePlus
- Connect BI tools, Python scripts, or R without middleware
- Exported backups are fully portable to any compatible system
Why it matters
- No vendor can hold your historical data ransom
- Your data integrates with your existing modeling stack
- Survives the end of any subscription or contract
- Works with your IT infrastructure — no new tooling required
- You own the structure, not just the rows
CREATE TABLE collars (
collar_id UUID PRIMARY KEY,
hole_id VARCHAR(32) NOT NULL UNIQUE,
easting NUMERIC(12,3),
northing NUMERIC(12,3),
elevation NUMERIC(8,3),
max_depth NUMERIC(8,2),
project_id UUID REFERENCES projects(project_id)
);
CREATE TABLE intervals (
interval_id UUID PRIMARY KEY,
collar_id UUID REFERENCES collars(collar_id),
from_m NUMERIC(8,2) NOT NULL,
to_m NUMERIC(8,2) NOT NULL,
lith_code VARCHAR(16),
rqd NUMERIC(5,2),
logged_by UUID REFERENCES users(user_id)
);Download your entire database anytime
Your exploration data is worth more than the drill program that created it. Blue Butterfly ensures you never lose access to what you've built.
One-click full export
Download your complete database as CSV or a portable SQL dump. No support ticket, no cooldown period.
Anytime, no questions asked
Your export is yours to run whenever you need it. No approval process, no lock-out.
Point-in-time backups
AWS-hosted automated backups with 30-day retention. Restore to any state if something goes wrong.
No proprietary formats
Standard SQL dump. Import into any PostgreSQL-compatible system. No special tools required.
| Feature | Others | Blue Butterfly |
|---|---|---|
| Export to CSV / standard formats | ||
| Full SQL database download | ||
| Open, documented schema | ||
| No vendor lock-in | ||
| Point-in-time backup restore |
"Others" refers to common geological logging platforms. Assessment based on public documentation.
Live sync between cloud and local
Multiple geologists. One project. Every record synchronized to a single source of truth. No "which version is current?" No stale exports on a shared drive.
Cloud / AWS
Live · Encrypted
Desktop
Tablet
Mobile
Instant sync
Changes propagate within seconds. Everyone on the project sees updates in real time.
Offline field mode Soon
Log core with zero internet. Full functionality, changes queue for sync automatically.
Conflict resolution
Timestamp-based merge logic. If two users edit the same record, changes reconcile intelligently.
Sync log
Full audit trail of every sync event. Know exactly when and by whom every record changed.
No more "wait, which version is current?"
Single source of truth, always.
Enterprise-grade infrastructure
Built on AWS. Secured by design.
Encrypted at rest and in transit
AES-256 storage encryption. TLS 1.3 for all connections — in the browser, in the app, everywhere.
SOC 2 alignment
Security controls aligned to SOC 2 Type II framework. Infrastructure that meets enterprise security standards.
Regional data residency
Choose where your data lives — North America, Europe, Australia. Data stays in your jurisdiction.
99.9% uptime SLA
Redundant systems, automatic failover, and continuous monitoring. Your data is available when you need it.
Automatic daily backups
Your data is never at risk from an accidental deletion or system event.
Data Ownership
Your data is yours. Period.
- Complete SQL database — yours to query, export, or migrate
- Open schema with full documentation
- Export to CSV or portable SQL dump, anytime
- Point-in-time recovery for 30 days
- No vendor lock-in, ever
- Hosted on AWS infrastructure in your region