What is the best way to make an online reader?

Question

Project management

Hello everyone, I like to read books, but I didn’t find the function of saving a fragment and tagging it with a tag in any reader. I need to mark fragments of text with tags in order to find something in common between different books and work with it. Decided to write my bike
While I'm thinking about how to make the backbone itself correctly - books can be stored both in the database and in the file system, fs - it seems like an order of magnitude more economical in terms of resources. And the fragments themselves are already in the database
Stack: ASP MVC, JS, HTML, CSS, MS SQL
I will be glad to comments and advice on the issue

Answer 1

instead of saving pieces of the text of the book - can you get by with simple anchor links?
add an anchor tag to the html document and add the required set of tags to its dataset

Answer 2

Books in files, list of books in the database. Tags in db.
Books: id | title | description | photo | file_path
Tags: id | tag_name
Tags: id | book_id | tag_id | book_line_number_start | book_line_number_finish | comment_id
Comments: id | text

Answer 3

In general, IMHO, but in Alreader there was something similar. But it is offline and on Android.
So, if the reader is online, then you must first decide whether we will store books on the server or where. Again IMHO, but it is better to use third-party resources, and on the server to present the interface for obtaining a book.
Fragments can even be stored in a simpler way - their offset and length. And on the front-end JS they will be highlighted or received.
PS I can help with the frontend a little, it's very interesting)

Answer 4

right now I'm reading in an allreader .... it saves fragments somewhere on the file system ... it seems even stupidly pours everything into one file ....
What's the problem? Books weigh a penny, and disk memory is quite accessible;
fragments can be stored in the database .... since for information about them, you still need to make a request, and then read the file to get a fragment, it turns out double work ...
this would be very handy, I'm not very friendly with the frontend, I didn't find any connection in your profile...
so I found a ready implementation of the frontend https://tympanus.net/codrops/2012/12/11/fullscreen... really needs to be tweaked