Development with JsonPowerDB

JsonPowerDB is a database server that offers developer-friendly REST API services. It is known for its high performance, lightweight nature, Ajax support, and serverless architecture. This makes it simple to use and ideal for real-time database applications.

Developing database applications with JsonPowerDB is quick and easy, as it does not require any server-side programming or scripting, nor does it need any database installation. Whether you are working on a dynamic website, a mobile app, or a data analytics portal, JsonPowerDB makes the development process enjoyable and fast. All you need is a basic understanding of HTML, CSS, Bootstrap, and JavaScript.

Additionally, JsonPowerDB is just as easy and fast to use with server-side programming languages like Java, .NET, Python, or PHP.

Features of JsonPowerDB

JsonPowerDB (JPDB) is a state-of-the-art, innovative, and flexible multi-mode DBMS with several unique selling points (USPs):

High Performance: JsonPowerDB uses a proprietary algorithm for CRUD (Create, Read, Update, Delete) operations, which significantly boosts its performance compared to many popular DBMS. This means that operations like inserting, retrieving, updating, and deleting data are executed much faster, making it ideal for applications that require high-speed data processing.

Serverless Development: JsonPowerDB supports serverless development, allowing developers to build fully dynamic applications without needing server-side programming. This feature is particularly beneficial for UI developers, as it simplifies the development process and speeds up the creation of applications.

Integrated Server and Caching: JsonPowerDB includes a built-in web/application server and embedded caching. This integration ensures that data retrieval and processing are extremely fast, as the data is readily available in memory. The embedded caching reduces the need to repeatedly access the database, further enhancing performance.

Native NoSQL: JsonPowerDB provides native NoSQL support, which means it can handle unstructured data efficiently. This feature allows for excellent query performance, making it suitable for applications that require flexible data models and quick access to large volumes of data.

Multi-Database Querying: JsonPowerDB supports querying across multiple databases within the JPDB ecosystem. This capability allows developers to perform complex queries that span different databases, providing a more comprehensive view of the data and enabling more sophisticated data analysis.

Versatile DBMS: JsonPowerDB is a multi-mode DBMS, meaning it can function as a Document DB, Key-Value DB, and RDBMS. This versatility allows developers to choose the most appropriate data model for their application, whether it involves storing documents, key-value pairs, or relational data.

Schema-Free: JsonPowerDB is schema-free, which simplifies the development and maintenance of the database. Developers do not need to define a fixed schema before inserting data, allowing for more flexibility and easier adaptation to changing data requirements.

Web Services API: JsonPowerDB offers a web services API that is compatible with any programming language that supports HTTP. This feature makes it easy to integrate JsonPowerDB with various applications and services, regardless of the programming language used.

Pluggable API Framework: JsonPowerDB includes a pluggable API framework, enabling developers to create custom APIs and integrate them into any cloud JPDB instance. This flexibility allows for the extension of JsonPowerDB’s functionality to meet specific application needs.

Standardized API Development: JsonPowerDB standardizes the API development framework, making the development process more straightforward, readable, and less prone to errors. This standardization helps maintain consistency and quality across different APIs and applications.

Enhanced Security: JsonPowerDB features multiple layers of security to protect data from unauthorized access and breaches. These security measures ensure that sensitive information is safeguarded, providing peace of mind for developers and users alike.

Real-Time Performance: JsonPowerDB is designed to be nimble and easy to use, with in-memory data storage that enables real-time performance. This feature is crucial for applications that require immediate data access and processing, such as real-time analytics and monitoring systems.

Language Syntax

JsonPowerDB (JPDB) uses JSON syntax rules:

• <...>: User-specified value.

• <<...>>: Optional parameter, defaults if not used.

• |: OR, choose one of the specified values.

• ...: Ellipsis, indicating more values can be added if needed.

Setup Instructions

Connection Token

To interact with JsonPowerDB, you need a connection token for security. Here’s how to get it:

1. Log in to the JPDB API Dashboard.

2. Click on the “Tools” option in the left navigation.

3. Select the “Tokens” panel and choose the “connection-token” option from the dropdown.

4. Copy the “connection-token” from the token table.

5. If there is no “connection-token” or you need a new one, click the “Generate Connection_Token” button to create a new token.

6. Copy the newly generated “connection-token” from the token table.

Response Headers

