Maybe rewrite the library
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
John Oss 61e1ee5cbc Add default backup for the database 6 months ago
db Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
.gitignore Initial commit 6 months ago
LICENSE Initial commit 6 months ago
README.md Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
catalogue.db Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
go.mod Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
go.sum Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
goread Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
main.go Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
new-catalogue.db Add default backup for the database 6 months ago
permissions.go Day 1: Worked out more robust schema, wrote some go code for interacting with it. 6 months ago
schema.sql Add default backup for the database 6 months ago

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