TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    InterSystems IRIS

    Score7 out of 10
    N/AInterSystems IRIS is a complete cloud-first data platform that includes a multi-model transactional data management engine, an application development platform, and interoperability engine, and an open analytics platform. It is is the next generation of InterSystems' data management software. It includes…N/A

    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
    InterSystems IRISSQLite
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    InterSystems IRISSQLite
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    InterSystems IRISSQLite
    Considered Both Products
    InterSystems
    No answer on this topic
    Open Source
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    45 Answers
    100%
    Would buy again
    11 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    40 Answers
    100%
    Delivers good value for the price
    11 Answers
    Happy with the feature set
    98%
    Happy with the feature set
    44 Answers
    100%
    Happy with the feature set
    11 Answers
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    32 Answers
    90%
    Lived up to sales and marketing promises
    9 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    41 Answers
    100%
    Implementation went as expected
    11 Answers
    Features
    InterSystems IRISSQLite
    Relational Databases
    Comparison of Relational Databases features of InterSystems IRIS and SQLite
    Feature
    InterSystems IRIS
    9.0
    1 Ratings
    11% above category average
    SQLite
    -
    Ratings
    ACID compliance10.01 Ratings00 Ratings
    Database monitoring10.01 Ratings00 Ratings
    Database locking8.01 Ratings00 Ratings
    Encryption10.01 Ratings00 Ratings
    Disaster recovery10.01 Ratings00 Ratings
    Flexible deployment7.01 Ratings00 Ratings
    Multiple datatypes8.01 Ratings00 Ratings
    Best Alternatives
    InterSystems IRISSQLite
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    MariaDB Platform
    Score9.1 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    PostgreSQL
    Score8.8 out of 10
    Enterprises
    SAP IQ
    Score5.4 out of 10
    MySQL
    Score8.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    InterSystems IRISSQLite
    Likelihood to Recommend
    7.0
    (45 ratings)
    8.0
    (14 ratings)
    Likelihood to Renew
    8.2
    (1 ratings)
    -
    (0 ratings)
    Usability
    9.0
    (4 ratings)
    8.0
    (2 ratings)
    Support Rating
    7.4
    (4 ratings)
    1.0
    (1 ratings)
    Implementation Rating
    8.2
    (1 ratings)
    -
    (0 ratings)
    Configurability
    -
    (0 ratings)
    10.0
    (1 ratings)
    Ease of integration
    -
    (0 ratings)
    10.0
    (1 ratings)
    User Testimonials
    InterSystems IRISSQLite
    Likelihood to Recommend
    InterSystems
    Intersystems IRIS is a really great tool for Interoperability. It has so many capabilities out of the box and then such a great developer community on top of that, that there are really no limits to what you can do in terms of data manipulation and translation. Personally I find it to be a great tool if you are looking for Interoperability software.
    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
    InterSystems
    • Connecting with mutliple vendor platforms and systems allowing us to consume and provide data as needed.
    • Allowed us to implement our own RESTful api engine to server data to our internal applications.
    • Setting up their recommendations for high availability allow us to perform server maintenance with minimal down time to our users.
    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
    InterSystems
    • Enhanced documentation, more comprehensive and user-friendly documentation, including detailed tutorials and examples
    • Improving compatibility and integrations with others programming languages
    • Introducing tools and techniques to optimize the performance of ObjectScript applications, such as profiling tools, performance monitoring utilities, and code optimization guidelines
    • A better compatibility with Python libraries
    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
    Usability
    InterSystems
    The interface is very intuitive, the documentation is very good so it is not complicated to operate.
    The security is complex, but you can create a special role to access and the user ONLY can operate with the part that it allows.
    Also, you can examine the data very quick with the SQL Browser integrated.
    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
    InterSystems
    The InterSystems WRC has always been helpful and responsive. The folks I have spoken with are always understanding of our needs and questions and regardless of if the question is simple or complex we are always met with the same professionalism and helpfulness every time. I have no hesitations contacting InterSystems for help!
    Read full review
    Open Source
    I haven't needed support yet.
    Incentivized
    Read full review
    Implementation Rating
    InterSystems
    Will done based on a proper planning, so this will makes execution more easier and better.
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    InterSystems
    We are using InterSystems IRIS [especially] for database operations as the query performance is really good for [a large] amount of customer data. You can easily integrate for any application like web, desktop, and many more. It also provides BI functionality which is also very easy to implement using InterSystems IRIS[.]
    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
    InterSystems
    • Very Fast and scalable software to deal with big data flow, safe and robust.
    • The studio IDE is quite old fashion and lacks a few facilities
    • amazing for complex data consumption, its milyi-model capability wich allows multiple different models for a single set of codes.
    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