Results of 1 - 5 of about 5 for author (0.001 sec.)
- Full-Text Search Extension 12428
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...age Create a table and fill it with text data: CREATE TABLE documents ( document_identifier VARCHAR, text_content VARCHAR, author VARCHAR, doc_version INTEGER ); INSERT INTO documents VALUES ('doc1', 'The mallard is a dabbling duck that breeds througho...domestic species of small carnivorous mammal.', 'Laurens Kuiper', 2 ); Build the index, and make both the text_content and author columns searchable. PRAGMA create_fts_index( 'documents', 'document_identifier', 'text_content', 'author' ); Search the au...thor field index for documents that are authored by Muhleisen . This retrieves doc1 : SELECT document_identifier, text_content, score FROM ( SELECT *, fts_main_documents... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Analyzing a Git Repository 9394
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...: CREATE TABLE commits AS FROM read_csv( 'git-log.csv', delim = '?', header = false, column_names = ['timestamp', 'hash', 'author', 'message'] ); This will result in a nice DuckDB table: FROM commits LIMIT 5; ┌──────────────────────────┬────────────┬──...────────────────┬───────────────────────────────────────────────────────────────────────────────┐ │ timestamp │ hash │ author │ message │ │ timestamp with time zone │ varchar │ varchar │ varchar │ ├──────────────────────────┼────────────┼──────────... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- DuckLake 8751
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...───────────────┬─────────┬────────────────┬───────────────────┐ │ snapshot_id │ snapshot_time │ schema_version │ changes │ author │ commit_message │ commit_extra_info │ │ int64 │ timestamp with time zone │ int64 │ map(varchar, varchar[]) │ varchar │ va...olumn type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message VARCHAR commit_extra_info VARCHAR ducklake_table_info The ducklake_table_info function returns info... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Community Extensions 8530
- Community-contributed extensions can be installed from the Community Extensions repository since summer 2024 . Please visit the “Community Extensions” section of the documentation for more details. Warning Community extensions are contribut
...lt by the Community Extension CI, not that its code is safe. Install and load community extensions only if you trust their author and source. See the security considerations for details. Deprecated Starting with DuckDB 2.0, community extensions are no... - https://man.mtool.work/duckdb/2.0/extensions/community_extensions.html
- Create Synthetic Data 6802
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...Commercial occur. │ Professor big but executive plan fast body b… │ false │ │ 13540103502347468651 │ 2023-08-23 │ Specific author. │ Across cut market eight. Thing pull open spa… │ false │ │ 4800297459639118879 │ 2004-02-18 │ Beautiful learn. │ Upon co... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work