Results of 1 - 10 of about 10 for items (0.004 sec.)
- Python DB API – DuckDB 12836
- 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 a second time to close the transaction. Below are some short examples: # create a table con . execute ( "CREATE TABLE items (item VARCHAR, value DECIMAL(10, 2), count INTEGER)" ) # insert two items into the table con . execute ( "INSERT INTO item...s VALUES ('jeans', 20.0, 1), ('hammer', 42.2, 2)" ) # retrieve the items again con . execute ( "SELECT * FROM items" ) print ( con . fetchall ()) # [('jeans', Decimal('20.00'), 1), ('hammer', Dec...imal('42.20'), 2)] # retrieve the items one at a time con . execute ( "SELECT * FROM items" ) print ( con . fetchone ()) # ('jeans', Decimal('20.00'), 1) print (... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- R Client – DuckDB 11620
- 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
...used for queries that produce results (e.g., SELECT ). Below an example. # create a table dbExecute ( con , "CREATE TABLE items (item VARCHAR, value DECIMAL(10, 2), count INTEGER)" ) # insert two items into the table dbExecute ( con , "INSERT INTO it...ems VALUES ('jeans', 20.0, 1), ('hammer', 42.2, 2)" ) # retrieve the items again res <- dbGetQuery ( con , "SELECT * FROM items" ) print ( res ) # item value count # 1 jeans 20.0 1 # 2 hammer 42.2...dbGetQuery methods. Here is an example: # prepared statement parameters are given as a list dbExecute ( con , "INSERT INTO items VALUES (?, ?, ?)" , list ( 'laptop' , 2000 , 1 )) # if you want to reuse a prepared statement multiple times, use dbSendSt... - https://man.mtool.work/duckdb/1.3/clients/r.html
- Java JDBC Client – DuckDB 9814
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...onnection ( "jdbc:duckdb:" ); // create a table Statement stmt = conn . createStatement (); stmt . execute ( "CREATE TABLE items (item VARCHAR, value DECIMAL(10, 2), count INTEGER)" ); // insert two items into the table stmt . execute ( "INSERT INTO i...tems VALUES ('jeans', 20.0, 1), ('hammer', 42.2, 2)" ); try ( ResultSet rs = stmt . executeQuery ( "SELECT * FROM items" )) { while ( rs . next ()) { System . out . println ( rs . getString ( 1 )); System . out . println ( rs . getInt ( 3 ));...er the JDBC API: import java.sql.PreparedStatement ; try ( PreparedStatement stmt = conn . prepareStatement ( "INSERT INTO items VALUES (?, ?, ?);" )) { stmt . setString ( 1 , "chainsaw" ); stmt . setDouble ( 2 , 500.0 ); stmt . setInt ( 3 , 42 ); stm... - https://man.mtool.work/duckdb/1.3/clients/java.html
- Conversion between DuckDB and Python – DuckDB 8616
- 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
...his functionality. See the Python guides for more examples. Fetch as Pandas DataFrame: df = con . execute ( "SELECT * FROM items" ). fetchdf () print ( df ) item value count 0 jeans 20.0 1 1 hammer 42.2 2 2 laptop 2000.0 1 3 chainsaw 500.0 10 4 iphone...300.0 2 Fetch as dictionary of NumPy arrays: arr = con . execute ( "SELECT * FROM items" ). fetchnumpy () print ( arr ) {'item': masked_array(data=['jeans', 'hammer', 'laptop', 'chainsaw', 'iphone'], mask=[Fals...)} Fetch as an Arrow table. Converting to Pandas afterwards just for pretty printing: tbl = con . execute ( "SELECT * FROM items" ). fetch_arrow_table () print ( tbl . to_pandas ()) item value count 0 jeans 20.00 1 1 hammer 42.20 2 2 laptop 2000.00 1... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Node.js Client (Neo) – DuckDB 7812
- 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
...alues import { DuckDBTypeId } from ' @duckdb/node-api ' ; if ( columnType . typeId === DuckDBTypeId . ARRAY ) { const arrayItems = columnValue . items ; // array of values const arrayString = columnValue . toString (); } if ( columnType . typeId === D...bigint const intervalString = columnValue . toString (); } if ( columnType . typeId === DuckDBTypeId . LIST ) { const listItems = columnValue . items ; // array of values const listString = columnValue . toString (); } if ( columnType . typeId === Du... - https://man.mtool.work/duckdb/1.3/clients/node_neo/overview.html
- Concurrency – DuckDB 7812
- 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
...ack and forth to disk during each query. It also allows the caching of functions pointers, the database catalog, and other items so that subsequent queries on the same connection are faster. DuckDB is optimized for bulk operations, so executing many s... - https://man.mtool.work/duckdb/1.3/connect/concurrency.html
- Schema – DuckDB 7723
- 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
...ractice Use the most restrictive types possible when creating columns. Avoid using strings for encoding more specific data items. Microbenchmark: Using Timestamps We illustrate the difference in aggregation speed using the creationDate column of the L... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Friendly SQL – DuckDB 7723
- 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
...ommas DuckDB allows trailing commas , both when listing entities (e.g., column and table names) and when constructing LIST items . For example, the following query works: SELECT 42 AS x , [ 'a' , 'b' , 'c' ,] AS y , 'hello world' AS z , ; "Top-N in Gr... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- CREATE SEQUENCE Statement – DuckDB 7723
- 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
...TH 1 MAXVALUE 10 CYCLE ; Creating and Dropping Sequences Sequences can be created and dropped similarly to other catalogue items. Overwrite an existing sequence: CREATE OR REPLACE SEQUENCE serial ; Only create sequence if no such sequence exists yet:... - https://man.mtool.work/duckdb/1.3/sql/statements/create_sequence.html
- Vector Similarity Search Extension – DuckDB 7615
- 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
...l the PRAGMA hnsw_compact_index ( ' index_name ' ) pragma function to trigger a re-compaction of the index pruning deleted items, or re-create the index after a significant number of updates. Bonus: Vector Similarity Search Joins The vss extension als... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work