DEV Community: Prasanna Kumar

Google FireStore Data Source Plugin for Grafana.

Prasanna Kumar — Mon, 20 Nov 2023 03:32:29 +0000

firestore-grafana-datasource

Google Firestore Data Source Plugin for Grafana.

Grafana Firestore Data Source Plugin enables integrating data on Firestore on to Grafana dashboards.

It uses FireQL to capture user query that translated to issue queries on Firestore and construct results.

FireQL is a Go library to query Google Firestore database using SQL syntax.

Features

Use Google Firestore as a data source for Grafana dashboards
Configure Firestore data source with GCP Project Id and Service Account for authentication
Store Service Account data source configuration in Grafana encrypted storage Secure JSON Data
Query Firestore collections and path to collections
Auto detect data types: string, number, boolean, json, time.Time
Query selected fields from the collection
Order query results
Limit query results
Query Collection Groups

Firestore data source configuration

Using datasource

FireQL - Query Google Firestore database using SQL syntax.

Prasanna Kumar — Wed, 04 Jan 2023 09:41:11 +0000

FireQL is the Golang library and interactive CLI tool to query the Google Firestore database using SQL syntax.

It is built on top of the official Google Firestore Client SDK that will allow running queries Cloud Firestore database using SQL syntax.

pgollangi / FireQL

Interactive CLI and Go library to query Google Firestore database using SQL syntax.

FireQL

FireQL is the Golang library and interactive CLI tool to query the Google Firestore database using SQL syntax.

It is built on top of the official Google Firestore Client SDK that will allow running queries Cloud Firestore database using SQL syntax. Inspired by Firebase FireSQL.

Usage

FireQL can be used as Go library or interactive command-line tool.

Go Library

An example of querying collections using SQL syntax:

