Results of 1 - 10 of about 10 for comes (0.003 sec.)
- Collations 12585
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
.... These orderings are often incompatible with one another. For example, in English the letter y comes between x and z . However, in Lithuanian the letter y comes between the i and j . For that reason, different collations ar... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- Concurrency 10815
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...reads can also simultaneously update separate tables or separate subsets of the same table. Optimistic concurrency control comes into play when two threads attempt to edit (update or delete) the same row at the same time. In that situation, the second... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
- Importing Duckbox Tables 9635
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...; Then, reading a duckbox table is as simple as: FROM read_duckbox('duckbox.csv'); shellfs is a community extension and it comes without any support or guarantees. Only use it if you can ensure that its inputs are appropriately sanitized. Please consu... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- Excel Import 9046
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...or can be controlled with the stop_at_empty parameter: -- Read the first 100 rows, or until the first empty row, whichever comes first SELECT * FROM read_xlsx('test_excel.xlsx', range = '1:100', stop_at_empty = true); -- Always read the whole sheet, e... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Indexes 9046
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...a second location. Maintaining that second copy complicates processing. Thus, certain limitations currently apply when it comes to modifying data that is also stored in secondary indexes. As expected, indexes have a strong effect on performance, slow...048 rows) moving through DuckDB's processing pipeline. When updating i = 2047 to i = 2048 , we do not yet know that 2048 becomes 2049, and so forth. That is because we have not yet seen that chunk. Thus, we throw a constraint violation. CREATE TABLE m... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- Deploy 8456
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...his is the DuckDB engine itself, compiled to WebAssembly and instantiated by the browser. Like the JS Worker component, it comes in the same three flavors, each paired with the JS worker of the same flavor: mvp — for example duckdb-mvp.wasm , loaded b... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Extensions 8456
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionali
...load statistics as JSON files: core extensions and community extensions . Built-In Extensions DuckDB's binary distribution comes standard with a few built-in extensions. They are statically linked into the binary and can be used as is. For example, to... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- Run Queries 7866
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...xtension, build the value with createStruct() (or createArrayOf() ) and cast the parameter to GEOMETRY ; a GEOMETRY result comes back as Well-Known Binary through getBlob() : try (Statement stmt = conn.createStatement()) { stmt.execute("INSTALL spatia...l.Date / LocalDate become an org.duckdb.DuckDBDate , Timestamp / LocalDateTime become a DuckDBTimestamp , OffsetDateTime becomes a DuckDBTimestampTZ , and Time / LocalTime become a DuckDBTime — and marshals it to the corresponding DuckDB type: import... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Timestamp Types 7866
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...ime zones, calendars and collations natively. To set the time zone to use, first load the icu extension. The icu extension comes pre-bundled with several DuckDB clients (including the CLI, Python, R, JDBC and ODBC) and is autoloaded on first use, so t... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Python Client API 5506
- 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
...very row, a batch at a time, over one run of the relation. The rows are read once into the engine's memory, so every batch comes from the same run and the connection is free between batches; the caller holds one batch at a time rather than the whole r... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work