Aikataulu – Linux palvelimet ict4tn021 4-ti ja 5-to – alkusyksy 2017 – 5 op

Aloita nollasta. Opiskele 8 viikkoa ja hallitset omaa Linux-palvelinta. Opintojakson suoritettuaan opiskelija: Osaa hallita Linuxia palvelimena Osaa tehdä tärkeimmät asetukset tärkeimmille palvelimille (Apache, OpenSSH) Osaa asentaa www-ohjelmointiin sopivan alustan Osaa tehdä itselleen uusia asetuksia palvelinohjelmistoihin ohjeiden avulla Tietää esimerkkejä palvelintilan … Continue reading

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

Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

Create a new database item, then open it for editing: LAST_INSERT_ID(). Undo is better than “are you sure”. Mark items deleted, then empty trash when sure. Read the basics first: MySQL Install and One Table Database – SQL CRUD tutorial … Continue reading

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

MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

MySQL is the most popular multi-user database. In this tutorial, you’ll learn to Install MySQL Server and Client on Ubuntu Automate MySQL login Create, read, update and delete data (CRUD)

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

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

Forgot MySQL server root password? It’s trivial to change it in Ubuntu and Debian. $ sudo dpkg-reconfigure mysql-server-5.1 To get the version of your package, just type ‘sudo dpkg-reconfigure mysql-server-5″ and press tab a couple of times. It simply asks for … 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
  • Picks

  • Boxing Clock for AndroidOcton8 Diving T-ShirtsShaking Tower Panda Android GameLearn Chinese with Android
  • Student projects