The DuckDB community is so nice. I hit an OOM issue and asked for help and great advices from the DuckDB team and user groups within few hours. www.linkedin.com/pulse/etl-30...

💯

S3? Okay, Season 3

Tired of reading #Iceberg docs or blogs and still feeling lost? Maybe 👇 this will help you finally get why Iceberg is so awesome

#SQL is like #LEGO Very basic/boring building blocks can create gigantic masterpieces, or nightmares ..

No thanks, OpenAI

If you have billions of keys in a dimension table, you may want such a dictionary 1)never out-of-memory 2)work in multi-node 3)cache the hot data to minimize hit miss 4)when the hot data changes in upstream, the cache update itself proactively.. Too good to be true? Well, we just did it, in Timeplus

A new way to generate TPCH dataset in MySQL(or other databases): 1. Simply run `CALL dbgen(sf = 1);` in @duckdb.org 10 million rows generated in few seconds 2. Setup a MySQL locally or via Aiven 3. Download the single binary from slingdata.io Configure the yaml. Then `sling run -r your.yaml` DONE

Have you tried napkin.ai? Write down bullet points and one-click to generate various options for diagrams. Good to illustrate your ideas, and do more fine tuning if needed

Before everyone knows it, go notes.cleve.ai/unwrapped to gen such infograph for your LinkedIn "metrics" (I don't think you will read a 12-page PDF, so I did some PS work to create "Executive Summary"). Happy Holiday 🎄🎁

I created too many boring roadmap slides. This is how a road-map should be really is (credit: Frostpunk 2 steam page)

What's best way to visualize software releases? I don't know. Here is how I abuse #SQL to turn our 27 releases of our open source repo this year as a line chart github.com/timeplus-io/... #data #viz #chart

Anyone using flyway? One of our customers prefer using it and we added a Timeplus plugin for it, and I found a bug to handle protobuf in SQL statement, so I filed an issue on their repo and got lucky number 4000 github.com/flyway/flywa...

Looking at such realtime chart for #bitcoin is both satisfying and terrifying [You can try this via demo.timeplus.cloud and choose the marketdata demo set, and go Dashboards]

You can use a single command to load live #bluesky feed to a SQL database and build viz/alerts. Say you can check how people are talking about you or your brand and take some actions, or train an AI model. 10min short video, or just check the first 30s www.youtube.com/watch?v=QjIb...

www.apache.org/logos/ is such a nice site to download the official logos for Apache projects. I used to download them via wikipedia or crop from different websites

I just knew something new: Oracle doesn't support AS for table alias.. github.com/dbeaver/dbea...

Speed-run🏃‍♂️‍➡️ Setup a EC2 box and build a real-time dashboard with Timeplus for #BitCoin price in just 2 mins * The free-trier t2.micro, with 1 vCPU and 1 G memory, and 8GB disk is just fine * Download the 200MB Timeplus package * You can grab the live price from #coinbase with 3 clicks. * #OHLC viz

I am a weekly-active-user of @sidequery.ai , if not DAU

Some of my BlackFriday purchases: * Filmora, video editor, perpetual license, 80->60. Reasons: all-in-one video editor, AI features LGTM, support the developers * TablePlus, SQL client, perpetual license, 90->68. Reasons: lightweight SQL client on Mac, support the developers * God of War: Ragnarök

Our AWS security groups are `launch-wizard-` and they cannot be renamed 😭 I don't think there is an easy way in AWS console to see which port is allowed in which SG. Well, you can export the data to CSV. Don't use a text editor to search. Try SQL, such as sidequery.ai with in memory duckdb

After getting a few good deals on Xbox and PS Store, I am waiting for Steam Autumn Sale.. Why they don't call this BlackFriday❓https://steamdb.info/sales/history/

Many organizations standardize streaming processing with Apache Flink and use OLAP databases (e.g. ClickHouse) as the downstream or serving layer. Nothing wrong with it. But what if you can use a single system to do both Flink and ClickHouse's job. That's why we built Timeplus, a C++ based Flink+CH