jsonq - A PHP query builder for JSON

•    PHP

---

JsonQ is a simple, elegant PHP package to Query over any type of JSON Data. It'll make your life easier by giving the flavour of an ORM-like query on your JSON. You can start Query your data using the various query methods such as find, where, orWhere, whereIn, whereStartsWith, whereEndsWith, whereContains and so on. Also you can aggregate your data after query using sum, count, groupBy, max, min etc.

json json-data json-query jsonq json-manager php-json

jsonq - simple json field access for golang

•    Go

---

Simplify your golang json usage by extracting fields or items from arrays and objects with a simple, hierarchical query. API Documentation on godoc.org.This package is meant to make working with complex feeds a bit more easy. If you have simple feeds you want to model with struct types, check out jflect, which will create struct definitions given a json document.

dasel - Query, update and convert data structures from the command line

•    Go

---

Dasel (short for data-selector) allows you to query and modify data structures using selector strings. Comparable to jq / yq, but supports JSON, YAML, TOML, XML and CSV with zero runtime dependencies.

config cli yaml toml parser json query portable xml configuration update selector data-structures xml-parser devops-tools yaml-processor json-processing

json-query - Retrieves values from JSON objects for data binding

•    Javascript

---

Retrieves values from JSON objects for data binding. Offers params, nested queries, deep queries, custom reduce/filter functions and simple boolean logic. Specify a query and what to query. Returns an object that describes the result of the query.

data-binding filter json query

jsquery - JsQuery – json query language with GIN indexing support

•    C

---

JsQuery – is a language to query jsonb data type, introduced in PostgreSQL release 9.4. It's primary goal is to provide an additional functionality to jsonb (currently missing in PostgreSQL), such as a simple and effective way to search in nested objects and arrays, more comparison operators with indexes support. We hope, that jsquery will be eventually a part of PostgreSQL.

jsonb gin query-language json json-query

simdjson-go - Golang port of simdjson: parsing gigabytes of JSON per second

•    Go

---

This is a Golang port of simdjson, a high performance JSON parser developed by Daniel Lemire and Geoff Langdale. It makes extensive use of SIMD instructions to achieve parsing performance of gigabytes of JSON per second. Performance wise, simdjson-go runs on average at about 40% to 60% of the speed of simdjson. Compared to Golang's standard package encoding/json, simdjson-go is about 10x faster.

tape json-files ndjson json-document simdjson tape-format golang-standard

graphql - An implementation of GraphQL for Go / Golang

•    Go

---

A work-in-progress implementation of GraphQL in Go. Its currently a port of graphql-js v0.6.0 which is based on the April 2016 GraphQL specification. Future efforts will be guided directly by the latest formal GraphQL specification (currently: October 2016).The following is a simple example which defines a schema with a single hello string-type field and a Resolve method which returns the string world. A GraphQL query is performed against this schema with the resulting output printed in JSON format.

graphql graphql-go subscriptions

jmespath.js - Javascript implementation of JMESPath, a query language for JSON

•    Javascript

---

jmespath.js is a javascript implementation of JMESPath, which is a query language for JSON. It will take a JSON document and transform it into another JSON document through a JMESPath expression. In the example we gave the search function input data of {foo: {bar: {baz: [0, 1, 2, 3, 4]}}} as well as the JMESPath expression foo.bar.baz[2], and the search function evaluated the expression against the input data to produce the result 2.

jmespath jsonpath json xpath

pgweb - Web-based PostgreSQL database browser written in Go

•    Go

---

Pgweb is a web-based database browser for PostgreSQL, written in Go. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.

postgresql pgweb cross-platform postgresql-client postgresql-gui postgresql-admin postgresql-management postgres database-management

sqler - write APIs using direct SQL queries with no hassle, let's rethink about SQL

•    Go

---

SQL-er is a tiny portable server enables you to write APIs using SQL query to be executed when anyone hits it, also it enables you to define validation rules so you can validate the request body/query params, as well as data transformation using simple javascript syntax. sqler uses nginx style configuration language (HCL) amd javascript engine for custom expressions. RESTful server could be used to interact directly with i.e mobile, browser, ... etc, in this mode SQLer is protected by authorizers, which gives you the ability to check authorization against another 3rd-party api. Each macro you add to the configuration file(s) you can access to it by issuing a http request to /<macro-name>, every query param and json body will be passed to the macro .Input.

