TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Elasticsearch

    Score8.5 out of 10
    N/AElasticsearch is an enterprise search tool from Elastic in Mountain View, California.

    $16

    per month

    SQLite

    Score8 out of 10
    N/ASQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is one of the most widely deployed databases in the world.N/A
    Pricing
    ElasticsearchSQLite
    Editions & Modules
    Standard
    $16.00
    per month
    Gold
    $19.00
    per month
    Platinum
    $22.00
    per month
    Enterprise
    Contact Sales
    No answers on this topic
    Offerings
    Pricing Offerings
    ElasticsearchSQLite
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    ElasticsearchSQLite
    Considered Both Products
    Elastic
    No answer on this topic
    Open Source
    No answer on this topic
    Key User Insights
    Would buy again
    82%
    Would buy again
    14 Answers
    100%
    Would buy again
    11 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    16 Answers
    100%
    Delivers good value for the price
    11 Answers
    Happy with the feature set
    100%
    Happy with the feature set
    17 Answers
    100%
    Happy with the feature set
    11 Answers
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    13 Answers
    90%
    Lived up to sales and marketing promises
    9 Answers
    Implementation went as expected
    87%
    Implementation went as expected
    13 Answers
    100%
    Implementation went as expected
    11 Answers
    Best Alternatives
    ElasticsearchSQLite
    Small Businesses
    Apache Solr
    Score7.9 out of 10
    MariaDB Platform
    Score9.1 out of 10
    Medium-sized Companies
    IBM Watson Discovery
    Score9 out of 10
    PostgreSQL
    Score8.8 out of 10
    Enterprises
    Amazon CloudSearch
    Score8.5 out of 10
    MySQL
    Score8.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    ElasticsearchSQLite
    Likelihood to Recommend
    9.0
    (48 ratings)
    8.0
    (14 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    10.0
    (1 ratings)
    8.0
    (2 ratings)
    Support Rating
    7.8
    (9 ratings)
    1.0
    (1 ratings)
    Implementation Rating
    9.0
    (1 ratings)
    -
    (0 ratings)
    Configurability
    -
    (0 ratings)
    10.0
    (1 ratings)
    Ease of integration
    -
    (0 ratings)
    10.0
    (1 ratings)
    User Testimonials
    ElasticsearchSQLite
    Likelihood to Recommend
    Elastic
    Elasticsearch is a really scalable solution that can fit a lot of needs, but the bigger and/or those needs become, the more understanding & infrastructure you will need for your instance to be running correctly. Elasticsearch is not problem-free - you can get yourself in a lot of trouble if you are not following good practices and/or if are not managing the cluster correctly. Licensing is a big decision point here as Elasticsearch is a middleware component - be sure to read the licensing agreement of the version you want to try before you commit to it. Same goes for long-term support - be sure to keep yourself in the know for this aspect you may end up stuck with an unpatched version for years.
    Incentivized
    Read full review
    Open Source
    SQLite is a lightweight and efficient database management system. With SQLite, performance increases as memory are added. It's reliable and well-tested before release. SQLite handles memory allocation and I/O errors gracefully. SQLite provides bug lists and code-change chronologies. All bugs are disclosed, and it's compatible with iOS, Android, MAC, and Windows. SQLite is open-source, allowing developers to tailor it to their specific needs.
    Incentivized
    Read full review
    Pros
    Elastic
    • As I mentioned before, Elasticsearch's flexible data model is unparalleled. You can nest fields as deeply as you want, have as many fields as you want, but whatever you want in those fields (as long as it stays the same type), and all of it will be searchable and you don't need to even declare a schema beforehand!
    • Elastic, the company behind Elasticsearch, is super strong financially and they have a great team of devs and product managers working on Elasticsearch. When I first started using ES 3 years ago, I was 90% impressed and knew it would be a good fit. 3 years later, I am 200% impressed and blown away by how far it has come and gotten even better. If there are features that are missing or you don't think it's fast enough right now, I bet it'll be suitable next year because the team behind it is so dang fast!
    • Elasticsearch is really, really stable. It takes a lot to bring down a cluster. It's self-balancing algorithms, leader-election system, self-healing properties are state of the art. We've never seen network failures or hard-drive corruption or CPU bugs bring down an ES cluster.
    Incentivized
    Read full review
    Open Source
    • Our products are using SQLite in embedded Linux and in Windows software.
    • It is truly a stable cross-platform database.
    • The fact that it is a zero-configuration database engine, it is particularly a nice advantage when you work in the embedded world.
    • Being a single database file, it provides ease for those who need to quickly transfer data to someone else, or quickly browse data.
    Incentivized
    Read full review
    Cons
    Elastic
    • Joining data requires duplicate de-normalized documents that make parent child relationships. It is hard and requires a lot of synchronizations
    • Tracking errors in the data in the logs can be hard, and sometimes recurring errors blow up the error logs
    • Schema changes require complete reindexing of an index
    Incentivized
    Read full review
    Open Source
    • Although it is excellent at what it does, you should be really careful and plan accordingly if you know that your database is going to scale at a huge level because it is not suitable of databases which are of Enterprise level and demands top-notch security and protection.
    • If your project involves multiple people working on the same database simultaneously, then that becomes a big problem, because it only allows single write at one time. You really need to be forward thinking in a manner to predict if this database will cater to all the needs of your project.
    • The most common difficulty with this is the lack of some of the basic functionality which is present in the other premier databases like Joints, Stored Procedure calls, Security and permission grants. If you do require all those things then you are better off not using this software.
    • Lastly, if you are using this in an Andriod App development cycle then also your options are limited because it does not integrate with PostgreSQL and MYSQL.
    Incentivized
    Read full review
    Likelihood to Renew
    Elastic
    We're pretty heavily invested in ElasticSearch at this point, and there aren't any obvious negatives that would make us reconsider this decision.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Usability
    Elastic
    To get started with Elasticsearch, you don't have to get very involved in configuring what really is an incredibly complex system under the hood. You simply install the package, run the service, and you're immediately able to begin using it. You don't need to learn any sort of query language to add data to Elasticsearch or perform some basic searching. If you're used to any sort of RESTful API, getting started with Elasticsearch is a breeze. If you've never interacted with a RESTful API directly, the journey may be a little more bumpy. Overall, though, it's incredibly simple to use for what it's doing under the covers.
    Incentivized
    Read full review
    Open Source
    I have given this rating cause its irreplaceable in some of the areas like no more installation need except from a single library. I find dialect is simple in use cases. its suitable for any professionals with various skill levels. its easily connect with various os and devices. very less maintenance or administration required.
    Incentivized
    Read full review
    Support Rating
    Elastic
    We've only used it as an opensource tooling. We did not purchase any additional support to roll out the elasticsearch software. When rolling out the application on our platform we've used the documentation which was available online. During our test phases we did not experience any bugs or issues so we did not rely on support at all.
    Incentivized
    Read full review
    Open Source
    I haven't needed support yet.
    Incentivized
    Read full review
    Implementation Rating
    Elastic
    Do not mix data and master roles. Dedicate at least 3 nodes just for Master
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    Elastic
    As far as we are concerned, Elasticsearch is the gold standard and we have barely evaluated any alternatives. You could consider it an alternative to a relational or NoSQL database, so in cases where those suffice, you don't need Elasticsearch. But if you want powerful text-based search capabilities across large data sets, Elasticsearch is the way to go.
    Incentivized
    Read full review
    Open Source
    We looked at other traditional RDBMS products, but found them to be cumbersome to deploy. They take up more space, and consume more computing resources than SQLite does. While the performance or direct integration to our primary applications may have been better or easier if we had gone with a traditional RDBMS, the performance of SQLite has been more than acceptable. The performance and speed to deploy made SQLite a much more attractive option for us than a traditional RDBMS.
    Incentivized
    Read full review
    Return on Investment
    Elastic
    • We have had great luck with implementing Elasticsearch for our search and analytics use cases.
    • While the operational burden is not minimal, operating a cluster of servers, using a custom query language, writing Elasticsearch-specific bulk insert code, the performance and the relative operational ease of Elasticsearch are unparalleled.
    • We've easily saved hundreds of thousands of dollars implementing Elasticsearch vs. RDBMS vs. other no-SQL solutions for our specific set of problems.
    Incentivized
    Read full review
    Open Source
    • No licensing fees has a net increase on ROI
    • The active community has kept support costs low, further increasing ROI
    • The wide range of supported platforms and high level of compatibility has increased ROI by reducing time spent porting the database model to any platform specific solutions.
    Incentivized
    Read full review
    ScreenShots