HNHacker News
TopNewBestAskShowJobs

tianzhou

210 karma · joined August 11, 2011

Chief Sketching Officer at bytebase.com
submissionscomments
tianzhou··on Show HN: DBLift – database migration management for Python teams
Congrats on the launch, good project name and glad to see new project trying to address the classic schema migration problem.
tianzhou··on The startup's Postgres survival guide
FWIW, I built pgschema https://github.com/pgplex/pgschema which is a declarative approach to manage this.
tianzhou··on Why It's So Hard to Add a Column in the Middle of a PostgreSQL Table
I see this as the same argument in old days where Harvard law school banned computer in favor of the typewriter https://x.com/stevesi/status/2075994207508922406

What I would argue is knowing what topic to write is more important, and I am confident if you throw this particular question to AI, the response would be much worse.

tianzhou··on Why It's So Hard to Add a Column in the Middle of a PostgreSQL Table
Author here. I did use AI to assist writing. The way I do it is I feed all my past writings (around 200+ posts) to the AI and let it record my style.

I research the topic, lay the outlines and let AI write it. Then I further refine section by section with a combination of AI and manual editing).

What you have pointed out is valid and it helps me to improve the process. And I have edited the post based on your suggestion.

As a non-native speaker and engineer with 15+ database development experience, I think I will continue to use AI to assist writing (I rarely use AI if I write in my native language). This post still takes me almost an afternoon to finish, but without AI, it will take me much more time.

tianzhou··on Google Workspace CLI
Good stuff. I added to the latest star-history.com issue https://www.star-history.com/blog/ai-ui-irrelevant
tianzhou··on Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite
If someone is looking for a more comprehensive coverage for Postgres, please check out https://github.com/pgschema/pgschema.

I built this last summer and thought it was fairly complete. And it turns out I was naive. 6 months later, I have resolved ~100 issues reported by the users.

tianzhou··on Database Linting and Analysis for PostgreSQL
Appreciate the Bytebase shoutout! Skeema has definitely been an inspiration.
tianzhou··on What’s New in PostgreSQL 18 – a Developer’s Perspective
Author here — I nearly overlooked this in the changelog. Definitely my second favorite feature (uuidv7() is tough to beat)
tianzhou··on Asciinema CLI 3.0 rewritten in Rust, adds live streaming, upgrades file format
I ask Manus to write a script to demo my CLI tool and use asciinema to record it. It's perfect

Whole process: https://www.pgschema.com/blog/demo-with-manus-and-asciinema Replay: https://manus.im/share/8fEln1OzxpnsRSU1PnHweG?replay=1

tianzhou··on Pgschema – Declarative schema migration for Postgres
Author here. To put it simply, my bank account doesn't have 3 commas mate.

https://x.com/mitchellh/status/1964785527741427940

tianzhou··on Ask HN: How many of you open up your production DBs to internal users?
Check out Bytebase which handles all human-to-db operations (schema change, ad-hoc change, ad-hoc query). Disclaimer: I am the co-founder.
tianzhou··on Database Tools in 2024: A Year in Review
While database tools may not grab headlines like high-profile data infrastructure, they are equally indicative of the industry’s momentum.
tianzhou··on Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website)
We have been building such a tool as well, please check out https://github.com/bytebase/bytebase
tianzhou··on Show HN: Outerbase Studio – Open-Source Database GUI
https://www.bytebase.com/sql-editor/ with data access control, dynamic data masking.
tianzhou··on Building a better and scalable system for data migrations
This post addresses the data migration specifics well. Besides, there is the part about scaling the organization to deploy database migrations. We've built a project https://github.com/bytebase/bytebase to address this.
tianzhou··on Code in Database vs. Code in Application
From the stored procedure Pro clan:

1. Some applications can't tolerate the roundtrip latency, so the typical way is to put the business logic inside the stored procedure.

2. DBA wants to guard the database.

tianzhou··on PostgreSQL 17
(Bytebase co-founder) Bytebase implements this https://www.bytebase.com/docs/change-database/synchronize-sc...
tianzhou··on PostgreSQL 17
>> I really wish someone will implement DB Projects (dacpac) for Postgresql

Bytebase did https://www.bytebase.com/docs/change-database/synchronize-sc...

tianzhou··on Figma Slides
Combining the best of Google Slides and Apple Keynote
tianzhou··on LLMs and SQL
Quite a few folks are working it actually https://star-history.com/blog/text2sql
tianzhou··on Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
We have been building https://github.com/bytebase/bytebase for 3+ years. You can think it of as GitHub/GitLab for SQL changes, with integrated GitOps, code review and deployment.

You can further check out this tutorial to get a feel of our GitOps solution

https://www.bytebase.com/docs/tutorials/database-change-mana...

tianzhou··on The Great Migration from MongoDB to PostgreSQL
Architecture-wise, Postgres is more extensible. Another reason is licensing. Both contribute to a viral ecosystem.

https://www.bytebase.com/blog/postgres-vs-mysql/

tianzhou··on HashiCorp Exploring Potential Sale
Cisco or Okta
tianzhou··on How Figma's databases team lived to tell the scale
FWIW, we at bytebase building the batch change feature to make this less painful https://www.bytebase.com/docs/change-database/batch-change/
tianzhou··on Incident report for February 21st, 2024
We are also building Bytebase, which enforces the change review process for such operations
tianzhou··on Incident report for February 21st, 2024
We have been working on bytebase (https://github.com/bytebase/bytebase) for 3+ years to address this. With a change review workflow, environment propagations, and try not to disturb the dev flow if possible.
tianzhou··on My notes on Gitlab's Postgres schema design (2022)
+1. We have been working on a schema migration tool called Bytebase for 3+ years. And we follow the similar principles.
tianzhou··on Is the "modern data stack" still a useful idea?
FWIW, we are building a CI/CD solution snowflake https://www.bytebase.com/docs/tutorials/database-change-mana...
tianzhou··on Modern Snowflake Stack
Modern Snowflake Stack can be thought of as an implementation of Modern Data Stack
tianzhou··on Ask HN: Has GitHub recently changed the CSS in PR review button?
As a frequent code reviwer, the CSS seems to be off.
Page 1 of 3Next →