This document explains how to generate sample data for any database automatically from its database schema defined as DDL
statements.
I wanted to automate the process from data modelling to testing it with sample data in actual database.
RDB
is the abbreviation for requirements database. Requirements database stores the requirements information in structured relational format in Excel or tsv files.
This document is a work-in-process. I will work on it.
Association rules is used as a common recommendation algorithm.
Most of the examples are taken from fzf wiki: https://github.com/junegunn/fzf/wiki/Examples-(vim)
Debugging a weird problem
Bug: Using data.table inside own package messes up bracket []
operator
Rmarkdown examples
How to use and format time and date information in R.
datapasta is an R tool to generate reproducible code documentation.
There are too many ways of looping in R data structures. Here is an unfinished summary of them.
datafiller is a tool to generate SQL from DDL files.
My study notes and examples to remember how to use bash arrays.
My study notes and examples to remember how to loop in bash.
jq is a very powerful tool for json parsing. Here are a few examples on how to use it.
My study notes on R from various sources.
My reading notes from the book
My reading notes from the book
My study notes from the video training.
This is an old book but it is one of the best programming books ever written.