Blog of Raivo Laanemets

An information system to manage shipping. The system helps to plan, price and track shipments. The application is used by Lasita Maja AS. Lasita produces log cabins and ships them to retail partners all around Europe. Shipping is done through 3rd party service providers. The application includes a small Android phone app to take photos of loaded trucks before they are sent out and to automatically upload and associate the photos with shipment orders. The system was built around the previously developed app Koormaplaanid.

There is a longer writeup about the project.

Technology

• Node.js
• ExpressJS
• React
• Bootstrap
• DroidScript
• MySQL

A dialog system with questions and yes/no and selection answers. I built it to learn about the React framework. The application can be used online from https://project.rlaanemets.com. The set of questions is structured as a tree data structure that is supposed to ask questions "intelligently". It only asks certain top-level questions and then proceeds to ask only those questions that make sense by previous answers.

Technology

• React

I consolidated a number of forks of the existing Node.js and SWI-Prolog language bridge, merged different features of them and published on the NPM registry.

As I was not satisfied with technical constraints of the native addon based language bridge, I created another one that works over standard IO.

• GitHub: https://github.com/rla/node-swipl
• STDIO-based: https://github.com/rla/node-swipl-stdio

A web app to optimize 2D package layout for trucks. It provides a simple UI to enter package details and then construct the load by drag-and-drop. Load construction is made easier by using colorful labels and backgrounds. The application is used by Lasita Maja AS.

Technology

• KnockoutJS
• Bootstrap

Screenshots

The package data input area and the work area:

A set of proprietary tools for controlling specific desktop apps with hardware connected through Raspberry Pi. The project contains:

• A software component for Raspberry Pi written in Python. The software receives events from various sources, including Flic.io buttons and the GPIO header pins and sends TCP packets corresponding to the events.
• A web application to configure Pi's remotely. Built as a ExpressJS web application with MySQL as the data storage.
• A desktop application to run certain actions based on TCP packets received from Pi's. The application was built onto the Electron platform using the Vue.js framework.
• A set of small network applications acting as a hub for distributing events between the desktop machines. Written in Node.js.

Technology

• Raspberry Pi
• Python
• Flic.io
• JavaScript
• Electron
• Vue.js
• ExpressJS
• MySQL

This application started from a weekend project to automatically detect bot visitors and create corresponding filters for Google Analytics (GA). However, at some point of time I started to use it as the main visitor tracker on this blog and some other sites. It allows to browse individual visitor sessions, something that is not possible on GA. Due to not being a widespread solution, it also attracts a lot less referral spam. The code is Open Source and available on GitHub.

• Blog article: https://rlaanemets.com/post/show/announcement-session-viewer
• GitHub: https://github.com/rla/human-track

Technology

• Node.js
• ExpressJS
• Bootstrap
• MySQL

Screenshots

List of session and a single session view:

Simplest single-line chart library. Draws the chart using the HTML5 canvas. I built it as I needed something fully responive that I can easily drop into any project that needs simple line charts.

Rendering output:

• GitHub: https://github.com/rla/dataline
• Demo: http://demos.rlaanemets.com/dataline/example.html
• Blog post: https://rlaanemets.com/post/show/announcement-dataline-chart-library

DOM-EEE is a small Open-Source declarative portable library for extracting data from web pages. I wrote it to simplify development of web scrapers. The library can be used in many JavaScript environments: browsers (userscripts), PhantomJS, Node.js (through Cheerio or jsdom).

• GitHub: https://github.com/rla/dom-eee
• Blog post: https://rlaanemets.com/post/show/announcement-dom-eee

A frontend web application to browse and monitor logs stored inside a MySQL database. The application started as a proprietary solution to monitor various projects but later I released it as Open Source. The application replaced my previous solution using a SaaS service that became a bit too pricey for my logging volume. The system also monitors log events from uptime, domain expiration, and SSL certificate expiration check scripts.

