Skip to content

feat: Add support for partial indexes - #80

Merged
isaacvando merged 2 commits into
mainfrom
support-partial-indexes
Apr 14, 2026
Merged

feat: Add support for partial indexes#80
isaacvando merged 2 commits into
mainfrom
support-partial-indexes

Conversation

@isaacvando

Copy link
Copy Markdown
Collaborator

Ticket(s) Closed

  • Closes #

What

Adds support for partial indexes with where.

Why

How

Tests

@isaacvando
isaacvando changed the base branch from main to allow-aliased-expressions-in-indexes April 13, 2026 20:37
@codecov

codecov Bot commented Apr 13, 2026

Copy link
Copy Markdown

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 90.13%. Comparing base (1be207f) to head (6ad9c1d).
⚠️ Report is 1 commits behind head on main.

Additional details and impacted files

Impacted file tree graph

@@            Coverage Diff             @@
##             main      #80      +/-   ##
==========================================
+ Coverage   89.99%   90.13%   +0.14%     
==========================================
  Files          19       19              
  Lines        2358     2393      +35     
  Branches      702      718      +16     
==========================================
+ Hits         2122     2157      +35     
  Misses        236      236              
Flag Coverage Δ
rails-paradedb 90.13% <100.00%> (+0.14%) ⬆️
rb3.2 90.42% <100.00%> (+0.14%) ⬆️
rb3.3 90.42% <100.00%> (+0.14%) ⬆️
rb3.4 90.13% <100.00%> (+0.14%) ⬆️
rb4.0 90.13% <100.00%> (+0.14%) ⬆️
rl7.2 90.13% <100.00%> (+0.14%) ⬆️
rl8.1 90.13% <100.00%> (+0.14%) ⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

Files with missing lines Coverage Δ
lib/parade_db/index.rb 82.88% <100.00%> (+0.27%) ⬆️
lib/parade_db/migration_helpers.rb 85.66% <100.00%> (+0.84%) ⬆️
🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

Base automatically changed from allow-aliased-expressions-in-indexes to main April 13, 2026 20:38
@isaacvando
isaacvando force-pushed the support-partial-indexes branch from 4d2f8f6 to 170a9a6 Compare April 13, 2026 20:39
@isaacvando
isaacvando marked this pull request as ready for review April 13, 2026 20:39
@isaacvando
isaacvando marked this pull request as draft April 13, 2026 20:44
@isaacvando
isaacvando force-pushed the support-partial-indexes branch from 170a9a6 to e458158 Compare April 13, 2026 21:12
@isaacvando
isaacvando marked this pull request as ready for review April 13, 2026 21:16
Comment thread lib/parade_db/index.rb
Comment thread lib/parade_db/migration_helpers.rb Outdated
@isaacvando
isaacvando merged commit 7e86327 into main Apr 14, 2026
15 checks passed
@isaacvando
isaacvando deleted the support-partial-indexes branch April 14, 2026 13:45
philippemnoel pushed a commit to paradedb/paradedb that referenced this pull request Apr 15, 2026
# Ticket(s) Closed

- Closes #

## What

Adds ORM snippets to the index creation docs. This will allow us to
remove the index creation docs from the ORM READMEs.

paradedb/rails-paradedb#79,
paradedb/rails-paradedb#80, and
paradedb/rails-paradedb#82 should be released
before this is published so that all of the snippets work correctly.

None of the ORMs support creating indexes with more than 32 columns. I'm
not convinced we should support this in the ORMs personally as we'd have
to create the type to hold the 33+ columns and manage that also. Seems
like thre would be a lot of room for things to go wrong there.

## Why

This centralizes the docs and will allow us to clean up the ORM READMEs.

## How

## Tests
I modified the smoke test snippet job to support running these.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants