This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
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.
1 2 |
<script src="jaydata/jaydata.min.js" type="text/javascript"></script> <script src="jaydatapro/SqLiteProProvider.min.js" type="text/javascript"></script> |
Then use JayData as with the community drivers, the only difference is that you can use the extra features.