A recent data project required the program to emit data tables from node which could be piped to other processes. easy-table is one such package which provided a nice way to output text tables in the console.
(more…)
How to access Gmail using Python
In a previous post we saw how you could access Gmail in NodeJS. In this post we will see how we can access Gmail using Python.
(more…)
Combinatorial row pairing in databases
While working on a database design I came across the problem of finding combinations or ‘cartesian product’ between all the rows between one table to another table, but not repeating the same permutations.
Take the ‘Teams’ table below which lists four cricket teams. We want to create a combination list of matches between each teams.
(more…)
How to read and create zip files in nodejs
As I’ve been working on a small project for the past few months, mostly related to backend processing – files, databases etc. The small part of the project needed the ability to read and write zip files. I found the jsZip npm package adequate for my requirement. This allows me to quickly read and write zip files.
(more…)
Listing files using glob patterns in nodejs
In a previous post we saw how to monitor files changes in nodejs. This was required in a cron job to check which files were changed by the cron process. I also needed to search for files in a particular directory to check which files were newly created by the process. Although this is possible using the file-state-monitor package, I needed the ability to use glob patterns while searching.
(more…)
Fuzzy string matching in NodeJS
String matching is an integral part of any programming language. Many times, however, one requires to get a fuzzy instead of an exact match between strings. Usually in search applications the same word may be spelled differently – which if we do an exact math will return empty results. Fuzzy matching allows you to search for ‘nearby’ strings to a candidate string.
(more…)
How to access Gmail using NodeJS and the Gmail api
If you at any time need to programatically retrieve your Gmail account mails than the only proper way to do that is to use the Gmail api. The following post will show you how to access your Gmail account using the Gmail api and NodeJS. The code will handle all OAuth authentication and token processing.
(more…)
Creating custom stream filters in PHP
In this post we will see how to create a custom stream filter. Streams, first introduced in PHP 4.3, provide an abstration layer for file access. A number of different resources besides files – like network connections, compression protocols etc. can be regarded as “streams” of data which can be serially read and written to.
(more…)