home.social

#parquet — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #parquet, aggregated by home.social.

fetched live
  1. I've made a new release for the PHP DuckDB PDO driver:

    - Update to DuckDB 1.5.5
    - Support for PHP 8.6
    - Support for TrueAsync and Quack protocol
    - More examples in the readme:
    - ascii chart rendering with SQL
    - LLM integration
    - fetch public data
    - direct data copy from MySQL/MariaDB

    Binary releases are available on GitHub and can be installed or updated with PIE:

    pie install thomas-0816/pdo-duckdb-php

    github.com/thomas-0816/pdo-duc

    #php #duckdb #pdo #analytics #bigdata #parquet

  2. Spent the past couple of nights working up a #Golang utility to read the central XML file (exports.xml) from an #AppleHealth export and convert the <Record/> elements to #Parquet.

    Finally got that working tonight and was able to load the Parquet file into #DuckDB to begin doing some querying.

  3. Spent the past couple of nights working up a #Golang utility to read the central XML file (exports.xml) from an #AppleHealth export and convert the <Record/> elements to #Parquet.

    Finally got that working tonight and was able to load the Parquet file into #DuckDB to begin doing some querying.

  4. The "Awesome Parquet" list keeps growing.

    github.com/severo/awesome-parq

    The newest projects:

    1. GeoParquet Viewer 🗺️: A table and map viewer for GeoParquet files in the browser, by @mmohr.

    geoparquet.info/

    2. Hardwood ☕: A minimal dependency Java implementation of Apache Parquet, by @gunnarmorling.

    hardwood.dev/

    3. LakeQL 🚣: Pure JavaScript duck-compatible SQL query engine for Parquet and Iceberg data in object storage.

    github.com/earonesty/lakeql

    🧵

    #Parquet

  5. The "Awesome Parquet" list keeps growing.

    github.com/severo/awesome-parq

    The newest projects:

    1. GeoParquet Viewer 🗺️: A table and map viewer for GeoParquet files in the browser, by @mmohr.

    geoparquet.info/

    2. Hardwood ☕: A minimal dependency Java implementation of Apache Parquet, by @gunnarmorling.

    hardwood.dev/

    3. LakeQL 🚣: Pure JavaScript duck-compatible SQL query engine for Parquet and Iceberg data in object storage.

    github.com/earonesty/lakeql

    🧵

    #Parquet

  6. Do you use Adminer? It's the best PHP database management, since PHPMyAdmin has enshittified.

    But there has not been DuckDB / Parquet support, so here you go:
    ambience.sk/adminer-support-fo

    Both work in read-only mode and require external dependencies, but they work with Adminer!

  7. Do you use Adminer? It's the best PHP database management, since PHPMyAdmin has enshittified.

    But there has not been DuckDB / Parquet support, so here you go:
    ambience.sk/adminer-support-fo

    Both work in read-only mode and require external dependencies, but they work with Adminer!

    #adminer #php #db #database #duckdb #parquet #management #dbm

  8. #til about #GeoParquet files naming:

    It is RECOMMENDED to use .parquet as the file extension for a GeoParquet file. This provides the best interoperability with existing Parquet tools. The file extension .geoparquet SHOULD NOT be used

    #parquet #gis #geo #gischat

    geoparquet.org/releases/v1.1.0/

  9. #til about #GeoParquet files naming:

    It is RECOMMENDED to use .parquet as the file extension for a GeoParquet file. This provides the best interoperability with existing Parquet tools. The file extension .geoparquet SHOULD NOT be used

    #parquet #gis #geo #gischat

    geoparquet.org/releases/v1.1.0/

  10. #LabPlot (upcoming release) just got even more powerful.

    The latest merge request introduces native support for importing data from the following file formats:

    👉 #Apache #Parquet
    👉 #Apache #ORC
    👉 #Arrow #IPC (#Feather)

    —three of the most efficient and widely used columnar storage formats in data science.

    #DataScience #OpenSource #FOSS #FLOSS #KDE #DataViz #BigData #Data #DataAnalysis #Python #R #OpenData #HackerNews #TechNews #OpenData #Science #Research #Analytics #Tech #IT

  11. #LabPlot (upcoming release) just got even more powerful.

    The latest merge request introduces native support for importing data from the following file formats:

    👉 #Apache #Parquet
    👉 #Apache #ORC
    👉 #Arrow #IPC (#Feather)

    —three of the most efficient and widely used columnar storage formats in data science.

    #DataScience #OpenSource #FOSS #FLOSS #KDE #DataViz #BigData #Data #DataAnalysis #Python #R #OpenData #HackerNews #TechNews #OpenData #Science #Research #Analytics #Tech #IT

  12. When does #Iceberg beat #Parquet+projection on #AWSGlue, and when doesn't ?

    An end-to-end #ETL PoC on #AWS to find out: producer, #Kinesis, two #Firehose paths, two #Glue jobs, #Athena.

    🔮 Spoiler: how the data is read is the key to the choice.

    In the article: every choice with its why, plus a few gems from some Glue experience 😄

    alessandra.bilardi.net/diary/a

    #DiaryOfALazyDeveloper

  13. When does #Iceberg beat #Parquet+projection on #AWSGlue, and when doesn't ?

    An end-to-end #ETL PoC on #AWS to find out: producer, #Kinesis, two #Firehose paths, two #Glue jobs, #Athena.

    🔮 Spoiler: how the data is read is the key to the choice.

    In the article: every choice with its why, plus a few gems from some Glue experience 😄

    alessandra.bilardi.net/diary/a

    #DiaryOfALazyDeveloper

  14. Гайд: Как работать с форматом PARQUET

    В прошлом году мы начали публиковать данные в каталоге «Если быть точным» в формате Parquet . Его придумали инженеры Twitter и Cloudera в 2013 году, и сегодня он стал стандартом хранения аналитических данных — его используют Google, Amazon, Netflix и большинство современных data-платформ. В этом гайде мы расскажем, как эффективно работать с данными в формате Parquet с помощью Python.

    habr.com/ru/articles/1013604/

    #parquet #python #анализ_данных

  15. 🐒 Ah, yes, the holy grail of nerd bragging rights: a 47M+ item #archive of Hacker News, now in the culinary delight format of #Parquet for all your "data chef" needs. 🍽️ Updated every 5 minutes, because clearly, what's more riveting than a play-by-play of techie's daily musings? Oh wait, I forgot—🥱 anything else.
    huggingface.co/datasets/open-i #HackerNews #DataChef #TechieBraggingRights #DailyUpdates #HackerNews #ngated

  16. 🐒 Ah, yes, the holy grail of nerd bragging rights: a 47M+ item #archive of Hacker News, now in the culinary delight format of #Parquet for all your "data chef" needs. 🍽️ Updated every 5 minutes, because clearly, what's more riveting than a play-by-play of techie's daily musings? Oh wait, I forgot—🥱 anything else.
    huggingface.co/datasets/open-i #HackerNews #DataChef #TechieBraggingRights #DailyUpdates #HackerNews #ngated

  17. Ho provato a riversare un dump #Wikidata in #Parquet e ad interrogarlo con #DuckDB: ci mette meno di un'ora ad estrapolare tutte le 19.939.182 entità che rappresentano persone, incluse le sottoclassi di wdt:Q5.
    Decisamente meglio del mio deserializzatore implementato in Go, che per fare la stessa cosa ci mette quasi 8 ore.

  18. Ho provato a riversare un dump #Wikidata in #Parquet e ad interrogarlo con #DuckDB: ci mette meno di un'ora ad estrapolare tutte le 19.939.182 entità che rappresentano persone, incluse le sottoclassi di wdt:Q5.
    Decisamente meglio del mio deserializzatore implementato in Go, che per fare la stessa cosa ci mette quasi 8 ore.

  19. Munquet 0.2.1 just landed on Flathub 🚀

    Fixed a small race condition when canceling a conversion — turns out the process could finish right before you clicked “Yes” 😅

    Two lines later… all good.

    flathub.org/en/apps/io.gitlab.

    #Flatpak #GTK4 #OpenSource #Parquet #DataScience #Linux #Python #PyArrow

  20. Munquet 0.2.1 just landed on Flathub 🚀

    Fixed a small race condition when canceling a conversion — turns out the process could finish right before you clicked “Yes” 😅

    Two lines later… all good.

    flathub.org/en/apps/io.gitlab.

    #Flatpak #GTK4 #OpenSource #Parquet #DataScience #Linux #Python #PyArrow

  21. Munquet 0.2.0 is now available on Flathub 🎉

    ✨ Display real host paths via XDG Portal
    🛠 Introduced a .Devel Flatpak manifest for development builds

    Continuing to improve the Linux desktop data workflow 🚀

    flathub.org/en/apps/io.gitlab.

    #Flathub #Flatpak #XDGPortal #GTK4 #OpenSource #Parquet #Python #DataScience