search

stephenafamo / bob

SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite
https://bob.stephenafamo.com
MIT License
714 stars 37 forks source link

Benchmarks against other orms #73

Open inoc603 opened 1 year ago

inoc603 commented 1 year ago

I use sqlboiler extensively and this library just hits so many spots where I think sqlboiler could probably improve upon. Brilliant work!

I wonder if we have something like the benchmarks in sqlboiler's README for bob, apart from benchmarks for the query builder?

I would imagine bob having similar performance as sqlboiler, but it would be great to have some actual numbers. Maybe we can add bob to https://github.com/volatiletech/boilbench ?

stephenafamo commented 1 year ago

I actually tried to do this at some point, but I ran into issues trying to upgrade every package to its most recent version. It was also tricky to make sure we are not including the database network roundtrip as part of the benchmarks.

If you can give it a go, I would appreciate it. I am fairly certain that Bob is quite performant. Since the primary focus is the development experience and not speed, it may not be the fastest, but it is definitely no slouch.