In a previous post I mentioned that I use a combination of Ruby and SQLite as a micro-ETL environment. Many of you have asked what’s a micro-ETL environment (indeed what is ETL) and why Ruby and why SQLite?
ETL, as all you data-warehousing and business intelligence folks will know, is the Extracting, Transformation and Loading [...]
Archive for December, 2006
Ruby and SQLite. A micro ETL environment.
Posted in ETL on December 28, 2006 | 6 Comments »
Google Apps for Your Domain and ROBOTS.TXT
Posted in GAFyD, tagged google on December 20, 2006 | 2 Comments »
I’m a technical sort of guy, so when it comes to setting up a website the natural thing for me would be to build it using raw HTML/Javascript or maybe use a web framework such as Zimki, Ruby On Rails or MODx. But when it came to setting up a web presence for [...]
SQLite JDBC and Kettle (Pentaho Data Integration) ETL
Posted in ETL, kettle on December 18, 2006 | 17 Comments »
I’ve been a big fan of SQLite for several years now. Although I come from an Oracle database background, I find for day-to-day data smith’ing SQLite is ideal. Combine it with the expressive power of Ruby and you have a very powerful micro-ETL environment.
I’m also [...]
links for 2006-12-14
Posted in Uncategorized on December 14, 2006 | No Comments »
A CSS-based Form Template
(tags: css forms template html Design)
HoHoHo! : Design : Brand Spanking New
(tags: icons free mini)
SSH (SSH1, SSH2), WebDAV, FTP, SFTP free GUI Client for Windows. Download GUI for PuTTY - freeware SSH, FTP, WebDAV client here.
(tags: ssh windows webdav free client ftp)
Pentaho Data Integration:
(tags: kettle JavaScript java classes pentaho)
Pentaho Data Integration:
(tags: pentaho [...]
links for 2006-12-13
Posted in Uncategorized on December 13, 2006 | No Comments »
:: GOM PLAYER ::
(tags: video freeware Mediaplayer Player windows)
Panthius
(tags: crm SaaS ireland vsb sme erp)
DataRide.Net - Data conversion and forwarding services
EDIFACT
(tags: data conversion forwarding)
Data Entry: Data Conversion
(tags: conversion data text ocr service)
Data Conversion Laboratory - Data Conversion Services & Expertise
(tags: xml data conversion service)
Trio File Conversion Services, Products & Consulting
(tags: data conversion services cp/m wordstart [...]
links for 2006-12-12
Posted in Uncategorized on December 12, 2006 | No Comments »
S3 Xplorer
(tags: s3 ruby amazon explorer)
Alpha Geek: Video Editing 101 - Lifehacker
(tags: video editing tutorial)
Browser-Based: Surveying Your Application Needs
(tags: survey apex HTMLdb example)
Thomas Cox & Co, accountants
(tags: value based pricing)
links for 2006-12-11
Posted in Uncategorized on December 11, 2006 | No Comments »
MyBlogLog
(tags: blog tracking stats community mypace)
Tips on Cool New Uses for Your Cellular Phone - SeekingAlpha
(tags: tips phones mobile)
Driver Guide - free downloads - freeware and shareware Personal Interest › Hobbies › IRCommand2 3.82
(tags: IR infrared software)
Software Inspector - Secunia
(tags: Security updates windows agents check)
www.gleesonit.com - gleesonIT
(tags: gleeson IT googlepages)
links for 2006-12-10
Posted in Uncategorized on December 10, 2006 | No Comments »
Ask Doctor Spiller, A Dentist With 28 Years Experience
(tags: dental dentistry health teeth)
:: strix.org.uk :: Google UnSafeSearch ::
(tags: google search unsafe)
links for 2006-12-09
Posted in Uncategorized on December 9, 2006 | No Comments »
Backup, Sync and Listen to Your Digital Music Collection with an Oboe Locker @ MP3tunes.com
(tags: music mp3 storage online itunes)
Streampad - In tune with the world.
(tags: Music streaming mp3 P2P)
links for 2006-12-08
Posted in Uncategorized on December 8, 2006 | No Comments »
An Irish Town Planner’s Blog
(tags: town planning ireland)
Make Create: Google Backdoor
(tags: google hack backdoor user-agent)
MainframeGlitch - Secret Backdoor To Many Websites
(tags: google hack backdoor user-agent)
mozdev.org - useragentswitcher: index
(tags: firefox extensions user-agent)
Daily Cup of Tech » 10 Ways to Protect Your Home Network
(tags: network security backup)
All security products from Jetico: BestCrypt, BCWipe, Jetico Personal Firewall, BCArchive. [...]
links for 2006-12-07
Posted in Uncategorized on December 7, 2006 | No Comments »
Part 2: Changing Climates for Microsoft and Google, Desktops and Webs
(tags: web2.0 google microsoft desktop trends insight vmware)
Backup Del.icio.us with Excel
(tags: del.icio.us excel backup)
Webmail.us, Inc. | The Email Hosting Company™ | Business Email Hosting
(tags: email hosting amazon s3)
LAPTOP PARTS & BATTERIES, AC ADAPTERS for Dell, Sony, IBM, Compaq, HP, Toshiba, OEM - Wholesale Dealer
(tags: laptop [...]
links for 2006-12-06
Posted in Uncategorized on December 6, 2006 | No Comments »
MythTV Ubuntu Installation Guide
(tags: mythtv ubuntu linux pvr)
Getting Started : Download RoboMaker
(tags: rss mashup web scraper)
Dancing Trees: Home
(tags: computer services tech)
O’Byrne & Kennedy :: Chartered Accountants and Business Specialists // Homepage
(tags: value based fixed pricing)
code.enthought.com - Python-Enthought Edition
(tags: python distribution opensource bi)
Microsoft Excel: The king of BI
(tags: excel bi insight)
links for 2006-12-05
Posted in Uncategorized on December 5, 2006 | No Comments »
Using Google Calendar API via Visual Basic 6 | The Poorhouse
(tags: Google Calendar API Gdata VBA VB6)
Daily Dose of Excel » Blog Archive » Async XmlHttp calls
XMLHTTP Sub Test()
(tags: XMLHttpRequest Async vba)
DOM Tool
(tags: javascript dom html convertor)
Webmaster Help Center - Webmaster Guidelines
(tags: google seo guidelines webmaster)
links for 2006-12-04
Posted in Uncategorized on December 4, 2006 | No Comments »
CastleCops Spyquake,malwarewipe trojan, after selfhelp,dwwin.exe problm
(tags: exe)
links for 2006-12-03
Posted in Uncategorized on December 3, 2006 | No Comments »
Download of the Day: Any Video Converter (Windows) - Lifehacker
(tags: video convertor)
Download of the Day: Avi2Dvd (Windows) - Lifehacker
(tags: avi video dvd iso)
IntelliAdmin.com: New Remote Desktop client released by Microsoft
(tags: remote desktop)
The Simple Dollar » 30 Essential Pieces Of Free (and Open) Software for Windows
(tags: software freeware windows free tools utilities listof)
Gnucleus
(tags: p2p software gnutella [...]
links for 2006-12-02
Posted in Uncategorized on December 2, 2006 | No Comments »
Installing Ruby on Rails with Lighttpd and MySQL on Fedora Core 4
(tags: fedora raild linux ruby gem lighttpd)
Install multiple versions of IE on your PC | TredoSoft
(tags: browser testing ie5 ie6)
Amazon Web Services Developer Connection : GPG keys for yum repositories …
(tags: fedora ec2 yum keys)
links for 2006-12-01
Posted in Uncategorized on December 1, 2006 | No Comments »
411 Spyware Remove : The 411 on Spyware Removal
(tags: spyware manual automatic removal listof)
sqs.rubyforge.org
(tags: ruby sqs amazon simple queue service)
What's happening (Twitter et. al.)- You: First sub-prime mortgage defaults, next sub-prime credit card defaults http://tinyurl.com/5ccfd2 (via Twitter)
- You: Spilling rain outside, no -6C frost tonight; no magic winter wonderland walk in the woods tomorrow; back to the wet and the muck. (via Twitter)
- You: A regular expression visualiser http://osteele.com/tools/reanimator/ (via Twitter)
- You: @antgalvin I'll upload a picture when my broadband returns, too painful to do so under ISDN speeds (via Twitter)
- You: @antgalvin I last saw such "beards" in my teens, it obviously requires a heavy frost at the time the fungus fruits, we live & relearn (via Twitter)
- You: ..tree branches, the fungus fruiting threads are microscopic and can only be seen when covered in frost, known as Jack Frost's Beard. (via Twitter)
- You: The woods today glistened with hoarfrost covered spider webs, but more spectacular where the frosted "beards" of fungus that covered dead... (via Twitter)
- You: OS ETL tools Talend and Jitterbit compared http://tinyurl.com/5v6mpe (via Twitter)
- You: Got thru to Omnitel, problem local it seems, my local transmitter 127.19.20.1 aka Fr. Ryan's, needs rebooting,"Finding Fr Ryan" is the prob. (via Twitter)
- You: A Bullfinch pair feeding on the seedheads in the flowerbed outside my window. (via Twitter)
-
Recent Posts
- Spending time on Excel-SQLite, C, VBA Callbacks & Twitter
- Open Source Metrics and Benchmarks
- Windows on EC2 = SMEs on EC2
- I’ll give up Excel Pivot Tables when you take ‘em from my cold, dead hands
- Why Larry hates the cloud, and my data trinity.
- Clouds no longer pass by Windows.
- Oracle embraces the cloud.
- Twitter - the penny drops!
- Cloudy skies, cloudy apps…
- Amazon’s SAN in the cloud is a mirage…
- Talend + SQLite + Groovy the new Oracle …
- OLAP Cube as a Mind Map
- New universal SQLite JDBC library.
- Amazon S3; there’s a holdup on the buckets, Dear Liza…
- Groovy as Talend’s scripting language
-
Recent Comments
-
Top Posts
- Open Source Metrics and Benchmarks
- Geek Christmas Present Idea!
- Talend vs. Kettle (Pentaho PDI)
- PALO plugin for Kettle (Pentaho) ETL
- xlAWS - Excel VBA Code for accessing Amazon's S3 and SimpleDB
- Palo OLAP and sparse dimensions.
- Like Excel macros? You'll love this..
- xLITE - Excel/Proto SQLite utility
- I’ll give up Excel Pivot Tables when you take 'em from my cold, dead hands
- SQLite Star Query Part II
-
Top Clicks
Category Cloud
Archives
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- February 2006
