Results of 1 - 10 of about 30 for plain (0.002 sec.)
- Quack Remote Protocol 12347
- 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
...ck in a Nutshell In short, 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 hand...ying table names. quack_query(uri, query) : stateless querying . In all cases, you need to authenticate . The client picks plain HTTP automatically for local URIs ( localhost , 127.0.0.1 , ::1 ) and HTTPS otherwise. Either default can be overridden wi...host', 'SELECT 42', token = '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩'); Remote databases use HTTPS by default. To override on a plain-HTTP remote, run: {:.codebox-client} FROM quack_query( 'quack:remote.com', 'SELECT 42', token = '⟨MY_QUACK_TOKEN_012345678... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Reference 11859
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...persistent default quack secret, so that subsequent servers reuse it. disable_ssl BOOLEAN true for local, else false Serve plain HTTP. Local URIs default to plain HTTP, other URIs to HTTPS. ssl_cert_file VARCHAR (generated) Certificate file used when...ecret on the client side. DISABLE_SSL BOOLEAN true for local, else false Force the client transport. Local URIs default to plain HTTP. TYPE VARCHAR inferred Pin the secret type used for token resolution (e.g., quack ). SSL_FINGERPRINT VARCHAR (unset)...are evaluated on a fresh server-side connection every time, so the two settings below are global-scoped ( SET GLOBAL ). A plain SET on these is forwarded to the global slot automatically. Use RESET GLOBAL to restore the default, a plain RESET only cl... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Securing Quack with a Reverse Proxy 10884
- 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
...server} CALL quack_serve('quack:localhost'); In the client session, connect through Caddy on :8443 . Local URIs default to plain HTTP, so you have to force SSL on explicitly: {:.codebox-client} ATTACH 'quack:localhost:8443' AS quack ( TOKEN '⟨authenti...'SELECT 42'); If the round-trip succeeds, your traffic just went out as TLS to Caddy, got terminated, and was forwarded as plain HTTP to Quack on :9494 . Nginx + Let's Encrypt We expect this to be the most common choice. A minimal site for a Quack ser... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Migrating Python Code to DuckDB 2.0 10397
- This page lists what Python code written for DuckDB 1.x must change to run on DuckDB 2.0. Each item gives the 1.x form, the 2.0 form and the page that explains it. For changes outside the Python client, see Migrating to DuckDB v2.0 . Python
...es, use rel.to_arrow_reader() . Replace rel.execute() with rel.materialize() when you want to compute and retain the rows. Plain strings in expressions. 1.x: in ColumnExpression("s") == "x" and in rel.update(set={"a": "x"}) , the string "x" named a co...lumn. 2.0: in an expression a plain string is a value, so the comparison tests s against the text x and warns when x is also a column name; update() refuses a...plain string with a TypeError . Write col("x") for the column and lit("x") for the text. See the Expression API and update . Dot... - https://man.mtool.work/duckdb/2.0/clients/python/migration.html
- CREATE SECRET Statement 10153
- The CREATE SECRET statement creates a new secret in the Secrets Manager . Syntax for CREATE SECRET Warning When using the command line client , the CREATE SECRET statements are stored in your DuckDB history as plain text. Syntax for DROP SE
... - https://man.mtool.work/duckdb/2.0/sql/statements/create_secret.html
- httpfs Extension for HTTP and S3 Support 9422
- The httpfs extension is an autoloadable extension implementing a file system that allows reading remote/writing remote files. For plain HTTP(S), only file reading is supported. For object storage using the S3 API, the httpfs extension suppo
... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/overview.html
- Timestamp Issues 9422
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...In general, unless you need to use the current time zone for display (or other temporal binning operations) you should use plain TIMESTAMP s for temporal data. This will avoid confusing issues such as this, and the arithmetic operations are generally...year) and is faster than the previous ICU-based one. Even so, time zone-aware binning is more expensive than arithmetic on plain TIMESTAMP s. If the same temporal bins are computed repeatedly, one workaround is to precompute them in a calendar table f... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Crashes 8935
- DuckDB is thoroughly tested via an extensive test suite. However, bugs can still occur and these can sometimes lead to crashes. This page contains practical information on how to troubleshoot DuckDB crashes. Types of Crashes There are a few
...re specific to certain platforms or client languages. You can often isolate the issue to a smaller problem. Reproducing in Plain SQL Issues can also occur due to differences in client libraries. To understand whether this is the case, try reproducing...the issue using plain SQL queries with the DuckDB CLI client . If you cannot reproduce the issue in the command line client, it is likely relate... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
- CREATE TYPE Statement 8935
- The CREATE TYPE statement defines a new type in the catalog. Examples Create a simple ENUM type: CREATE TYPE mood AS ENUM ('happy', 'sad', 'curious'); Create a simple STRUCT type: CREATE TYPE many_things AS STRUCT(k INTEGER, l VARCHAR); Cre
...s table . Limitations Extending types to support custom operators (such as the PostgreSQL && operator) is not possible via plain SQL. Instead, it requires adding additional C++ code. To do this, create an extension .... - https://man.mtool.work/duckdb/2.0/sql/statements/create_type.html
- Expression API 8691
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
....filter(col("s") == col("x")).fetchall()) print(rel.filter(col("s") == duckdb.lit("x")).fetchall()) [] [('x', 'y')] When a plain string is also the name of a column of the relation, as in rel.filter(col("s") == "x") , DuckDB uses the string as a value...as b of t , give it by its parts with the older constructor, as in StarExpression(exclude=[col("t", "b")]) ; star() takes plain names only. import duckdb import pandas as pd df = pd.DataFrame({ 'a': [1, 2, 3, 4], 'b': [True, None, False, True], 'c':...unction call. It is built from the function name and any number of arguments, with fn(name, *args) . An argument that is a plain string is a value, so fn('upper', 's') passes the text s ; use col('s') for the column. import duckdb import pandas as pd... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
DuckDB 2.0 Documentation / man.mtool.work