François

@franssoa

Data Scientist & Computational Engineer

Lyon, France Joined July 2009

2.4K Following 208 Followers 591 Posts

Latest posts 5

New post: @Teradata → @PostgreSQL ETL with @DataPolars and a Chronos-2 forecast in between. 128,567 hours of French power data, 7-day forecast, all Arrow with our ADBC drivers.
Teradata cloud → Polars: 3.06 s
Polars → PostgreSQL: 0.08 s
blog.arpe.io/python-etl-ter…
#Python

Line chart of French electricity consumption in GW, hour by hour, for the forecast week of September 1 to 7, 2026 (UTC). The orange Chronos-2 forecast closely follows the blue line of actual consumption (real-time data), with a shaded band showing the 90% interval. Both lines show the same daily cycle: night lows around 32 to 36 GW and daytime peaks around 44 to 52 GW, with lower peaks on the weekend of September 5 and 6. Title: MAPE 2.5%.

François @franssoa Oct 30

SQL Server 2025 has a native VECTOR type. In a new Python post, we embed 1 million SQL Server rows on a GPU with sentence-transformers and write the vectors back with ArpeMSSQL, our ADBC driver:
blog.arpe.io/embedding-sql-…
@PythonPr @SQLServer @DataPolars @ApacheArrow

François @franssoa Oct 26

60 million rows from Oracle into a pandas DataFrame; a short Python post on doing it with our ADBC driver:
blog.arpe.io/from-oracle-to…
@pandas_dev @ApacheArrow #ADBC @Oracle

blog.arpe.io From Oracle to pandas with ArpeOracle | Ingestion Blog - ARPEIO Read a 60-million-row Oracle table into a pandas DataFrame with the ArpeOracle ADBC driver: 2.8x faster than python-oracledb, with exact decimals and no copy.

François @franssoa Oct 10

New short Python post: 7 million rows from SQL Server into a Polars 2.0 DataFrame with ArpeMSSQL, our ADBC driver.
blog.arpe.io/from-sql-serve…
#Python #Polars #ApacheArrow #ADBC #SQLServer

François @franssoa Dec 14, 2024

Pizzerias around the world, visualized with @datashader
aetperf.github.io/2024/12/12/Piz…