Sqlite_bookstore
An example SQLite implementation of an Online Bookstore (well... Marketplace) for my Database Systems class.
| Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
|---|---|---|---|---|---|---|---|---|---|---|
| Web2db | 13 | 3 years ago | 6 | September 22, 2020 | Python | |||||
| Fetch webpage full-text, persist link and full text to SQLITE3 db, resumable with tqdm progressbar. | ||||||||||
| Firelinks | 10 | 11 years ago | Ruby | |||||||
| Sync elinks with Firefox | ||||||||||
| Web Scraping Box Office Mojo | 6 | 5 years ago | Python | |||||||
| for each year scraped the table and collected all tables and made sqlite database. | ||||||||||
| Reask | 4 | 5 years ago | mit | JavaScript | ||||||
| Reask is a project developed with React&Flask. [ Reask 是用 React&Flask 开发的全栈项目 ] :rocket: | ||||||||||
| Sqlite_bookstore | 2 | 8 years ago | Python | |||||||
| An example SQLite implementation of an Online Bookstore (well... Marketplace) for my Database Systems class. | ||||||||||
Alternatives To Sqlite_bookstoreSelect To Compare
Alternative Project Comparisons
Readme
SQLite_Bookstore
An example SQLite implementation of an Online Bookstore
Setup
SQLite
Make sure you have SQLite installed.
Webpage
If you want to use the webpage elements, make sure you have a version of Python 2.X (2.6 or higher). Then install Flask.
Usage
SQLite
Run sqlite3 to open up the SQLite shell.
Run .read create.sql to create the tables and then .read populate.sql to insert the dummy data.
You can now run whatever queries you'd like on the data to test it out.
Webpage
Run python server.py and navigate to the provided link. (Probably 127.0.0.1:5000)
127.0.0.1:5000/books/ will display the book list, while 127.0.0.1:5000/skyler/history will display the transaction history for the USER with the username 'skyler'. This can be done for any user in the system.
Popular Sqlite Projects
Popular Webpage Projects
Popular Data Storage Categories
Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Python
Sqlite
Webpage