These are the best libraries to use for most xlsx reading and writing tasks as of 2019: For Writing – xlsxwriter (don’t us xlwt, it doesn’t support xlsx Format.) For Reading – xlrd (can read both xls and xlsx) Other libraries There’s a library called xlwt for writing to xls, however it is old and… Continue reading Reading and Writing Excel (xlsx) files with Python
Quick Monitor Buying Guide
Deciding the screen size You ought to consider the right physical size in inches with the screen resolution — deviating too much from the following chart would either make the screen too pixelated or you might find the default font size to be too small.
Google Glass never went away!
Google Glass appeared on the scene 7 years ago. There was a lot of excitement around it — a bit like the excitement for the Samsung Fold phone, but didn’t become an immediate hit. Apparently, the project never stopped and the Google Glass team has been milling along. A new video on the Google AR… Continue reading Google Glass never went away!
A very small Git tutorial
1. Github.com is not git 2. You only need to learn these six commands to get started: clone, status, add, commit, pull, push 3. push is akin to uploading your files to the server (for safe-keeping). Before pushing you’ve to write a comment about what you want to push using the commit command. pull is… Continue reading A very small Git tutorial
Setting up Django on Windows IIS Server
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. This post has been built over this very good post by Matt Woodward. The main edits/additions I’ve made to the original article are: Added the section on configuring a MySQL or Sqlite3 database on Windows. Added information on configuring the Firewall to access… Continue reading Setting up Django on Windows IIS Server
Why and When to use Celery with Python Web Servers
“Celery is an asynchronous task queue based on distributed message passing.” Let’s break that down: asynchronous => events happen outside of the main program flow. task queue based=> queues up the tasks to be performed. (The tasks themselves are queued up in a tool like Redis or RabbitMQ.) distributed message passing => multiple processes can… Continue reading Why and When to use Celery with Python Web Servers
Setting up a Python Virtual Environment for Web Development
Virtual Environments help in keeping all the packages required for one project at one place So you can avoid the issues with conflicting dependencies. You may even run different Python versions like 2.7, 3.5, 3.6 on the same system, inside different virtual envs. You can use the following steps when setting up any python project… Continue reading Setting up a Python Virtual Environment for Web Development
Navigating large codebases and contributing to Open Source
(I wrote the following as an email to a someone who asked me for advice. So it’s verbose and written with a personal tone.) I. Setup your system and build the project code Pick any good Integrated Development Environment (IDE). I like VS Code. You can work on any langauge in VSCode be it C++,… Continue reading Navigating large codebases and contributing to Open Source
Django’s Request-Response Cycle
Understanding the Request-Response Cycle is a crucial step in setting up for any WebServer. An example of the request-response cycle is when you “request” a web page by entering a URL in your browser and a web server sends a web page as ‘response’ to your browser. Of course, there’re usually several HTTP requests that… Continue reading Django’s Request-Response Cycle
Designing the Apple Watch UI – a quick guide
The Apple Watch is releasing in a month! Here’s a list of important things you need to know, if you’re interested in designing or developing an Apple Watch App: 1. Layout and Screen Sizes 38mm: 340 pixels x 272 pixels 42mm: 390 pixels x 312 pixels That’s an aspect ratio of 4:5. 2. Icon… Continue reading Designing the Apple Watch UI – a quick guide