TrustRadius: an HG Insights company

Apache Derby vs. HAProxy Community Edition

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Apache Derby

    Score7 out of 10
    N/AApache Derby is an embedded relational database management system, originally developed by IBM and called IBM Cloudscape.N/A

    HAProxy Community Edition

    Score9.3 out of 10
    N/AHAProxy Community Edition is a free, open source reverse-proxy offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It is presented as suited for very high traffic web sites.

    $0

    Pricing
    Apache DerbyHAProxy Community Edition
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Apache DerbyHAProxy Community Edition
    Free Trial
    NoNo
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Best Alternatives
    Apache DerbyHAProxy Community Edition
    Small Businesses
    No answers on this topic
    No answers on this topic
    Medium-sized Companies
    No answers on this topic
    F5 BIG-IP
    Score9.2 out of 10
    Enterprises
    No answers on this topic
    F5 BIG-IP
    Score9.2 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Apache DerbyHAProxy Community Edition
    Likelihood to Recommend
    7.0
    (3 ratings)
    9.0
    (7 ratings)
    Usability
    -
    (0 ratings)
    9.1
    (2 ratings)
    Support Rating
    -
    (0 ratings)
    9.7
    (2 ratings)
    User Testimonials
    Apache DerbyHAProxy Community Edition
    Likelihood to Recommend
    Apache
    If you need a SQL-capable database-like solution that is file-based and embeddable in your existing Java Virtual Machine processes, Apache Derby is an open-source, zero cost, robust and performant option. You can use it to store structured relational data but in small files that can be deployed right alongside with your solution, such as storing a set of relational master data or configuration settings inside your binary package that is deployed/installed on servers or client machines.
    Incentivized
    Read full review
    Open Source
    It prevents a single server failure from being a downtime event by adding redundancy to every layer of your architecture. A load balancer facilitates redundancy for the backend layer (web/app servers), but for a true high availability setup, you need to have redundant load balancers as well. So it is well suited for all production related servers and less suited for individual servers that do not require redundancy.
    Incentivized
    Read full review
    Pros
    Apache
    • Apache Derby is SMALL. Compared to an enterprise scale system such as MSSQL, it's footprint is very tiny, and it works well as a local database.
    • The SPEED. I have found that Apache Derby is very fast, given the environment I was developing in.
    • Based in JAVA (I know that's an obvious thing to say), but Java allows you to write some elegant Object Oriented structures, thus allowing for fast, Agile test cases against the database.
    • Derby is EASY to implement and can be accessed from a console with little difficulty. Making it appropriate for everything from small embedded systems (i.e. just a bash shell and a little bit of supporting libraries) to massive workstations.
    Incentivized
    Read full review
    Open Source
    • Low-Cost Load Balancer
    • Intelligent Request Routing based on URL and/or URI
    • Extremely flexible load balancing and healthchecks, can do almost anything including HTTP, HTTPS, PostgreSQL, etc.
    • SSL Termination
    Incentivized
    Read full review
    Cons
    Apache
    • It may not scale as well as some more mature database products.
    • Used it primarily from the command line with openjpa and jdbc, and from third-party clients such as Squirrel.
    • May benefit by providing more sophisticated tools to optimize query performance.
    Incentivized
    Read full review
    Open Source
    • A few, rare times each year, HAProxy CPU utilization spikes to 100% and server has to be rebooted - this may be related to HAProxy OR it could be an external factor causing this.
    Incentivized
    Read full review
    Usability
    Apache
    No answers on this topic
    Open Source
    It is very easy to use. I was able to find a lot of documents for it on the internet. Very good community support. There are lots of examples available to try. We mostly use a command-line user interface to interact with it. The CLI is also super easy to use and very easy to interact with
    Incentivized
    Read full review
    Support Rating
    Apache
    No answers on this topic
    Open Source
    We haven't used customer support. We mostly used the community version. We build a multi-node HAProxy cluster with HA to the proxy itself using opensource plugins available. With the support available on the internet and the documents available we don't need to use much customer support.
    Incentivized
    Read full review
    Alternatives Considered
    Apache
    SQLite is another open-source zero-cost file-based SQL-capable database solution and is a good alternative to Apache Derby, especially for non-Java-based solutions. We chose Apache Derby as it is Java-based, and so is the solution we embedded it in. However, SQLite has a similar feature set and is widely used in the industry to serve the same purposes for native solutions such as C or C++-based products.
    Incentivized
    Read full review
    Open Source
    We chose HA Proxy because it is cheaper than a hardware balancer, it is an open-source solution with a large community behind it and with constant updates. It also allows custom scripts according to needs.HA Proxy is a solution used in many internet sites like GitHub, Reddit, Twitter, and Tuenti.
    Incentivized
    Read full review
    Return on Investment
    Apache
    • Being Open source, the resources spent on the purchase of the product are ZERO.
    • Contrary to popular belief, open source software CAN provide support, provided that the developers/contributors are willing to answer your emails.
    • Overall, the ROI was positive: being able to experiment with an open source technology that could perform on par with the corporate products was promising, and gave us much information about how to proceed in the future.
    Incentivized
    Read full review
    Open Source
    • Significantly lower investment vs competitors. In the case of F5s we have Virtual Editions so we're paying for the hardware to run it on top of the several thousand dollar licenses that are required for each pair and we currently have a pair of F5s per client so there's a huge potential for cost savings there.
    • Requires our network engineers to learn a new skill or our Systems engineers to take on the responsibility of managing the load balancers. It's not a huge difference either way, but it does impact the way we have done business in the past.
    Incentivized
    Read full review
    ScreenShots