Results of 1 - 10 of about 77 for local (0.002 sec.)
- UI Extension 11755
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...dy loaded will be available. Since this instance is a native process (not Wasm), it can leverage all the resources of your local environment: all cores, memory and files. Closing this instance will cause the UI to stop working. The UI is served from a...thout launching the browser, run: CALL start_ui_server(); You can then load the UI in your browser by navigating to http://localhost:4213 . To stop the HTTP server, run: CALL stop_ui_server(); Local Query Execution By default, the DuckDB UI runs your...queries fully locally: your queries and data never leave your computer. If you would like to use MotherDuck through the UI, you have to opt-in... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- PostgreSQL Extension Connection Pool 10443
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...DB instance ( threads global configuration option). When the threads parameter is set too high (that may be necessary for local processing of other queries on DuckDB side) this can lead to attempts to open an excessive number of PostgreSQL connection...s still can be checked, but they are only checked when a connection is taken from the pool or returned to the pool. Thread-local Cache Idle connection in a pool are available for any caller thread, be it a DuckDB internal worker thread or a new client...queries from the same thread are run on the same connection as the first query. To support this the pg_pool_enable_thread_local_cache configuration option can be used - it makes an idle connection to be returned to a thread-local (and thread-private)... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Securing Quack with a Reverse Proxy 10153
- 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
...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 assumes HTTPS by default, so a properly fronted server “just works” from the client side too. This guide walks thr...ough three setups, in order of likely usefulness: A local TLS test setup with Caddy, so you can exercise the full HTTPS path on your machine. nginx + Let's Encrypt in production. C...+ Let's Encrypt in production. The two production setups are interchangeable. Pick whichever fits your operational stack. Local Test Setup with Caddy You can exercise the full HTTPS path on your own machine using Caddy. Caddy issues itself a certific... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- PostgreSQL Extension Functions 10070
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...liseconds to wait when acquiring a connection from a pool where all available connections are already taken. enable_thread_local_cache ( BOOLEAN ): whether to enable the connection caching in thread-local cache. Such connections are getting pinned to...worker threads are unable to obtain a connection - they return without doing any work and without throwing an error thread_local_cache_enabled ( BOOLEAN ): whether caching the connections caching in thread-local cache is enabled; thread-local connecti...ons are NOT cleared by the reaper thread thread_local_cache_hits ( UBIGINT ): the number of times connections were successfully acquired from a thread-local cache without going... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Timestamp with Time Zone Functions 9973
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...ime zone extension such as ICU is loaded, then a time zone can be parsed from a string and cast to a representation in the local time zone: SELECT '2022-10-08 13:13:34 Europe/Amsterdam'::TIMESTAMPTZ::VARCHAR; 2022-10-08 04:13:34-07 -- the offset will...differ based on your local time zone ICU Timestamp with Time Zone Operators The table below shows the available mathematical operators for TIMESTAMP...the ICU provided scalar functions that operate on plain TIMESTAMP values. These functions assume that the TIMESTAMP is a “local timestamp”. A local timestamp is effectively a way of encoding the part values from a time zone into a single value. They... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Security 9876
- 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
...en is passed explicitly or supplied by a quack secret, the server generates a random token at startup. The server binds to localhost only, non-local hostnames require an explicit allow_other_hostname = true . The server does not use TLS for local URIs..., as TLS for localhost communication only adds dependencies for no real benefit. Non-local URIs default to HTTPS with a self-signed certifica...te (see quack_serve parameters ). Bestpractice 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... - https://man.mtool.work/duckdb/2.0/quack/security.html
- S3 Express One 9213
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...e microbenchmarks of the performance guide ). Experiment File size Runtime Loading only from Parquet 4.1 GB 3.5 s Creating local table from Parquet 4.1 GB 5.1 s The “loading only” variant is running the load as part of an EXPLAIN ANALYZE statement to...measure the runtime without actually creating a local table, while the “creating local table” variant uses CREATE TABLE ... AS SELECT to create a persistent table on the local... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- Multiple Python Threads 9213
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
...ne functions to be executed by the writer and reader threads. Each thread must use the .cursor() method to create a thread-local connection to the same DuckDB file based on the original connection. This approach also works with in-memory DuckDB databa...Exception instead of waiting. def write_from_thread(duckdb_con): # Create a DuckDB connection specifically for this thread local_con = duckdb_con.cursor() # Insert a row with the name of the thread. insert_time is auto-generated. thread_name = str(cur...rent_thread().name) result = local_con.execute(""" INSERT INTO my_inserts (thread_name) VALUES (?) """, (thread_name,)).fetchall() def read_from_thread(duckd... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- Table Functions 9034
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...tion_set_init ( duckdb_table_function table_function , duckdb_table_function_init_t init ); void duckdb_table_function_set_local_init ( duckdb_table_function table_function , duckdb_table_function_init_t init ); void duckdb_table_function_set_function...uckdb_function_info info ); void * duckdb_function_get_init_data ( duckdb_function_info info ); void * duckdb_function_get_local_init_data ( duckdb_function_info info ); void duckdb_function_set_error ( duckdb_function_info info , const char * error )..._function_init_t init ); Parameters table_function : The table function init : The init function duckdb_table_function_set_local_init Sets the thread-local init function of the table function. Syntax void duckdb_table_function_set_local_init ( duckdb_... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Quack Remote Protocol 9034
- 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
...sion can see (in-memory tables, attached files, schemas) becomes reachable over the remote protocol. To start listening on localhost, run: {:.codebox-server} CALL quack_serve('quack:localhost'); The URI argument is optional: calling quack_serve() with...out it also listens on quack:localhost . quack_serve returns the listen URI, the HTTP URL, and, when the default authentication function is in use, the auth_...onnect. To choose the token yourself, pass the token parameter (see Security ): {:.codebox-server} CALL quack_serve('quack:localhost', token = '⟨my_token⟩'); Tip The DuckDB CLI can start a server directly with the -serve argument and connect to one wi... - https://man.mtool.work/duckdb/2.0/quack/overview.html
DuckDB 2.0 Documentation / man.mtool.work