Room Status Remotely with OfficeIOT – Haaga-Helia Student Project with Martela

My negotiation rooms are reserved, but is anyone actually there? What’s the utilization rate? OfficeIOT project helps you. It senses if people are in the room and sends this information to a server in the cloud. Users can then log … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Preseed MySQL Server Password with Salt Stack

MySQL is the most popular multi-user database in the world. When you install MySQL Server automatically, you must set database root password without asking user to type it. On Debian and Ubuntu, you can use Preseed to answer installer (apt-get) … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , | Leave a comment

Monty Widenius Speaks in Pasila

Monty Widenius speaks in Haaga-Helia. He created MySQL database. Database Transaction Summit on w36 Wed 2013-09-04. Free registration until w35 Fri 2013-08-30.

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

PupeSoft – Free Finnish ERP

Can you run a 70 million euro business on a Free ERP? PupeSoft is a Free Finnish ERP system. It allows a company to control all aspects of its business: from accounting, customer relationship management to warehouse. My students have … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

Reading StackOverflow XML Dump to MySQL Database

StackOverflow data is available for free. To play with the XML data dump, you must insert it into MySQL database. This report shows you how. This article is not for beginners. To follow this article, you should have the StackOverflow … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 1 Comment

Change MySQL Password on Ubuntu – dpkg-reconfigure mysql-server-5.1

Update: Fix forgotten MariaDB password on Ubuntu 18.04 and newer. Update: This method does not work on Ubuntu 16.04, and I have not tested it with newer versions either. Forgot MySQL server root password? It’s trivial to change it in … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 2 Comments

Static Advantage – Could WordPress Be 400 Times Faster?

Apache served static pages 400 times faster than dynamic WordPress pages. Could caching bring this speed advantage to WordPress? I measured pages with Apache benchmark tool “ab”, using 10 simultaneous connections. I used a powerful desktop as a server on … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , | Leave a comment

Build Web Interface to Database – LAMP Linux Apache MySQL PHP

Build Web Interface to Database – LAMP Linux Apache MySQL PHP In this howto, we program a simple database application. It reads data from a database, then prints it on a web page. Techniques teached here are used for building … Continue reading

Posted in Old Site | Tagged , , , , , , , | 1 Comment