[My SQL] With Recursive CTE(Common Table Expression)???
When you have one table for all of codes in your system, it is often to have unique_code and parent code in that table. It enables to track down hierarchical structure of codes to see who is parent or child of that record. MySQL Recursive CTE make is simple and clear to query those relationships […]
[Moodle] Running Moodle from Docker Image
Bitnami provide docker image for Moodle and it can be found in https://hub.docker.com/r/bitnami/moodle. In fact Bitnami provides a variety of Docker images, but I am not that familiar with this company. It looks solid though. docker-compose.yml file can be downloaded from their repository on GitHub. https://github.com/bitnami/containers/tree/main/bitnami/moodle You can copy docker compose yaml file and starts […]
[Crowdmark] Dashboard Composer Package
PHP Composer package named Crowdmark Dashboard is created to support large number of courses and participants. Repository is available on GitHub as https://github.com/waterloobae/CrowdmarkDashboard Composer package can be installed with Other details are available from repository. Instructions for Composer Package Install this packageĀ Copy /config/API_KEY_Example.php file as API_KEY.php. Then assign your Crowdmark API key to ‘$api_key` […]
[Crowdmark] Adding Crowdmark into Moodle through LTI 1.3 Advantage
In order to start this process, contact Crowdmark support for their end setups. It works best if you can set this up with Crowdmark together. It takes only about 10 minutes to set this up. In your Moodle, go go “Site administration” -> “Plugins” -> “Activity modules” ->”External tool”. Then, click “Manage tools”. You can […]
[Laravel] Laravel Blade Templates – overly simplified
I am going to use Laravel Blade Templates to render H1 tag in orange. It is overly simplified Laravel Blade Templates guide line. The full documentations are available on https://laravel.com/docs/blade First of all, create any customized resources you need like css, js or image files under /public directory. I am going to create /public/waterloobae.css as […]
MEC Origami LTD Folding Bicycle

MEC.ca has been producing a limited selection of folding bicycles. In the past, their lineup included a 24-inch model and some equipped with Shimano hub gears. However, the price was always a barrier for me, so I could only admire them without making a purchase. Initially, MEC’s folding bicycles were based on Dahon models, but […]
[Crowdmark] Reading Crowdmark cover page with locally installed Llama 3.2 Vision 11B
To experiment how to collect student information when student rooster is not predefined, reading Crowdmark cover page with locally installed Llama 3.2 Vision 11B was attempted to evaluate the accuracy of OCR function from the model. The image is one of typical Crowdmark cover page with QR code and the area for the student first […]
[Laravel] How to build Laravel application with Docker 2/2
What is this? When more than one developer or machine are needed for development, repository like Git makes the task easier. This article explains how to add new machine or a new developer to your development team while using Laravel Sail/Docker. 1. Clone the repository to your local machine You can clone the repository with […]
[Llama] Using Llama 3.2 11B Vision with Ollame in your local machine
After you install ollama, you can pull the model. Then, start ollama. It will start server can respond you with local AI which is Llama 3.2 11B here. Ollama provide Python and JavaScript Libraries you can install with pip and npm respectively. The details can be found https://ollama.com/blog/python-javascript-libraries Some other examples are also available from […]
[Laravel] How to build Laravel application with Docker 1/2
First Setup Run following command from the directory you would like to start building Laravel application. Then, Sail script is also installed in the application directory. Sail helps to run artisan command in to application Docker containers. So, it is easier to include sail in the PATH environment variable. To make sure this is always […]