HOWTO : SQL Joins
A simple and useful visual of joins in SQL by Taylor Brownlow from this post https://towardsdatascience.com/take-your-sql-from-good-to-great-part-3-687d797d1ede
Databases
HOWTO : Query json data in SQLite
A self note for querying json data in SQLite. BTW, I think SQLite is an under utilized and under appreciated swiss army tool for data storage...
HOW TO : Search for a record in MongoDB based on length
Quick entry for my own records. MongoDB is one of the popular open source document database that is part of the nosql movement. One of the...
Project Uptime : Progress Report 5 : Getting ready for Reddit and Hacker News
A very timely post on Hacker News by Ewan Leith about configuring a low end server to take ~11million hits/per month gave me some more ideas...
Project Uptime : Progress Report – 3
Things have been a bit hectic at work.. so didn’t get a lot of time to work on this project. Now that that the new server...
HOW TO : Dowload content from Oracle Metalink (Support) using wget
The usual process for a DBA to download files from Oracle Metalink (support) site is Login to Metalink from his/her workstation Download the file Upload the...