Hi
I am looking for a tool to make a simple application with a database hosted on the Internet. How is it to use Kexi for this?

Regards
Eivind

HI,
Interesting question, on time because the topic is a part of my private research.
I am sorry for delayed answer

Currently, using only Kexi it's not possible to generate, develop and maintain web apps/services. There were Kexi Web Forms but only reached an experimental stage.

However, if you have direct access to the hosted database server (MySQL, PostgreSQL) in a way that you're able to connect to it from your computer, you can use Kexi to create database project on this server. By database I mean tables and queries. This reduces Kexi to a simple tool for designing tables, queries, and easy population of data into the tables.

Then you could add web interface using any tools you want, to expose. Also, possibly some scripts to add server-side functionality. Whenever your users access the web page that use the database(s) created with Kexi, they won't call any routines of Kexi. Here, Kexi would be design tool only so far.

Queries stored by Kexi are not seen by the server, they are not database views. So you'd have to copy SQL statements from the SQL view and paste them to your web scripts that access the database (PHP, CGI, etc.). You can also modify the SQL statements what gives you more power than only using queries from within Kexi, which presents very simplified format of SQL to the users.

Regarding other objects, forms, reports, scripts, you are not able to expose them to your users. Or... with little modification of Kexi it may be possible to run Kexi in a batch (non-interactive) mode to generate reports at least (HTML, ODT, PDF formats) and export tabular data from tables/queries to a CSV file. Then the web server would be able to serve the file back to the user of a web browser. But this assumes your access to the server is rich enough that you are able to install and run Kexi there, somehow as a service.

Just a few use cases. There're probably more of them possible.

But the ultimate goal of Kexi is to be able to act as a business database app creation tool for the cloud / private cloud. Then a lot more would be possible without leaving Kexi and web browser.

Hi
Thank you for a good answer. I think of using MySQL Workbench and PhpMyAdmin. Do you have any advices and suggestions?

Best regards
Eivind Lowzow

eivindlowzow wrote:Thank you for a good answer. I think of using MySQL Workbench and PhpMyAdmin. Do you have any advices and suggestions?

Hi,
Both have their use. The advantage of web interface is availability on any computer armed with a web browser. Administration apps do not require sophisticated graphical interfaces unless you need features like convenient data entry. The Workbench app will give you easier data entry I think. Ultimately, for advanced frontend use cases, Kexi will be the richest solution.