- On 13th March 2013
- Posted by Orsolya Jusztin
- indices sqlite, javascipt data management, JayData, sqlite database, transactions in SQlite
Why choose SQLite Pro provider?
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 web sites 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.
SqLite Pro provider provides all features that the community version has with the same syntax, they are interchangeble. 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.
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:
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.
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.