July 29th 2017 - Hello World version 2!

Reading time: 5 minutes

Thought of linking my blogger account to my website, but a new website requires a new blog right? So that's why "Version 2". After taking a long hiatus from blogging, I've decided to resume blogging but this time more regularly. Some general topics that will make up this blog will be - social experiments, posts regarding software & tools, programming languages, movie reviews and about my personal experiences, etc.

I just want to keep my first post short & sweet, so I'm just going to say that this blog which is part of my website is also hosted on my raspberry pi Model B with the help of a sqlite database. The database holds the title of the post (Primary key), content and date of the post.

Sqlite + Python

Here are some of the links that will help you get started with sqlite. I intend to create a gist for this soon.

Zetcode SQLite Python Tutorial
Some Stackoverflow questions that helped me when I was stuck

sqlite3.OperationalError: syntax error
sqlite3.ProgrammingError: Incorrect number of bindings supplied.
Remove specific characters from a string in python
Happy coding till I come up with a new post!