Maybe rewrite the library

Go to file

John Oss 61e1ee5cbc Add default backup for the database		2022-10-06 19:33:42 -04:00
db	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
.gitignore	Initial commit	2022-10-05 13:37:23 -04:00
LICENSE	Initial commit	2022-10-05 13:37:23 -04:00
README.md	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
catalogue.db	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
go.mod	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
go.sum	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
goread	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
main.go	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
new-catalogue.db	Add default backup for the database	2022-10-06 19:33:42 -04:00
permissions.go	Day 1: Worked out more robust schema, wrote some go code for interacting with it.	2022-10-06 12:41:31 -04:00
schema.sql	Add default backup for the database	2022-10-06 19:33:42 -04:00

README.md

goread

Maybe rewrite the library, at the very least migrate to a better schema.

This is a proof of concept, mainly to get myself a bit more knowledgable about how our current library system works.

file.out contains a dump of all tables that have a NULL ISBN.

TODO:

Tighten up the columns w.r.t. null and bad values
Add more checks to ensure data is actually valid / not bad
Ensure we have the books we have in the catalogue
Add UTF-8 support for the UI/UX/storage
Perform normalization on data entered by users (e.g. ISBN sanitization / verification).
Double check formats of everything else