Skip to main content

Posts

Showing posts from August, 2017

MS Access: fancy InStr function

I want to compare the installed packages between a couple of Linux servers. Obviously, using a database comes to mind. And my Office Pro includes a pretty good database: MS Access. The problem I have tables with a list of Linux packages installed on several servers, one table per server. I want a table with all the packages common to all servers, and for each package (ex: audit-libs-python-1.8-2.el5 ), the package root ( audit-libs-python ) and the version ( 1.8-2.el5 ). Step 1: selecting the common packages SELECT DISTINCT Srv1.Package FROM Srv1, Srv2, Srv3, Srv4 WHERE Srv1.Package = Srv2.Package and Srv2.Package = Srv3.Package and Srv3.Package = Srv4.Package; Step 2: extracting the package root and version Package versions are not always written in a similar way. Some examples: Package                Root        Version anacron-2.3-45....

The 2044 Is Back

Long time ago, the SSM 2044 4-Pole Voltage Controlled Filter was everywhere. The chip was designed by Dave Rossum (E-MU). Its characteristic sound could be heard from different synths: Crumar Bit 01, most EMU products, Korg Mono/Poly, Polysix and Trident (Mk I and Mk II), Octave Plateau Voyetra 8 (used by Eurythmics), PPG Wave (used by Tangerine Dream) and many others. However, Solid State Micro Technology for Music is long ago gone, and SSM 2044 are now rare to find - mostly from dismantled synths - and, of course, expensive. Hopefully, Dan Parks, a former SSM employee, has decided to recreate the legendary filter with his company, Sound Semiconductor. The new filter is named SSI2144, and the datasheet is here: http://soundsemiconductor.com/downloads/ssi2144datasheet.pdf