GlareDB is designed to make time to first insight as quick as possible. Instead of having to rely on ETL pipelines to move data around, GlareDB hooks directly into your data sources. With GlareDB, you no longer have to wait before being able to work on the freshest data set.
GlareDB gracefully plugs into your stack and allows you to use the languages and tools you already know.
The example below uses
psql to perform the following steps:
- Connect a GlareDB deployment named
gdbto a PostgreSQL database
- Query a table
public.animalson the PostgreSQl database
psql "postgresql://user:firstname.lastname@example.org:6543/gdb" gdb=>
Connecting GlareDB to a PostgreSQL database:
This only needs to be done once.
pg_dbwill 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', );
SELECT * from pg_db.public.animals;
animal -------- cat dog monkey (3 rows)