Using DBKit to easily connect databases to Xojo applications

[@ChristianWheel]

This looks like a great time saver. Would love to see more helpful classes like this shipped with the product. For example I'm still using the deprecated Task class but would be great to have a modern version of it!

[@gperlman]

Thanks! If you have ideas for other classes like this, let us know. Regarding Task, is there a reason you can’t use the Thread class? Is it missing something you need?

[@kailahann164]

I’m just checking out DBKit. Looks great. This was the one key feature I missed in Xojo for RAD. I’ve watched many videos in the past about solutions like that and actually thought about developing something myself. One question about multi platform: Why don’t you use a Class Interface for the controls like Bob Gordon suggested in „Rapid Database Development“?

[@kailahann164]

Ok - you do have the "DBKit.Control" Interface ... So why is copying controls different to Bob's approach?

[@geoffperlman7886]

Thank you for you kinds words. DBKit is still in development and still changing. My primary goal was to make connecting a database to the user interface require no code at all. I'm continuing to move towards that goal. An interface of course would require the user to implement it which means writing code. However, I do realize there will be times when you'll want to use controls I haven't subclassed and that's where an interface can be handy so I do plan on adding one.

[@AndreasvanHaren]

I created a project following the video, but cannot get the New button to work. Nothing happens when I click it, no database/listbox row is created.

[@LanceDarby]

Question: can dbkit be used for multiple databases in a single application?

[@geoffperlman7886]

Yes, it can be. It automatically will connect to the first DBKit connection you create in your app class. However, you can manually (via code) set a Connector to any DBKit connection you make anywhere.

[@summerof100beaches6]

Good product, great demo.

[@rsals1328]

i wonder if the sql parameters are being sanitized before the sql query or we do it manually?

[@geoffperlman7886]

That's up to you to do as you can see in the Desktop and Web examples if you look at the SearchCustomers method. I am experimenting with a query method where you would simply pass in the WHERE clause but even then, I've written it so that you pass the WHERE and the values separately so that it can continue to be a prepared statement.

[@sergiomolino1891]

With Xojo 2023 r4 the Desktop example does not compile...

[@robvermeulen9884]

The option Build Step is enabled

[@LanceDarby]

Question: will dbkit work with a table using a varchar column as the primary key?

[@geoffperlman7886]

It should. I haven't explicitly tested that. If you have an issue with that let me know.

[@kakman1958]

FWIW, I've just downloaded 2023 R2 and there's no Examples folder so no DBKit available. I downloaded the DBKit resources from the Xojo site, but it doesn't include the module or example projects.

[@XojoInc]

Thanks for checking out DBKit! If you launch Xojo you'll see the project chooser. On the left menu look for the Examples at the bottom of the menu - below Templates.

[@kakman1958]

@@XojoInc Oh, thanks. I didn't realise the examples were no longer in separate folders.

[@geoffperlman7886]

@@kakman1958 They are now provided online so that we can add and update examples at any time.

[@robvermeulen9884]

Sorry Disabled