What users are saying about
39 Ratings
190 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100
39 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

Likelihood to Recommend

Azure SQL Database

Your upcoming app can be built faster on a fully managed SQL database and can be moved into Azure with a few to no application code changes. Flexible and responsive server less computing and Hyperscale storage can cope with your changing requirements and one of the main benefits is the reduction in costs, which is noticeable.
Niloofar Keshvari Nia | TrustRadius Reviewer

SQLite

I recommend the use of SQLite for embedded systems.If you need to store a large amount of data, store blobs, use triggers, handle multiple accesses at the same time, and need to optimize indexes, then I would recommend using another database system.SQLite should also be considered if the installation/configuration of a heavier database system is a problem.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Database-as-a-Service

Azure SQL Database
9.0
SQLite
Automatic software patching
Azure SQL Database
8.6
SQLite
Database scalability
Azure SQL Database
9.6
SQLite
Automated backups
Azure SQL Database
9.0
SQLite
Database security provisions
Azure SQL Database
9.0
SQLite
Monitoring and metrics
Azure SQL Database
8.9
SQLite
Automatic host deployment
Azure SQL Database
8.9
SQLite

Pros

Azure SQL Database

  • Maintenance is always an issue, so using a cloud solution saves a lot of trouble.
  • On premise solutions always suffer from fragmented implementations here and there, where several "dba's" keep track of security and maintenance. With a cloud database it's much easier to keep a central overview.
  • Security options in SQL database are next level... data masking, hiding sensitive data where always neglected on premise, whereas you'll get this automatically in the cloud.
Anonymous | TrustRadius Reviewer

SQLite

  • The biggest one has to be that it is freeware and open source as well. It means for an entry level person who wants to learn relational database and even for a team in the early development stage where security and size of the data are not much, it is a perfect fit in those cases.
  • It requires no extra configuration or space because it a server-less installation and also done in just a few mins. So, installing this is never a blocker. It is the actual lite version of SQL as the name suggests and it very powerful and capable of doing all the things which SQL can do, but lacks some of the security and advanced features.
  • It prepares the data for us in a structured form in terms of Tables with a file size less than 1 Mb for the complete database entries. It saves us a lot of physical space.
  • It is the most suitable DB for Android systems because mobile apps do not have a lot of space or resources for a separate DB, but this one integrates with the whole ecosystem very nicely and we are able to make the most out of it and that too with a file lesser than 1 Mb in size.
Anonymous | TrustRadius Reviewer

Cons

Azure SQL Database

  • One needs to be aware that some T-SQL features are simply not available.
  • The programmatic access to server, trace flags, hardware from within Azure SQL Database is taken away (for a good reason).
  • No SQL Agent so your jobs need to be orchestrated differently.
  • The maximum concurrent logins maybe an unexpected problem.
  • Sudden disconnects.
  • The developers and admin must study the capacity and tier usage limits https://docs.microsoft.com/en-us/azure/azure-subscription-service-limits otherwise some errors or even transaction aborts never seen before can occur.
  • Only one Latin Collation choice.
  • There is no way to debug T-SQL ( a big drawback in my point of view).
Arthur Zubarev | TrustRadius Reviewer

SQLite

  • Better data recovery when the database becomes corrupt would be ideal. I've learned to minimize it by closing the database more frequently, but it can still happen.
  • Lack of built-in data encryption.
  • SQLite is a single-user DBMS. If a multi-user system is required, then an alternative is required.
Aaron Bratcher | TrustRadius Reviewer

Likelihood to Renew

Azure SQL Database

Azure SQL Database 8.0
Based on 1 answer
This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.
Zimran Azim | TrustRadius Reviewer

SQLite

No score
No answers yet
No answers on this topic

Usability

Azure SQL Database

No score
No answers yet
No answers on this topic

SQLite

SQLite 9.0
Based on 1 answer
I have had a wonderful experience with SQLite because in my every project I use SQLite in the development phase because it's really fast, doesn't crash and very easy to maintain as well. It saves a lot on physical memory and dedicated server usage. It has all the basic functionality you would need to get the job done and that too at no cost at all. What more could you ask for !!!
Anonymous | TrustRadius Reviewer

Support Rating

Azure SQL Database

Azure SQL Database 9.0
Based on 6 answers
We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.
Anonymous | TrustRadius Reviewer

SQLite

SQLite 1.0
Based on 2 answers
I haven't needed support yet.
Rogério Rodrigues | TrustRadius Reviewer

Alternatives Considered

Azure SQL Database

We moved away from Oracle and NoSQL because we had been so reliant on them for the last 25 years, the pricing was too much and we were looking for a way to cut the cord. Snowflake is just too up in the air, feels like it is soon to be just another line item to add to your Azure subscription. Azure was just priced right, easy to migrate to and plenty of resources to hire to support/maintain it. Very easy to learn, too.
Anonymous | TrustRadius Reviewer

SQLite

SQLite has many types of queries to do CRUD operations. and even do manipulation to external files as well. it is fast and easy to implement compared to other Databases. SQLite support atomic behaviours, so app crash in any situation, the won't impact database or data within it. SQLite is best suited for desktop or mobile apps.
Mantosh Kumar | TrustRadius Reviewer

Return on Investment

Azure SQL Database

  • Perfect for small and medium databases, being very cost effective.
  • As a Platform as a Service, there is no concern about patches, upgrades and end of life.
  • Be aware of security and network capabilities. The service cannot run in the VNET as Azure Virtual Machines do.
Anonymous | TrustRadius Reviewer

SQLite

  • SQLite comes with phenomenal documentation and support online. Also, it has a very active online community and most likely you will find the solution to any problem there.
  • SQLite is a serverless relational database management system. So we do not need to have any pre-configurations to support it and also it does not require any physical space or memory because the complete DB file size is under 1 MB only.
  • There is no learning curve because the syntax is the same as that of SQL and installation is very fast and straightforward. So we can get to work as soon as the tool gets installed.
  • The best of all is that it is Freeware and an Open source too.
Anonymous | TrustRadius Reviewer

Pricing Details

Azure SQL Database

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Azure SQL Database Editions & Modules

Edition
2 vCORE$0.50441
6 vCORE$1.51311
10 vCORE$2.521
  1. Per Hour
Additional Pricing Details

SQLite

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

SQLite Editions & Modules

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Azure SQL Database
8.5
SQLite
9.0

Likelihood to Renew

Azure SQL Database
8.0
SQLite

Usability

Azure SQL Database
SQLite
9.0

Support Rating

Azure SQL Database
9.0
SQLite
1.0

Add comparison