first_page

Back to the Black Board with Tech Plans: Tabulating Technologies

Finally, some kind of big pictures emerge—some kind of expression of what I’ve been doing with most my adult life. This unimpressive rendition of a table started with the far left column as a list of data formats in decreasing disk space:

Back to the Black Board with Tech Plans

So, Apache log files are my largest set of data—then comes the Blog post data (you are reading now) in MySQL/WordPress. Notice how I still avoid storing my crap in “the cloud.”

The next column lists the technologies I use/built with the data forms in the first column. Here is where the organizational lousiness comes in because the order of items in this column has nothing to do with that in any of the columns. My struggle to compensate for this is through arrows going all over the place.

The arrows pointing to the third column intend to show me where the solutions in the first column will end up technologically. For example, DAR will use the Entity Framework, support WCF and maybe WF (Windows Workflow Foundation).

Another Tabular Attempt

**Data Format** **Application of Data Format** **Future of Application**
Apache log files DAR parses and loads these files into SQL Server 2008. DAR will be modified to run on some kind of dependency injection framework—probably [StructureMap](http://structuremap.sourceforge.net/) or [Unity](http://www.codeplex.com/unity/).

SSIS and SSRS are being introduced for processing the results of the load.

SQL Server 2008 [GenericWeb](http://genericweb.codeplex.com/) and DAR use various approaches in the `Songhay.Data` namespace. The `Songhay.Data.Linq` namespace will play a role here, featuring Entities Framework.
MySQL WordPress uses MySQL exclusively. No immediate plans to improve here.
SQLite SQLite.net and my custom PHP libraries approach. The `Songhay.Data.Linq` namespace *should* play a role here, featuring Entities Framework.
Word DOCX No released solutions approach. A WPF version of CleanXHTML is in the works.
OPML An internal InfoPath solution is used to generate list data. Newer PHP/Zend designs use OPML lists for lightweight site index data. A simple OPML editor for WPF and ASP.NET MVC is in the works.

rasx()