[ZODB-Dev] Tabular datas legacy into data.fs

[Dieter Maurer]

Pierre-Yves Delens wrote at 2005-1-8 10:17 +0100:
>we are intending to import a couple of Access/Excel/SqLite tables into ZODB.
>
>Are there nice "Howto's", best practices, or typical snippets for doing this
>?
>(via CSV and/or ODBC, or whatever...)

It depends on how you want to use your data...

Hopefully, you are aware that the ZODB is not optimal
for large amounts of highly structured data with a need for
flexible querying.

When your tables are small, then the product "TinyTablePlus"
might help you.

Large tables could be emulated by objects for each row
(implemented by e.g. a ZClass or an Archetype) with properties
for each field, all collected in a "BTreeFolder2" (representing
the table).


Note that especially querying is much different from SQL:

  *  only indexed based querying is supported (but indexes
     are often much more flexible than SQL)

  *  there are no joins; if you need them, a script must
     combine several queries.

-- 
Dieter