12/23/2023 0 Comments Sqlite tutorial pptUnlike other database engines that offer a Client/Server architecture, SQLite was not developed from its inception to support several simultaneous accesses over a database file residing under a network server. Independent of the SQLite implementation you decide to use, notice that all the database operations made on SQLite use the SQL language, in fact the SQL/92 and SQL/99 subset. String functions as SoundEx or not using accented characters for text search The first of these is the MBS Xojo SQL Plugin and the second one is MBS SQLite Extension, adding the following features over the ones you can find in the default SQLite implementation:Īdditional mathematical functions as Round or Powįunctions to save Blob values (large Binary Objects) in files, outside of the own database file something that is always preferred and even a good practice.įunctions to calculate Blob values checksums in the server For example, Monkeybread Software offers two Multiplatform plug-ins. For example, when this course was published, we already knew that the Xojo 2018.1 release will support 256 bits ciphering, being significantly more strong in comparison with the 128 bits used until Xojo 2017r3 release.Īnyway, if you find yourself in a situation where you need additional features not included in the Xojo provided SQLite implementation, you can turn to any of the available third parties add-ons and components that expand the use of SQLite even more. Of course, Xojo also updates the implemented SQLite library nearly every new release. Thus, the most important fact we have to remember is that, while we may not be using the latest available SQLite release, we will not be using a release far away either and with the assurance that we will get the same behavior no matter that the solution will be running under macOS, Windows or Linux, for example. In addition, sharing the same database library (or engine) release also means that our apps will be 100% portable between all the supported platforms. Xojo adds the most stable, tested and trustable SQLite release to the framework, avoiding some of the problems, backwards compatibility issues or bugs that may arise when adopting the latest available releases. This is the class we need to use for Console, Desktop, Web and iOS apps. In order to accomplish these operations, among others involved with database management, Xojo offers a Class that makes everything simpler: We can create an SQLite database from scratch via code from the app. We can design an SQLite database from scratch, using the integrated Database Editor in the Xojo IDE. We can connect with one or several already existing SQLite databases, working with the data contained in their respective tables. The databases generated with SQLite are common files, whose size is only limited by the Operating System used to store them. SQLite is included by default in a wide range of devices, even in the main Operating Systems used for Desktop, Smartphones, tablets, Smart TV, etc. SQLite has a low footprint, so your deployed executables will not need a lot of storage this is paramount if you need to deploy your Xojo solutions on embedded hardware with strict requirements. This means that you will not have to pay a license or royalties for using SQLite in your developed solutions, even if they are commercial. Xojo takes care of everything, offering the same behavior in all the supported platforms! What's more, thanks to Xojo you can forget about the need to include or add any SQLite libraries to the deployed executable package. This means that the users of the apps don 't need to use additional hardware or install additional or external components in order to use them. What Xojo licenses support the use of SQLite in your products? Absolutely all of them: Xojo Lite, Desktop, Pro, Web, iOS, Pi and Enterprise!Ī few reasons the SQLite a database engine so popular is: In addition, Xojo solutions using SQLite can be easily deployed to any of the supported platforms without the need of making changes in the base code (or with minimal changes). Users of these Xojo apps don 't have to install any additional components or libraries. SQLite and Xojo are a great team for managing large amounts of information easily.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |