Now is time to create a new SQLiteDatabase instance and assign it to this property, so it will point to the SQLite database file when the app is running. With the new property selected, go to the Inspector to set the name, type and scope using these values: Select the App object from the Navigator (the left panel in the Xojo IDE), choosing the Insert > Property option from the contextual menu. Start by adding a new property in charge of the reference to our SQLite database (of course, it will work also with PostgreSQL or MySQL engines). In fact this tutorial will put all the logic in the App object. The good part is that you can mix both worlds, adding the webservice part to your regular Web app!. The first thing you’ll notice is that Xojo adds a web page to the project by default – even when our web service does not display a UI. Let’s start creating a web service! Open the Xojo IDE, create a new Web project, and name it WebService. In addition, if you want to follow and reproduce the steps of this tutorial, then you need to download the Chinook Database, named “test.sqlite” in this tutorial. In the second part, we will create a Desktop client to talk with the web service (you may want to add iOS to the list).īefore we start, let me point out that this tutorial leaves out some details related to error checking, validation, data sanitizing and other specifics related to inputs and outputs in order to focus on the central topic. In this two part tutorial you will see how easy it is to create a basic web service using Xojo Web. Learn about APIs and web services with Xojo in the tutorial blog post. Of course, Xojo Web not only makes it possible to create your own web apps, but it also acts as the perfect middleware that your desktop and iOS apps can communicate with. I’m looking at you: HTML, CSS (is that even a language?), JavaScript, PHP, et al. Using Xojo Web to create complete web apps and solutions means not having to learn a bunch of interpreted languages and dozens of ever-changing frameworks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |