Home Page Project

Past Present and Future

Early in my web life, I realized that a database of notes would help me track ideas and work. I built a primitive notes database that used html textrea as the main input. There we some other inputs that allowed one to provide attributes for the content, but the beef was in the text area. The biggest feature was searchability. I was able to reuse notes on tricks or tecnhiques that I had discovered whether it was for system admin. or programming.

It also was a place to expound upon ideas and help guide the development/work process and acted as an area of reflection. The input interface allowed html but generally rich input was minimal. Lots of naked content. The notes system became more than anything a place to cut and paste chunks of useful information or write brief documentation either of which that would be useful to search upon later.

Now comes along something like MojoMojo, which while far from perfect, has allowed me to take my note writing to a much more satisfying level. Small to media size documents are easy to produce. Integrated search, hierarchy navigation and recent pages are ways I can easily locate documents. This means I’m now developing two or more content sources and I’d prefer to consolidate them whenever possible.

This project looks at developing a Catalyst based version of the original notes database which could provide “widgets” or “tranclusion” items to a mojomojo application.
However, I would like to continue accessing some the older information I have in my notes database and perhaps even load it into mojomojo.

Database

It’s a super simple database with only one table. The most useful fields have been:

• id - linking directly to content from view.
• content -
• last_modified (time based sorting and viewing)

main Table Schema

+---------------+-------------+------+-----+-------------------+----------------+
| Field         | Type        | Null | Key | Default           | Extra          |
+---------------+-------------+------+-----+-------------------+----------------+
| id            | smallint(6) | NO   | PRI | NULL              | auto_increment |
| cat           | varchar(16) | NO   | MUL |                   |                |
| event         | varchar(64) | NO   | MUL |                   |                |
| content       | text        | YES  | MUL | NULL              |                |
| last_modified | timestamp   | NO   |     | CURRENT_TIMESTAMP |                |
| f_year        | int(4)      | YES  |     | NULL              |                |
| f_month       | int(2)      | YES  |     | NULL              |                |
| f_day         | int(2)      | YES  |     | NULL              |                |
| project       | int(11)     | YES  |     | NULL              |                |
+---------------+-------------+------+-----+-------------------+----------------+

DBIC the Table

Using make_schema_at? I can get the table defined a DBIC Result class, no problem.

Get Local Copy of Database

Dump Database

When developing a database web application, it’s nice to have a local copy of the database. This database is in MySQL² and can be dumped with mysql

¹ Thanks to ideas from and , a small but budding picture has developed in my head. Updating access to an old notes database while considering ways to plug info widgets into MojoMojo.

² Before I got to know PostgreSQL.

My tags:

 

Popular tags: