what is difference between derby and mysql database


This post covers about comparison of derby and mysql database

MYSQL database

MySQL is a opensource from Oracle corporation, initially released in 1995 and supports all programming languages. It is written in C and C++ languages. These can be accessed by Client side libraries using JDBC/ODBC/native API. It is best suitable for small range to mid range applications.

It can be used in mobile and web applications of following types

  • ecommerce
  • CRM applications
  • Employee managements
  • ERP applications
  • school management
  • LMS systems

MYSQL hosting supported by popular providers like AWS,Azure and Google cloud

Derby Database

Derby is a opensource database from apache foundation, Initially released in 1997 and supports java programming language. These can be easy and quick to install and configure. This can be used as embedded database as well as managed servers.

It is used for small applications

It can be used in applications of following types of data stroage

  • CRON job storage
  • Cache storage
  • Application specific metadata

There is no hosting support from Cloud providers

Comparison of Derby and MySQL database?

Derby Database   MySql database  
Opensource developed by apache foundation Developed by Oracle
Suitable for small and embedded database in your applications suitable for web and mobile applications
It is written in java It is written C++
It does not support floating,date and enum types
Supports all OS with JVMS It also support all OS
It is RDMS It is also RDBMS
Released in 1997 initially released in 1995 initially
API access by JDBC and Interactive command only JDBC,ODBC,Native API and .net
java language only All programming language supports
No Partioning Support Horizontal partioning and composite shard
Supports ACID transactions Supports ACID transactions
Master Slave Replication master-master and master-slave replication
No DBaas support full managed instance hosting AWS,Google cloud,and Azure
THE BEST NEWSLETTER ANYWHERE
Join 90,000 subscribers and get a daily digest of full stack tutorials delivered to your inbox directly.No spam ever. Unsubscribe any time.

Similar Posts