Search Results for "sql sorting queries"

FunSQL is a Julia library for the compositional construction of SQL queries. Julia programmers sometimes need to interrogate data with the Structured Query Language (SQL). But SQL is notoriously hard to write in a modular fashion. FunSQL exposes full expressive power of SQL with compositional semantics. FunSQL allows you to build queries incrementally from small independent fragments. This approach is particularly useful for building applications that programmatically construct SQL queries.

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, TiDB, and many more via ODBC. The docker image runs on port 3000 and uses /var/lib/sqlpad for the embedded database directory. latest tag is continuously built from latest commit in repo.

...One can for example query any of the following data sources: any array, DataFrames, DataStreams (including CSV, Feather, SQLite, ODBC), DataTables, IndexedTables, TimeSeries, Temporal, TypedTables and DifferentialEquations (any DESolution). The package currently provides working implementations for in-memory data sources, but will eventually be able to translate queries into e.g. SQL. There is a prototype implementation of such a "query provider" for SQLite in the package, but it is experimental at this point and only works for a very small subset of queries. Query is heavily inspired by LINQ, in fact right now the package is largely an implementation of the LINQ part of the C# specification. Future versions of Query will most likely add features that are not found in the original LINQ design.

...Customize the look of nodes, edges, and clusters with the Style Designer. Build a CSS-like gallery of reusable styles that lets you apply consistent visual themes. Run SQL queries for advanced data import. Export graphs as BMP, GIF, JPG, PDF, PNG, or SVG files (with animation support). View Graphviz DOT code and command-line messages. Works on Windows and macOS with a ribbon interface and UTF-8 support for global text. Explore illustrated guides at https://exceltographviz.com With over 10,000 downloads and a SourceForge Community Choice award, this open-source VBA tool clarifies complex data. ...

ORBIT : Operating Business Intelligence Tool Making Data Accessible Through Centralized Database Access ORBIT is a business intelligence tool designed to make data accessible to a broad audience within your company by centralizing access to databases. With this application, users can easily create reports, perform interactive analyses, and extract insights from raw data. The application simplifies data handling by providing easy-to-use features for non-technical users while maintaining...

GraphQL is a data query language for APIs and a runtime for fulfilling those queries with your existing data developed by Facebook in 2012 and launched on the internet in 2015. It is an alternative to REST and ad-hoc web service architectures.

Open source simple business intelligence application and sql editor tool for Clickhouse. Auto-completion of fields, dictionaries and functions. Tips on fields and functions in Russian and English. Reformatting queries / autoformat. Minimizes brackets and subqueries. Setting the autocompletion / enableLiveAutocompletion. Backlight brackets. The list of functions is loaded based on the capabilities of the server.

Vytics lets you query and plot csv data, Excel files, databases (SQL and NoSQL). You can also organize your queries, data and graphs into reports and projects.

Webcockpit is a Web Application Generator for realtime charting and monitoring solutions. Generates JSP code to create chart images and HTML tables from SQL queries. Supports Drill-Down and pluggable look&feel. Uses JFreeChart, Displaytag and Cewolf.

This is a SQL interface for scilab. It will enable users of scilab to do queries to a sql database and get the results in a normal scilab array. <p> <a href="http://www-rocq.inria.fr/scilab/"'>Scilab homepage</a>