News for hackers. Stuff that matters.
Re:Show HN: DBChaos – Database stress testing tool by bma13 on Monday January 01, 2024 @02:57PM (#38834825)
If using Postgres (as shown in the GitHub example), what are the benefits over using something established like pgbench?
Re:Show HN: DBChaos – Database stress testing tool by debarshri on Monday January 01, 2024 @07:22PM (#38836611)
Thanks for asking. I think goal here is diferent. If your goal is benchmarking a query, i would recommend pgbench. Goal is to keep running the query or bunch of queries concurrently for x amount of time and observe dependent application and database behavior.

One of the features we are adding would allow you specify an audit log and replay allá queries on the database. Also something we are planning to add is parameter randomization. This is kind of the goal of this tool.

Re:Show HN: DBChaos – Database stress testing tool by stevomacdaddy on Monday January 01, 2024 @04:16PM (#38835425)
Plans to add support for MongoDB?
Re:Show HN: DBChaos – Database stress testing tool by debarshri on Monday January 01, 2024 @07:23PM (#38836620)
We will be adding support for MongoDB in couple of weeks.
Re:Show HN: DBChaos – Database stress testing tool by 22c on Monday January 01, 2024 @10:03PM (#38837588)
I would normally not particularly care enough to mention a lack of license, but permissively licensed open source tools in the DB stress testing space are few and far between.

Are you planning to add a proper license at some point?

Re:Show HN: DBChaos – Database stress testing tool by debarshri on Monday January 01, 2024 @10:27PM (#38837756)
Added MIT License.
Re:Show HN: DBChaos – Database stress testing tool by 22c on Monday January 01, 2024 @10:31PM (#38837781)
Appreciated, thank you!
Re:Show HN: DBChaos – Database stress testing tool by qainsights on Monday January 01, 2024 @10:55PM (#38837920)
How it is different from performing chaos exercises using LitmusChaos or ChaosMesh?
Re:Show HN: DBChaos – Database stress testing tool by tills13 on Tuesday January 02, 2024 @12:40AM (#38838520)
When is this actually preferable over hand-selected queries run occasionally for regression testing (missing / incomplete indexes for example)?

The only thing I can think of is testing auto-scaling.

Re:Show HN: DBChaos – Database stress testing tool by debarshri on Tuesday January 02, 2024 @01:08AM (#38838660)
Autoscaling, replication problems, undesired application behavior due to database slowness, database misconfigurations etc. are some other things were this can be used.

We use it internally to figure misconfiguration, CDC behaviour as well as trigger performance.

Another thing that is in works is, replaying audit logs on the database as is.