A container for all my views with excerpts from technology, travel, films, books, kannada, friends and other interests. I am Thejesh GN, friends call me Thej.
I run the microblog.pub as my ActivityPub server. Since I had almost reached 100+ followers and following, I was curious about the diversity or spread of instances. So I wrote some SQL queries to explore the downloaded SQLite.
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.
We have made updates to DataMeet’s COVID19 dataset to include new columns. Also, we have added SQLite DB. In case you like SQLing.
Table of Contents1 System2 Install SQLite3 and Libreoffice Base3 Install UnixODBC4 Install SQLIte ODBC Driver5 Configure ODBC – Driver6 Configure databases to be used by ODBC – Data Source Name (DSN)7 Use your SQLite in Libreoffice Base7.1 Setup7.2 Create a Report8 Remember9 Footnotes I love SQLIte for its simplicity, portability and stability. Most...
I love personal analytics. Ever since I have started logging using Nomie, I have experimented with data, mostly using spreadsheet. It’s interesting to find patterns and make corrections. Nomie uses CouchDB as the cloud storage. CouchDB is a great database but I prefer a simple RDBMS when I want to query. So sometime...
I have been using SQLite as a format to distribute open data for a while. I also use it to share private data. I do encrypt before sending the private data. Its mostly by putting the sqlite file inside an encrypted container (GPG, TrueCrypt or 7zip encrypted archive). It works as a simple...
There are many ways to subscribe to this blog. Email is probably the best.
Thejesh GN (ತೇಜೇಶ್ ಜಿ.ಎನ್) "Thej" is an Independent Technologist, Hacker, Maker, Traveler, Blogger, InfoActivist, Open data and Open internet enthusiast from Bangalore, India. He loves experimenting with all things life and hence some times he is called hacker and other times duct tape. You can read more about him here. Email [ i @ thejeshgn dot com]. PGP/GPG Keys are here.
(C) Thejesh GN.The views expressed on this site are mine (Thejesh GN) alone and do not necessarily reflect the views of my employer. Please read the terms and conditions before reading or commenting on this blog.
