QueryBuilder can be used on advanced search engine pages, administration backends, etc. to build complex queries or filters. It is highly customisable and can be used with many jQuery widgets like autocompleters and sliders.
It outputs a structured JSON of rules which can be easily parsed to create SQL/NoSQL/whatever queries.
Recorded version of a vision talk presented at VLDB 2011 (37th International Conference on Very Large Data Bases). PowerPoint slides, paper, and online demo ...
Dataclips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create a query on dataclips.heroku.com, and then share the resulting URL with co-workers, colleagues, or the world. The recipients of a dataclip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats
The Visual Query Builder helps you construct complex database queries without you having to know the syntax of SQL statements. A rich set of visual options are available to let you combine SQL clauses like JOINs, GROUP BY with properties like Indexes, Operators, Aliases, Sort Type, Sort Order and Criteria. Based on your selections, the Visual Query Builder will generate a complete SQL statement that can be executed. Features like Quick Criteria Mode, Quick Filtering, Index Assistant, flexible layouts, and drag and drop to include JOINs save you time and make the process of building queries more powerful and intuitive.
The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook data model here.
Apache Drill provides low latency ad-hoc queries to many different data sources, including nested data. Inspired by Google's Dremel, Drill is designed to scale to 10,000 servers and query petabytes of data in seconds.
Korma is a domain specific language for Clojure that takes the pain out of working with your favorite RDBMS. Built for speed and designed for flexibility, Korma provides a simple and intuitive interface to your data that won't leave a bad taste in your mouth.
The DBacesslayer aka DBSlayer aka Släyer is a lightweight database abstraction layer suitable for high-load websites where you need the scalable advantages of connection pooling. Written in C for speed, DBSlayer talks to clients via JSON over HTTP
Expose your database (or any fine grained subset of it) to executives or business analysts (or any other non-technical personnel) for quick browsing and ad-hoc reports.
B. Howe, G. Cole, N. Khoussainova, and L. Battle. Proceedings of the 2011 ACM SIGMOD International Conference on Management of data, page 1319--1322. New York, NY, USA, ACM, (2011)