Autoloading is used to initialize a new SQL catalog with scripts containing tables, functions, and procedures while creating a new database with monetdb. Such scripts are kept in the MonetDB library area ./lib/monetdb5/createdb/ . The prefix number is used to direct the order of their execution. A summary of the current collection is illustrated below
| Script | Description |
|---|---|
| 09_like.sql | String regular pattern matching using PCRE |
| "like"(val string, pat string, esc string) | |
| "ilike"(val string, pat string, esc string) | |
| 10_math.sql | Polar arithmetic |
| degrees(r double) returns double | |
| radians(r double) returns double | |
| 11_times.sql | OS timer and io |
| procedure times() | |
| 12_url.sql | URL manipulations (see manual ) |
| 13_date.sql | POSIX formatted date coercions ((see man strptime/strftime) |
| str_to_date(d string, format string) returns date | |
| date_to_str(d date, format string) returns string | |
| 14_inet.sql | PostgreSQL inet data type (see manual) |
| 15_history.sql | Query history management (see manual) |
| 16_tracelog.sql | Query trace table (see manual) |
| 17_compress.sql | Bulk gzip column compression (experimental!) |
| 18_dictionary.sql | Dictionary encoding compression (experimental!) |
| 19_cluster.sql | Table clustering functionality (experimental!) |
| 20_vacuum.sql | Table vacuum commands (experimental!) |
| 21_dependency_functions.sql | Schema analysis |
| 22_clients.sql | Client administration |
| clients() returns table | |
| password_hash(n string) returns string | |
| 23_skyserver.sql | Application support library |
| 24_zorder.sql | Application support library (experimental!) |
| 25_debug.sql | Debugging tools |
| environment() returns table | |
| storage() returns table | |
| bbp() returns table | |
| queryCache() returns table | |
| querylog() | |
| procedure evalAlgebra(stmt string, opt bool) | |
| 40_geom.sql | GIS extension library (see manual) |
| 99_system.sql | System administration (internal) |
Along the same line, MonetDB library area ./lib/monetdb5/autoload/ contains MAL scripts to be executed each time the server is started.30_geom.mal 40_sql.mal 50_datacell.mal 70_vault.mal 72_fits.mal 80_lsst.mal 80_udf.mal
- Printer-friendly version
- Login to post comments