askrobots / dbbasic Public

Model-config web apps: describe the app in configuration instead of writing code. Built on Polars and DuckDB.

0 downloads

dbbasic/docs/AI_CONFORMANCE_STANDARDS.md
Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 Add DBBasic crate engine logo and update README 0d628db 1 year, 2 months ago History
AI_CONFORMANCE_STANDARDS.md · 8.2 KB · 429 lines

AI Conformance Standards

How AI Knows What to Do Correctly Every Time

The Problem

AI is powerful but needs guidelines to ensure:

  • Consistency across implementations
  • Security best practices
  • Performance optimization
  • Business rule compliance
  • Regulatory requirements

The Solution: Conformance Standards

1. Data Standards

data_standards:
  user_data:
    required_fields:
      - id: "unique identifier"
      - created_at: "timestamp"
      - updated_at: "timestamp"

    privacy:
      pii_fields: [email, phone, ssn, credit_card]
      encryption: required
      audit_log: required

    validation:
      email: "RFC 5322 compliant"
      phone: "E.164 format"
      password: "min 8 chars, complexity rules"

  ai_ensures:
    - All PII is encrypted at rest
    - Audit logs for access
    - GDPR compliance for EU users
    - Automatic data validation

2. Security Standards

security_standards:
  authentication:
    standard: "OAuth 2.0 / JWT"

    requirements:
      - Password hashing: bcrypt/argon2
      - Session timeout: 30 minutes
      - 2FA: available
      - Rate limiting: required

  api_security:
    standard: "OWASP Top 10"

    ai_implements:
      - SQL injection prevention
      - XSS protection
      - CSRF tokens
      - Rate limiting
      - Input sanitization

  compliance:
    standards: [SOC2, HIPAA, PCI-DSS]

    ai_ensures:
      SOC2: "Audit trails on all data access"
      HIPAA: "PHI encryption and access controls"
      PCI: "No credit card storage, use tokens"

3. Performance Standards

performance_standards:
  response_times:
    page_load: < 2 seconds
    api_response: < 200ms
    database_query: < 100ms

  optimization:
    standard: "Web Vitals"

    ai_ensures:
      - Lazy loading for images
      - Database query optimization
      - Caching strategy
      - CDN for static assets

  scaling:
    standard: "12-Factor App"

    ai_implements:
      - Stateless services
      - Config from environment
      - Horizontal scaling ready
      - Graceful degradation

4. Code Generation Standards

code_generation_standards:
  patterns:
    standard: "Clean Architecture"

    ai_follows:
      - Separation of concerns
      - Single responsibility
      - Dependency injection
      - Interface segregation

  error_handling:
    standard: "Graceful Degradation"

    ai_ensures:
      - Never expose stack traces
      - User-friendly error messages
      - Automatic retry logic
      - Circuit breakers for external services

  testing:
    standard: "Test Pyramid"

    ai_generates:
      - Unit tests: 80% coverage
      - Integration tests: Critical paths
      - E2E tests: User journeys

5. Business Logic Standards

business_standards:
  financial:
    standard: "GAAP / Double-Entry"

    ai_ensures:
      - Debits equal credits
      - Audit trail for all transactions
      - Currency handling (no float math)
      - Timezone-aware timestamps

  inventory:
    standard: "FIFO/LIFO/Average"

    ai_implements:
      - Stock level validation
      - Reorder point alerts
      - Batch tracking
      - Expiration handling

  pricing:
    standard: "Revenue Recognition"

    ai_handles:
      - Tax calculation by region
      - Discount application rules
      - Currency conversion
      - Subscription proration

6. Integration Standards

integration_standards:
  apis:
    standard: "REST/GraphQL/gRPC"

    ai_conforms_to:
      REST: "Richardson Maturity Model Level 3"
      GraphQL: "Apollo Federation spec"
      gRPC: "Protocol Buffers v3"

  webhooks:
    standard: "Webhook.site specs"

    ai_implements:
      - Retry with exponential backoff
      - Signature verification
      - Idempotency keys
      - Event versioning

  data_formats:
    standard: "JSON Schema / OpenAPI"

    ai_validates:
      - Schema compliance
      - Version compatibility
      - Backwards compatibility

7. Accessibility Standards

