Jove Zhong @jove95.bsky.social · 31/03/2025The 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... 171
Jove Zhong @jove95.bsky.social · 19/03/2025Tired of reading #Iceberg docs or blogs and still feeling lost? Maybe 👇 this will help you finally get why Iceberg is so awesome 020
Jove Zhong @jove95.bsky.social · 06/03/2025#SQL is like #LEGO Very basic/boring building blocks can create gigantic masterpieces, or nightmares .. 011
Jove Zhong @jove95.bsky.social · 10/02/2025If 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 000
Jove Zhong @jove95.bsky.social · 06/02/2025A 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 000
Jove Zhong @jove95.bsky.social · 17/01/2025Have 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 000
Jove Zhong @jove95.bsky.social · 23/12/2024Before 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 🎄🎁 000
Jove Zhong @jove95.bsky.social · 21/12/2024I created too many boring roadmap slides. This is how a road-map should be really is (credit: Frostpunk 2 steam page) 010
Jove Zhong @jove95.bsky.social · 20/12/2024What'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 000
Jove Zhong @jove95.bsky.social · 18/12/2024Anyone 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...github.comSemicolon inside $$ block are treated as statement delimiter · Issue #4000 · flyway/flywayWhich version and edition of Flyway are you using? Flyway OSS Edition 11.1.0 by Redgate If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fi... 000
Jove Zhong @jove95.bsky.social · 12/12/2024Looking 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] 030
Jove Zhong @jove95.bsky.social · 12/12/2024You 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...youtube.comReal-time social listening and action with Bluesky and TimeplusYouTube video by Timeplus 000
Jove Zhong @jove95.bsky.social · 04/12/2024www.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 websitesapache.orgApache Project logosWelcome to The Apache Software Foundation! 000
Jove Zhong @jove95.bsky.social · 03/12/2024I just knew something new: Oracle doesn't support AS for table alias.. github.com/dbeaver/dbea... 000
Jove Zhong @jove95.bsky.social · 03/12/2024Speed-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 020
Jove Zhong @jove95.bsky.social · 02/12/2024I am a weekly-active-user of @sidequery.ai , if not DAU 022
Jove Zhong @jove95.bsky.social · 29/11/2024Some 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 010
Jove Zhong @jove95.bsky.social · 28/11/2024Our 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 010
Jove Zhong @jove95.bsky.social · 27/11/2024After 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/ 010
Jove Zhong @jove95.bsky.social · 27/11/2024Many 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 010
