JayData WebSQL Provider Pro

The JayData Pro product line is for professional users. Pro products come with extra features and support. The features have been designed and developed with business apps in mind. SqLite Pro extra features allow app developers to create business grade websites and mobile applications. With our professional support, we save developers long hours of precious time and they can also get fast bugfixes and patches if needed.

Features

SqLite Pro provider provides all features that the community version has with the same syntax, they are interchangeable. The Pro version can work both with the community version of JayData and with JayData Pro. However, the Pro version adds new features that are missing from the community version.

Transactions

SqLite database engine provides ACID transaction support. With sqLite Pro provider, you can use this feature from JayData with a very simple syntax. Transactions can be used to isolate operations so your data won’t be corrupted. You can also use atomicity to be able to roll back transactions. You can read about transactions in this blogpost:

http://jaydata.org/blog/database-transaction-handling-in-jaydata.

Indices

SqLite has built-in index support. With sqLite Pro providers, you can utilize this feature from JayData. Indices must be declared with the Entity Context declaration, JayData creates the indices on the database. Then sqLite does the rest, selects the appropriate index for a given query, updates the indices when you insert or update a record. It is the responsibility of the developer to declare the necessary indices when a query can not use any index then the database must do a full table scan which can be slow, having too many indices might slow down inserts and updates and might take a lot of space.

http://jaydata.org/blog/database-indices

How to use

When you purchase sqLite Pro provider then you get a zip file. Copy SqLiteProProvider.min.js file to your website or into your mobile application. In your html file, after you included jaydata.min.js include SqLiteProProvider.min.js.

Then use JayData as with the community drivers, the only difference is that you can use the extra features.