Results of 1 - 10 of about 12 for reverse (0.006 sec.)
- List Functions 13301
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...t, lambda(x,y)[, initial_value]) Alias for list_reduce . array_resize(list, size[[, value]]) Alias for list_resize . array_reverse(list) Alias for list_reverse . array_reverse_sort(list[, col1]) Alias for list_reverse_sort . array_select(value_list, ind...value]]) Resizes the list to contain size elements. Initializes new elements with value or NULL if value is not set. list_reverse(list) Reverses the list . list_reverse_sort(list[, col1]) Sorts the elements of the list in reverse order. See the Sorting...value is not set. | | Example | list_resize([1, 2, 3], 5, 0) | | Result | [1, 2, 3, 0, 0] | | Alias | array_resize | list_reverse(list) | Description | Reverses the list . | | Example | list_reverse([3, 6, 1, 2]) | | Result | [2, 1, 6, 3] | | Alias | a... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Python Client API 10329
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...: ('regexp_replace', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']), 'replace': ('replace', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']), 'reverse': ('reverse', 0, ['VARCHAR']), 'right': ('right', 0, ['VARCHAR', 'BIGINT']), 'right_grapheme': ('right_grapheme', 0, ['VAR...: ValueOrExpr ) → StrExpr Every occurrence of the source replaced by the target. Arguments: source, target. SQL: replace . reverse ( * args : ValueOrExpr ) → StrExpr Reverses the string . SQL: reverse . right ( * args : ValueOrExpr ) → StrExpr Extract t...list_product', 0, []), 'reduce': ('list_reduce', 0, ['ANY[]', 'LAMBDA']), 'resize': ('list_resize', 0, ['ANY[]', 'ANY']), 'reverse': ('list_reverse', 0, []), 'reverse_sort': ('list_reverse_sort', 0, ['ANY[]']), 'select': ('list_select', 0, ['T[]', 'BIGI... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Quack Remote Protocol 10152
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...the Quack protocol and its interactions work as follows: HTTP-based. Quack messages travel over plain HTTP or HTTPS via a reverse proxy (see Security ). This means standard load balancers, firewalls, and reverse proxies handle Quack traffic the same wa...ference ). For production deployments, we recommend binding the server to localhost and fronting it with a TLS-terminating reverse proxy. See Securing Quack with a Reverse Proxy . URI Format Quack endpoints use the quack: URI scheme and 9494 as the defa... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Securing Quack with a Reverse Proxy 10152
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...e / application server: put a proven HTTP reverse proxy in front of it, and let the proxy terminate TLS. The Quack client cooperates with this: for non-local URIs it assume...re, so DuckDB's HTTPS client trusts the cert without any extra config. 1. Run Caddy Save this Caddyfile : localhost:8443 { reverse_proxy 127.0.0.1:9494 { flush_interval -1 } request_body { max_size 256MB } } Then start Caddy: brew install caddy # macOS,...ncrypt and needs almost no configuration. A complete public-facing Quack proxy: # /etc/caddy/Caddyfile quack.example.com { reverse_proxy 127.0.0.1:9494 { # Equivalent of nginx `proxy_buffering off`. Required so Quack's # streamed FETCH responses pass th... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Security 9162
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...For any deployment beyond local-only, do not expose Quack directly to the internet. We recommend you to put a proven HTTP reverse proxy in front of it and let the proxy terminate TLS. The Quack client is shipped with these assumptions in mind: for non-...it assumes HTTPS by default, so a properly fronted server "just works" from the client side too. See Securing Quack with a Reverse Proxy for nginx and Caddy recipes (production and local-test). Authentication and Authorization For every database call, t... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Editing 8012
- The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo
...ove forward a word History Key Action Ctrl + P Move to previous history entry Ctrl + N Move to next history entry Ctrl + R Reverse search the history Ctrl + S Forward search the history Ctrl + Up Move to first history entry Ctrl + Down Move to last hist... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- Text Functions 7676
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...ring count number of times. replace(string, source, target) Replaces any occurrences of the source with target in string . reverse(string) Reverses the string . right(string, count) Extract the right-most count characters. right_grapheme(string, count)...places any occurrences of the source with target in string . | | Example | replace('hello', 'l', '-') | | Result | he--o | reverse(string) | Description | Reverses the string . | | Example | reverse('hello') | | Result | olleh | right(string, count) | D... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- What's New in the Docs for 2.0 7676
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...to one directly. Quack extension CONNECT and DISCONNECT statements CLI -serve and -connect arguments Securing Quack with a reverse proxy Remote pushdown to PostgreSQL and MySQL VARIANT Becomes a First-Class Citizen The VARIANT type stores semi-structure... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Spatial Functions 7517
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...etry with all vertices reduced to the given precision ST_RemoveRepeatedPoints Remove repeated points from a LINESTRING. ST_Reverse Returns the geometry with the order of its vertices reversed ST_ShortestLine Returns the shortest line between two geometr...EOMETRY ST_RemoveRepeatedPoints (geom GEOMETRY, tolerance DOUBLE) Description Remove repeated points from a LINESTRING. ST_Reverse Signature GEOMETRY ST_Reverse (geom GEOMETRY) Description Returns the geometry with the order of its vertices reversed ST_...he source coordinate -- reference system definition (WGS84) says otherwise. SELECT ST_Transform( -- note the axis order is reversed here st_point(4.892360, 52.373123), 'EPSG:4326', 'EPSG:3857', always_xy := true ); ---- POINT (544615.0239773799 6867874.... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Python Function API 7340
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...nce(strings, pa.ChunkedArray) assert isinstance(sep, pa.ChunkedArray) return pc.binary_join_element_wise(strings, pc.ascii_reverse(strings), sep) duckdb.create_function( "mirror", mirror, [VARCHAR, VARCHAR], return_type=VARCHAR, type="arrow", ) duckdb.s... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
DuckDB 2.0 Documentation / man.mtool.work