Labels Milestones

New Issue

Full-text searching #155

Open

opened 6 years ago by jking · 0 comments

jking commented 6 years ago

Owner

The following would be required to implement full-text searching in The Arsse:

• An implementation for SQLite
• An implementation for PostgreSQL
• An implementation for MySQL
• A means of disabling full-text indexing to conserve space or processing time
• A basic LIKE-based fallback if the feature is disabled or unavailable for SQLite, already done

The implementations would need to handle not only querying, but also populating the index when articles are added, as well as cleaning it up properly (if necessary) when articles are deleted.

All databases should have an implementation before a release with full-text searching is made.

The following would be required to implement full-text searching in The Arsse: - An implementation for SQLite - An implementation for PostgreSQL - An implementation for MySQL - A means of disabling full-text indexing to conserve space or processing time - A basic `LIKE`-based fallback if the feature is disabled or unavailable for SQLite, already done The implementations would need to handle not only querying, but also populating the index when articles are added, as well as cleaning it up properly (if necessary) when articles are deleted. All databases should have an implementation before a release with full-text searching is made.

jking added the

feature

label 6 years ago

jking added this to the Future milestone 6 years ago

jking added a new dependency 6 years ago

#154 Full-text searching with MySQL

jking added a new dependency 6 years ago

#153 Full-text searching with PostgreSQL

jking added a new dependency 6 years ago

#152 Full-text searching with SQLite

jking added a new dependency 6 years ago

#156 Implement Fever

jking removed a dependency 6 years ago

#156 Implement Fever

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

arch

arch2

dbtest

docker

getopt

master

microsub

phake

reader

redup

rpm

0.1.0

0.1.1

0.10.0

0.10.1

0.10.2

0.10.3

0.10.4

0.10.5

0.2.0

0.2.1

0.3.0

0.3.1

0.4.0

0.5.0

0.5.1

0.6.0

0.6.1

0.7.0

0.7.1

0.8.0

0.8.1

0.8.2

0.8.3

0.8.4

0.8.5

0.9.0

0.9.1

0.9.2

Labels

Apply labels

Clear labels

admin tools api bug documentation duplicate enhancement feature help wanted in progress internals invalid packaging question testing trivial wontfix

No Label admin tools api bug documentation duplicate enhancement feature help wanted in progress internals invalid packaging question testing trivial wontfix

Milestone

Set milestone

Clear milestone

No items

No Milestone

Future

Assignees

Assign users

Clear assignees

No Assignees

1 Participants

Notifications

Subscribe

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Depends on

#154 Full-text searching with MySQL

MensBeam/Arsse

#153 Full-text searching with PostgreSQL

MensBeam/Arsse

#152 Full-text searching with SQLite

MensBeam/Arsse

Write Preview

Loading…

Cancel

Save

There is no content yet.