Missing index options
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- PHP
- Stars
- 4.5k
- Forks
- 884
- PR merge metrics
- No merged PRs in 30d
Description
There appears to be no way to set the index order (ASC/DESC) and nulls order (FIRST/LAST). The latter is probably not available in MySQL but is nevertheless part of the SQL standard.
Another major omission is the index access type. In Postgres, this could be heap, btree, hash, gist, gin, spgist or brin. I don't know how portable this is though.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files, tests, or entry points are named. Start by examining how Phinx currently defines indexes for PostgreSQL and MySQL, then compare which index order, nulls order, and access-type options each database supports; done means the API and portability limits are documented and covered by tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php, postgresql, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 32/100