For Developers
Inserting data via the PostgREST API using Python - Dataroc
An article of my own: the second part of a tutorial on PostgREST. This time, learn how to use the write capabilities of the API using secure authorization from a Python script.
Tailscale + VS Code = pristine remote development experience
I've been using VS Code for years, and the Remote SSH feature is a game-changer. I get a native VS Code IDE running directly on my home server from anywhere in the world. With this extension, this workflow gets even better!
Data Engineering
Get 30x speedups when reading databases with ConnectorX + Arrow + dlt | dlt Docs
If rust + arrow + duckb is a new data engineering stack, now you can get a feel of it with dlt. We recently added native arrow tables (and panda frames) loading. What it means? You can pass an Arrow table to dlt pipeline.run or pipeline.extract methods, have it normalized, saved to parquet and loaded to your destination.
Cryo: extract blockchain data to parquet, csv, json or python dataframes
Stumbled across this nice project. Enables efficient extraction of blockchain data. If you know the particular contract and/or topic you want to extract data for, this makes it super easy to do so!
Five Days of Chaos at OpenAI: and What Started It
It’s been five incredibly turbulent days at the leading AI tech company, with the exit and then return of CEO Sam Altman. Tensions likely started years ago, when their non-profit charter changed.
Hummingbot Community
A Latency Analysis of Kucoin, HTX, and Gate.io Exchanges
Viktoria is back with more latency analysis: Kucoin, HTX, and Gate.io! Great for anyone who wants to run HFT bots on crypto exchanges.