Category

Software

Programming and software

Page 5

Log events via PHP to database with Windows or Linux command line

Here’s a neat example (for Linux and Windows systems) of how to easily capture (log) and store the result of some script or program or really anything, in a central database table. Sure you could use just a log file, but spinning up an instance of MySQL (or SQLite) is…

Deepmind’s AlphaStar crushes best StarCraft 2 players

So today’s Deepmind’s StartCraft AI, named AlphaStar  neural network AI thoroughly trounced a couple of top StarCraft players. The first set of matches against Dario ” TLO ” Wünsch (StarCraft II player from Germany. TLO is a former Brood War and Supreme Commander player currently playing for Team Liquid.). AlphaStar…

PHP on Linux authenticate users with a Windows Server Active Directory

A common request when building INTRANET web applications is to have users use only one  common shared set of  login credentials. Typically in most small and medium businesses this means that logging into a Windows Server of some kind to access the network.  Windows Servers use Active Directory (AD) ,which…

Easy battery powered Mailbox Door IoT sensor using ESP32

This post is how I took my rusty (literally) old mailbox and made it into a battery powered smart mailbox (an IoT device) , that sends you an SMS  (text messagE) or MQTT alerts, and in the process  how I  learned about Arduino and particularly  the ESP32 chip which lets…

Running Mosquitto MQTT on Windows 10 super easy

So I’ve been playing with IoT lately,  using platforms such as  Arduino ,ESP32, Raspberry Pi and when it comes to being able to have these devices communicate with a hub or server, the de facto standard is to use a MQTT  server and protocol  . Unfortunately, prior to Windows 10  finding…

Raspberry Pi Zero W LED matrix stock ticker code and demo

So I was recently intrigued by Raspberry Pi Zero W, it’s small ARM-based Linux PC with integrated WiFi and ability to connect shields (known as Hats or pHats in Raspberry lingo) , got me thinking what kinds of interesting applications could I use it for. After coming across the Scroll…

code for MySql / MariaDB to trigger / signal external script from database

One feature I often wish MySQL / MariaDB (I’ll refer from now to just MariaDB referring to both) had was the ability to trigger or launch an  external script or open a socket connection to some external site; on a database event. Perhaps using a stored procedure in other words…