• GitHub: https://github.com/rla/mysql-syslog-viewer
• Blog post: https://rlaanemets.com/post/show/announcement-mysql-syslog-viewer

Technology

• Node.js
• ExpressJS
• Bootstrap
• MySQL
• Rsyslog

Screenshots

An automated system to place sports bets using data gathered from specific sites. The system scraps data from sites and places bets using the API provided by Pinnacle, an online bookmarker. The data on the system is stored in an optimized MySQL instance, running queries on 100k+ of rows in 1-2ms. Part of the system was implemented in SWI-Prolog.

Technology

• Node.js
• ExpressJS
• MySQL
• SWI-Prolog
• Pinnacle API

Internal electronic voting system for the Estonian Free Party (Vabaerakond). Includes a voting interface with various types of questions for voters and an administration section to manage question, to manage party members, and to see report of votes on the current questions. The system is intergrated with the cryptographic Estonian ID-card and Mobile-ID APIs to support secure voting.

• Link: https://vali.vabaerakond.ee/

Technology

• Node.js
• ExpressJS
• MySQL
• Bootstrap
• KnockoutJS
• Estonian ID-card APIs
• Mobile-ID APIs

Screenshots

Scale Laser is an online CAD application and e-commerce site for model railroad builders. My role in the project was to build the overal frontend part of the site, the e-commerce system including the cart and payment integration with Stripe and the backend manager/scheduler for production. The first release is still in development.

Technology

• Prolog
• RDF
• Bootstrap
• Stripe

Screenshots

22rolling is a vehicle sales portal. It supports 10 different vehicle types and is localized into 8 countries and 9 languages.

• Link: https://22rolling.ee/en/passenger

Technology

• Node.js
• ExpressJS
• MySQL
• Bootstrap
• KnockoutJS
• Browserify
• AWS S3
• AWS CloudFront CDN

Screenshots

Personal cycling and running blog. The blog is built onto the Blog-Core framework. The site design is also created by me.

• Link: http://cycling.rlaanemets.com/

Technology

• Blog-Core

Screenshots

Photo gallery generator. I did not find gallery generator that satisfied all my needs and I had to build my own. This one supports nested albums, incremental building, metadata in JSON, custom templates (EJS) and generates gallery output into a separate directory tree from the source directories. It is built as a Node.js command-line application and uses ImageMagick to generate thumbnails.

• GitHub: https://github.com/rla/gallery-gen
• npmjs.org: https://www.npmjs.com/package/rla-gallery-gen
• Example: http://gallery.rlaanemets.com/

Technology

• Node.js
• ImageMagick

Journaled in-memory JSON database for PhantomJS. The data file format is compatible with Node.js package dirty. The library simplifies development of web scraping code by not requiring external database in projects where it is not needed.

• GitHub: https://github.com/rla/phantomjs-dirty
• npmjs.org: https://www.npmjs.com/package/phantomjs-dirty

Helper library to make it easier to build KnockoutJS-base Single-Page-Applications. Offers more flexibility than built-in KO components and prevents unnecessary reflows.

• GitHub: https://github.com/rla/kontainer
• npmjs.org: https://www.npmjs.com/package/kontainer
• Blog post: http://rlaanemets.com/post/show/kontainer-template-viewmodel-lifecycle-manager-for-knockoutjs

A traffic bot to generate real-looking traffic for a specific site using the headless scriptable browser PhantomJS. The bot starts from a random referral page and visits random links on the site. The amount of generated traffic depends on the number of the launched parallel processes of the bot and the configured delay between selecting the next navigation link.

Technology

• PhantomJS

Personal homepage, blog and portfolio page.

• Live site: you are browsing it!
• GitHub: https://github.com/rla/blog

Technology

• Blog-Core

Company homepage for Infdot OÜ. The site has been a test ground for various web technologies and has been rewritten many times.

• Link: http://infdot.com (not maintained since 2017-01-01, redirects to this blog)

Technology

• Blog-Core

Screenshots

