Feeds:
Posts
Comments

Archive for the ‘xLite’ Category

Excel as a document-oriented NoSQL database

Posted in ETL, Python, SQLite, VBA, data, excel, xLite, tagged , , on March 2, 2010 | Leave a Comment »

I’ve been a long time fan of CouchDB, one of the many NoSQL databases to appear in the last few years. CouchDB is a document-oriented database, which with solid B-tree indexing and easy replication, topped off by a MapReduce style view mechanism, puts it up there as a best-of-breed noSQL datastore.
Now it may seem strange that [...]

Read Full Post »

Excel 2010 Application.Caller Bug

Posted in ETL, SQLite, VBA, excel, xLite, tagged , , on February 11, 2010 | Leave a Comment »

I’ve just released another xLite “introduction”, this time the xLiteWorkbookFunction function. I’ve had most of the now released functionality working (and in use) for quite a while but had delayed publishing until I’d installed Excel 2010 as I’d wished to test against a modern Excel version.
I’d not bothered with Excel 2007, as I couldn’t see the [...]

Read Full Post »

xLite Beta Updated – adds Python as an Excel Scripting Language

Posted in BI, ETL, Python, excel, xLite on February 7, 2010 | Leave a Comment »

I’ve updated the xLite Beta with bug fixes and added a new page introducing xLite’s Excel/VBA and Python extensions to SQLite.
See http://www.gobansaor.com/xlite
The u() function allows any VBA UDF (user defined functions) to be called from SQLite.
The x() function allows an inbuilt function or indeed most any formula (but not a UDF, use u() instead) to be [...]

Read Full Post »

TAG Cubes – SQLite Star Query Part III

Posted in ETL, Palo, SQLite, VBA, excel, olap, xLite, tagged , , on September 29, 2009 | 9 Comments »

It’s no secret that I’m a huge fan of SQLite and Excel, particularly when used in combination. I also greatly admire the open source BI engines, Palo and Mondrian. Mondrian appeals because of its “ROLAP with a cache” architecture and its implementation of MS’s excellent MDX language. When I say MDX is excellent I’m talking with my [...]

Read Full Post »

Spending time on Excel-SQLite, C, VBA Callbacks & Twitter

Posted in BI, ETL, Palo, SQLite, VBA, Web2.0, excel, xLite, tagged , on November 20, 2008 | 3 Comments »

Haven’t posted here in a while as my spare time has been soaked up programing, well actually refactoring would be more exact.  My xLite “SQLite empowered Excel” codebase has grown over the years and required a serious makeover to get rid of stuff I no longer use and to generally make it more robust.  I [...]

Read Full Post »

Python to replace VB6 …

Posted in ETL, Python, VBA, excel, xLite, tagged , , on May 5, 2008 | 2 Comments »

… well at least for me. As I discussed previously I’ve been seriously investigating using Python as my primary datasmithing scripting language, in effect a new VBA. I also currently use VBA’s compiled cousin, VB6, for certain tasks such as building Excel RTD servers. The problem with VB6 is it depends on [...]

Read Full Post »

xlAWS – 100,000 downloads?

Posted in AmazonAWS, Proto, S3, SQLite, SimpleDB, VBA, programming, xLite, xlAWS, tagged , on April 2, 2008 | 2 Comments »

Not sure, but this morning I received my monthly AWS bill, and it was double its usual amount! When I investigated the extra cost it was due to 133GBs of downloads from my www2.gobansaor.com bucket. This is the S3 bucket in which I store the xlAWS zip file, xlAWS being a “library-of-sorts” of [...]

Read Full Post »

Proto – desktop BI tool.

Posted in ETL, Proto, RSSBus, VBA, news, xLite on September 9, 2007 | 1 Comment »

I see that Proto have repositioned their excellent VBA scripted mash-up product as a “desktop business intelligence system”. This is to be welcomed as the first time I used it I described it as a “mash-up tool for adults” and although it has the ability to play hard ball with the other Web2.0 mash-up [...]

Read Full Post »

In Memory OLAP

Posted in BI, ETL, Palo, SQLite, VBA, data, excel, olap, xLite on September 5, 2007 | 9 Comments »

The consolidation within the BI market continues, this time with the purchase of Applix by Cognos. As Timo Elliott points out, the interesting bit is the Applix TM1 memory-centric OLAP product. For the vast majority of OLAP users (i.e. the millions of Excel Pivot table jockeys) in-memory OLAP is nothing new, but traditionally [...]

Read Full Post »

SQLite Star Query Part II

Posted in BI, ETL, Palo, SQLite, VBA, excel, olap, xLite on August 31, 2007 | 1 Comment »

In my previous post I looked at simulating a bitmap-join in SQLite using a sub-query and the INTERSECT command. The problem is of course, this is a simulation, SQLite lacks bitmap indices and although the sub-query will read only the fact table’s index B-trees (avoiding accessing the fact table proper) and should be [...]

Read Full Post »

Talend vs. Kettle (Pentaho PDI)

Posted in BI, ETL, Java, JavaFX, JavaScript, Palo, Ruby, SQLite, Talend, kettle, xLite, tagged on May 27, 2007 | 5 Comments »

Over the last few weeks I’ve received a lot of traffic from Goggle searches comparing Talend and Kettle and also from Vincent McBurney’s ITtoolbox article comparing the two products, so where do I stand?
As ETL tools they take different approaches, Kettle is a meta data driven framework (which is in turn tightly integrated into an [...]

Read Full Post »

I’ve got talend and I’m going to use it…

Posted in BI, ETL, Java, Palo, SQLite, Talend, data, excel, kettle, olap, xLite on April 30, 2007 | 1 Comment »

For the last few months I’ve being looking for my ideal ETL platform. That ideal would be open source, platform independent (well at least Windows and Linux), flexible, and easily deployable. It had looked like a combination of Kettle and my micro-ETL combinations of Ruby/SSQLite and Excel/SQLite would be the eventual “winners”. [...]

Read Full Post »

Proto

Posted in ETL, Proto, SQLite, excel, xLite, tagged on April 13, 2007 | 5 Comments »

In the two months since I first came across Proto I’ve worked my way through most of the tutorials and sample applications and I’ve come away with a very positive impression of the product. I hadn’t however managed to the find the time to create a VBA based component; that is until last [...]

Read Full Post »

Habemus Proto

Posted in ETL, Proto, SQLite, excel, xLite on April 10, 2007 | 1 Comment »

I’ve just uploaded my first Proto module; a rewrite of a VBA module I’ve been using for many years to provide me with a bridge between the ease of use of desktop user-focused tools and the power of a SQL enabled database. In the past that database was Oracle (and occasionally MS Access) and [...]

Read Full Post »