[pilot-db-list] palm-db-tools - take two

[Yedidyah Bar-D. <di...@ta...>]

Hi all,

I now spent some time on this again. After looking at various other
options, I decided the fastest will be to fix palm-db-tools, and not
rewrite it in some other language as I suggested in the past. So I
sat down and did it. You can find in
<http://www.cs.tau.ac.il/~didi/palm-db-tools-with-filters-and-scripts.patch>
a patch that allows pdb2csv and csv2pdb export and import the following:
Global scripts
Filters (both simple and advanced)
The "formula" of a calculated field

Note that it does not (yet?) interpret the bytecode, only stores it.
So you can't edit it on a PC. But you can do the following:
1. pdb2csv
2. edit the csv with whatever tool you want
3. csv2pdb
sync the pdb, "Rebuild Database", and have everything working, with all
you filters and scripts.

You can't, for obvious reasons, change the structure of the DB on the PC,
as the scripts contain references to columns by their index. Still, it's
a start.

Is anyone interested?

Is anyone interested in interpreting formulas on a PC?
Of course it's more convinient, and also allows things like creating
SQL views based on your filters, but it's more work.

Where should this be maintained? palm-db-tools.sf.net seems dead to me.

Does anyone have recommendations/opinions about how to edit the csv on
the PC? Besides the obvious excell/openoffice, that is. Something that
will have the snappiness and features of pilot-db (and I can say that
in my experience most web apps aren't as fast and convinient), and will
be multiuser?  I know this was discussed in the past here, but it was
theoretic. Now, with a working palm-db-tools, it's closer to reality.

Thanks,
-- 
Didi