GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → sarathak → django-db-benchmark

sarathak / django-db-benchmark

Licence: MIT License
Comparing Database performance with Django ORM

Programming Languages

python
139335 projects - #7 most used programming language
shell
77523 projects
Dockerfile
14818 projects

Labels

mysqldjangosqlitepostgresqldatabasesmariadbperformance-analysis

Projects that are alternatives of or similar to django-db-benchmark

Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 2,315 (+13517.65%)
Mutual labels:  sqlite, databases, mariadb
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 7,712 (+45264.71%)
Mutual labels:  sqlite, databases, mariadb
Tbls
tbls is a CI-Friendly tool for document a database, written in Go.
Stars: ✭ 940 (+5429.41%)
Mutual labels:  sqlite, mariadb
Dbbench
🏋️ dbbench is a simple database benchmarking tool which supports several databases and own scripts
Stars: ✭ 52 (+205.88%)
Mutual labels:  sqlite, mariadb
Manage Fastapi
🚀 CLI tool for FastAPI. Generating new FastAPI projects & boilerplates made easy.
Stars: ✭ 163 (+858.82%)
Mutual labels:  sqlite, databases
Sqlancer
Detecting Logic Bugs in DBMS
Stars: ✭ 672 (+3852.94%)
Mutual labels:  sqlite, mariadb
Sequelize
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js
Stars: ✭ 25,422 (+149441.18%)
Mutual labels:  sqlite, mariadb
Atdatabases
TypeScript clients for databases that prevent SQL Injection
Stars: ✭ 154 (+805.88%)
Mutual labels:  sqlite, databases
Phpmyfaq
phpMyFAQ - Open Source FAQ web application for PHP and MySQL, PostgreSQL and other databases
Stars: ✭ 494 (+2805.88%)
Mutual labels:  sqlite, mariadb
Ocaml Caqti
Cooperative-threaded access to relational data
Stars: ✭ 175 (+929.41%)
Mutual labels:  sqlite, mariadb
Linq2db
Linq to database provider.
Stars: ✭ 2,211 (+12905.88%)
Mutual labels:  sqlite, mariadb
Qxorm
QxOrm library - C++ Qt ORM (Object Relational Mapping) and ODM (Object Document Mapper) library - Official repository
Stars: ✭ 176 (+935.29%)
Mutual labels:  sqlite, mariadb
Easydb
Easy-to-use PDO wrapper for PHP projects.
Stars: ✭ 624 (+3570.59%)
Mutual labels:  sqlite, databases
Typeorm
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Stars: ✭ 26,559 (+156129.41%)
Mutual labels:  sqlite, mariadb
Denodb
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Stars: ✭ 498 (+2829.41%)
Mutual labels:  sqlite, mariadb
Ebean
Ebean ORM
Stars: ✭ 1,172 (+6794.12%)
Mutual labels:  sqlite, mariadb
Sqlprovider
A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
Stars: ✭ 423 (+2388.24%)
Mutual labels:  sqlite, mariadb
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (+2705.88%)
Mutual labels:  sqlite, mariadb
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (+894.12%)
Mutual labels:  sqlite, mariadb
Heidisql
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi
Stars: ✭ 2,864 (+16747.06%)
Mutual labels:  sqlite, mariadb
View All Similar Projects ➔

Comparing Database performance with Django ORM

  • Postgresql
  • MySQL
  • MariaDB
  • SQLite
  • CockoroachDB

Comparing database operation performance using django ORM.

PostgreSQL vs MySQL vs MariaDB vs SQLite vs CockoroachDB

The results given below are based on AWS T2 micro

Insert performance comparison

Tested 1000 row insert in all databases and calculated time is taken.

Insert

Bulk Insert performance comparison

Tested 1000 row bulk insert in all databases and calculated time is taken.

Insert

Bulk Delete performance comparison

Tested 1000 row delete in all databases and calculated time is taken.

Insert

Bulk Delete performance comparison

Tested 1000 row bulk delete in all databases and calculated time is taken.

Insert

Update performance comparison

Tested 1000 row update in all databases and calculated time is taken.

Insert

Bulk update performance comparison

Tested 1000 row bulk update in all databases and calculated time is taken.

Insert

Select performance comparison

Tested 1000 in 1000 rows select operation in non indexed column in all databases and calculated time is taken.

Insert

Select index performance comparison

Tested 1000 in 1000 rows select operation in indexed column in all databases and calculated time is taken.

Insert

Installation

  • install docker and docker compose
  • clone repository
  • run ./start.sh
  • result will be stored in reports/graph
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].