relspecgo/TODO.md

RelSpec - TODO List

Input Readers / Writers

• [✔️] Database Inspector
  • [✔️] PostgreSQL driver
  • MySQL driver
  • SQLite driver
  • MSSQL driver
  • [✔️] Foreign key detection
  • [✔️] Index extraction
  • [*] .sql file generation with sequence and priority
• [✔️] .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

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