Blogging/CMS framework. Fills the gap in Prolog web frameworks. Comes with a set of simple themes.

• Link: http://blog-core.net
• GitHub: https://github.com/rla/blog-core
• Themes: https://github.com/rla/blog-core-themes
• Pack: http://www.swi-prolog.org/pack/list?p=blog_core

Technology

• SWI-Prolog
• KnockoutJS
• Bootstrap
• Markdown
• Less

An HTML templating library for SWI-Prolog. Installable as a pack.

• Pack: http://www.swi-prolog.org/pack/list?p=simple_template
• GitHub: https://github.com/rla/simple-template

A data structure validation library for SWI-Prolog. Inspired by JSON-Schema but also includes support for Prolog terms. Installable as a pack.

• Pack: http://www.swi-prolog.org/pack/list?p=dict_schema
• GitHub: https://github.com/rla/dict-schema

HTTP router for SWI-Prolog. Uses path expressions (like post/show/Slug) containing logical variables to denote URL paths. Simplifies web application development in Prolog. Installable as a pack.

• Pack: http://www.swi-prolog.org/pack/list?p=arouter
• GitHub: https://github.com/rla/alternative-router

Sorts list of dicts by a key in dict. Installable as a pack. Recent SWI-Prolog releases contain the sort/4 predicate which obsoletes the library.

• Pack: http://www.swi-prolog.org/pack/list?p=sort_dict
• GitHub: https://github.com/rla/sort-dict

An in-memory document-based transactional database for SWI-Prolog. Used as the database in the Blog-Core project. Installable as a pack.

• Pack: http://www.swi-prolog.org/pack/list?p=docstore
• GitHub: https://github.com/rla/docstore

A Markdown parser for SWI-Prolog. Installable as a pack.

• Pack: http://www.swi-prolog.org/pack/list?p=markdown
• GitHub: https://github.com/rla/prolog-markdown

A Bash shell script to clone/pull user's GitHub repositories.

• GitHub: https://github.com/rla/github-backup

An implementation of Promises/A+ by translating the spec directly into code. Passes the test suit but is quite slow. Done for fun.

• GitHub: https://github.com/rla/slowises

AVR MCU-based cooling system for PC. The project includes a firmware for AVR and a setup/configuration utility for PC. Built for evaluating an AVR MCU and the avr-gcc compiler. Also done for fun. Deployed to provide silent cooling for my main computer.

• GitHub: https://github.com/rla/cooling
• Blog post: http://rlaanemets.com/post/show/avr-based-cooling-fan-controller

Technology

• avr-gcc
• Node.js serialport package

Photos

A web scrapper for extracting timetables from homepages of UK cinemas. The project included custom web scrappers for about 20 different sites using the scripted headless browser PhantomJS. It also included a Node.js-based web app to store the extracted data in a MySQL database.

Technology

• PhantomJS
• Node.js
• ExpressJS

A web scrapper to extract sports betting data from the BetExplorer site. The project included a PhantomJS-based scrapper to extract the data and scripts to calculate the required statistics from the extracted data.

Technology

• PhantomJS

An online poker news and affiliate site.

Technology

• WordPress

Screenshots

A network of online gambling affiliate sites to serve as landing pages from other marketing channels. Built onto WordPress with custom design and theme.

Technology

• WordPress

Screenshots

Ledlamp.ee is an online web store for LED lamps. I inherited the project and did not build the initial version. I helped to relocate the project to the new hosting provider and fixed issues with frontend HTML and PDF invoices.

• Link to site: http://www.ledlamp.ee/

Technology

• Magento

Screenshots

Logi.ee is a web-based diary for physical activity. My role in the project was to be a technical mentor. I contributed the backend code for integration with the Fortumo and Sendsmaily services.

• Link: http://logi.ee/

Technology

• Node.js
• ExpressJS
• MongoDB
• Mongoose
• Fortumo
• Sendsmaily

Screenshots

