Results of 1 - 10 of about 15 for Stack (0.001 sec.)
- Quack on WebAssembly 14054
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...-1 eu-west-1 ap-northeast-1 ap-southeast-1 Only inputs are the type of the instance (default t3.micro) and the name of the stack (needs to be unique on the same org/region). Template is maintained at https://github.com/duckdb/duckdb-quack-infra Deploy...via Web UI Visit https://console.aws.amazon.com/cloudformation/home#/stacks/quickcreate?templateURL=https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml&stackName=my-duckdb-quack-demo Log...-in, select a name, possibly an instance class, and click Launch Stack . This will incur billing. Make sure you check the stack page afterward, and delete the non-relevant anymore stacks. Deplo... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Deploying Quack 11808
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...Let's Encrypt TLS. As its output, it surfaces the per-instance token and connection URI. One-Click Launch Open the Launch Stack URL . Click Create stack in the bottom right. Wait about two minutes for CREATE_COMPLETE . Open the stack's Outputs tab. C...session pre-wired to the new instance, or copy QuackURI and Token to connect from a local DuckDB session (see below). The stack defaults to a t3.micro instance; other sizes are selectable on the Parameters page when launching. Supported regions: us-e...-west-1 , eu-central-1 , ap-northeast-1 , ap-southeast-1 . Connecting from a Local DuckDB Copy QuackURI and Token from the stack's Outputs tab and substitute below: -- Register the credentials once per session. CREATE SECRET quack_credentials ( TYPE q... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- query and query_table Functions 9143
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...2017 2017 quarter 1 3 month 1 9 The query function allows for even more flexibility. For example, users who prefer pandas' stack syntax over SQL's UNPIVOT syntax , may use: CREATE OR REPLACE MACRO stack(table_name, index, name, values) AS TABLE FROM q...am', '10', '12', '15'), ('US', 'New York', '100', '120', '150') ) _(country, city, '2000', '2010', '2020') ) SELECT * FROM stack('cities', ['country', 'city'], 'year', 'population'); country city year population NL Amsterdam 2000 10 NL Amsterdam 2010... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
- UNPIVOT Statement 8464
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...rs 100 200 300 400 500 600 UNPIVOT Manually The most typical UNPIVOT transformation is to take already pivoted data and re-stack it into a column each for the name and value. In this case, all months will be stacked into a month column and a sales col...are supported. This can be useful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query below will generate a dataset with a separate column for the number of...are supported. This can be useful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query below will generate a dataset with a separate column for the number of... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- SeaweedFS Import 8098
- Prerequisites For SeaweedFS , the S3-compatible gateway allows you to use DuckDB's S3 support to read and write from SeaweedFS buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only nee
...your_secret_access_key" } ], "actions": ["Admin", "Read", "Write", "List", "Tagging"] } ] } Then start the whole SeaweedFS stack in one container and create a bucket: docker run -d --name seaweedfs -p 8333:8333 \ -v "$(pwd)/s3config.json:/etc/seaweedf... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/seaweedfs_import....
- Integration with PyTorch 8098
- PyTorch tensors can be built from DuckDB query results by exporting each result batch as Apache Arrow . This pattern is useful when training or serving models on Parquet data because DuckDB can filter and project the input before the batche
...M train_dataset WHERE label = 1 """).to_arrow_reader(batch_size=2) for batch in reader: features = torch.tensor( np.column_stack( [ batch.column(0).to_numpy(), batch.column(1).to_numpy(), ] ), dtype=torch.float32, ) labels = torch.tensor(batch.column(... - https://man.mtool.work/duckdb/2.0/guides/python/pytorch.html
- Building Extensions 7993
- Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the BUILD_EXTENSIONS flag to the list of extensions that you want to be built. For example: BUILD_EXT
...instantly to make sure that there aren't situations where this memory is still being used, despite not being pinned. DEBUG_STACKTRACE When a crash or assertion hit occurs in a test, print a stack trace. This is useful when debugging a crash that is ha... - https://man.mtool.work/duckdb/2.0/dev/building/building_extensions.html
- macOS 7993
- Prerequisites Install Xcode and Homebrew . Then, install the required packages with: brew install git cmake ninja Building DuckDB Clone and build DuckDB as follows. git clone https://github.com/duckdb/duckdb cd duckdb GEN=ninja make Once th
...tion: Users report that reinstalling Xcode fixed their problem. See related discussions on the DuckDB GitHub issues and on Stack Overflow . Warning Attempting to reinstall your Xcode suite may impact other applications on your system. Proceed with cau... - https://man.mtool.work/duckdb/2.0/dev/building/macos.html
- Securing Quack with a Reverse Proxy 7941
- 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
.... Caddy + 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 c... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Profile and Monitor 7889
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...pilled to temporary storage for this tag. The standard JFR startTime , duration , and eventThread fields are also present. Stack traces are disabled for this event. Attribution The monitor is keyed on the native DuckDB instance address, the dbAddress... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
DuckDB 2.0 Documentation / man.mtool.work