mysql sqlite3 postgresql cockroach mssql api-rest restful baas

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

•    Svelte

---

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.

electron mysql sql sql-server mongodb sqlite postgresql database-gui database-manager database-tools

tiedot - Your NoSQL database powered by Golang

•    Go

---

tiedot is a document database engine that uses JSON as document notation; it has a powerful query processor that supports advanced set operations; it can be embedded into your program, or run a stand-alone server using HTTP for an API. It runs on *nix and Windows operating systems.tiedot has fault-tolerant data structures that put your data safety first, while easily scales to 4+ CPU cores.

nosql database db tiedot document-database

easyjson - Fast JSON serializer for golang.

•    Go

---

Package easyjson provides a fast and easy way to marshal/unmarshal Go structs to/from JSON without the use of reflection. In performance tests, easyjson outperforms the standard encoding/json package by a factor of 4-5x, and other JSON encoding packages by a factor of 2-3x. easyjson aims to keep generated Go code simple enough so that it can be easily optimized or fixed. Another goal is to provide users with the ability to customize the generated code by providing options not available with the standard encoding/json package, such as generating "snake_case" names or enabling omitempty behavior by default.

json json-serialization code-generation json-parser perfomance

query-server - Query Server Search Engines https://query-server.herokuapp.com

•    Python

---

The query server can be used to search a keyword/phrase on a search engine (Google, Yahoo, Bing, Ask, DuckDuckGo, Baidu, Exalead, Quora, Parsijoo, Dailymotion, Mojeek and Youtube) and get the results as json, xml or csv. The tool also stores the searched query string in a MongoDB database for analytical purposes.

safesql - Static analysis tool for Golang that protects against SQL injections

•    Go

---

SafeSQL is a static analysis tool for Go that protects against SQL injections.SafeSQL uses the static analysis utilities in go/tools to search for all call sites of each of the query functions in package database/sql (i.e., functions which accept a string parameter named query). It then makes sure that every such call site uses a query that is a compile-time constant.

Defiant JS - Lightning-fast searches on JSON using XPath expressions, and transform JSON using XSLT

•    Javascript

---

DefiantJS provides the ability for you to build smart templates applicable on JSON structures, based upon proven & standardized technologies such as XSLT and XPath. DefiantJS also extends the global object JSON with the method "search", which enables searches on JSON structures with XPath expressions and returns matches as an array-like object.

xpath xslt web-worker json search browser xpath-queries query node

Dgraph - Fast, Transactional, Distributed Graph Database

•    Go

---

Dgraph is a horizontally scalable and distributed graph database, providing ACID transactions, consistent replication and linearizable reads. It's built from ground up to perform for a rich set of queries. Being a native graph database, it tightly controls how the data is arranged on disk to optimize for query performance and throughput, reducing disk seeks and network calls in a cluster.

graph-database database distributed throughput latency production graphql-server

omniparser - omniparser: a native Golang ETL streaming parser and transform library for CSV, JSON, XML, EDI, text, etc

•    Go

---

Omniparser is a native Golang ETL parser that ingests input data of various formats (CSV, txt, fixed length/width, XML, EDI/X12/EDIFACT, JSON, and custom formats) in streaming fashion and transforms data into desired JSON output based on a schema written in JSON. In the example folders above you will find pairs of input files and their schema files. Then in the .snapshots sub directory, you'll find their corresponding output files.

parser json schema csv etl xml schemas transform edifact edi codeless x12 idr fixed-length omniparser-schema

jsonpath - Query and manipulate JavaScript objects with JSONPath expressions

•    Javascript

---

Query JavaScript objects with JSONPath expressions. Robust / safe JSONPath engine for Node.js. Here are syntax and examples adapted from Stefan Goessner's original post introducing JSONPath in 2007.

jsonpath json-path object traversal json path data-structures

trefle-api - 🍀 Trefle is a botanical JSON REST API for plants species, allowing you to search and query over all the registered species, and build the next gardening apps and farming robots

•    Ruby

---

⚠️ Unfortunately, Trefle is over for now. 🍀 Trefle is a botanical JSON REST API for plants species, allowing you to search and query over all the registered species, and build the next gardening apps and farming robots.

database plants api-rest biodiversity hacktoberfest trefle trefle-api plants-species gardening-apps farming-robots