Continuous Integration script to run project build/test and write result into a log. Supports Git only. Works in cases when Jenkins is overkill. The build log output is supposed to be monitored by a realtime logging service.

• GitHub: https://github.com/rla/log-ci

Attempt to document the offline database synchronization system developed for the FitSmarty project. The code sets up a MySQL database and two SQLite databases. Then runs random operations in them, synchronizes, and checks consistency. The code is very verbose but works.

• GitHub: https://github.com/rla/sql-sync

Client-side hashchange regex router for singe-page applications. Works on Chrome 5, Firefox 3.6 and IE 10+. Initial codebase was extracted from one of my frontend projects. Since then it has been improved with methods required for other projects. The library includes support for asking confirmation to leave the current route. This feature was not supported by other front-end router libraries.

• GitHub: https://github.com/rla/router
• npmjs.org: https://www.npmjs.com/package/hash-regex-router
• Blog post: http://rlaanemets.com/post/show/router-renamed-to-hash-regex-router-and-upgraded

Small library for making REST queries. It takes away the most verbosity of using XMLHttpRequest and has hooks for request start/end. It is now rendered obsolete by the browsers new built-in fetch API and the Promises.

• GitHub: https://github.com/rla/xhr-json

Keha Arengu Monitooring (KAM) is a computer software to track person's health and fitness. It was initially based on the popular Excel worksheet distributed at tervislik.net. The objective of the project was to implement the application which would be more usable, more maintainable, and with more features than the Excel worksheet. FitSmarty was the English localization of the application.

• Link: http://kehakool.ee/

Technology

• C++
• Qt
• SQLite
• NSIS

The application supports all 3 desktop platforms: Windows, Mac OS X and Linux.

Screenshots

The web/mobile port of the KAM/FitSmarty project.

Technology

• Node.js
• MySQL
• KnockoutJS
• Jade
• Stylus

Included custom offline data replication between MySQL master and SQLite slaves.

Screenshots

Custom CRM to handle sales of the KAM software. It includes the frontend store view and the backend with user management, sales, license key management and invoicing.

Technology

• Yii Framework
• MySQL
• wkhtmltopdf (for PDF invoices)

Includes integration with Estonian banks to handle payments.

Helper application to track users of KAM/FitSmarty software. It includes both the web application for collecting statistics and displaying reports and the client code to send application usage events from the desktop software. The application took 3 days to put together.

Technology

• Node.js
• MongoDB
• KnockoutJS
• Bootstrap
• ExpressJS
• MongoLab
• AppFog cloud

Personal web-based replacement for Google Reader and other feed readers. It tracks seen/read/important state of articles and is built for high performance. Scales well beyond 500 feeds that the most other feed readers struggle with.

• Live application: http://feeds.rlaanemets.com/#unseen (most actions require authentication)
• GitHub: https://github.com/rla/feeds

Technology

• Node.js
• SQLite
• fast-feed

Node.js binding for the RapidXML parser for very fast newsfeed parsing.

• GitHub: https://github.com/rla/fast-feed
• npmjs.org: https://www.npmjs.com/package/fast-feed

The Estimator is an application for estimating the time that a project takes. It divides the project into components and components into tasks. The tasks are estimated to take min to max hours. The app then calculates total min to max hours for the whole project.

The application was built to evaluate the KnockoutJS and Bootstrap frameworks.

• Live application: http://demos.rlaanemets.com/estimator/
• GitHub: https://github.com/rla/estimator

Technology

• KnockoutJS
• Bootstrap

Uses the localStorage API to store data.

Proof-of-concept source-to-source Prolog to JS compiler. Includes a translator written in Prolog and a small runtime (200 loc) written in JavaScript. It can run simpler programs, like the queens benchmark.

• GitHub: https://github.com/rla/prolog-target-js

Technology

• SWI-Prolog
• JavaScript

A RESTful API for entering time logs remotely. The API uses HTTP GET/POST with JSON-based messages and error handling. My scope of the work was writing the initial API specification.

• Link to application: https://cworklog.com/

