Files
relspecgo/TODO.md
Hein aba22cb574
Some checks failed
CI / Test (1.25) (push) Failing after -23m58s
CI / Test (1.24) (push) Successful in -23m22s
CI / Lint (push) Successful in -25m3s
CI / Build (push) Successful in -25m15s
Integration Tests / Integration Tests (push) Successful in -25m52s
feat(ui): add relationship management features in schema editor
- Implement functionality to create, update, delete, and view relationships between tables.
- Introduce new UI screens for managing relationships, including forms for adding and editing relationships.
- Enhance table editor with navigation to relationship management.
- Ensure relationships are displayed in a structured table format for better usability.
2026-02-07 09:49:24 +02:00

2.1 KiB

RelSpec - TODO List

Input Readers / Writers

  • [✔️] Database Inspector
    • [✔️] PostgreSQL driver (reader + writer)
    • MySQL driver
    • [✔️] SQLite driver (reader + writer with automatic schema flattening)
    • MSSQL driver
    • [✔️] Foreign key detection
    • [✔️] Index extraction
    • [✔️] .sql file generation (PostgreSQL, SQLite)
  • [✔️] .dbml: Database Markup Language (DBML) for textual schema representation.
  • [✔️] Prisma schema support (PSL format) .prisma
  • [✔️] Drizzle ORM support .ts (TypeScript / JavaScript) (Mr. Edd wanted to move from Prisma to Drizzle. If you are bugs, you are welcome to do pull requests or issues)
  • [☠️] Entity Framework (.NET) model .edmx (Fuck no, EDMX files were bloated, verbose XML nightmares—hard to merge, error-prone, and a pain in teams. Microsoft wisely ditched them in EF Core for code-first. Classic overkill from old MS era.)
  • [✔️] TypeORM support
  • [] .hbm.xml / schema.xml: Hibernate/Propel mappings (Java/PHP) (💲 Someone can do this, not me)
  • Django models.py (Python classes), Sequelize migrations (JS) (💲 Someone can do this, not me)
  • [] .avsc: Avro schema (JSON format for data serialization) (💲 Someone can do this, not me)
  • [✔️] GraphQL schema generation

UI

  • [✔️] Basic UI (I went with tview)
  • [✔️] Save / Load Database
  • [✔️] Schemas / Domains / Tables
  • [✔️] Add Relations
  • Add Indexes
  • Add Views
  • Add Sequences
  • Add Scripts
  • Domain / Table Assignment

Documentation

  • [✔️] API documentation (godoc)
  • Usage examples for each format combination

Advanced Features

  • Dry-run mode for validation
  • Diff tool for comparing specifications
  • Migration script generation
  • Custom type mapping configuration
  • Batch processing support
  • Watch mode for auto-regeneration

Future Considerations

  • Web UI for visual editing
  • REST API server mode
  • Support for NoSQL databases

Performance

  • Concurrent processing for multiple tables
  • Streaming for large databases
  • Memory optimization
  • Caching layer for repeated operations