Why GlareDB?
GlareDB is designed to make time to first insight as quick as possible. Instead of having to rely on ETL (Extract-Transform-Load) pipelines to move data across databases, GlareDB hooks directly into your data sources. With GlareDB, you no longer have to wait on an ETL pipeline before being able to work on the freshest data.
Simple interface
GlareDB gracefully plugs into your stack and allows you to use the languages and tools you already know.
Example: query an external PostgreSQL database in 2 steps
The example below uses psql
to perform the following steps:
- Connect a GlareDB deployment named
gdb
to a PostgreSQL database - Query a table
public.animals
on the PostgreSQl database
Connecting:
psql "postgresql://user:password@proxy.glaredb.com:6543/gdb"
Response:
gdb=>
Connecting GlareDB to a PostgreSQL database:
This only needs to be done once.
pg_db
will be recognized as a data source for future sessions and queries, unless it is explicitly removed.
CREATE EXTERNAL DATABASE pg_db
FROM postgres
OPTIONS (
host = 'localhost',
port = '5432',
user = 'postgres',
password = 'postgres',
database = 'postgres',
);
Response:
CREATE DATABASE
Querying pg_db
:
SELECT * from pg_db.public.animals;
Response:
animal
--------
cat
dog
monkey
(3 rows)
Refer to data sources for more information on data sources