Blog Archives

6 JSON interview Q&As

Q1. What is JSON and how does it differ from an XML? A1. JSON (JavaScript Object Notation) is a lightweight, text-based, language-netral like XML, but less verbose than XML data exchange format. JSON is used in Web services to exchange data between client and server. Client makes ajax requests to…

JSON processing in RDBMs like PostgreSQL & Timescale Database Q&As

Q01. What is JSON?
A01. JSON is a semi-structured open standard data format that consists of key-value pairs. PostgreSQL supports native JSON data type since version 9.2. It provides many functions and operators for manipulating JSON data.

Q02. What is Timescale Database?
A02. TimescaleDB is an open-source time series database that extends PostgreSQL. TimescaleDB gives you the power of standard SQL queries on time-series data at scale.

Q03. What is the use of JSON in RDBMs? What are the weaknesses?
A03. JSON being self-describing by containing not only the actual data, but also information about the data, which is know …

JSON, Jackson, and Maven example

Step 1: Create a new simple-json project using Maven CLI.

press “Enter” for all the prompts. This creates a new “simple-json” folder with MVN artefacts like pom.xml, etc. Step 2: Import the maven project into your IDE. E.g. in eclipse File –> Import –> Existing Maven Projects and browse…

300+ Java & Big Data FAQs - Quick Prep

Java & Big Data Tutorials