Category: Technology

0

Blogring – Web Component using Vanilla JavaScript

I wanted to write a simple web component to display the Blogring. Currently, I have embed.html, I use it in an iframe, inside which we get the data to create the content and set it as the innerHTML of a div. I just wanted a fancy tag that would embed the Blogring.

0

SQLLine – One CLI for connecting to Relational Databases

f you are in the Python world (or not), you probably are using dbcli/pgcli for accessing the Postgres database. pgcli is Postgres CLI with autocompletion and syntax highlighting. Similarly, there are CLIs for MySQL, SQLite, Redis, etc. If you are in the mood to explore other CLI tools, you can trey SQLLine. It’s one CLI for many RDBMS.

0

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.

0

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.

1

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.