luckyframework / luckyframework/avram
Support use a self-defined index type when run create_index in migration.
Nobody has claimed this yet.
- Dominant language
- Crystal
- Stars
- 183
- Forks
- 67
- PR merge metrics
- No merged PRs in 30d
Description
What i expected is to create a index like this:
```
CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);
```
As described by the [tuturial](https://pgroonga.github.io/tutorial/) of that pg extension.
but, because the type of index has been limited to only several type, use create_index is impossible, i have to use execute to do this.
```
execute <<-'HEREDOC'
CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);
HEREDOC
```
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
The issue does not name a file or test. Start by tracing the migration create_index API and how it validates index types, then inspect existing migration tests and generated PostgreSQL SQL. Done means create_index can emit a self-defined USING clause such as pgroonga while preserving support for existing index types.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- crystal, postgresql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100