An offline Android client for CWorkLog.

• GitHub: https://github.com/rla/cworklog-android

Technology

• PhoneGap
• Plain HTML5 and JavaScript

Screenshots

A Prolog library to parse YAML documents. Supports only a good subset of YAML.

• GitHub: https://github.com/rla/prolog-yamltiny

A double-entry financial journal. Keeps records in YAML files.

• GitHub: https://github.com/rla/placcounting

Sitecheck is a Bash script to monitor a number of web sites. It periodically queries the list of sites and logs the OK/FAIL result. The log itself can be monitored using a real-time logging service.

• GitHub: https://github.com/rla/sitecheck

Specification and code for the thread analysis (main only, unique, many) of the C language for the Goblint static analyzer. The thread analysis was supposed to reduce the number of false positives from the thread locking/synchronization analyzer.

• Goblint's repository: https://github.com/goblint/analyzer

A toy project to study the problem of dataflow analyses during the time I prepared my master thesis. The code includes many common analyses used by compilers.

• GitHub: https://github.com/rla/while

LLJ is a Prolog-like logic language for running on JVM. It allows close integration with Java libraries. The source code is extensively commented and covered with a high number of test cases. At the time of release it was faster and more memory efficient than many other Prolog implementations on JVM.

• GitHub: https://github.com/rla/llj

Technology

• Java
• Prolog
• Maven
• JUnit

A Redmine plugin to automate release file management. The plugin allows the build artifacts to be uploaded into Redmine File's section using curl or a similar HTTP utility.

• GitHub: https://github.com/rla/redmine_infdot_upload

A project to provide fast and accurate search results from a collection of existing documents. The project also included PHP scripts to dump documents into the search database. The search application was tuned to retrieve the search results from over 100000 documents in less than 0.1 seconds.

• Link to live system: http://oshosearch.net/Convert/search.php?q=meditate&area=Consciousness&col=Osho&cat=All

Technology

• Solr
• WordNet

The WordNet database was used for implementing synonyms support.

An online pool (8-ball) game. The game features game rooms, chat and pool game between 2 players and observers.

• Open Sourced in 2013: https://github.com/rla/bcup

Technology

• Java Applets
• Spring framework
• Project Lombok
• MySQL
• ANT

Ignition starter for vehicles with internal combustion engines. The project included custom circuit design and firmware.

Technology

• PIC MCU
• HiTech C compiler

Photos

Part of a coursework to implement a compiler for a lazy functional language called Puf. The project implemented compiler in the Java language. I worked together with Merli Uus. My contribution was mostly the parser and the optimizations.

• Original Google Code repo (defunct soon): http://code.google.com/p/puf-vam-impl/
• GitHub: https://github.com/rla/puf-vam-impl

Technology

• Java
• ANTLR

My old blog engine. Written to evaluate some new (at the time) Java technology. It never got any posts.

• GitHub: https://github.com/rla/old-blog

Technology

• Java
• Maven
• Wicket
• OpenJPA
• OsCache

The Seals Database for the National History Archive. My responsibility was to gather requirements from the archive specialists, document them, produce the application specification, and later test the actual application against the specification. The set of acceptance tests was implemented using the Selenium test utility.

• Live site: http://www.ra.ee/pitserid/

A web-based front-end for mplayer. It extracts metainfo (title, artist and album) from music files (mp3 and flac) and makes it easy to create playlists based on this info. The metainfo is extracted using the entagged library.

• GitHub: https://github.com/rla/media

Technology

• Java
• Wicket
• Prevayler
• Maven

Self-service portal for Elion customers. Elion is the largest telecom company in Estonia. I worked in a team of 6 people as a Java programmer. My responsibility was to implement features based on the HTML prototype and specification documents. Large part of the work involved writing PL/SQL unit tests for the legacy Oracle database.

Technology

• Java
• Oracle
• Spring Web Flow

The repo with ancient code going back to 2001: https://github.com/rla/old-code