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)
Aggregation (dplyr::summarise) functions and window functions (dplyr::lead, lag, top_n etc.) operate on rows only. Aggregation functions output single row from an input of a group of rows. Window functions output one row per input row.
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.
Various examples on using databases in R
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.
Dün Ali Nesin, egitimpedia’daki söyleşisinde https://www.facebook.com/egitimpedia/videos/1776967268994888/, çocuklara matematik nasıl öğretilir sorusuna şu tür bir yanıt verdi: Soyut düşünme becerisi gelişmeden, ispata dayalı matematik öğretilemez. Bu yüzden ilkokulda soyut matematiği öğretmek doğru olmaz. Fakat ileriki yaşlarda matematik yapabilmek için, en çok gereken beceri konsantrasyondur. Dolayısıyla, konsantrasyon nasıl öğretilebilir, ona bakmalı.