[JSONstore] stores a multidimentional JSON object into a WebDNA database
JSON standard is language-independent and its data structures, arrays and objects, are universally recognized. These structures are supported in some way by nearly all modern programming languages and are familiar to nearly all programmers. These qualities make it an ideal format for data interchange on the web. It handles different types of data: numbers, strings, boolean, arrays... The problem relies in JSON objects structure that can be complicated to handle as it can include other nested objects, arrays, arrays with objects, objects with nested arrays, objects with nested objects, object with nested arrays and objects... a number of structures that are difficult to recognize and parse and even more complicated to store.
{
"first": "John",
"last": "Doe",
"age": 39,
"interests": [ "Reading", "Mountain Biking", "Hacking" ],
"favorites": {
"color": "Blue",
"sport": "Soccer",
"food": "Spaghetti"
},
"skills": [
{
"category": "JavaScript",
"tests": [
{ "name": "One", "score": 90 },
{ "name": "Two", "score": 96 }
]
},
{
"category": "CouchDB",
"tests": [
{ "name": "One", "score": 79 },
{ "name": "Two", "score": 84 }
]
},
{
"category": "WebDNA",
"tests": [
{ "name": "One", "score": 97 },
{ "name": "Two", "score": 93 }
]
}
]
}
first=John
last=Doe
age= 39
interests:array=["Reading","Mountain Biking","Hacking"]
skills:array=[{"category":"JavaScript","tests":[{"name":"One", "score":90},{"name": "Two", "score": 96 }]},{"category":"CouchDB","tests":[{"name":"One","score":79},{"name":"Two","score":84 }]}, {"category":"WebDNA","tests":[{"name":"One","score":97},{"name":"Two","score":93}]
favorites:color=blue
favorite:sport=Soccer
favorite:food=Spaghetti
first - last - age - interests:array - favorites:color - favorite:sport - favorite:food - skills:array
If the database does not exist, then WebDNA will automatically create it with the proper fields
[JSONstore db=whatever.db]
JSONobject
[/JSONstore]
From version 8.2, it is possible to use a table with [JSONstore table=whatever.db]
A debug=on option is available to know exactly what and how it is stored
first=John
last=Doe
age= 39
interests:array=["Reading", "Mountain Biking", "Hacking"]
favorites:color=Blue
favorites:sport=Soccer
favorites:food=Spaghetti
skills:array=[{"category": "JavaScript", "tests": [{ "name": "One", "score": 90 }, { "name": "Two", "score": 96 }]}, { "category": "CouchDB", "tests": [ { "name": "One", "score": 79 }, { "name": "Two", "score": 84 }]}, { "category": "WebDNA", "tests": [ { "name": "One", "score": 97 }, { "name": "Two", "score": 93 }]}]
{
"first": "[first]",
"last": "[last]",
"interests": [interest:array],
"favorites": {
"color": "[favorite:color]",
"food": "[favorite:food]"
"sport": "[favorite:sport]"
}
"skills": [skills:array]
}
DOWNLOAD WEBDNA NOW!
A compilation of some user's questions...
AWS Raw WebDNA LAMP-Plus WebServerAmazon Web Services (AWS) README for Machine Image ID...
WebDNA ModulesA list of the currently available modules...
WebDNA LibrariesA list of available libraries for WebDNA...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
[biotype]BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...
[FindString Source=...
[copyfolder]Copy a folder and all its contenton your webspace...
[movefolder]Move a folder and all its contenton your webspace...
[removehtml]Removes HTML or WebDNA tags from a string of text...
[addfields][addfields db=...
[delete][delete db=some...