Query data from
any remote source with SQL

Streambiki =
Queries as a Service (QaaS)

Extract from JSON, CSV, TSV or NDJSON
Output to JSON, CSV, TSV or NDJSON
Use and share your data your way

https://remote-server.com/users.json

{
  "name": "users",
  "people": [
    {
      "name": "Bob",
      "age": "32",
      "status": "offline"
      "cityId": "NY"
    },
    {
      "name": "Sophie",
      "age": "20",
      "status": "online"
      "cityId": "LA"
    },
    {
      "name": "Karen",
      "age": "23",
      "status": "online"
      "cityId": "NY"
    }
  ],
  "cities": [
    {
      "id": "NY",
      "city": "New York"
    },
    {
      "id": "LA",
      "city": "Los Angeles"
    }
  ]
}

My Custom Query

source

https://remote-server.com/users.json

SELECT 
    name,
    CAST(age AS INT) AS age,
    city
FROM 
    people
JOIN
    cities ON people.cityId = cities.id
WHERE 
    people.status = "online"

https://streambiki.com/me/my-custom-query.json

[
    {
        "name": "Sophie",
        "age": 20,
        "city": "Los Angeles"
    },
    {
        "name": "Karen",
        "age": 23,
        "city": "New York"
    }
]

https://streambiki.com/me/my-custom-query.csv

name	age	city
Sophie	20	Los Angeles
Karen	23	New York

Your data at your fingertips
with zero maintenance

Convert between formats

✓

Read your external source and work with tables like a local database

Input formats: CSV, TSV, JSON, NDJSON

✓

Output the results in a different format

Output formats: CSV, TSV, JSON, NDJSON

Model data to your needs

✓

Turn properties into table columns

✓

SELECT only the properties you need

✓

Rename properties with your own alias

✓

CAST() to ensure strict data typing

My Custom Query

source

https://remote-server.com/users.json

SELECT 
    name AS firstName,
    CAST(age AS INT) AS age
FROM 
    people

Use the power of SQL
to get the result you're looking for

✓

Filter with a WHERE clause

✓

Aggregate with common SQL functions like COUNT(), SUM(), AVG(), MIN(), MAX()

✓

Write conditions with IF() or CASE()

My Custom Query

source

https://remote-server.com/users.json

SELECT 
    COUNT(*) as totalOnline,
    SUM(IF(name="Bob"),1,0) as howManyBobs,
    AVG(age) AS averageAge,
    MIN(age) AS youngestAge,
    MAX(age) AS oldestAge
FROM 
    people
WHERE 
    status = "online"

Get insight into different data sets
like it's your own relational database

✓

Turn nested arrays into tables

✓

Query any direction with JOIN, LEFT JOIN, RIGHT JOIN, WHERE EXISTS()

✓

Join multiple URLs

coming

My Custom Query

users

https://remote-server.com/users.json

jobs

https://other-server.com/jobs.csv

SELECT 
    name,
    CAST(age AS INT) AS age,
    city
FROM 
    users.people
JOIN
    users.cities ON users.people.cityId = users.cities.id
LEFT JOIN
    jobs ON users.people.jobId = jobs.id

Share your query results
with easy but controlled access to others

✓

Public URLs

✓

Private URLs

✓

Result caching

coming

✓

Usage analytics

coming

Seamless integration into your code
built by developers for developers

✓

Use our service as your back-end API

✓

Work with every programming language

✓

Improve the scalability of your project without additional complexity

My IDE

fetch('https://streambiki.com/me/my-custom-query.json', {
  method: 'GET',
  headers: {
    contentType: 'application/json',
  }
})
  .then(response => response.json())
  .then(data => {
    console.log(data);
  })
  .catch(error => {
    alert(error.message);
  });

Query data from any remote source with SQL

Query data from
any remote source with SQL