JayData SQLite Pro provider

14 Mar
Categories: JayData Pro
Author: Gabor Dolla
- - - - -

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.

 

Features

 

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.

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.

 

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

Buy $250 for 3 apps
OR
Download Free - 30 days trial

SQlite, provider

Leave a comment
comments powered by Disqus