How to make a database application - step by step example

Databases
81

+1 VERY NiCE.

Are you making it generally available, if so, how may I get a copy?

82

I will make available the compiled chinook client, to let people see whatā€™s possible to do with pure xojo code
(and also sell myself !)
the database editor is still too ā€œpreliminaryā€ to be sold, but it suits my needs to make and edit databases,
so I modify it when I need it only.
Right now Iā€™m testing the libraries on local customers, then selling it may be ?

83

@Jean-Yves Pochez I hope you have an entry for Rob Dickinson as well as Bruce :slight_smile:

84

I have to agree in that itā€™s very complicated to create a database app in Xojo. Iā€™ve tried it for about a year and gave up now one year or so ago. I did a lot of reading and watched all the videos I could find and I do understand how to create a basic app, using the coding etc. But writing, updating etc data to a database is very confusing. I would love to return to Xojo from FileMaker, but I know I will get stuck at the same problem again, leaving me frustrated and stop again with Xojo. Iā€™m hopeful waiting for a time that this part of Xojo will be more simpler.

85

Itā€™s really not that hard if you understand the concepts and there are tons of example code on this forum.

I canā€™t think of another language where you could connect to a database, read, write and delete records and do all of that in less than ten lines of code.

There is also the very very excellent ARGen which will help you a lot too.

I cannot agree that using databases in Xojo is hard, itā€™s easier than in any other programming language out there.

87

Well, VB6 could do it more than two decades agoā€¦

This days there are LOTS of other tools (cant discuss them here) that can do it now. And many others that not only can do this, but actually can create all the GUI just from the database structureā€¦

Xojo is aware of this lack of functionality and it is actually on the roadmap: Roadmap ā€” Xojo documentation, at this date is No. 8

88

The database structure and the GUI, certainly in my app, have nothing to do with one another. Reading from and writing to the appā€™s databases is a tiny part of the overall app. Just because an app uses databases does not make it a database app.

1 Like
89

This ^^^^^

90

Iā€™ll rephrase to to say languages today that have a future thenā€¦

I read that roadmap entry as meaning control binding but until we get clarification weā€™ll all be guessing I suppose.

91

and always split the data and the program code to 2 db