Summarize this content to 400 words in Persian Lang <\/p>\n
\u2754 \u062f\u0631\u0628\u0627\u0631\u0647<\/p>\n
\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0634\u0645\u0627 \u0647\u0645 \u06cc\u06a9\u06cc \u0627\u0632 \u0637\u0631\u0641\u062f\u0627\u0631\u0627\u0646 PostgreSQL \u0647\u0633\u062a\u06cc\u062f \u0648 \u0647\u0645 \u0627\u062e\u06cc\u0631\u0627\u064b duckdb \u067e\u0630\u06cc\u0631\u0646\u062f\u0647\u0634\u0645\u0627 \u0647\u0631 \u062f\u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0622\u0646\u0647\u0627 \u062f\u0648\u0633\u062a \u062f\u0627\u0631\u06cc\u062f \u0646\u0642\u0627\u0637 \u0642\u0648\u062a \u0648 \u0627\u06a9\u0648\u0633\u06cc\u0633\u062a\u0645 \u0647\u0627… \u0648 \u062a\u0639\u062c\u0628 \u0645\u06cc \u06a9\u0646\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u0634\u0648\u062f<\/p>\n
\u0627\u0645\u06a9\u0627\u0646 \u0627\u0631\u0633\u0627\u0644 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632\/\u0628\u0647 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627… \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc\u060c \u0645\u0646\u0638\u0648\u0631 \u0645\u0646 \u0627\u0633\u062a \u0686\u06cc\u0632\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 \u0628\u0627\u0632\u06cc \u0646\u06cc\u0633\u062a sql shell \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u062f\u0631 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644<\/p>\n
: \u0628\u062f\u0648\u0646 \u067e\u0627\u06cc\u062a\u0648\u0646\u060c \u0628\u062f\u0648\u0646 \u062c\u0627\u0648\u0627\u060c…<\/p>\n
\ud83d\udc49 \u062e\u0628 \u0627\u06cc\u0646 \u062f\u0642\u06cc\u0642\u0627\u064b \u0647\u0645\u0627\u0646 \u0686\u06cc\u0632\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u0646 \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646 \u0635\u062d\u0628\u062a \u062e\u0648\u0627\u0647\u0645 \u06a9\u0631\u062f \u0628\u0647 \u0644\u0637\u0641:<\/p>\n
\ud83e\udd14 \u0627\u0645\u0627 \u0686\u0631\u0627 \u0627\u06cc\u0646 \u067e\u0633\u062a\u061f<\/p>\n
3 \u062f\u0644\u06cc\u0644 \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0648 \u0686\u0631\u0627\u06cc\u06cc \u06a9\u0634\u06cc\u062f\u0646\/\u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 \u0627\u0632 \u0622\u0646 PostgreSQL\/duckdb \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632: <\/p>\n
DuckDB
\nPostgreSQL<\/p>\n
\u0645\u062f\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647
\n\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u062a\u0648\u0646\u06cc
\n\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc<\/p>\n
\u0645\u062c\u0648\u0632
\n\u0628\u0627
\n\u0645\u0627\u0646\u0646\u062f BSD<\/p>\n
\u0628\u062f\u0648\u0646 \u0633\u0631\u0648\u0631
\n\u0628\u0644\u0647
\n\u062e\u06cc\u0631<\/p>\n
\ud83c\udfaf \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0645\u0627 \u0627\u0646\u062c\u0627\u0645 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f<\/p>\n
\u0645\u0627 \u0641\u0642\u0637 \u0627\u0632 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644: <\/p>\n
\ud83d\udc0b \u0646\u0635\u0628 \u0648 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06a9\u0627\u0646\u062a\u06cc\u0646\u0631\u06cc PostgreSQL (\u0628\u0627 Podman)<\/p>\n
\ud83d\udc18 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<\/p>\n
\ud83d\udd01 \u0627\u06cc\u062c\u0627\u062f \u0648 \u062a\u063a\u0630\u06cc\u0647 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u0645\u06cc\u0632 \u06a9\u0648\u0686\u06a9<\/p>\n
\ud83e\ude84 \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f psql \u062c\u062f\u0648\u0644 \u0627\u0632 duckdb<\/p>\n
\ud83d\udddc\ufe0f \u0635\u0627\u062f\u0631\u0627\u062a psql \u062c\u062f\u0648\u0644 \u0628\u0647 \u0641\u0627\u06cc\u0644 \u067e\u0627\u0631\u06a9\u062a<\/p>\n
\ud83d\udd2c \u0628\u0627\u0632\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f parquet \u0641\u0627\u06cc\u0644 \u0628\u0627 parquet-cli<\/p>\n
\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u0627 \u0627\u0646\u062c\u0627\u0645 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f \u062d\u0631\u06a9\u062a \u0645\u0639\u06a9\u0648\u0633 : <\/p>\n
\u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 PostgreSQL \u0627\u0632 \u062f\u0627\u062e\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f duckdb<\/p>\n
\u062a\u0633\u062a \u0645\u062d\u062a\u0648\u06cc\u0627\u062a \u062c\u062f\u0648\u0644 \u0627\u0632 sql<\/p>\n
\ud83c\udf7f \u0646\u0633\u062e\u0647 \u06cc \u0646\u0645\u0627\u06cc\u0634\u06cc<\/p>\n
\ud83d\udcdc shell \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627<\/p>\n
\u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 PostgreSQL \u0631\u0627 \u0646\u0635\u0628 \u0648 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n
export PGPASSWORD=mysecretpassword<\/p>\n
# Boot a postgresql instance
\npodman run –name postgres -e POSTGRES_PASSWORD=$PGPASSWORD -d\\
\n -p 5432:5432 docker.io\/library\/postgres<\/p>\n
# Check container status
\npodman ps -a<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
\u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f psql \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062e\u0627\u0631\u062c \u0627\u0632 Contenair \u0628\u0647 PostgrSQL \u0628\u0631\u0633\u06cc\u0645:<\/p>\n
# Install `psql` on the host so the database can be accessed
\n# from outside de container
\nsudo apt install -y postgresql-client<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u06a9\u0646\u0648\u0646\u060c \u0686\u0646\u062f \u0634\u06cc PostgreSQL \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n
# Create a demo database
\npsql -h localhost -p 5432 -U postgres -c “CREATE DATABASE demo;”<\/p>\n
# Create a table
\npsql -h localhost -p 5432 -U postgres -d demo\\
\n -c “CREATE table customers(id varchar primary key);”<\/p>\n
# Feed the PostgreSQL table with some data
\npsql -h localhost -p 5432 -U postgres -d demo\\
\n -c “insert into customers values \\
\n (‘Duffy duck’),\\
\n (‘Daisy Duck’),\\
\n (‘Donald Duck’),\\
\n (‘Ludwig Von Drake’);”<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
\u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f duckdb :<\/p>\n
# (Quick and dirty) duckdb install
\nwget https:\/\/github.com\/duckdb\/duckdb\/releases\/download\/v1.0.0\/duckdb_cli-linux-amd64.zip
\nunzip duckdb_cli-linux-amd64.zip
\ncp duckdb \/usr\/bin\/
\nrm duckdb duckdb_cli-linux-amd64.zip<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
\u062d\u0627\u0644\u0627 \u06a9\u0627\u0631\u0647\u0627\u06cc \u062c\u0627\u0644\u0628 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f…<\/p>\n
\u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0627\u0632 duckdb<\/p>\n
\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 postgres \u0628\u0631\u0633\u06cc\u0645 duckdb :<\/p>\n
duckdb -c “ATTACH ‘dbname=demo user=postgres password=mysecretpassword host=127.0.0.1’\\
\n AS db (TYPE POSTGRES, READ_ONLY);
\nshow all tables;
\nselect * from db.customers;
\nCOPY db.customers TO ‘db.customers.parquet’ (FORMAT PARQUET);”<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
… \u0633\u067e\u0633 \u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f parquet \u0641\u0627\u06cc\u0644:<\/p>\n
ls -ltr
\nfile db.customers.parquet<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
… \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f parquet \u0641\u0627\u06cc\u0644 \u0627\u0632 duckdb :<\/p>\n
duckdb -c “select * from ‘db.customers.parquet’;”<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
\u0646\u062a\u06cc\u062c\u0647 \u0622\u0632\u0645\u0627\u06cc\u0634 parquet \u0641\u0627\u06cc\u0644 \u0628\u0627 parquet-cli :<\/p>\n
pip install parquet-cli
\nparq -h<\/p>\n
parq db.customers.parquet –count
\nparq db.customers.parquet –head
\nparq db.customers.parquet –tail<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
duckdb \u27a1\ufe0f PostgreSQL<\/p>\n
\u0628\u06cc\u0627\u06cc\u06cc\u062f:<\/p>\n
“\u0636\u0645\u06cc\u0645\u0647” \u0646\u0645\u0648\u0646\u0647 \u0631\u0627\u0647 \u062f\u0648\u0631 PostgreSQL \u0627\u0632 duckdb \u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627<\/p>\n
\u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u0645\u06cc\u0632<\/p>\n
\u062e\u0648\u0631\u0627\u06a9 \u062c\u062f\u0648\u0644<\/p>\n
\u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u0645\u062d\u062a\u0648\u06cc\u0627\u062a \u062c\u062f\u0648\u0644 \u0627\u0632 psql<\/p>\n
duckdb -c “ATTACH ‘dbname=demo user=postgres password=mysecretpassword host=127.0.0.1’\\
\n AS db (TYPE POSTGRES);\\
\n create table db.heroes(name varchar primary key);\\
\n insert into db.heroes values\\
\n (‘Dumbo’),\\
\n (‘Man-Elephant’),\\
\n (‘Tantra’),\\
\n (‘Elephant Man’),\\
\n (‘The Elephantmen’),\\
\n (‘Mammomax’) ;
\n”<\/p>\n
psql -h localhost -p 5432 -U postgres -d demo\\
\n -c “select * from heroes;”<\/p>\n
\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n
\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n
\u2696\ufe0f \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f DuckDB \u062f\u0631 \u0645\u0642\u0627\u0628\u0644 PostgreSQL<\/p>\n
\u062f\u0631 \u0632\u06cc\u0631 \u0627\u06cc\u0646 \u062a\u0641\u06a9\u06cc\u06a9 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0635\u0646\u0648\u0639\u06cc \u0627\u0632 \u0647\u062c\u0648\u0645 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f: <\/p>\n