I use an app that runs under the LAMP environment with its data in MySQL, using ubuntu.

I think kexi will be able to import this database however it must save it in a new database in order to use it. What I would like to do is create queries, forms and scripts that can read this external MySQL database but I do not want to disturb the original (PHP) application.

I assume the reason that kexi needs to create its own version of the database is that it also needs to store scripts, forms and queries and maybe some housekeeping info in the same database.

If kexi could keep separately its stuff and read the data from the external database that would be great.

Another way I thought about is that I could import the external database, then save it as a kexi database, then rename it as the original external database, however I wonder if all the original data names would be changed, possibly with a new prefix.

If someone knows how all this works please let me know if this goal is even possible.

I hope I've explained my need clearly.

Thanks

rich

Perhaps their aren't many people using kexi.

At least with Kexi 1.x I believe it required its own format for external databases which would be a mess if other software tried to use those tables. Not sure how this has changed for Kexi 2.x though.

Hi,
Kexi does not support external data sources for now without importing (see also the FAQ at kexi-project.org). It is possible to implement in is an important TODO indeed for 2.x series.

Of course unless you alter the table definitions in any way, you are free to change the date (add/remove/update records). Kexi works just fine with that. The only thing is that updating in opened data view (forms/queries/reports/tables) do not occur automatially: user needs to close the object (not the database) and open again.

PS:
I am just unable to track forums (there are thousands possible forums where kexi questions can appear). I am trying to use RSS but seems not to work yet.

@jstaniek: The following RSS feed will retrieve all posts matching the search "Kexi" in the Office & Productivity forum and its sub-forums.

RSS Feed

bcooksley wrote:@jstaniek: The following RSS feed will retrieve all posts matching the search "Kexi" in the Office & Productivity forum and its sub-forums.

RSS Feed

Thanks, I tried that earlier today. Unfortunately, I got ''"KDE Community Forums" has no items.'' message in Google Reader - no idea why, since it works very very nicely in Akregator...

Maybe the url is way too complicated for the GReader? I would be grateful for checking that out since too often I only have access to RSS via the GReader.

The problem was due to the Forum identifying Google Feedfetcher as a Spider, which disallowed it access to the Search system, and thus RSS feeds. This has now been corrected.

Thank you Jarosław Staniek for your answer.

When version 2.x can access the external database I will have a tool almost like phpmyadmin except that I can make context aware forms and reports and also make rules to allow only legal modifications.

It would be great to have a primary forum for kexi.

richwein wrote:Thank you Jarosław Staniek for your answer.

When version 2.x can access the external database I will have a tool almost like phpmyadmin except that I can make context aware forms and reports and also make rules to allow only legal modifications.

yeah, ok!

richwein wrote:It would be great to have a primary forum for kexi.

Yes. So far you can subscribe here: https://mail.kde.org/mailman/listinfo/kexi

@bcooksley, it would be cool to have one or more options as follows:

1. Transfer posts from selected forums or threads transferred to mailing lists like kexi@kde.org. For now I need to post URL to a topic by hand (so time consuming)...
2. Transfer answers from kexi@kde.org posts to appropriate forum topic. To have this feature, forum would need a dedicated email address and track message ids...
3. NNTP<->forum gateway

Regarding Option 3, a Forum <-> Akonadi resource is under development which will use the OCS API.
We haven't been able to find any software which allows an NNTP gateway to be done ( except for a very old and unmaintained Python daemon ).

I'll discuss the other two items with the other Administrators, we can likely easily implement a notification a new topic has been started, replies to it and their contents ( or ml replies ) will likely be more complicated.