8 Database Support
8 Database Types Supported In CRUD APIs
This deep populate feature is supported in all types of databases and supported in all APIs, which returns data.
MongoDB
Find data from mongodb
MySQL
Get city data from mysql
SQL Server
Get states data from sql server database
Maria DB
Get countries data from maria database
Oracle DB
Get continent data from database
PostgreSQL DB
Get planets data from postgresql database
Ti DB
Get planets data from TI database
Percona XtraDB
Get planets data from Percona Xtra database
- One GET API call can get data from N number of different types of databases with N number of data complexity.
- Stream APIs can stream huge amount of data.
- In our custom APIs, we can get huge data as one by one object so we can process them one by one.
- If caching is enabled in any table/collection, it can leverage that and speed up the process.
8 Database support request body
{
"find": {
"person_name": "Kishan"
},
"deep": [
{
"s_key": "street_id",
"t_key": "id",
"t_table": "streets",
"deep": [
{
"s_key": "area_id",
"t_key": "id",
"t_table": "areas",
"deep": [
{
"s_key": "city_id",
"t_key": "id",
"t_table": "cities",
"deep": [
{
"s_key": "state_id",
"t_key": "id",
"t_table": "states",
"deep": [
{
"s_key": "country_id",
"t_key": "id",
"t_table": "countries",
"deep": [
{
"s_key": "continent_id",
"t_key": "id",
"t_table": "continents",
"deep": [
{
"s_key": "planet_id",
"t_key": "id",
"t_table": "planets",
"deep": [
{
"s_key": "galexy_id",
"t_key": "id",
"t_table": "galaxies"
}
]
}
]
}
]
}
]
}
]
}
]
}
]
}
]
}
Response from 8 different databases
{
"person_name": "Kishan",
"street_id": { // from MongoDB
"id": 12,
"street_name": "TIRUPATI",
"area_id": { // from MySQL
"id": 24,
"area_name": "RANIP",
"city_id": { // from SQL_SERVER
"id": 382480,
"city_name": "AHMEDABAD",
"state_id": { // from MariaDB
"id": 91,
"state_name": "GUJARAT",
"country_id": { // from Oracle
"id": 4,
"country_name": "INDIA",
"continent_id": { // from PostgreSQL
"id": 3,
"countinent_name": "ASIA"
"planet_id": { // from Ti DB
"id": 2,
"planet_name": "EARTH"
"galexy_id": { // from Percona XtraDB
"id": 1,
"galaxies_name": "Milky Way"
}
}
}
}
}
}
}
}
}
Save/Update in 8 databases in one API call
MongoDB
Find data from mongodb
MySQL
Get city data from mysql
SQL Server
Get states data from sql server database
Maria DB
Get countries data from maria database
Oracle DB
Get continent data from database
PostgreSQL DB
Get planets data from postgresql database
Ti DB
Get planets data from TI database
Percona XtraDB
Get planets data from Percona Xtra database
- One GET API call can get data from N number of different typea of databases with N number of data complexity.
- Moreover we can stream data also, we can get a huge amount of data also.
- In our custom APIs, we can get huge data as one by one object so we can process them one by one.
Master save request body
{
"person_name": "Kishan",
"street_id": { // for MongoDB
"id": 12,
"street_name": "TIRUPATI",
"area_id": { // for MySQL
"id": 24,
"area_name": "RANIP",
"city_id": { // for SQL_SERVER
"id": 382480,
"city_name": "AHMEDABAD",
"state_id": { // for MariaDB
"id": 91,
"state_name": "GUJARAT",
"country_id": { // for Oracle
"id": 4,
"country_name": "INDIA",
"continent_id": { // for PostgreSQL
"id": 3,
"continent_name": "ASIA"
"planet_id": { // for Ti DB
"id": 2,
"planet_name": "EARTH"
"galexy_id": { // for Percona XtraDB
"id": 1,
"galaxies_name": "Milky Way"
}
}
}
}
}
}
}
}
}
Master Save Response
{
"_id": "6458d476462d139b9181e3d7",
"person_name": "Kishan",
"street_id": 5555
}
Find-join from any databases in one API call
Get list of orders of product "iPhone 14 Pro" of users with name "James". Database tables can be in any different type of databases.
Find-join request body
{
"find": {
"product_id.name": "iPhone 14 Pro",
"user_id.name": "James"
}
}
List of orders
{
"success": true,
"statusCode": 200,
"data": [
{
"id": 2,
"product_id": 1,
"price": 1200,
"currency": "USD",
"user_id": 2
}
]
}
API Maker®. All rights reserved 2025
Visitors: 0
Developed by : SAVA - ISO 9001 Certified Company