JayData.org

Feature matrix

The following table shows the features of JayData and summarizes the feature availability for each provider and data service. There are many features under development and we have even more on the roadmap. You can find not available features (marked with N/A), which aren’t feasable due to the limitation of the underlying datastore or data service.

Feature name/ProviderHTML5 local-StorageSQLite WebSQLWebSQL ProODataASP.NET WebAPIIndexedDBIndexedDB ProMongoDBMongoDB Pro
LicenceMIT/GPL v3MIT/GPL v3Commercial/
30day trial
MIT/GPL v3MIT/GPL v3MIT/GPL v3Commercial/
30day trial
MIT/GPL v3Commercial/
30day trial
PriceFreeFree$350FreeFreeFree$350Free$350
Compatible with JayData open-source libraryYESYESYESYESYESYESYESYESYES
Compatible with JayData Pro libraryYESYESYESYESYESYESYESYESYES
Total support hours for provider-specific questions004000404
Total number of apps for production, commercial or training purposes (**)--3---3-3
Query Operations
filter()YESYESYESYESYESYES**YESYESYES
map()YESYESYESYESYESYES**YESYESYES
orderBy()YESYESYESYESYESYES**YESYESYES
orderbyDescending()YESYESYESYESYESYES**YESYESYES
Order by multiple columsYESYESYESYESYESYES**YESYESYES
take()YESYESYESYESYESYES**YESYESYES
skip()YESYESYESYESYESYES**YESYESYES
GroupingSOONSOONSOONSOONSOONSOONSOONSOONSOON
HavingSOONSOONSOONN/AN/ASOONSOONN/ASOON
include/extendSOONYESYESYESYESSOONSOONYES**YES**
some()YESSOONSOONYESYESNOYESSOONSOON
every()SOONSOONSOONYESYESNOYESSOONSOON
inlineCount()SOONSOONYESSOONNOSOONYESYES
next()YESYESYESYESYESNOYESYESYES
prev()YESYESYESYESYESNOYESYESYES
contains()YESYESYESYESYESNOYESYESYES
startsWith()YESYESYESYESYESNOYESYESYES
endsWith()YESYESYESYESYESNOYESYESYES
length()YESYESYESYESYESYESYESYESYES
distance() – geoN/AN/AN/AYES***SOONN/AN/ANOYES
intersects() – geoN/AN/AN/AYES***SOONN/AN/ANOYES
Write operations
InsertYESYESYESYESYESYESYESYESYES
UpdateYESYESYESYESYESYESYESYESYES
DeleteYESYESYESYESYESYESYESYESYES
addMany()YESYESYESYESYESYESYESYESYES
Result operations
toArrayYESYESYESYESYESYESYESYESYES
foreachYESYESYESYESYESYESYESYESYES
singleYESYESYESYESYESYES**YESYESYES
countYESYESYESYESYESYES**YESYESYES
firstYESYESYESYESYESYES**YESYESYES
JavaScript types
numberYESYESYESYESYESYESYESYESYES
datetimeYESYESYESYESYESYESYESYESYES
stringYESYESYESYESYESYESYESYESYES
boolYESYESYESYESYESYESYESYESYES
objectYESSOONSOONN/AYESYESYESYESYES
geography typesYESYESYESYESYESYESYESYESYES
GuidYESYESYESYESYESYESYESYESYES
arrayYESYESYESYESYESYESYESYESYES
$data.Day/Edm.DateSOONSOONSOONYESSOONSOONSOONSOONSOON
$data.EnumSOONSOONSOONYESSOONSOONSOONSOONSOON
Relation multiplicities
1..1YESYESYESYESYESYESYESYESYES
1..NYESYESYESYESYESYESYESYESYES
N..M with 2x 1..NYESYESYESYESYESYESYESYESYES
Complex type mappingN/AN/AN/AYESYESSOONSOONYESYES
TransactionsNONOYESYESNONOYESN/AN/A
IndexingNONOYESNONONOYESNOYES
Batch/Multi-queryN/AN/AN/ASOONNON/AN/ASOONSOON
Schema generation from JS entityYESYESSOONN/AYESYESN/AN/A
JS Entity generation from schemaSOONSOONYESSOONSOONSOONN/AN/A
Recommended max. records***10 K5-600 KN/AN/A10K7-800 K1mil1mil

YES: Currently available

YES**: Operates with the help of InMemory provider

YES***: Only with MongoDb Provider Pro

M: Manual

SOON: This feature will be supported in the future

N/A: Not supported by the protocol

* only with take

*** applies only to commercial Pro providers