Openbill Core

B 80 completed
Data Tool
unknown / sql · small
53
Files
1,093
LOC
1
Frameworks
5
Languages

Pipeline State

completed
Run ID
#367756
Phase
done
Progress
1%
Started
Finished
2026-04-13 01:31:02
LLM tokens
0

Pipeline Metadata

Stage
Cataloged
Decision
proceed
Novelty
52.98
Framework unique
Isolation
Last stage change
2026-05-10 03:35:17
Deduplication group #65666
Member of a group with 1 similar repo(s) — this repo is canonical view group →
Top concepts (2)
Project DescriptionWeb Backend
Provenance: Repobility (https://repobility.com) — every score reproducible from /scan/

AI Prompt

Create a core billing system using PostgreSQL. I need this system to manage accounts and transfers entirely through stored procedures and triggers, ensuring high reliability by avoiding external APIs. The system must track accounts (with balance and currency), record transfers between accounts, and handle fund holds. It should also manage account categories and policies. The core principle is that all financial operations must be recorded, and the system's total balance must always equal zero. Please structure the necessary SQL schema, functions, and triggers to enforce these rules.
sql postgresql billing database stored-procedures finance backend
Generated by gemma4:latest

Catalog Information

A PostgreSQL-based core billing system that manages accounts and transfers using stored procedures and triggers.

Description

This core billing solution operates entirely within PostgreSQL, providing a lightweight yet reliable framework for managing financial accounts and transfers. It defines tables for accounts, transfers, holds, categories, and policies, and enforces business rules through triggers and functions. All monetary movements are recorded as immutable operations, ensuring that balances are automatically updated and the overall system balance always sums to zero. The design eliminates external APIs, reducing attack surface and simplifying deployment across languages and platforms. It is ideal for applications that require a dependable, language-agnostic billing engine with strict auditability.

الوصف

يعمل هذا الحل الأساسي للفاتورة بالكامل داخل قاعدة بيانات PostgreSQL، موفراً إطاراً خفيفاً وموثوقاً لإدارة الحسابات المالية والتحويلات. يعرّف جداول للحسابات، والتحويلات، والحجز، والفئات، والسياسات، ويطبّق القواعد التجارية عبر المحفزات والإجراءات. تُسجّل جميع التحويلات المالية كعمليات غير قابلة للتعديل، ما يضمن تحديث الأرصدة تلقائياً ويجعل إجمالي رصيد النظام يساوي صفرًا دائمًا. يزيل التصميم الحاجة إلى واجهات برمجة تطبيقات خارجية، ما يقلل من سطح الهجوم ويُبسط نشر النظام عبر لغات ومنصات مختلفة. يُعد مثاليًا للتطبيقات التي تتطلب محرك فاتورة موثوقًا، مستقلًا عن اللغة، مع إمكانية تدقيق صارمة.

Novelty

7/10

Tags

billing financial-transfers account-management transaction-integrity audit-trail multi-currency data-consistency

Claude Models

claude-opus-4.6

Quality Score

B
80.1/100
Structure
75
Code Quality
99
Documentation
37
Testing
85
Practices
80
Security
100
Dependencies
50

Strengths

  • CI/CD pipeline configured (github_actions)
  • Good test coverage (110% test-to-source ratio)
  • Consistent naming conventions (snake_case)
  • Low average code complexity \u2014 well-structured code
  • Good security practices \u2014 no major issues detected
  • Properly licensed project

Recommendations

  • Add a linter configuration to enforce code style consistency

Security & Health

4.6h
Tech Debt (E)
A
OWASP (100%)
PASS
Quality Gate
A
Risk (10)
All rows above produced by Repobility · https://repobility.com
Apache-2.0
License
0.0%
Duplication
Full Security Report AI Fix Prompts SARIF SBOM

Languages

sql
38.0%
markdown
26.9%
shell
25.4%
yaml
5.8%
ruby
4.0%

Frameworks

Rails

Concepts (2)

Per-row analysis by Repobility · https://repobility.com
CategoryNameDescriptionConfidence
Repobility analyzer · published findings · https://repobility.com
auto_descriptionProject Description![Build Status](https://github.com/openbill-service/openbill-core/actions)80%
auto_categoryWeb Backendweb-backend70%

Quality Timeline

1 quality score recorded.

View File Metrics

Embed Badge

Add to your README:

![Quality](https://repos.aljefra.com/badge/91948.svg)
Quality BadgeSecurity Badge
Export Quality CSVDownload SBOMExport Findings CSV