This is the Linux app named OctoSQL whose latest release can be downloaded as v0.12.1.zip. It can be run online in the free hosting provider OnWorks for workstations.
Download and run online this app named OctoSQL with OnWorks for free.
Follow these instructions in order to run this app:
- 1. Downloaded this application in your PC.
- 2. Enter in our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 3. Upload this application in such filemanager.
- 4. Start the OnWorks Linux online or Windows online emulator or MACOS online emulator from this website.
- 5. From the OnWorks Linux OS you have just started, goto our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 6. Download the application, install it and run it.
SCREENSHOTS:
OctoSQL
DESCRIPTION:
OctoSQL is predominantly a CLI tool which lets you query a plethora of databases and file formats using SQL through a unified interface, even do JOINs between them. (Ever needed to join a JSON file with a PostgreSQL table? OctoSQL can help you with that.) OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. At the same time it's an easily extensible full-blown dataflow engine, and you can use it to add a SQL interface to your own applications. OctoSQL supports a bunch of file formats out of the box, but you can additionally install plugins to add support for other databases. You can specify the output format using the --output flag. Available values for it are live_table, batch_table, csv and stream_native. With Go in version >= 1.18 the application can be built from source. This can be achieved by cloning the repository and running go install from the project directory.
Features
- To use databases which are not included in the core of OctoSQL - like PostgreSQL or MySQL - you need to install a plugin. Installing plugins is very easy
- Plugins are grouped into repositories, and potentially have many versions available
- Browsing available and installed plugins is possible through OctoSQL itself
- Some plugins, like the random_data plugin, can be used without any additional configuration
- OctoSQL is statically typed
- Most of the type system is straight-forward and intuitive, similar to what you'd find in other SQL dialects
Programming Language
Go
Categories
This is an application that can also be fetched from https://sourceforge.net/projects/octosql.mirror/. It has been hosted in OnWorks in order to be run online in an easiest way from one of our free Operative Systems.