accessibility_standards:
  web:
    standard: "WCAG 2.1 Level AA"

    ai_ensures:
      - Alt text for images
      - Keyboard navigation
      - Screen reader compatible
      - Color contrast ratios
      - Focus indicators

  mobile:
    standard: "iOS/Android Guidelines"

    ai_follows:
      - Platform conventions
      - Gesture standards
      - Accessibility APIs

8. Localization Standards

localization_standards:
  i18n:
    standard: "ICU Message Format"

    ai_handles:
      - Date/time formatting
      - Number formatting
      - Currency display
      - Pluralization rules
      - Right-to-left support

  content:
    standard: "XLIFF 2.1"

    ai_manages:
      - Translation keys
      - Context for translators
      - Variable placeholders

How AI Uses Standards

The Lookup Process

when: "AI generates authentication"

ai_process:
  1_check_standards:
    finds: "security_standards.authentication"

  2_apply_requirements:
    implements:
      - bcrypt for passwords
      - JWT with expiration
      - Rate limiting on login

  3_verify_compliance:
    checks:
      - OWASP compliance ✓
      - SOC2 requirements ✓
      - Industry best practices ✓

  4_generate_code:
    output: "Compliant authentication service"

Multiple Standards Support

project_standards:
  primary: "enterprise_secure"

  includes:
    - SOC2 compliance
    - HIPAA for health data
    - PCI for payments
    - GDPR for EU users

ai_combines:
  "Most restrictive rule wins"

  example:
    session_timeout:
      SOC2: 30 minutes
      HIPAA: 15 minutes
      chosen: 15 minutes  # Most restrictive

Custom Standards

company_standards:
  name: "AcmeCorp Standards"

  extends: "enterprise_secure"

  customizations:
    branding:
      colors: ["#FF5733", "#C70039"]
      fonts: ["Roboto", "Open Sans"]

    business_rules:
      approval_threshold: 10000
      tax_calculation: "custom_formula"

    naming:
      database_tables: "snake_case"
      api_endpoints: "kebab-case"
      functions: "camelCase"

Standards Evolution

Learning From Usage

standard_improvement:
  observes: "Common patterns across projects"

  discovers:
    "80% of projects need soft delete"

  updates_standard:
    data_standards:
      soft_delete:
        standard: "paranoid pattern"
        adds: deleted_at timestamp
        ensures: "Never actually DELETE"

Industry Updates

standard_updates:
  monitors:
    - OWASP Top 10 (yearly)
    - WCAG updates
    - Platform guidelines
    - Regulatory changes

  auto_updates:
    when: "New CVE published"
    action: "Update security standards"

    when: "New accessibility guideline"
    action: "Update WCAG compliance"

The Benefits

For AI

  • Clear guidelines to follow
  • Consistent output
  • Fewer edge cases
  • Learning from best practices

For Humans

  • Predictable results
  • Compliance built-in
  • Best practices automatic
  • No expertise required

For Business

  • Regulatory compliance
  • Security by default
  • Performance guaranteed
  • Reduced liability

Examples In Action

E-commerce Checkout

specification: "Add checkout flow"

ai_consults_standards:
  - PCI: "No credit card storage"
  - GDPR: "Consent checkboxes"
  - Accessibility: "Keyboard navigable"
  - Performance: "< 2 second response"
  - Security: "HTTPS required"

generates:
  Compliant checkout with:
    - Tokenized payments
    - Privacy consent
    - Full accessibility
    - Optimized queries
    - Encrypted transmission

Healthcare Portal

specification: "Patient records system"

ai_consults_standards:
  - HIPAA: "PHI encryption"
  - Accessibility: "Screen reader support"
  - Audit: "Access logging"
  - Performance: "Sub-second queries"

generates:
  Compliant system with:
    - End-to-end encryption
    - Complete audit trail
    - WCAG AA compliance
    - Optimized data access

The Bottom Line

Without Standards:

  • AI might generate insecure code
  • Inconsistent implementations
  • Compliance nightmares
  • Performance issues

With Standards:

  • AI generates secure, compliant code
  • Consistent across all projects
  • Best practices built-in
  • Performance guaranteed

Standards aren't restrictions. They're AI superpowers.


"Give AI standards, and it builds perfectly every time."