Blogring, aka my Webring
ad to my readers. Only personal blogs or blogs that individuals write are included. It’s done now, and it’s live.
Author: Thejesh GN
Linked List: Tools for SQL Developers
I love SQL. There is nothing like playing with the data once you know it. I give it all the respect a programming language deserves. I store it in files as .sql files, add them git, use configuration to set schema name, etc. I use quite a few tools to deal with SQL (and databases). Here are my most used.
How to Download Them All
One of the primary jobs as a Data Archivist at DataMeet is to download and archive the data from the internet. Mostly from government websites. I usually use python scripts to download, scrape and clean the data. But sometimes, I just need to download many files and store them. I could still use python, but its an overkill. So here are some of the methods that I use.
Jinja2 as a Command Line Application
The most common use of Jinja2 is in web applications, where it is used to create HTML files from template files. But I have used it outside web applications too.
Sending Email to Self with Swaks
Email is one of those protocols that still works. It reaches me where I am. It also has various clients and libraries that work reasonably well. And it can carry almost any kind of content (Of course, there are limitations attachment size and type, etc). I use it every day, including emailing to myself.
Counting Blog Posts using xidel
I wanted to write 100 posts in 2021, and I am nowhere close to that. I tried to look at the posts by year and see how I have performed over the years. Of course, I could have done that manually by looking at the year archive count or running a query on the database. But recently, I have started using Xidel, so why not use it? :)
