Results 1 to 5 of 5

Thread: Best way to setup an ebook site

  1. #1
    Join Date
    Oct 2007
    Location
    Kentucky, USA
    Beans
    731
    Distro
    Ubuntu

    Best way to setup an ebook site

    I have an employer who wishes to charge a monthly fee for users to be able to read ebooks (unlimited number of them). The employer has a text format in which the ebook must be submitted to the site, the site will then pick apart the book as the user requests it's individual chapters. I wondered if it would be better to place the books into a MySQL directory (chapter by chapter) and show them to the user that way. The book list could get pretty large so the database itself would get big soon as well. How would I go about a distributed database scheme? We're expecting thousands of books as we will accept user submitted content. The entire site is also running off of python with an Ubuntu server (if that makes any difference).
    Which is more important in obtaining the truth, "what" or "why"? Trick question. They are of equal importance.
    Freely ye have received, freely give.

  2. #2
    Join Date
    Nov 2007
    Location
    Wisconsin
    Beans
    1,139

    Re: Best way to setup an ebook site

    Seems like the user should have a local client, to track the current books/chapters, hold bookmarks, download the next, update account information, etc.
    That client should be in charge of "showing" titles and handling the user's search/browse input and translating that into your server SQL search.

    Are you only doing the database? Or are you involved with the larger customer activity flow design?

  3. #3
    Join Date
    Feb 2007
    Location
    West Hills CA
    Beans
    8,585
    Distro
    Ubuntu 12.10 Quantal Quetzal

    Re: Best way to setup an ebook site

    I would look at http://drupal.org or another content management system (CMS). There are several plug-ins to drupal for e-commerce and it uses mysql or PostgreSQL so it will scale as your book collection grows.
    -------------------------------------
    Oooh Shiny: PopularPages

    Unumquodque potest reparantur. Patientia sit virtus.

  4. #4
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    9,041
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: Best way to setup an ebook site

    I generally prefer to let the operating system manage file storage and just place URIs in the database. I don't see any gains to putting the books themselves into the database.
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  5. #5
    Join Date
    Feb 2008
    Beans
    4,300
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Best way to setup an ebook site

    Excellent thought! That way a book probably takes, I dunno, maybe 10 KB of space in the database. A million books, 10 GB.

    You certainly don't want a single folder containing all the chapters of all the books. Even advanced files systems bog down at some point.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •