Results of 1 - 10 of about 10 for scripts (0.004 sec.)
- marimo Notebooks – DuckDB 14176
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ell-suited to interactively working with data, and its representation as a Python file makes it simple to run notebooks as scripts. Installation To get started, install marimo and DuckDB from your terminal: pip install "marimo[sql]" # or uv add "marimo[...ause marimo stores notebooks as pure Python, for many reasons , such as git-friendly diffs and running notebooks as Python scripts. The SQL statement itself is an f-string, letting you interpolate Python values into the query with {} (shown later). In p...UI elements that can be used to parameterize SQL queries Ability to export notebooks as standalone applications or Python scripts, or even run entirely in the browser with WebAssembly . Next Steps Read the marimo docs . Try the SQL tutorial: marimo tut... - https://man.mtool.work/duckdb/1.3/guides/python/marimo.html
- Dot Commands – DuckDB 8992
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...CLI (silently) autocompletes them. For example: .mo ma Is equivalent to: .mode markdown Tip Avoid using shorthands in SQL scripts to improve readability and ensure that the scripts and futureproof. Importing Data from CSV Deprecated This feature is onl... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Python – DuckDB 8992
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...and Stubs *.pyi stubs in duckdb-stubs are manually maintained. The connection-related stubs are generated using dedicated scripts in tools/pythonpkg/scripts/ : generate_connection_stubs.py generate_connection_wrapper_stubs.py These stubs are important... - https://man.mtool.work/duckdb/1.3/dev/building/python.html
- Windows – DuckDB 8313
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...on Windows, we recommend using the Visual Studio compiler. To use it, follow the instructions in the CI workflow : python scripts/windows_ci.py cmake \ -DCMAKE_BUILD_TYPE = Release \ -DCMAKE_GENERATOR_PLATFORM = x64 \ -DENABLE_EXTENSION_AUTOLOADING = 1... - https://man.mtool.work/duckdb/1.3/dev/building/windows.html
- Extension Distribution – DuckDB 8313
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...sion ├── tpcds.duckdb_extension └── tpch.duckdb_extension See the extension-template repository for all necessary code and scripts to set up a repository. When installing an extension from a custom repository, DuckDB will search for both a gzipped and n... - https://man.mtool.work/duckdb/1.3/extensions/extension_distribution.html
- Importing Duckbox Tables – DuckDB 8313
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rmat Execution Format Pivot Sitemap Live Demo Documentation / Guides / Snippets Copy Markdown Importing Duckbox Tables The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbo... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- Securing Extensions – DuckDB 8313
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...te code execution by design. This is less dramatic than it sounds. For better or worse, we are quite used to piping random scripts from the web into our shells, and routinely install a staggering amount of transitive dependencies without thinking twice.... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/securing_ext...
- Building DuckDB from Source – DuckDB 7955
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...source code files ( duckdb.hpp and duckdb.cpp ) with approximately 0.5M lines of code. To generate this file, run: python scripts/amalgamation.py Note that amalgamation build is provided on a best-effort basis and is not officially supported. Limitatio... - https://man.mtool.work/duckdb/1.3/dev/building/overview.html
- Friendly SQL – DuckDB 7955
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...to DuckDB. Clauses Creating tables and inserting data: CREATE OR REPLACE TABLE : avoid DROP TABLE IF EXISTS statements in scripts. CREATE TABLE ... AS SELECT (CTAS) : create a new table from the output of a table without manually defining a schema. INS... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- PostgreSQL Compatibility – DuckDB 7955
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nsensitivity by making identifiers fully case insensitive throughout the system but preserving their case . In DuckDB, the scripts above complete successfully: CREATE TABLE MyTaBLe ( x INTEGER ); SELECT * FROM "MyTaBLe" ; CREATE TABLE "PreservedCase" (... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work