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
    Psi
    Psi
    Psi is cross-platform powerful XMPP
    client designed for experienced users.
    There are builds available for MS
    Windows, GNU/Linux and macOS.. Audience:
    End Users...
    Download Psi
  • 2
    Blobby Volley 2
    Blobby Volley 2
    Official continuation of the famous
    Blobby Volley 1.x arcade game..
    Audience: End Users/Desktop. User
    interface: OpenGL, SDL. Programming
    Language: C++, Lua. C...
    Download Blobby Volley 2
  • 3
    SuiteCRM
    SuiteCRM
    SuiteCRM is the award-winning Customer
    Relationship Management (CRM)
    application brought to you by authors
    and maintainers, SalesAgility. It is the
    world�s mos...
    Download SuiteCRM
  • 4
    Poweradmin
    Poweradmin
    Poweradmin is a web-based DNS
    administration tool for PowerDNS server.
    The interface has full support for most
    of the features of PowerDNS. It has full
    support...
    Download Poweradmin
  • 5
    Gin Web Framework
    Gin Web Framework
    Gin is an incredibly fast web framework
    written in Golang that can perform up to
    40 times faster, thanks to its
    martini-like API and custom version of
    httprout...
    Download Gin Web Framework
  • 6
    CEREUS LINUX
    CEREUS LINUX
    CEREUS LINUX basado en MX LINUX con
    varios entornos de escritorios. This is
    an application that can also be fetched
    from
    https://sourceforge.net/projects/cereu...
    Download CEREUS LINUX
  • More »

Linux commands

  • 1
    aa-clickquery
    aa-clickquery
    aa-clickquery - program for querying
    click-apparmor DESCRIPTION: This program
    is used to query click-apparmor for
    information. USAGE: aa-clickquery
    --click-fra...
    Run aa-clickquery
  • 2
    aa-exec-click
    aa-exec-click
    aa-exec-click - program for executing
    click packages under confinement
    DESCRIPTION: This program is used to
    execute click package under AppArmor
    confinement. I...
    Run aa-exec-click
  • 3
    cpio
    cpio
    cpio - copy files to and from archives ...
    Run cpio
  • 4
    cpipe
    cpipe
    cpipe - copy stdin to stdout while
    counting bytes and reporting progress ...
    Run cpipe
  • 5
    FvwmSave
    FvwmSave
    FvwmSave - the Fvwm desktop-layout
    saving module ...
    Run FvwmSave
  • 6
    FvwmSave1
    FvwmSave1
    FvwmSave - the FVWM desktop-layout
    saving module ...
    Run FvwmSave1
  • More »

Ad