BigQuery support

[w113st]

Hi, can you support BigQuery?

[victorteokw]

Hi @w113st, What is BigQuery?

[victorteokw]

@w113st, could you please star this repo? Thanks

[victorteokw]

@w113st, Is it a database? Are you familiar with Teo? How do you think to support it?

[w113st]

Hi Victor, it's Google's relational database that supports geoqueries. 10 GiB of data is free. You can use node package like this:

const {BigQuery} = require('@google-cloud/bigquery');
const bigquery = new BigQuery();

async function queryWithPagination(pageNumber, resultsPerPage) {
  const query = `
    SELECT *
    FROM your_table
    ORDER BY some_column
    LIMIT @resultsPerPage
    OFFSET @offset
  `;

  const options = {
    query: query,
    params: {resultsPerPage, offset: (pageNumber -  1) * resultsPerPage},
    location: 'US',
  };

  const [rows] = await bigquery.query(options);
  return rows;
}

There's a local emulator you can use for testing: https://github.com/goccy/bigquery-emulator

[victorteokw]

@w113st, I think in the future, Cassandra and BigQuery will be supported. The current SQL connector cannot support BigQuery.

[w113st]

Ok sure thank you. I will keep following your work after GraphQL Joker

[victorteokw]

Thanks @w113st