Terefang74if i can do almost all of that without looking at the cheat-sheet, have i become a Data Analyst already ?
HackerNoonDuckle is an open-source project created by Sourav Roy. It is currently in public beta at v0.0.12, dual-licensed under MIT and Apache-2.0. https://hackernoon.com/what-the-heck-is-duckle #duckdb
POSETTE: An Event for PostgresWhat if you could run analytical queries inside Postgres without an ETL pipeline? At POSETTE 2026, Nitin Jadhav (Microsoft) demos pg_duckdb on Azure Database for PostgreSQL, querying tables & Parquet files from object storage.
Mark your calendar for POSETTE Livestream 4 on Thu 18 Jun
#PosetteConf #PostgreSQL #Postgres #Database #Community #Microsoft #Azure #DuckDB #Analytics #OpenSource #Parquet
InfoQ#DuckDB has announced Quack - a new remote protocol over HTTP that enables multiple DuckDB instances to connect to and work with the same database across a network.
Quack brings client-server capabilities to a database that has traditionally been local and embedded.
🔗 Learn more: https://bit.ly/4foyrOp
ethagnawlI've just published a new blog post in my series on #DuckDB. This one explores DuckDB's Vector Similarity Search extension, the Quack protocol and how they can be used together.
Please read, share and let me know if you have any feedback!
https://peterdohertys.website/blog-posts/double-shot-of-duck.html
Mohit SindhwaniIt's great to be able to find your own post to help you with a new setup! This time #DuckDB #Ruby gem installation on #Windows! You need to do a couple of things so it works.
Using DuckDB on Windows and with Ruby
DuckDB is a fast, open-source database for Online Analytics Processing (OLAP) workloads. It is similar to SQLite3 in the sense that it’s intended to be built directly into a host process and runs within it rather than a separate stand-alone server. Let’s look at setting this up and using it in Windows and also from Ruby.
SMT#Bioinformatics #VEP #DuckDB
I just got the realization that instead of trying to parse in C ensembl VEP's caches (ridiculous idea given the perl serialization format), duckdb has a mysql reader and i can just load this into duckdb the ensembl DB tables i need ! this make the duckvep project much more manageable and mostly sql kernel work now since we already have variant keys and cgranges udfs in the duckhts extension https://github.com/RGenomicsETL/duckhts
I just got the realization that instead of trying to parse in C ensembl VEP's caches (ridiculous idea given the perl serialization format), duckdb has a mysql reader and i can just load this into duckdb the ensembl DB tables i need ! this make the duckvep project much more manageable and mostly sql kernel work now since we already have variant keys and cgranges udfs in the duckhts extension https://github.com/RGenomicsETL/duckhts
hrbrmstr 🇺🇦 🇬🇱 🇨🇦If you are more of a "GUI" person when it comes to databases and data pipelines, Duckle — https://github.com/SouravRoy-ETL/duckle/ — seems dope on first glance and the local "AI" helper is optional. #DuckDB
Christian HollingerI built a thing: https://skaldmaps.com
SkaldMaps is a research, analysis, and rating platform for real estate investments, including primary home buyers (or renters). It lets you analyze, filter, and rank all US ZIP codes by a model you define yourself.
HabrPostgreSQL и аналитика: что меняется, когда хранилище становится общим
HTAP — одна из главных тем в мире СУБД. Вокруг PostgreSQL массово появляются конструкции с внешними аналитическими движками со своими моделями хранения данных и ограничениями совместимости, однако бизнесу не совсем комфортно жить в архитектуре, где транзакционные данные находятся в одной системе, аналитика - в другой, а между ними - разного рода ETL, CDC и прочие parquet-файлы. В Tantor мы движемся по иному пути, развивая HTAP внутри PostgreSQL, а не рядом с ним. Вокруг этой идеи строятся СУБД Tantor Polar и машина баз данных Tantor XData Gen3, в которой OLTP и аналитика, не теряя совместимости с Postgres, работают поверх общего хранилища данных и общей видимости транзакций. В этой статье хочется поговорить не столько о самом термине HTAP, сколько о том, как меняется архитектура PostgreSQL, когда OLTP и аналитика начинают работать поверх общего хранилища данных.
https://habr.com/ru/companies/tantor/articles/1039680/
#tantor #tantor_postgres #xdata #tantor_xdata #oracle_exadata #duckdb #greenplum #kafka #clickhouse
