EnglishFrenchSpanish

Ad


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
    Brackets
    Brackets
    Brackets is a free, modern open-source
    text editor made especially for Web
    Development. Written in HTML, CSS, and
    JavaScript with focused visual tools and
    prepr...
    Download Brackets
  • 2
    Free Pascal Compiler
    Free Pascal Compiler
    A 32/64/16-bit Pascal compiler for
    Win32/64/CE, Linux, Mac OS X/iOS,
    Android, FreeBSD, OS/2, Game Boy
    Advance, Nintendo NDS and DOS;
    semantically compatible wi...
    Download Free Pascal Compiler
  • 3
    Canon EOS DIGITAL Info
    Canon EOS DIGITAL Info
    Canon doesn�t have shutter count
    included on the EXIF information of an
    image file, as opposed to Nikon and
    Pentax. There�s no official Canon based
    application ...
    Download Canon EOS DIGITAL Info
  • 4
    rEFInd
    rEFInd
    rEFInd is a fork of the rEFIt boot
    manager. Like rEFIt, rEFInd can
    auto-detect your installed EFI boot
    loaders and it presents a pretty GUI
    menu of boot option...
    Download rEFInd
  • 5
    ExpressLuke GSI
    ExpressLuke GSI
    This SourceForge download page was to
    grant users to download my source built
    GSIs, based upon phhusson's great
    work. I build both Android Pie and
    Android 1...
    Download ExpressLuke GSI
  • 6
    Music Caster
    Music Caster
    Music Caster is a tray music player
    that lets you cast your local music to a
    Google Cast device. On the first run,
    you will need to click the arrow in your
    tas...
    Download Music Caster
  • More »

Linux commands

Ad