SQLite Quote Database That I Use for My Lockscreen
I’ve been using Zen Quotes API for a while now. It’s a great app that provides quotes for my lockscreen. But I was unable to filter based on author. So I decided to create my own personal quote API. First I needed a source of quotes. I found datasets of quotes on Kaggle Quotes Dataset and Quotes-500K. I think these datasets were created by scraping the web for quotes. The Plan Create sqlite database to store quotes. Create table quotes with columns quote, author, tags. Import quotes from the dataset. Perform READ operations on the database. easy peasy. The Implementation The problem is that one dataset is in csv format and the other is in json format. We need a common format to import the quotes into the database. I decided to convert the json dataset to csv format. Time to flex my command-line-fu. ...