Cubesqladmin console insert table install#
Cubesqladmin console insert table portable#
Cubesqladmin console insert table software#
Cubesqladmin console insert table code#
Cubesqladmin console insert table license#

Unlike 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.

Functions to calculate Blob values checksums in the server.

Functions 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.

Additional mathematical functions as Round or Pow.

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:

Cubesqladmin console insert table software#

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 from time to time. 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.

Cubesqladmin console insert table portable#

In addition, sharing the same database library (or engine) release also means that our apps will be 100% portable between all the supported platforms. Why this difference between the official and the supported SQLite library? The answer is that 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. In both cases -and at the time this course has been published- Xojo uses the 3.20.1 (2017, August 24) version of the SQLite engine, while the officially latest available from the SQLite Website is the 3.22.0 (2018, January 22) version. This is the class we need to use for our iOS apps. This is the class we need to use for Console, Desktop and Web apps. In order to accomplish these operations, among others involved with database management, Xojo offers two classes to choose from depending of the target platform:

Cubesqladmin console insert table code#

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.

Cubesqladmin console insert table license#

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.

Cubesqladmin console insert table install#

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.

13.7 Quiz 7: Creating, Inserting, Updating and Deleting Records.

13.5 Quiz 5: Setting the DataControl Source.

13.3 Quiz 3: Integrated Database Editor.

8 Adding New records, Inserting, Updating and Deleting.

4 Creating the Schema with SQL … From the Editor.