luckyframework / luckyframework/avram

Support use a self-defined index type when run create_index in migration.

Open
#1,029 0 comments 0 reactions 0 assignees View on GitHub

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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.