[Tutor] Paradox table

Derrick 'dman' Hudson dman@dman.ddts.net
Thu, 12 Sep 2002 10:35:32 -0400


--NzB8fVQJ5HfG6fxh
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Sep 11, 2002 at 03:14:30PM +0200, A wrote:
| Hi,
|  Is there a module for reading Paradox database (.DB) files with Python?
| I need to run the script under Linux, so I can not use ODBC.
| Any suggestion would be appreciated

One way to access the data is to export it from paradox in CSV format.
CSV is an open standard and several (python) parsers exist for it.
However, using this method won't allow you to easily access the data
from both paradox and from your script, instead you would need to
re-export it every time you modified it in paradox and you would not
be able to modify it using your script.  If you can, it would probably
be easiest to migrate to a different db such as postgresql.  Postgres
databases are much more accessible than paradox is (at least with the
paradox version I've seen, 3.5).

-D

--=20
Dishonest money dwindles away,
but he who gathers money little by little makes it grow.
        Proverbs 13:11
=20
http://dman.ddts.net/~dman/

--NzB8fVQJ5HfG6fxh
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj2ApjQACgkQO8l8XBKTpRTx3gCffJpmKdlJQRAY9CGoEcoF5SAq
eEoAmwTscJwQ242oQzdIrTWij2gaADES
=UTTW
-----END PGP SIGNATURE-----

--NzB8fVQJ5HfG6fxh--