{"id":4577,"date":"2021-02-01T17:35:33","date_gmt":"2021-02-01T17:35:33","guid":{"rendered":"http:\/\/weijia.io\/?page_id=4577"},"modified":"2022-08-24T23:46:31","modified_gmt":"2022-08-24T23:46:31","slug":"book-playlist","status":"publish","type":"page","link":"https:\/\/www.weijia.io\/zh\/book-playlist\/","title":{"rendered":"CSE 412 Book Playlist Project"},"content":{"rendered":"<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"513\" src=\"https:\/\/weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-frontpage-1024x513.png\" alt=\"\" class=\"wp-image-4585\" srcset=\"https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-frontpage-1024x513.png 1024w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-frontpage-600x301.png 600w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-frontpage-300x150.png 300w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-frontpage-768x385.png 768w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-frontpage.png 1157w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-justify\">In CSE412: Database Management, our team made a smart book recommendation website. Users added their favorite books to the system and our website will recommend relevant books for them based on their favorite books. Our database stores more than a million rows of data, which is also a good reference for recommendations.<\/p>\n\n\n\n<p><a href=\"https:\/\/ebook-ce845.web.app\" data-type=\"URL\" data-id=\"https:\/\/ebook-ce845.web.app\"><strong>Click here to see our website<\/strong><\/a><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/github.com\/SWeijia\/ebook_Web_Application\">Click here to see c<\/a><a href=\"https:\/\/ebook-ce845.web.app\" data-type=\"URL\" data-id=\"https:\/\/ebook-ce845.web.app\">ode<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p style=\"font-size:24px\"><strong>About Project<\/strong><\/p>\n\n\n\n<p>In this project, I was mainly responsible for the Data Processing of the whole project (including Data cleaning before Data import, SQL statement design, database maintenance), database building, and providing technical support for website builders in terms of database. <\/p>\n\n\n\n<p>Data source provided by <a href=\"https:\/\/www.goodreads.com\" data-type=\"URL\" data-id=\"https:\/\/www.goodreads.com\"><em>Goodreads<\/em><\/a>.<\/p>\n\n\n<p><span>The technologies used:<\/span><\/p>\n<ul>\n<li>PostgreSQL<\/li>\n<li>React.js<\/li>\n<li>Bootstrap<\/li>\n<li>Node.js<\/li>\n<\/ul>\n<p>Team members:<\/p>\n\n\n<div class=\"wp-block-themeisle-blocks-advanced-columns has-2-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-collapsedRows-layout has-nogap-gap has-vertical-unset\" id=\"wp-block-themeisle-blocks-advanced-columns-dd0bcf8c\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div class=\"wp-block-themeisle-blocks-advanced-column\" id=\"wp-block-themeisle-blocks-advanced-column-745ea76c\">\n<ul class=\"wp-block-list\"><li>\u7d22\u4f1f\u5609<\/li><li>Mitchell Bucklew<\/li><li>Qingya Chen<\/li><\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-themeisle-blocks-advanced-column\" id=\"wp-block-themeisle-blocks-advanced-column-c49f3863\">\n<ul class=\"wp-block-list\"><li>Christopher Canales<\/li><li>Tsz San Chong<\/li><li>Ting Xia<\/li><\/ul>\n<\/div>\n<\/div><\/div>\n\n\n\n<p>Now, let&#8217;s see how it&#8217;s work.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"635\" src=\"https:\/\/weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-login-1024x635.png\" alt=\"\" class=\"wp-image-4600\" srcset=\"https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-login-1024x635.png 1024w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-login-600x372.png 600w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-login-300x186.png 300w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-login-768x476.png 768w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-login.png 1167w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Register page<\/em><\/figcaption><\/figure>\n\n\n\n<p>This page allows the user to create a new account, the userid is randomly assigned by the system, and the user is notified when log in.<\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"675\" src=\"https:\/\/weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-main--1024x675.png\" alt=\"\" class=\"wp-image-4597\" srcset=\"https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-main--1024x675.png 1024w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-main--600x395.png 600w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-main--300x198.png 300w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-main--768x506.png 768w, https:\/\/www.weijia.io\/wp-content\/uploads\/2021\/02\/book-playlist-main-.png 1504w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Main pages <\/em><\/figcaption><\/figure>\n\n\n\n<p>The home page displays the user&#8217;s list of books. On the left is a list of books that we randomly generate, which changes every time. The top right shows the user&#8217;s favorite books. If you click the &#8220;Recommend?&#8221; below, system will recommend corresponding books for users based on user data of more than 1 million lines in the background.<\/p>\n\n\n\n<p class=\"has-text-align-center\">If you have any questions, please contact me : )<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In CSE412: Database Management, our team made a smart book recommendation website. Users added their favorite books to the system and our website will recommend relevant books for them based on their favorite books. Our database stores more than a million rows of data, which is also a good reference [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"class_list":["post-4577","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/pages\/4577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/comments?post=4577"}],"version-history":[{"count":32,"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/pages\/4577\/revisions"}],"predecessor-version":[{"id":5198,"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/pages\/4577\/revisions\/5198"}],"wp:attachment":[{"href":"https:\/\/www.weijia.io\/zh\/wp-json\/wp\/v2\/media?parent=4577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}