mugiten/jadb
2
0
Fork 0
Code Issues 45 Pull Requests Actions Activity

Split out Kanji/Reading element's readingDoesNotMatchKanji/news/ichi/spec/gai/nf into separate tables #54

New Issue
Open
opened 2025-05-22 16:06:36 +02:00 by oysteikt · 1 comment
oysteikt commented 2025-05-22 16:06:36 +02:00
Owner
Copy Link

With the addition of the "materialized view" in #44, we can now split out these fields into separate tables to avoid storing a bunch of NULLs

With the addition of the "materialized view" in #44, we can now split out these fields into separate tables to avoid storing a bunch of NULLs
oysteikt added the space-reduction label 2025-05-22 16:24:53 +02:00
oysteikt added this to the Kanban project 2025-06-23 10:33:10 +02:00
oysteikt moved this to Low pri in Kanban on 2025-06-23 10:43:42 +02:00
oysteikt added a new dependency 2025-06-23 12:39:27 +02:00
#40 Word search: optimize word regrouping
oysteikt changed title from Split out Kanji/Reading element's `news`/`ichi`/`spec`/`gai`/`nf` into separate tables to Split out Kanji/Reading element's `readingDoesNotMatchKanji`/`news`/`ichi`/`spec`/`gai`/`nf` into separate tables 2025-06-25 09:18:23 +02:00
oysteikt commented 2025-06-25 11:01:42 +02:00
Author
Owner
Copy Link

We're going to need create/update/delete triggers for JMdict_EntryScore on every individual table. I think that should make this issue dependent on #53

We're going to need create/update/delete triggers for `JMdict_EntryScore` on every individual table. I think that should make this issue dependent on #53
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
search-ux
Improvement in search accuracy, or more powerful search options
 space-reduction
Reduce the amount of space taken up by the database
 time-reduction
Reduce the amount of time taken when creating or querying the database
art
Requires some creativity
 big
This is gonna take a while
 blocked
This issue/PR depends on one or more other issues/PRs
 bug
Something brokey
 ci-cd
Continuous integrals and continuous derivation
 crash report
Report an oopsie
 data source
New data source / use more data from existing data source
 disputed
Kranglefanter
 documentation
Documentation changes required
 duplicate
This issue or pull request already exists
 feature request
good first issue
Get your hands dirty with a new project here
 me gusta
( ͡° ͜ʖ ͡°)
 nix
packaging
question
security
Skommel
 techdebt spring cleaning
The code is smelly 👃
 testing
Poke it and see if it explodes
 ui/ux
User complaints about ergonomics and economics and whatever
 wontfix
Nei, vil ikke
No Label space-reduction
Milestone
No items
No Milestone
Projects
Clear projects
No project Kanban
Assignees
Clear assignees
oysteikt
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Blocks
#40 Word search: optimize word regrouping
mugiten/jadb
Reference: mugiten/jadb#54
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?