- Postgresql
- MySQL
- MariaDB
- SQLite
- CockoroachDB
Comparing database operation performance using django ORM.
PostgreSQL vs MySQL vs MariaDB vs SQLite vs CockoroachDB
Tested 1000 row insert in all databases and calculated time is taken.
Tested 1000 row bulk insert in all databases and calculated time is taken.
Tested 1000 row delete in all databases and calculated time is taken.
Tested 1000 row bulk delete in all databases and calculated time is taken.
Tested 1000 row update in all databases and calculated time is taken.
Tested 1000 row bulk update in all databases and calculated time is taken.
Tested 1000 in 1000 rows select operation in non indexed column in all databases and calculated time is taken.
Tested 1000 in 1000 rows select operation in indexed column in all databases and calculated time is taken.
- install docker and docker compose
- clone repository
- run ./start.sh
- result will be stored in reports/graph