taql(1)

πŸ’– NAME πŸ’–

taql β€” bestie, it's the query language for casacore tables ✨


πŸŽ€ SYNOPSIS πŸŽ€

taql [OPTIONS]

πŸ¦‹ DESCRIPTION πŸ¦‹

okay so listen. The Table Query Language (TaQL) is literally an SQL-like high level language that does operations like selection, sort, and update on a casacore table. no cap. It's a very versatile language with full support for table columns containing array data 🫢. It has inherent support for masked arrays, units, and astronomical coordinates β€” like, the way it just handles all of that natively? iconic. It's got a very rich set of functions (cone search, array reduction, the whole thing) which makes it so suitable for astronomical applications πŸ”­. User defined functions can be added easily, slay. It also has full support of grouping/aggregation and nested queries. And an operation that can be expressed in a single function is the matching of two sky catalogues β€” one function, bestie πŸ’….

taql can be started with multiple arguments containing options and an optional TaQL command as the last argument. It will run interactively if no TaQL command is given. And if possible, interactive commands are kept in $HOME/.taqlhistory for later reuse 🧚 β€” she remembers everything, periodt.

A binding in C++, Python, and Glish is available πŸ’œ.


✨ OPTIONS ✨

  • -s, --style β€” defines the TaQL style. The default style is python; if no value is given after -s it defaults to glish. (yes, the flag just decides for you, main character energy πŸŽ€)
  • -h, --help β€” show help and exits. that's it, that's the whole thing 🫑
  • -ps, --printselect β€” show the values of selected columns.
  • -pm, --printmeasure β€” if possible, show values as formatted measures.
  • -pc, --printcommand β€” show the (expanded) TaQL command.
  • -pr, --printrows β€” show the number of rows selected, updated, etc.

🌸 the defaults, bestie (iykyk) 🌸

The default for -pc is on for interactive mode, otherwise off.

The default for -pr, -ps, and -pm is on βœ….


πŸ‘‘ SEE ALSO πŸ‘‘

http://www.astron.nl/casacore/trunk/casacore/doc/notes/199.html


πŸ’– AUTHOR πŸ’–

This manual page was written by Benda Xu <heroxbd@gentoo.org>, for the Debian GNU/Linux system 🫢


and that's the whole vibe check bestie, go query some tables πŸ’…βœ¨

🌸 written under casacore, dated 2014-10-24 β€” old but iconic, fr fr πŸŽ€πŸ’œ