Database Visual Designer

[tseyfarth]

Hello All!

Work projects are starting to diminish, so I can begin a slow return to KB/Q7B.

I really like the look, feel and functionality of KB. Almost, not exactly but really really close to going "home"....

Anyway, in preparation for some new focus on Q7B/KB, I wondered what you all use for Database development and design. I have not settled on a specific database product yet, but want one that works with Java, Q7B/KB under windows and Linux. Apple would be nice too but not mandatory.

Anyway, knowing how friendly this forum is, I thought I'd ask the question.

Which/what Database does everyone prefer? My app will run on both full power desktop machines as well as (really targeted at) an embedded computer running linux (embeddedARM.com). So while there will be significant power available, not as much as a desktop machine.

The database will be accessed (read/write) often. So that may have an affect too. The user interface will be separated from the core. Let me explain:
The core will be a polling loop. Polling devices, processing any request they have OR commands from a disconnected user interface.

The user interface most desirably will be either through a web browser, and/or through a standard GUI.

Most all of the database activity will be done by the polling loop, however other apps including the user interface and likely others, will also perform reads and writes.

So, there you have it. Any ideas for step one, the visual DB designer? This is one step we did NOT do a great job on the first time. So with a complete re-development, I would like to get it "more right" this time!

Thanks
Tim

[berndnoetscher]

Hello All!

Work projects are starting to diminish, so I can begin a slow return to KB/Q7B.

I really like the look, feel and functionality of KB. Almost, not exactly but really really close to going "home"....

Anyway, in preparation for some new focus on Q7B/KB, I wondered what you all use for Database development and design. I have not settled on a specific database product yet, but want one that works with Java, Q7B/KB under windows and Linux. Apple would be nice too but not mandatory.

Anyway, knowing how friendly this forum is, I thought I'd ask the question.

Which/what Database does everyone prefer? My app will run on both full power desktop machines as well as (really targeted at) an embedded computer running linux (embeddedARM.com). So while there will be significant power available, not as much as a desktop machine.

The database will be accessed (read/write) often. So that may have an affect too. The user interface will be separated from the core. Let me explain:
The core will be a polling loop. Polling devices, processing any request they have OR commands from a disconnected user interface.

The user interface most desirably will be either through a web browser, and/or through a standard GUI.

Most all of the database activity will be done by the polling loop, however other apps including the user interface and likely others, will also perform reads and writes.

So, there you have it. Any ideas for step one, the visual DB designer? This is one step we did NOT do a great job on the first time. So with a complete re-development, I would like to get it "more right" this time!

Thanks
Tim

In your case, I would try the Q7Basic database example as you target embedded computers, which needs fastest execution speed possible. The example shows, which db features are currently implemented. If it is sufficient for you and you like the Qt designer this is the way to go. Supported are sqlite, mysql, postgresql right now.

[tseyfarth]

Thanks B.
Is there a sample also that uses the COM ports?

I did not see one.
TY
Tim

[berndnoetscher]

Thanks B.
Is there a sample also that uses the COM ports?

I did not see one.
TY
Tim

This is not implemented yet, but it will be like in KBasic.
In fact, I will just copy the related code parts. When it will be available? Maybe in December 2010.