Dear Axion devs,
My primary question is: How can I add (or replace) a new persistent
database abstraction (in my case Jakarta POI) to the Axion JDBC
engine?
Objective
---------
In lots of businesses, spreadsheets are used to communicate
information in some kind of user-friendly manner, e.g. reports,
questionaires, software requirements and 'regular' data. Even the
European Central Bank used spreadsheets to distribute timeseries data
across Europe to national banks.
Most of these spreadsheets are structured in a way that these could be
processed by a machine rather than a human. Luckily several frameworks
out there help to do this (e.g. Jakarta POI).
I want to enhance the spreadsheet access further by means of a JDBC
driver. I would primarily build a 'simple' driver, which uses each
worksheet as a table where the first row specifies the column names
(or something like that) -- secondly I would see how to wire complex
spreadsheet data to Table abstractions.
Axion
-----
I searched several OSS JDBC databases to give me a headstart in
creating the driver, and I found out most implementations have
severely complex abstractions of Database, Table, Type etc. that they
seemed unusable.
When I checked out Axion I was surprised by its clean design and
rather clean abstractions of Database and Table so I choose to use
Axion as the JDBC engine for the driver.
Where to start?
---------------
Well, it seems that I just need to wire the Axion engine to POI, so I
need to build some Axion/Poi adapter. I prefer to have a non-obtrusive
adapter which doesn't interfere/change any code in Axion.
I noticed there are three types of Tables:
table.disk=org.axiondb.engine.DiskTableFactory
table.memory=org.axiondb.engine.MemoryTableFactory
table.external=org.axiondb.engine.tables.ExternalTableFactory
This might seem like adding another TableFactory might do the trick.
The question is, is that feasable in the current codebase? Or do I
need to provide another implementation for the DiskTableFactory and
all its helper classes?
Thanks in advance,
--
Bart Guijt
GSM: +31 6 55107304
---------------------------------------------------------------------
To unsubscribe, e-mail:
dev-unsubscribe@...
For additional commands, e-mail:
dev-help@...
