As you might have already guessed, this blog is created and maintained on a Chyrp Lite platform. It is perfect for me and what I am doing because it is thin,  conducive for quick and extensive writing, and I can practice my  development chops by extending it to what I want.

The problem I am running into first is the limitation of the Markdown  set I have here. Minimal features and commands, and I can't do a  footnote. I no rikey. But then I realised that where Markdown doesn't do  the little thing that I am craving, which at that point was a footnote,  regular HTML steps in and solves the problem quite adequately. Now the  document says exactly that it is that I wanted it to say.

There are things that are extendible, and things that simply need to be approached a different way.

Where's my categories?

One thing that I noticed is that I don't have any way to enter  categories. I want to be able to divide my posts into major areas like  ramblings or platform or application specific groupings, similar to this  one, because with what I have been doing, we are about to get into  MariaDB. That is basically a MySQL vsariant, so virtually all of my  commands I show you should translate over to Oracle's (I've warned you  about them before...) MySQL and Percona, which is another variant.

So I poked around in the twig code a little bit and realised that this was not my real problem. My real problem was that I had no data for the dropdown selector, and that the  only way that could happen was if it was not populated. So I dug into my  database to see.


MariaDB [whm_chyrp]> show tables;
+---------------------+
| Tables_in_whm_chyrp |
+---------------------+
| categorize          |
| groups              |
| pages               |
| permissions         |
| pingbacks           |
| post_attributes     |
| posts               |
| sessions            |
| users               |
+---------------------+
9 rows in set (0.00 sec)

Yes, I see that there is a table in there with the name I am looking for. That table is categorize, and I'm pretty sure that it's going to tell me the categories, of which I have none at the moment.

MariaDB [chyrp]> show columns in categorize;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | int(11)      | NO   | PRI | NULL    | auto_increment |
| name         | varchar(128) | NO   |     | NULL    |                |
| clean        | varchar(128) | NO   | UNI | NULL    |                |
| show_on_home | tinyint(1)   | YES  |     | 1       |                |
+--------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Now the test is to populate a row or two in this database table and see how it responds to the change.