JsonPowerDB may return the following information in milliseconds in the response headers for IML, IRL, IDL, and ISL APIs:

• serverTime: Time taken by the server to process the request and return a response.

• reqResTime: Time taken to convert the request to a response (excluding KVP API). It includes parseTime and execTime.

• parseTime: Time taken to parse and validate the request.

• execTime: Time taken to execute the validated request.

Commands

IML (JPDB Index Manipulation Language)

To insert, update, and delete JSON data, use the following commands with the HTTP POST method:

• Base URL: http://api.login2explore.com:5577

• Endpoint URL: /api/iml (unless specified otherwise)

Commands:

• PUT: Insert a single record into the database.

• PUT_ALL: Insert multiple records into the database.

• UPDATE: Update multiple records or add a new column to a record.

• SET: Insert a new record or update an existing record based on the primary key.

• SET_ALL: Insert and update records based on the primary key.

• REMOVE: Remove records from the database.

Pluggable APIs

• COPY COLUMN: Copies columns.

• RENAME COLUMN: Renames columns.

• REMOVE COLUMN: Removes columns.

• CHANGE COLUMN TYPE: Changes the data type of columns.

• MERGE COLUMN: Merges two columns.

IRL (JPDB Index Retrieval Language)

IRL is used to retrieve JSON data. Here are the details:

• HTTP Method: POST

• Base URL: http://api.login2explore.com:5577

• Endpoint URL: /api/irl

Commands

• GET (Deprecated - use GET_BY_KEY): Retrieves a single record by JSON data.

• GET_BY_KEY: Retrieves a single record by JSON data.

• GET_ALL: Retrieves multiple records from a relation.

• FIND_RECORD / FIND_ALL_RECORDS: Retrieves records by JSON data.

• GET_RECORD (Deprecated - use GET_BY_RECORD): Retrieves a single record by record number.

• GET_BY_RECORD: Retrieves a single record by record number.

• FIRST_RECORD: Retrieves the first record from the JPDB database.

• LAST_RECORD: Retrieves the last record from the JPDB database.

• NEXT_RECORD: Retrieves the next record by record number.

• PREV_RECORD: Retrieves the previous record by record number.

• GET_RELATION_STATS / GET_RELATION_SIZE: Gets the total number of records and the size of the relation.

• GET_ALL_DB: Retrieves all database names from the JPDB database.

• GETALLREL (Deprecated - use GET_ALL_RELATIONS): Retrieves all relation details from the JPDB database.

• GET_ALL_RELATION (Deprecated - use GET_ALL_RELATIONS): Retrieves all relation details from the JPDB database.

• GET_DB_STATS / GET_ALL_RELATIONS: Retrieves all relation details from the JPDB database.

• GET_USER_STATS: Retrieves user details.

• GET_INDEXED_COL: Retrieves all indexed column names from the JPDB database.

• GET_NON_INDEXED_COL: Retrieves all non-indexed column names from the JPDB database.

• GET_ALL_COL: Retrieves all column names from the JPDB database.

• IS_COLUMN_INDEXED: Checks whether a column is indexed.

Conclusion

JsonPowerDB (JPDB) stands out as a modern, innovative, and versatile database management system (DBMS) that offers numerous unique features. It excels in high performance due to its proprietary algorithm for CRUD operations, making it significantly faster than many other DBMS options. The serverless development capability allows for rapid and straightforward creation of dynamic applications without the need for server-side programming.

With its integrated server and caching, JsonPowerDB ensures lightning-fast data retrieval and processing. Its native NoSQL support and ability to handle unstructured data efficiently make it suitable for applications requiring flexible data models. The multi-database querying feature allows for complex queries across different databases, providing a comprehensive view of the data.

JsonPowerDB’s versatility as a Document DB, Key-Value DB, and RDBMS, along with its schema-free design, simplifies development and maintenance. The web services API compatibility with any programming language that supports HTTP, and the pluggable API framework, offer flexibility and ease of integration.

Standardized API development ensures a more straightforward, readable, and less error-prone development process. Enhanced security features provide multiple layers of protection for sensitive data. Lastly, its real-time performance, with in-memory data storage, makes it ideal for applications requiring immediate data access and processing.

Overall, JsonPowerDB is a powerful tool for developers looking to build efficient, high-performance, and flexible database applications quickly and easily.

Note: URL for JsonPowerDB Docs: https://login2explore.com/jpdb/docs.html