I just finished a new MySQL module, available at MMM-MysqlQuery.

This queries a MySQL database you have access to on a regular basis, and displays the results as an HTML table on MagicMirror.

Screenshots:

SELECT tarih, sabah, oglen, aksam FROM yemek WHERE tarih=‘$bugun’

Looks like Turkish :-)
“select date, morning, noon, evening from… where…”

You could pick the current date on the MySQL server directly by calling a function on the MySQL server:

SELECT tarih, sabah, oglen, aksam
FROM yemek
WHERE tarih=current_date()

You can see this in action:

mysql> create table dailystuff (tarih date);

mysql> insert into dailystuff values ('2018-09-10');
mysql> insert into dailystuff values ('2018-09-11');
mysql> insert into dailystuff values ('2018-09-12');

mysql> select * from dailystuff where tarih=current_date();
+------------+
| tarih      |
+------------+
| 2018-09-11 |
+------------+
1 row in set (0.00 sec)

Sounds good. For a lark, I just wrote MMM-MysqlQuery which might help if your MM has access to the database directly.

Let me know if this would work and if not, we’ll talk about REST?

I just finished a new MySQL module, available at MMM-MysqlQuery.

This queries a MySQL database you have access to on a regular basis, and displays the results as an HTML table on MagicMirror.

Screenshots:

It’s been a year since posted, but maybe others are interested. Reminders in Google Calendar don’t look like they can be delivered in ical/ics format, so this might be a good opportunity to build a module.

A simple approach could be a converter/proxy that shows reminders as an .ical feed so you can use the default calendar module. It would then show reminders alongside calendar events. This could also save some space on the mirror.

A separate module would be straightforward and simpler for others to understand and setup, though. Maybe a module that takes up zero space when there are no reminders?

Sounds like a lot of fun. What’s the current feeling on a UI and expected config for this?

How about the config is a string value holding database DNS, username, password, SQL SELECT statement, etc.
Output just creates a formatted

with alternating row coloring, date and number formatting, left/right alignment based on type, etc.?

Should it refresh the query on a schedule maybe?

Description

I’d like to announce the Beta release of MMM-MinecraftStatus module!

This module watches a remote Minecraft server and reports back on the number of logged-in players and latency to the server. If the server is unreachable or down, it displays an alert.

For fun, it will play a notification sound if the number of players changes from 0 to a positive number, and plays a different alert sound if the server is unreachable.

It’s in Beta now, so please give it a try: instructions at the link above. Let me know what doesn’t work, or other features you’d like, and PLEASE tell me if it works! I need to confirm a few people are happy to call it production-ready. Thanks!
Created initially for a Minecraft server I run for my daughter and her friends. When the alert sound plays telling us someone is on the server, it’s great to see the light in my daughter’s eyes as she runs for the computer to join her friend online.

Screenshots

Download

[card:ralberth/MMM-MinecraftStatus]