docs-pr6283.prs-0-us-east-1.engineering.fragment.dev Open in urlscan Pro
2600:9000:21a2:8400:9:a68b:7880:93a1  Public Scan

Form analysis
0 forms found in the DOM

Text Content

FRAGMENT
Documentation
Login ↗
Menu
Get Access
The database for money
_
The database 
for money
_
FRAGMENT is the Ledger API for engineers that move money. Stop wrangling payment
tables, debugging balance errors and hacking together data pipelines. Start
shipping the features that make a difference.
Get Access

Why FRAGMENT
Postgres wasn't built for money and forces you to invent your own ways to track
it. FRAGMENT comes with real-time, double-entry accounts that store and track
every penny out of the box.
Postgres
0 CREATE TABLE Payments (PaymentID INT PRIMARY KEY AUTO_INCREM
1 ALTER TABLE Payments ADD COLUMN PaymentStatus VARCHAR(255);
2 AUTOVACUUM ANALYZE;
3 EXPLAIN ANALYZE SELECT SUM(Amount) FROM Payments;
4 INSERT INTO Transactions (PaymentID, TransactionType, Amount
5 CREATE TABLE BalanceHistory (ID INT PRIMARY KEY, Balance DEC
6 ALTER TABLE Transactions ADD COLUMN currency VARCHAR(255);
7 ALTER TABLE Transactions ADD CONSTRAINT is_iso_currency (IS_
8 CREATE TABLE ReconMatch (PaymentID INT, TransactionID INT, P
9 BEGIN; SELECT * FROM ledger WHERE ledger_id = 123 FOR UPDATE
10 └─ ERROR: deadlock detected
11 ERROR: database is not accepting commands to avoid wraparoun
12 CREATE INDEX idx_payment_status ON Payments(PaymentStatus);
13 SELECT * FROM BalanceHistory WHERE Date = "2021-01-01";
14 └─ ERROR: could not create unique index "payment_id";
15 CREATE TABLE ACCOUNT_


























FRAGMENT
1 query ledgerAccount (
2 path: "user:456/available"
3 ) {
4 name
5 balance
6 }
Book a demo
Book a demo
How it works
1
 Design your Schema
1
 Design your Schema
Choose from a library of example Ledgers. Use our Schema designer to customize
them to match your flow of funds.

2
 Link your financial systems
2
 Link your
financial systems
Track the state of every transaction from your bank, card and payment systems.
Instantly update your Ledger when they change.

Stripe
Native Link

Increase
Native Link

Unit
Native Link

Custom
Custom Link
3
 Integrate your product
3
 Integrate your product
Generate an SDK to read and write balances. Call our API to check or update
them.
Store your Schema
Copy

mutation StoreSchema(
  $schema: SchemaInput!
) {
  storeSchema(schema: $schema) {
      schema {
        name
        version {
          version
          created
          json
        }
      }
    }
  }
}

Store your Schema
Copy

mutation StoreSchema($schema: SchemaInput!) {
  storeSchema(schema: $schema) {
    schema {
      name
      version {
        version
        created
        json
      }
    }
  }
}

Post an entry
Copy

mutation WalletTransfer(
  $ik: SafeString!
  $entry: LedgerEntryInput!
) {
  addLedgerEntry(ik: $ik, entry: $entry) {
    lines {
      amount
      account { path }
    }
  }
}

Post an entry
Copy

mutation WalletTransfer(
  $ik: SafeString!
  $entry: LedgerEntryInput!
) {
  addLedgerEntry(
    ik: $ik, entry: $entry
  ) {
    lines {
      amount
      account { path }
    }
  }
}

Get a balance
Copy

query GetBalance(
  $account: LedgerAccountMatchInput!
) {
  ledgerAccount(ledgerAccount: $account) {
    balance(
      consistencyMode: "strong"
      at: "2022-02-01"
    )
  }
}

Query a balance
Copy

query GetBalance(
  $account: LedgerAccountMatchInput!
) {
  ledgerAccount(
    ledgerAccount: $account
  ) {
    balance(
      consistencyMode: "strong"
      at: "2022-02-01"
    )
  }
}

Work with us to design your Ledger in 45 minutes.
Talk to an engineer
Talk to an engineer
Performance
FRAGMENT is really fast. Check out our latest load test:
Requests: 19,622,609

Metric
Throughput
Latency @p95
Reads
7,489rps
33ms
Writes
14,578rps
69ms
Under the hood →
Under the hood →
FAQ
→
Will you help me design my Ledger?
→
How do I collaborate with my finance team?
→
Can FRAGMENT be used as an online database?
→
How do I access my data in FRAGMENT?
→
What tech stack do you use?
Updates
 * 2024-03-01
   February Changelog: Schema Drafts and Schema Flexibility
 * 2024-02-19
   FRAGMENT Under the Hood
 * 2024-02-01
   January Changelog: Entry Groups and Ledger Designer
 * 2024-01-23
   FRAGMENT named to Fintech Innovation 50 ↗

No one builds their own database.
Why build one for money?
Get Access
Get Access
©
 FRAGMENT  
2024
1 Documentation
2 API Reference
3 Changelog
1 Documentation
2 API Reference
3 Changelog
 1. About
 2. Contact
 3. FRAGMENT Mono

 1. Login ↗
 2. Legal
 3. Status

○● Light
○● Dark
● System