EnglishFrenchSpanish

Ad


OnWorks favicon

ase-db - Online in the Cloud

Run ase-db in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command ase-db 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


ase-db - Put stuff into or query database

SYNOPSIS


ase-db db-name [selection] [options]

DESCRIPTION


Selecton is a comma-separated list of selections where each selection is of the type "ID",
"key" or "key=value". Instead of "=", one can also use "<", "<=", ">=", ">" and "!="
(these must be protected from the shell by using quotes). Special keys: id, user,
calculator, age, natoms, energy, magmom, and charge. Chemical symbols can also be used to
select number of specific atomic species (H, He, Li, ...).

OPTIONS


-h, --help
show this help message and exit

-v, --verbose

-q, --quiet

-n, --count
Count number of selected rows.

-l, --long
Long description of selected row

-i db-name, --insert-into=db-name
Insert selected rows into another database.

-a [type:]filename, --add-from-file=[type:]filename
Add results from file.

-k key1=val1,key2=val2,..., --add-key-value-pairs=key1=val1,key2=val2,...
Add key-value pairs to selected rows. Values must be numbers or strings and keys
must follow the same rules as keywords.

-L N, --limit=N
Show only first N rows (default is 20 rows). Use --limit=0 to show all.

--offset=N
Skip first N rows. By default, no rows are skipped

--delete
Delete selected rows.

--delete-keys=key1,key2,...
Delete keys for selected rows.

-y, --yes
Say yes.

--explain
Explain query plan.

-c col1,col2,..., --columns=col1,col2,...
Specify columns to show. Precede the column specification with a "+" in order to
add columns to the default set of columns. Precede by a "-" to remove columns.
Use "++" for all.

-s column, --sort=column
Sort rows using column. Use -column for a descendin sort. Default is to sort
after id.

--cut=CUT
Cut keywords and key-value columns after CUT characters. Use --cut=0 to disable
cutting. Default is 35 characters

-p [a,b:]x,y1,y2,..., --plot=[a,b:]x,y1,y2,...
Example: "-p x,y": plot y row against x row. Use "-p a:x,y" to make a plot for each
value of a.

--csv Write comma-separated-values file.

-w, --open-web-browser
Open results in web-browser.

--no-lock-file
Don't use lock-files

--analyse
Gathers statistics about tables and indices to help make better query planning
choices.

-j, --json
Write json representation of selected row.

--unique
Give rows a new unique id when using --insert-into.

Selection examples: calculator=nwchem, age<1d, natoms=1, user=alice, 2.2<bandgap<4.1,
Cu>=10.

Use ase-db online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    VASSAL Engine
    VASSAL Engine
    VASSAL is a game engine for creating
    electronic versions of traditional board
    and card games. It provides support for
    game piece rendering and interaction,
    and...
    Download VASSAL Engine
  • 2
    OpenPDF - Fork of iText
    OpenPDF - Fork of iText
    OpenPDF is a Java library for creating
    and editing PDF files with a LGPL and
    MPL open source license. OpenPDF is the
    LGPL/MPL open source successor of iText,
    a...
    Download OpenPDF - Fork of iText
  • 3
    SAGA GIS
    SAGA GIS
    SAGA - System for Automated
    Geoscientific Analyses - is a Geographic
    Information System (GIS) software with
    immense capabilities for geodata
    processing and ana...
    Download SAGA GIS
  • 4
    Toolbox for Java/JTOpen
    Toolbox for Java/JTOpen
    The IBM Toolbox for Java / JTOpen is a
    library of Java classes supporting the
    client/server and internet programming
    models to a system running OS/400,
    i5/OS, o...
    Download Toolbox for Java/JTOpen
  • 5
    D3.js
    D3.js
    D3.js (or D3 for Data-Driven Documents)
    is a JavaScript library that allows you
    to produce dynamic, interactive data
    visualizations in web browsers. With D3
    you...
    Download D3.js
  • 6
    Shadowsocks
    Shadowsocks
    A fast tunnel proxy that helps you
    bypass firewalls This is an application
    that can also be fetched from
    https://sourceforge.net/projects/shadowsocksgui/.
    It ha...
    Download Shadowsocks
  • More »

Linux commands

Ad