Top Rated Apache Derby Alternatives
The best part of this software is that it is open source and easy to use. It has a low memory requirement and easy to use with java. Review collected by and hosted on G2.com.
The user manual is not good and very less help support available. Review collected by and hosted on G2.com.
22 out of 23 Total Reviews for Apache Derby
Overall Review Sentiment for Apache Derby
Log in to view review sentiment.
Apache Derby is an SQL relational database system in which its extensive language compiler determines the various expressions during compilation time and produces substantial results. We can use both implicit and explicit functions to denote our associated records and data types in our environment. It follows Derby database connection schematics with which we utilize its subfunctional protocols and properties to connect with our various enterprise database systems. Review collected by and hosted on G2.com.
Apache Derby follows java-based SQL drivers, which efficiently establishes connections with our object drivers. It is capable of taking more than one argument besides our regular JDBC connection URL, which helps to provide authentication and authorization within our set database connection. I prefer using Apache Derby for my relational database management system in our enterprise. Review collected by and hosted on G2.com.
This is a Relational database management system. It is a database system implemented fully in java. It is very easy to install, deploy, and use. I would say it is well suited for beginners who want to learn DBMS as it is easy to configure and use. It has a very small setup to install. It is available with a command-line tool called "ij tool" to access databases and fire various SQL queries. Apache derby is good to use for java applications. Review collected by and hosted on G2.com.
Apache derby has quite fewer features than any other database system. It is not suitable for large scale enterprise applications. Some of the SQL statements which are available in MySQL are not there in apache derby. As it is made in java so it is comparatively slower than C/C++ database systems. It is less popular in the developers' community. Review collected by and hosted on G2.com.
Lightweight and much easier to use than any other Databases.Best suited for applications which need a small embeddable DB. Review collected by and hosted on G2.com.
The only limitation that i see is that it is not designed for data warehousing and would not do well for data analytics for which a No-SQL DB would serve better. Review collected by and hosted on G2.com.
Apache Derby is an in memory database which does not require any dedicated database and as I am using Spring in which it is very easy to manage the derby Review collected by and hosted on G2.com.
As Compare to H2 its performance with Hibernate is not so good Review collected by and hosted on G2.com.
I found that Apache Derby also known as Java DB is very fast .Additionally ,much easier to configure / use and it’s hardly takes 15 mins to set up the DB . Review collected by and hosted on G2.com.
We have used Apache Derby with in one of the Java swing based stand alone application . I haven’t faced any challenge with this , looks to me there could be issues scalability aspects compared to other enterprise players Review collected by and hosted on G2.com.
The embedded driver was the main reason that made me to use this database. Really easy to use and user friendly. Review collected by and hosted on G2.com.
I used netbeans to develop the app and I have to say that the installation was the only thing that made my time hard. Also I think the documentation is a bit outdated. Review collected by and hosted on G2.com.
I have not faced any glitches till date like the derby server stopping abruptly or it’s not starting sometimes. One single command in Linux VMs and it’s works like a charm Review collected by and hosted on G2.com.
I have been using derby from past two years for my projects and I have not seen any complaints till date Review collected by and hosted on G2.com.
Lightweight
Embedded in your Java application
Useful for both smaller projects or integration testing Review collected by and hosted on G2.com.
Hard to manage multiple connections too
Had some issues with lock files when the host computer crashed. Review collected by and hosted on G2.com.
