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.

Sign up for GitHub

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

Jump to bottom

Move SQLite meta items / episode parameters to JSON #29

Closed
danieljsummers opened this issue Aug 20, 2022 · 1 comment
Closed

Move SQLite meta items / episode parameters to JSON #29

danieljsummers opened this issue Aug 20, 2022 · 1 comment
Assignees
@danieljsummers
Milestone
v2

Comments

@danieljsummers
Copy link
Collaborator

There are no queries where these are in a WHERE clause; change them to TEXT fields in the post/page tables, and store them as JSON. This will save extra queries and JOINs.
@danieljsummers danieljsummers added this to the v2 milestone Aug 20, 2022
@danieljsummers danieljsummers self-assigned this Aug 20, 2022
@danieljsummers
Copy link
Collaborator Author

This has been completed, and will be part of v2-rc2

@danieljsummers danieljsummers mentioned this issue Aug 21, 2022
Merged
danieljsummers added a commit that referenced this issue Aug 21, 2022
@danieljsummers
v2 RC2 (#33)
5f3daa1 
* Add PostgreSQL back end (#30)
* Upgrade password storage (#32)
* Change podcast/episode storage for SQLite (#29)
* Move date/time handling to NodaTime (#31)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@danieljsummers danieljsummers

Labels
None yet
Projects
None yet
Milestone
v2
Development

No branches or pull requests
1 participant
@danieljsummers