Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TSV database #29

Open
Tracked by #39 ...
brainwo opened this issue Apr 26, 2024 · 0 comments · May be fixed by #52
Open
Tracked by #39 ...

TSV database #29

brainwo opened this issue Apr 26, 2024 · 0 comments · May be fixed by #52
Assignees
Labels
enhancement New feature or request p1 Important issue
Milestone

Comments

@brainwo
Copy link
Owner

brainwo commented Apr 26, 2024

Ideally the database should be located in different file. Using TSV would be much helpful for personal data processing.
SQLite should support writing to TSV, however I'm not sure if it would be the best fit.

Why TSV?

Easiest format to process. All you need is GNU coreutils:

cat data.tsv | tail -n +2 | cut -d$'\t' -f2 | sort

This example reads second column of a TSV file without its header and sort them.

Other considerations:

JSON

JSON is also easy, there is jq. But it requires installation.

CSV

Can be easy, but parsing quoted field adds extra works.

@brainwo brainwo added the enhancement New feature or request label Apr 26, 2024
@brainwo brainwo added this to the Release 0.1 milestone Apr 26, 2024
@brainwo brainwo self-assigned this Apr 26, 2024
@brainwo brainwo pinned this issue Apr 26, 2024
brainwo added a commit that referenced this issue Apr 29, 2024
- Add rss_dart dependency
- Add Feed page
- Move configPathLookup to const.dart
- Video duration is now optional on ListItemVideo
- Error thumbnails now show an icon
- Add setting entry for feed list
- Add helper functions to read and write to feed.yaml
- !Feature regression: video history disabled due to support for videos from Feed, will be added back in #29
@brainwo brainwo linked a pull request May 5, 2024 that will close this issue
3 tasks
@brainwo brainwo linked a pull request May 5, 2024 that will close this issue
3 tasks
@brainwo brainwo changed the title CSV database TSV database May 15, 2024
@brainwo brainwo added the p1 Important issue label Sep 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request p1 Important issue
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant