EnglishFrenchSpanish

Ad


OnWorks favicon

gda-sql-5.0 - Online in the Cloud

Run gda-sql-5.0 in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command gda-sql-5.0 that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

NAME


gda-sql - an SQL console based on Libgda

SYNOPSIS


gda-sql [--help] [-v] [--version] [-o] [--output-file <filename>] [-C] [--command] [-f]
[--commands-file <filename>] [-i] [--interactive] [-l] [--list-dsn] [-L]
[--list-providers] [-s] [--http-port <port>] [-t] [--http-token <token phrase>]
[--data-files-list] [--data-files-purge <criteria>] [connection's spec] [connection's
spec...]

DESCRIPTION


gda-sql is an SQL console based on the Libgda library.

It enables you to type in queries interactively, issue them to be executed by a
connection, and see the query results.

Several connections can be opened at the same time, allowing you to switch the active
connection to any opened connection. When starting, gda-sql opens a connection for each
connection specified on the command line (plus optionally one corresponding to the
GDA_SQL_CNC environment variable). The prompt indicates the current connection used when
executing commands. See the .c internal command for an explanation about the syntax to
specify a connection on the command line.

Alternatively, input can be from a file. In addition, it provides a number of meta-
commands and various shell-like features to facilitate writing scripts and automating a
wide variety of tasks.

It is also possible to run the tool as a script using the classic '#!' string at the start
of a script file, with the limitation that behaviour of arguments passed on the line after
the '#!' command is undefined. Example:

#!/bin/path/to/gda-sql

#!/usr/bin/env gda-sql

OPTIONS


gda-sql accepts the following options:

--help Show command-line options.

-o, --output-file <filename>
Specifies a file to which outputs are redirected.

-C, --command
Run only single command (SQL or internal) and exit.

-f, --commands-file <filename>
Execute commands from <filename>, then exit (except if -i specified).

-i, --interactive
Keep the console opened after executing a file (used with the -f option).

-l, --list-dsn
List configured data sources and exit.

-L, --list-providers
List installed database providers and exit

-s, --http-port <port>
Starts the embedded HTTP server on port <port>

-t, --http-token <token phrase>
Requires HTTP clients to authenticate by providing the <token phrase> (empty
phrase by default)

--data-files-list
Lists all the files used to hold information related to each connection (ie.
information gathered by the tool about the connection such as meta data, defined
statements,...)

--data-files-purge <criteria>
Removes file used to hold information related to each connection for the criteria
passed as argument (note that adding "list-only" to the criteria, either before or
after it using a comma, will not actually remove the file):

"non-dsn": remove all the files which do not correspond to a DSN (data source
name). These are the files created when a connection is specified using connection
parameters instead of using a DSN

"non-exist-dsn": same as "non-dsn" except it also removes the files which were for
DSN which don't exist anymore

"all": remove all the files, for a complete cleanup

For example: --data-files-purge all,list-only lists all the files (which would be
removed if the command was --data-files-purge all).

ENVIRONMENT


gda-sql can be configured through some environment variables:

GDA_SQL_CNC
to define a connection to systematically be opened when the program starts.

PAGER to define a text pager program to use (by default determined by the system).

GDA_NO_PAGER
to specify that no text pager should be used.

GDA_SQL_EDITOR EDITOR VISUAL
to define a text editor to be used (variables are examined in this order).

GDA_SQL_VIEWER_PNG
to define a PNG viewer.

GDA_SQL_VIEWER_PDF
to define a PDF viewer.

GDA_SQL_HISTFILE
to define the history file name to use (by default .gdasql_history), set to
NO_HISTORY to disable history logging.

GDA_DATA_MODEL_DUMP_ROW_NUMBERS
if set, the first column of the output will contain row numbers

GDA_DATA_MODEL_DUMP_ATTRIBUTES
if set, also dump the data model's columns' types and value's attributes

GDA_DATA_MODEL_DUMP_TITLE
if set, also dump the data model's title

GDA_DATA_MODEL_NULL_AS_EMPTY
if set, replace the 'NULL' string with an empty string for NULL values

GDA_DATA_MODEL_DUMP_TRUNCATE
if set to a numeric value, truncates the output to the width specified by the
value. If the value is -1 then the actual terminal size (if it can be determined)
is used

gda-sql can be compiled with support for binary relocatibility.
This will cause data, plug-ins and configuration files to be searched relative to the
location of the gda-sql executable file.

Use gda-sql-5.0 online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    strace
    strace
    The strace project has been moved to
    https://strace.io. strace is a
    diagnostic, debugging and instructional
    userspace tracer for Linux. It is used
    to monitor a...
    Download strace
  • 2
    gMKVExtractGUI
    gMKVExtractGUI
    A GUI for mkvextract utility (part of
    MKVToolNix) which incorporates most (if
    not all) functionality of mkvextract and
    mkvinfo utilities. Written in C#NET 4.0,...
    Download gMKVExtractGUI
  • 3
    JasperReports Library
    JasperReports Library
    JasperReports Library is the
    world's most popular open source
    business intelligence and reporting
    engine. It is entirely written in Java
    and it is able to ...
    Download JasperReports Library
  • 4
    Frappe Books
    Frappe Books
    Frappe Books is a free and open source
    desktop book-keeping software that's
    simple and well-designed to be used by
    small businesses and freelancers. It'...
    Download Frappe Books
  • 5
    Numerical Python
    Numerical Python
    NEWS: NumPy 1.11.2 is the last release
    that will be made on sourceforge. Wheels
    for Windows, Mac, and Linux as well as
    archived source distributions can be fou...
    Download Numerical Python
  • 6
    CMU Sphinx
    CMU Sphinx
    CMUSphinx is a speaker-independent large
    vocabulary continuous speech recognizer
    released under BSD style license. It is
    also a collection of open source tools ...
    Download CMU Sphinx
  • 7
    Old Feren OS Repositories
    Old Feren OS Repositories
    This was the Official Repository for
    Feren OS. To add the latest one, run
    this command: (16.04-based) echo
    "deb ...
    Download Old Feren OS Repositories
  • More »

Linux commands

Ad