Wiktor asked at https://bugs.kde.org/show_bug.cgi?id=370090#c6

I read yesterday on Postgres wiki that Kexi can operate on existing DB. I was searching for an app that could be used to prepare some report / visualization and checked if Kexi is OK.

Answering here for others.

Kexi can't operate on existing DB, not yet. For now you need to import the db e.g. from postgres to the same postgres server (and different db name) using the Import Database function. It's quite well tested feature in Kexi 3.

Or you can create metadata records in kexi_* tables ("system" tables) by hand but that's more for "hackers".

Kexi can't operate on existing DB, not yet.

It would be a huge step forward if it could, as Kexi could then be used to easily update records on web servers.
More confortable than phpMyAdmin or pgMyAdmin, for publishing comfort and for people that are not experienced in working with databases.

I'm dreaming Kexi to interface with PostgreSQL ; are there some plans in this directions?

Can you tell a little more about the metadata records? Explain if they allow linking a remote database and how to do this?

Thanks a lot.

Julien Demigeek wrote:

Kexi can't operate on existing DB, not yet.

It would be a huge step forward if it could, as Kexi could then be used to easily update records on web servers.
More confortable than phpMyAdmin or pgMyAdmin, for publishing comfort and for people that are not experienced in working with databases.

I'm dreaming Kexi to interface with PostgreSQL ; are there some plans in this directions?

Can you tell a little more about the metadata records? Explain if they allow linking a remote database and how to do this?

Yes that would be a huge step. The *Admin apps are quite low-level and devoted to given implementation, Kexi is very high level. There are plans, no timeline. We need budget for this larger change.

As for the format it's easiest for me if you create e.g. a new database with a few tables in Postgres and analyze contents of the metadata kexi__ tables.

The schema is in kexi/src/examples/Simple_Database.kexi.sql. Meaning of tables and field can be hopefully deduced from the names.

Please also see A1.8 at http://www.kexi-project.org/wiki/wikivi ... xiFAQ.html.
In Kexi source code there are src/tools/add_column, src/tools/delete_column that alter the metadata. These operations use the kexi__ tables too.

Disclaimer: the format will be eventually fully documented. I'd say it's the opportunity for you and others to document it, things work this exactly way

Thank you for your response!

I'm afraid I won't help with development of this particular functionality due to lack of free time and of C++ / Qt dev skills. Instead I would like to donate to this feature development if there is such option .

Thanks @Druedain.
There are donating options available so far outlined at https://community.kde.org/Kexi/Contact#Donations.