JSON vs. PascalABC.NET vs. TaffyDB vs. dbForge Query Builder for SQL Server Comparison Chart

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language Standard ECMA-262 3rd Edition - December 1999. JSON is a text format that is completely language independent but uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others. These properties make JSON an ideal data-interchange language. JSON is built on two structures: 1. A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array. 2. An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence. These are universal data structures. Virtually all modern programming languages support them in one form or another.

​TaffyDB is an open source JavaScript library that brings powerful database functionality into your JavaScript applications. It offers a small file size with extremely fast queries and a powerful JavaScript-centric data selection engine. TaffyDB includes database-inspired features such as count, update, and insert, and provides robust cross-browser support. It is easily extended with your own functions and is compatible with any DOM library, as well as server-side JavaScript. Creating a database is straightforward, you can create a new empty database, a database with a single object, an array, or a JSON string. Once you have a database, you can run queries against it by calling the root function and building filter objects. TaffyDB allows you to filter using the database name and object comparison, access data easily, and modify data on the fly. You can also use functions to give you full control over the results of your query.