DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Last call! Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workloads.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • Non-blocking Database Migrations
  • Why "Polyglot Programming" or "Do It Yourself Programming Languages" or "Language Oriented Programming" sucks?
  • Embed a Spreadsheet Into Your Web App
  • Functional Programming Patterns With Java 8

Trending

  • How to Configure and Customize the Go SDK for Azure Cosmos DB
  • Optimizing Integration Workflows With Spark Structured Streaming and Cloud Services
  • How to Practice TDD With Kotlin
  • Cosmos DB Disaster Recovery: Multi-Region Write Pitfalls and How to Evade Them
  1. DZone
  2. Data Engineering
  3. Databases
  4. Why I Use OrientDB on Production Applications

Why I Use OrientDB on Production Applications

By 
Dave Sims user avatar
Dave Sims
·
Mar. 05, 15 · Tutorial
Likes (6)
Comment
Save
Tweet
Share
18.0K Views

Join the DZone community and get the full member experience.

Join For Free

Like many other Java developers, when i start a new Java development project that requires a database, i have hopes and dreams of what my database looks like:

  • Java API (of course)
  • Embeddable
  • Pure Java
  • Simple jar file for inclusion in my project
  • Database stored in a directory on disk
  • Faster than a rocket

First I’m going to review these points, and then i’m going to talk about the database i chose for my latest project, which is in production now with hundreds of users accessing the web application each month.

What I Want from My Database

Here’s what i’m looking for in my database. These are the things that literally make me happy and joyous when writing code.

Java API

I code in Java. It’s natural for me to want to use a modern Java API for my database work.

Embeddable

My development productivity and programming enjoyment skyrocket when my database is embedded. The database starts and stops with my application. It’s easy to destroy my database and restart from scratch. I can upgrade my database by updating my database jar file.

It’s easy to deploy my application into testing and production, because there’s no separate database server to startup and manage. (I know about the issue with clustering and an embedded database, but i’ll get to that.)

Pure Java

Back when i developed software that would be deployed on all manner of hardware, i was a stickler that all my code be pure Java, so that i could be confident that my code would run wherever customers and users deployed it.

In this day of SaaS, i’m less picky. I develop on the Mac. I test and run in production on Linux. Those are the systems i care about, so if my database has some platform-specific code in it to make it run fast and well, i’m fine with that. Just as long as that platform-specific configuration is not exposed to me as the developer.

Simple Jar File for Inclusion in My Project

I really just want one database jar file to add to my project. And i don’t want that jar file messing with my code or the dependencies i include in my project.

If the database uses Guava 1.2, and i’m using Guava 0.8, that can mess me up. I want my database to not interfere with jars that i use by introducing newer or older versions of class files that i already reference in my project’s jars.

Database Stored in a Directory on Disk

I like to destroy my database by deleting a directory. I like to run multiple, simultaneous databases by configuring each database to use a separate directory.

That makes me super productive during development, and it makes it more fun for me to program to a database.

Faster Than a Rocket

I think that’s just a given.

My Latest Project That Needs a Database

My latest project is Floify.com. Floify is a Mortgage Borrower Portal, automating the process of collecting mortgage loan documents from borrowers and emailing milestone loan status updates to real estate agents and borrowers.

Mortgage loan originators use Floify to automate the labor-intensive parts of their loan processes.

The web application receives about 500 unique visitors per month.

Floify experienced 28% growth in january 2015. Floify’s vital statistics are:

  • 38,301 loan documents under management
  • 3,619 registered users
  • 3,113 loan packages under management

The Database I Chose for My Latest Project

When i started Floify, i looked for a database that met all the criteria i’ve described above.

I decided against databases that were server-based (Postgres, etc).

I decided against databases that weren’t Java-based (MongoDB, etc).

I decided against databases that didn’t support ACID transactions.

I narrowed my choices to OrientDB  and Neo4j. It’s been a couple years since that decision process occurred, but i distinctly remember a few reasons why i ultimately chose OrientDB over Neo4j:

  1. Performance benchmarks for OrientDB were very impressive.
  2. The OrientDB development team was very active.
  3. Cost. OrientDB is free. Neo4j cost more than what i was willing to pay or what i could afford. I forget which it was.

My Favourite OrientDB Features

Here are some of my favourite features in OrientDB. These are not competitive advantages to OrientDB. It’s just some of the things that make me happy when coding against an embeddable database.

  • I can create the database in code.
  • I don’t have to use SQL for querying, but most of the time, i do. I already know SQL, and it’s just easy for me.
  • I use the document database, and it’s very pleasant inserting new documents in Java.
  • I can store multi-megabyte binary objects directly in the database.
  • My database is stored in a directory on disk. When scalability demands it, i can upgrade to a two-server distributed database. I haven’t been there yet.
  • Speed. For me, OrientDB is very fast, and in the few years i’ve been using it, it’s become faster.

OrientDB doesn’t come in a single jar file, as would be my ideal. I have to include a few different jars, but that’s an easy tradeoff for me.

Future

In the future, as Floify’s performance and scalability needs demand it, i’ll investigate a multi-server database configuration on OrientDB.

In the meantime, i’m preparing to upgrade to OrientDB 2.0, which was recently released and promises even more speed. Go speed. :-)

OrientDB Database Web application Production (computer science) Java (programming language) JAR (file format) IT

Opinions expressed by DZone contributors are their own.

Related

  • Non-blocking Database Migrations
  • Why "Polyglot Programming" or "Do It Yourself Programming Languages" or "Language Oriented Programming" sucks?
  • Embed a Spreadsheet Into Your Web App
  • Functional Programming Patterns With Java 8

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!