import (
    "github.com/pgollangi/fireql"
)
func main() {
    fql, err := fireql.New("<GCP_PROJECT_ID>")
    //OR
    fql, err = fireql.New("<GCP_PROJECT_ID>", fireql.OptionServiceAccount("<SERVICE_ACCOUNT_JSON>"))
    if err != nil {
        panic(err)
    }
    
    // Now, execute SELECT query
    result, err := fql.Execute("SELECT * `users` order by id desc limit 10")
    if err != nil {
        panic(err)
    }
    _ = result

…

View on GitHub

Usage

FireQL can be used as a Go library or interactive command-line tool.

Go Library

An example of querying collections using SQL syntax:

import (
    "github.com/pgollangi/fireql"
)

func main() {
    fql, err := fireql.New("<GCP_PROJECT_ID>")
    //OR
    fql, err = fireql.New("<GCP_PROJECT_ID>", fireql.OptionServiceAccount("<SERVICE_ACCOUNT_JSON>"))
    if err != nil {
        panic(err)
    }

    // Now, execute SELECT query
    result, err := fql.Execute("SELECT * `users` order by id desc limit 10")
    if err != nil {
        panic(err)
    }
    _ = result
}

Command-Line

fireql [flags]

Example:

$ fireql --project $PROJECT_ID
Welcome! Use SQL to query Firestore.
Use Ctrl+D, type "exit" to exit.
Visit github.com/pgollangi/FireQL for more details.
fireql>select id, name from users limit 2
+------+------------+
|  ID  |    NAME    |
+------+------------+
| 1046 | bob        |
| 1047 | smith      |
+------+------------+
(2 rows)
fireql>

Read the documentation for more information on CLI usage.

Examples

Some cool SELECT queries that are possible with FireQL:

select * from users
select *, id as user_id from users
select id, email as email_address, `address.city` AS city from `users`
select * from users order by 'address.city' desc limit 10
select * from `users` where id > 50
select id, LENGTH(contacts) as total_contacts from `users`

See Wiki for more examples.

Installation

Homebrew

brew install pgollangi/tap/fireql

Updating:

brew upgrade fireql

Scoop (for windows)

scoop bucket add pgollangi-bucket https://github.com/pgollangi/scoop-bucket.git
scoop install fireql

Docker

docker run pgollangi/fireql

Go

go install github.com/pgollangi/fireql@latest

Manual

You can alternately download a suitable binary for your OS at the releases page.

Limitations

All of firestore query limitations are applicable when running queries using FireQL.

In addition to that:

Only SELECT queries for now. Support for INSERT, UPDATE, and DELETE might come in the future.
Only AND conditions supported in WHERE clause.
No support for JOINs.
LIMIT doesn't accept an OFFSET, only a single number.
No support of GROUP BY and aggregate function COUNT.

Future scope

Expand support for all logical conditions in WHERE clause by internally issuing multiple query requests to Firestore and merging results locally before returning.
GROUP BY support
Support other DML queries: INSERT, UPDATE, and DELETE

Thanks for the read! Try using this if you are working with Firestore and share feedback.

Originally posted on my blog https://me.p11r.dev/fireql

India: Covid19 hospitals on Map

Prasanna Kumar — Fri, 07 May 2021 04:28:00 +0000

Hello!

I have created a site to locate covid19 hospitals in India on map with details like beds availability, contact information and directions to the hospitals.

Idea is to bring all hospitals on the map so that any one quickly search nearby hospitals or search hospitals near to an address. And be able to navigate to it using the directions.

Site: https://covidhospitals.online/
GitHub: https://github.com/covidhospitals/covidhospitals

Features:

Explore nearby hospitals using current device location
Search address to look at hospitals around that.
See hospitals contact details like phone, address along with beds availability
Get directions to navigate to hospital location

Built With

Source of Data

Currently hospital location, and beds information is being collected for AP, and Delhi states. Feel free to volunteer to contribute the data adhering the JSON format.

State or Locality	Site	Normalised data
Andhra Pradesh	http://dashboard.covid19.ap.gov.in/	See here
Delhi	https://coronabeds.jantasamvad.org/	See here

Credits

A big thanks Netlify for hosting the covidhospitals.online
Thanks to npoint.io for hosting the AP hospital location data.

Please feel to make changes to the site and add more data sources to it. Any contributions are most welcome.

go-portfinder: Go implementation of npm portfinder

Prasanna Kumar — Wed, 14 Apr 2021 13:15:53 +0000

Go implementation of npm portfinder. A simple tool to find an open port on the current machine.

Installation

$ go get github.com/pgollangi/go-portfinder

Usage

package main

import (
    "github.com/pgollangi/go-portfinder"
)

func main(){
     // scans and returns first open port on all network interfaces of current machine.
     openPort, err := portfinder.GetPort(&PortFinderOptions {
         StartPort: 9090,
         StopPort: 9099
     })
}

Repo: https://github.com/pgollangi/go-portfinder

fastget - ultra fast download files over HTTP(S)

Prasanna Kumar — Mon, 14 Sep 2020 04:27:56 +0000

⚡fastget is an open source CLI tool and Go library to ultra fast download files over HTTP(S).

https://github.com/pgollangi/fastget

Features

Concurrent download of files over HTTP(S) if server supports Accept-Ranges. Otherwise, fallback to single thread download.
Increase no. of concurrent workers to speed up download. Use flag --workers.
Add curl like custom headers to authentifacte HTTP(S) requests. Use flag --header.
Specify output file to write downloads. Default to file name of URL.

Demo

netselect: A CLI tool to find the fastest host based on the lowest ICMP latency.

Prasanna Kumar — Fri, 28 Aug 2020 18:01:57 +0000

netselect is a CLI tool and go library to select the fastest host based on the lowest ICMP latency.
Try it and let me know your feedback. I would greatly appreciate it.

https://github.com/pgollangi/netselect

$ netselect google.com google.in google.us
google.com       55 ms  100% ok         ( 3/ 3)
google.in        56 ms  100% ok         ( 3/ 3)
google.us        59 ms  100% ok         ( 3/ 3)