TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    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

    ThingWorx

    Score6.2 out of 10
    N/AThingWorx is an IoT and machine-to-machine (M2M) development platform acquired by PTC in 2014 and merged with Axeda Machine Cloud in the same year, to expand PTC's development offerings.N/A
    Pricing
    SQLiteThingWorx
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    SQLiteThingWorx
    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
    Features
    SQLiteThingWorx
    Internet of Things
    Comparison of Internet of Things features of SQLite and ThingWorx
    Feature
    SQLite
    -
    Ratings
    ThingWorx
    7.9
    7 Ratings
    1% below category average
    IoT Device Management00 Ratings8.57 Ratings
    Device Security00 Ratings7.97 Ratings
    IoT Data Management00 Ratings7.56 Ratings
    IoT Analytics00 Ratings7.37 Ratings
    IoT Integration00 Ratings8.17 Ratings
    Best Alternatives
    SQLiteThingWorx
    Small Businesses
    MariaDB Platform
    Score9.1 out of 10
    AWS IoT Core
    Score10 out of 10
    Medium-sized Companies
    PostgreSQL
    Score8.8 out of 10
    No answers on this topic
    Enterprises
    MySQL
    Score8.5 out of 10
    AWS IoT Core
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    SQLiteThingWorx
    Likelihood to Recommend
    8.0
    (14 ratings)
    8.7
    (10 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    10.0
    (1 ratings)
    Usability
    8.0
    (2 ratings)
    -
    (0 ratings)
    Support Rating
    1.0
    (1 ratings)
    10.0
    (1 ratings)
    Configurability
    10.0
    (1 ratings)
    -
    (0 ratings)
    Ease of integration
    10.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    SQLiteThingWorx
    Likelihood to Recommend
    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
    Velotic
    It is well suited for situations where you require an end-to-end platform for pushing code and managing data and security of the IoT application. However, it is not well suited for the case when you want to scale the app up to many users and this requires more from the part of the product.
    Incentivized
    Read full review
    Pros
    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
    Velotic
    • Asset Monitoring - quick and easy to deploy, can connect to the plant floor and get real-time data from devices.
    • Analytics - The TWX Analytics extension has a variety of analyses that can be done into any data source input into TWX.
    • Alerts notification - you can program alerts to be sent via email/SMS seamlessly.
    Incentivized
    Read full review
    Cons
    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
    Velotic
    • Advanced functionality in control and data visualization often requires additional coding from the user.
    • Support and tutorials provided are often lacking in detail or are not readily transferable.
    • Mashup development works poorly on small monitors or laptops.
    Read full review
    Likelihood to Renew
    Open Source
    No answers on this topic
    Velotic
    We started more than a year ago and do not plan to replace it
    Incentivized
    Read full review
    Usability
    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
    Velotic
    No answers on this topic
    Support Rating
    Open Source
    I haven't needed support yet.
    Incentivized
    Read full review
    Velotic
    Experienced and knowledgeable customer support executives, Thingworx is a very large product and contains a myriad of features which is not easy to remember without enough training or hands-on experience
    Incentivized
    Read full review
    Alternatives Considered
    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
    Velotic
    Well-suited - multiple streams from many data sources, highly scalable application scenarios.Good for a quick test of internet of things (IoT) connectivity and for deploying access via the web. Smooth deployment, easy to couple to devices. Easy cooperation with Splunk, which we use also.
    Incentivized
    Read full review
    Return on Investment
    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
    Velotic
    • Good for quick deployment of customer specific control of IoT
    • Good for quick test of IoT platform
    • Difficult to debug complicate system
    Incentivized
    Read full review
    ScreenShots