EnglishFrenchSpanish

OnWorks favicon

ase-db3 - Online in the Cloud

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

This is the command ase-db3 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-db3 online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    Image Downloader
    Image Downloader
    Crawl and download images using
    Selenium Using python3 and PyQt5.
    Supported Search Engine: Google, Bing,
    Baidu. Keywords input from the keyboard
    or input from ...
    Download Image Downloader
  • 2
    Eclipse Tomcat Plugin
    Eclipse Tomcat Plugin
    The Eclipse Tomcat Plugin provides
    simple integration of a tomcat servlet
    container for the development of java
    web applications. You can join us for
    discussio...
    Download Eclipse Tomcat Plugin
  • 3
    WebTorrent Desktop
    WebTorrent Desktop
    WebTorrent Desktop is for streaming
    torrents on Mac, Windows or Linux. It
    connects to both BitTorrent and
    WebTorrent peers. Now there's no
    need to wait for...
    Download WebTorrent Desktop
  • 4
    GenX
    GenX
    GenX is a scientific program to refine
    x-ray refelcetivity, neutron
    reflectivity and surface x-ray
    diffraction data using the differential
    evolution algorithm....
    Download GenX
  • 5
    pspp4windows
    pspp4windows
    PSPP is a program for statistical
    analysis of sampled data. It is a free
    replacement for the proprietary program
    SPSS. PSPP has both text-based and
    graphical us...
    Download pspp4windows
  • 6
    Git Extensions
    Git Extensions
    Git Extensions is a standalone UI tool
    for managing Git repositories. It also
    integrates with Windows Explorer and
    Microsoft Visual Studio
    (2015/2017/2019). Th...
    Download Git Extensions
  • More »

Linux commands

Ad