Hacktoberfest 2026: los issues que los mantenedores marcaron para octubre, abiertos y aptos para principiantes. Explorar issues de Hacktoberfest

Filters: ILIKE and any-column minors, and a cancel for filtered counts

Abierto
  • ¿Algo no está bien?
#45 0 comentarios 0 reacciones 0 asignados Ver en GitHub

Los mantenedores suelen responder en 1 día

Nadie ha tomado este issue todavía.

Evaluación

Dificultad
5/5
Tiempo estimado
Más de una semana
Aptitud para principiantes
25/100
Tipo de issue
Nueva funcionalidad
Claridad
Bastante claro
Estado de actividad
Activo
Stack tecnológico
mysql, postgresql, react, rust, sqlite, tauri, typescript
Área
database, desktop

Línea de trabajo

Start with src-tauri/src/driver/{postgres,mysql,sqlite}.rs, src-tauri/src/manager.rs, and src/features/grid/, then read the deferred tasks in docs/notes/plan-03-followups.md and the filtered-count note in docs/notes/plan-05-followups.md. Reproduce the filtered-count and filter-minor behaviors across the listed database paths. Done means the UI can cancel a long filtered count and remain usable, each listed minor has a test or documentation, and the stated test, lint, and Rust checks pass.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

area:backend area:frontend size:M status:ready type:task

Context

Known behaviour from plan 3 Task 8: a high exact_count_threshold setting makes filtered counts scan up to that many rows; they hold the browse connection until done and have no user-facing cancel. Several filter minors from Task 2 and Task 6 are grouped here.

To do

  • Add a user-facing cancel for a running filtered count (Cancelled state in the grid footer, count shown as approximate afterwards); avoid holding the whole browse connection if possible.
  • ILIKE on MySQL _bin collations is case-sensitive: fall back to LOWER() comparison or document it in the filter hint.
  • The any-column filter does not see PostgreSQL bytea[] as binary.
  • PostgreSQL simple-query path maps errors with map_err, not map_live_err (lost-connection classification).
  • MySQL filtered path takes about 5 round trips: merge DEALLOCATE and the variable clear; a KILL in the middle of cleanup may leave session variables set.
  • ILIKE typed in the quick bar is accepted on MySQL / SQLite: hint LIKE instead.

Acceptance criteria

  • A filtered count above the threshold can be cancelled from the UI and the grid stays usable.
  • Each minor fixed with a test or documented.
  • pnpm test && pnpm lint green (plus cargo clippy --all-targets -- -D warnings and pnpm test:rust when Rust changes)

Likely files touched

  • src-tauri/src/driver/{postgres,mysql,sqlite}.rs (filters, counts)
  • src-tauri/src/manager.rs
  • src/features/grid/ (filters bar, footer)

Linked docs

  • docs/notes/plan-03-followups.md (Deferred Task 2, Task 6, Task 8)
  • docs/notes/plan-05-followups.md (Open: filtered counts)
Lenguaje dominante
TypeScript
Estrellas
0
Forks
0
Merge medio
1 h 19 min
PR fusionados (30 d)
28

Preparar el entorno

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de Cemoche/tablemax

Todos los issues de Cemoche/tablemax

Issues similares

Más issues de TypeScript

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.