I am currently planning an application that works on an object's relational database. The work is simple: just extract the data, analyze it, show it to the user and write down some changes. To support a wide range of databases, I am currently looking for an access library that matches all (or at least some) of the following requirements (sorted by importance):
Java or Python. I use Jython, so both are possible, but I would prefer Python over Java
Return metadata about the database. I need to get a list of all tables and their schemas. Ideally, this information is returned as objects.
the ability to retrieve a record from multiple tables using
full runtime configuration from code. I do not want something that is needed, that is, the display configuration in any XML file.
some kind of ORM mapping. I could live without him, but it would be nice. I would be completely fine if I got a bunch of objects with data in them and had to do the rest by reflection.
What is the best library for such a task (given that at least one exists;)).
source
share