Want to see who topped the 2019 Best Software Awards?

SQLite

4.3
(148 reviews)

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine

Work for SQLite?

Learning about SQLite?

We can help you find the solution that fits you best.

SQLite Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 152 SQLite reviews
LinkedIn Connections
SQLite review by Mahesh K.
Mahesh K.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Lite Database with awesome feature"

What do you like best?

The best feature of sqlite which I like most is its very light weight with all the feature of RDMS (relational database management system) . This database is very easy to integrate with any application. It can be used with from small to heavy applications because of its nice features. SQLite is structured query based tool which support all the queries of relational database. It has schema based database.It is very easy to maintain database system.

What do you dislike?

The things which i dislike in the sqlite is it have less support for any issue. It is not supported some function which we used in other RDMS systems like truncate that's why we have to use delete in the sqlite. In the addition it is not support database size more than 1 GB so we can't use for huge applications.

Recommendations to others considering the product

As sqlite has great feature of RDMS I will recommend this tool to my all of friends & colleague so that they also can get benefits of sqlite which i got.

What business problems are you solving with the product? What benefits have you realized?

In our organization we have multiple web & other desktop application and we have to maintain backend database so in this way sqlite help us the most. It resolved the many problems for backend database. It is more easy to maintain other than RDMS. Because of its great feature we switched to sqlite for our many applications. In addition it is very cost effective tool so that we can get this easily.

It have many benefits which help the our organization to perform in more effective way & faster our backend query system.

Sign in to G2 Crowd to see what your connections have to say about SQLite
SQLite review by Jay M.
Jay M.
Validated Reviewer
Verified Current User
Review Source

"SQlite is a great database tool for small applications"

What do you like best?

1. It is easy to setup and connect to a local database for development.

2. It is free.

3. Integrates well with other tools (python / django for dev, DBBrowser for viewing data.)

4. It is truly a stable cross-platform database.

5. SQLite is fast. I've never had issues with the speed of data retrieval while using SQlite. When I think of local storage when creating an iOS app, the first thing I turn to is SQLite.

What do you dislike?

1. I don't like its documentation as I find it confusing sometimes, but I found video tutorials out there to find it helpful.

2. Lack of built-in data encryption.

3. As SQLite is a single-user DBMS, therefore, if a multi-user system is required, then an alternative to SQlite is required.

Recommendations to others considering the product

SQLite should be considered if the installation/configuration of a heavier database system is a problem for your project. But so far it is working out pretty well.

What business problems are you solving with the product? What benefits have you realized?

This software is used to manage the database for my embedded projects. SQLite is being used for a lot of applications that need to save relational data for itself, for instance, a communications driver, a system services and several other projects.

What Relational Databases solution do you use?

Thanks for letting us know!
SQLite review by George G.
George G.
Validated Reviewer
Verified Current User
Review Source

"Compact, light and easy to deploy"

What do you like best?

SQLite is a full-featured SQL implementation which you can start using with zero configuration as no setup or administration is needed. It is a serverless compact database in a single cross-platform disk file with a really small code footprint. It is free and it comes with SpatiaLite - an open source library which expands it's capabilities to handling spatial data.

What do you dislike?

The The old school SQLite management systems and a number of lacking features: database level locking (SQLite only supports one writer at a time per database file), materialized views, intricate spatial indexes (GIST, GIN).

Recommendations to others considering the product

You should by all means use SQLite (and SpatiaLite) for device-local storage, for application file formating and as a website database to back small to medium-sized websites.

SQLite is fast and reliable and it requires no configuration or maintenance.

You should avoid SQLite (and SpatiaLite) if you are developing Client/Server Applications, if you plan to handle very large datasets and if you expect high user writing concurrency.

What business problems are you solving with the product? What benefits have you realized?

I use SQLite to hold user/program settings, preferences or other front end related data needed for programms I develop, to store spatial data on GIS in mobile devices (tablets & smartphones) and to transfer data from my other client/server databases, edit them offline and synchronize them with the live databases again.

SQLite review by Riddhi B.
Riddhi B.
Validated Reviewer
Review Source

"SQLite: Light and Efficient Cross Platform Storage"

What do you like best?

SQLite is an excellent standalone and platform independent relational database. It requires no time for setup and configure. This tool offers a rich set of queries for basic operations like insert, delete, select and update. SQLite supports mobile platform as well. iOS and Android natively supports it. SQLite is reliable and requires no extra space. For small scale application where concurrency is not needed, SQLite fits well.

What do you dislike?

The biggest disadvantage is unavailability of joins and store procedures. SQLite does not support direct way to encrypt particular table or column to be encrypted. One can encrypt the entire database with open source libraries but native security is not upto the standard.

Recommendations to others considering the product

SQLite is extremely suitable when you are solving basic data science issues. The data that you have received is either in form of excel or csv then to store them in SQLite is extremely easy. For mobile application development, SQLite is must for persistent storage. When concurrency and decimal precision is not of utmost requirement, SQLite is the best tool to start with.

What business problems are you solving with the product? What benefits have you realized?

We are developing android mobile application where we store data using SQLite database. apart from that when data volume is not too high and basic db schema and validation is the prime need, we use SQLite. Because it is usable across platform, we can easily transport the SQLite database from Android to iOS and vice versa.

SQLite review by Apurv D.
Apurv D.
Validated Reviewer
Review Source

"SQLite - Easy, Light Weight and Reliable way to Store Data"

What do you like best?

1. As Sqlite is serverless tool, It requires no effort for setup and configuration.

2. It is very simple and so easy to learn.

3. It is supported on mobile OS as well. For iOS and Android application local data storage, SQLite is the best option.

4. As it makes only one file, it is really easy to port from one platform to other. This specially helps to test your product across different mobile platforms.

5. It has excellent documentation and community support. Most of the time, you can solve the problem on the tip of finger.

6. Now a days, many tools with great GUI available which makes it even easier to work with.

What do you dislike?

1. It has not sufficient types to handle decimal numbers. Sometimes you may have precision loss.

2. It is designed for single user and small scale applications. So for enterprise grade application, it is not suitable.

3. Store procedures are not supported.

4. No built in support to encrypt data which causes security issues (however many open source wrappers available to encrypt data stored in SQLite file).

Recommendations to others considering the product

If the size of data is limited and is not suppose to be grow after certain level, SQLite is great. It is a De facto standard of storage for Mobile application. So, for iOS and Android applications, I highly recommend SQLite to persist data.

What business problems are you solving with the product? What benefits have you realized?

We use Sqlite mainly to develop mobile applications. When mobile applications need to store relational data into local device itself, SQLite is the best choice. iOS has its native wrapper called Core-Data which also provides simpler way to store data on SQLite database. In a way where server and enterprise features are not required (specially for research and basic data analysis is required) , we use SQLite.

SQLite review by Prince K.
Prince K.
Validated Reviewer
Review Source

"sqlite, a light and easy to use software"

What do you like best?

Sqlite is a very light software for database management. Due to its light feature it can be easily used on mobile devices. It is very easy to install. Sqlite functions can be called very easily through small functions which reduces latency or any kind of delay. It is a server less software so require less or zero configuration. It is best suitable for embedded devices where no human intervention is required. It is the best software for relational database management for mobile users.

What do you dislike?

As it is not multi user type so only one user can write at one time. It is not secure.

Recommendations to others considering the product

I would recommend users to use Sqlite in case of small devices to handle the relational database. It is very compact and easy to use.

What business problems are you solving with the product? What benefits have you realized?

I have this to handle the database in my embedded devices in my projects. It is best for this because it doesn't require any kind of administration. It is the light version of SQL so very effective in case of small devices. It is very fast in its work as there is negligible amount of latency. It is very compact and easy to use software.

SQLite review by Hardik H.
Hardik H.
Validated Reviewer
Review Source

"Easy to use and researched."

What do you like best?

There is a lot of research for making the language.It is easy to install. It is also available for different platforms, which is used for small-time developers that want to use professional database software like this for free. It is also very fast.You don't need to have deep knowledge to create a new database.

What do you dislike?

It is not typed based.You cant perform all query very easily like any other development.It loading UI element. It is also slow for many operation on time.

Recommendations to others considering the product

SQlite database is the good choice for redistributable applicatio and App prototyping.Great place to start for a beginner in database.

What business problems are you solving with the product? What benefits have you realized?

I use this to manage database for my android local projects. It is very simple and very easy to use.It is also used for In-App Structures Storage. It requires no setup. It is dependent on extra program or features. It is best for small sized websites.

SQLite review by Julio G.
Julio G.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"SQL for mobile phones"

What do you like best?

There are many things I like so much about Sqlite.

We work with mobile devices and Sqlite is the best database administrator for that pruposes.

We mostly deploy sales force automation solutions in mobile devices, so we need a light and free solution for our clients, because they have many devices and it not feasible buying licenses for all.

Sqlite covers all our needs considering: speed, scalability, easy-to-use, SQL language based.

It is very easy to install and to administrate.

You don't need to have big knowledge to create a new database from scratch.

It is portable, each database is only one file which you can copy and move easily.

There are lots of free administrator software to open, manage and query a SQlite database.

You can share this type of datebases between different OS devices, such us iOS or Android.

They can be set in quite different ways, for showing the same data in different structures.

Well, what more can I say, let's try it.

What do you dislike?

It is not a type based database, this make it very flexible but sometimes it offers problems witn number precission.

Sqlite offers a limited set of SQL language, which means you can not do some queries that you would do without any problem in other platforms. In that cases, you have to find workarounds to solve your issue.

Recommendations to others considering the product

It is a free, light solution. You should try it.

What business problems are you solving with the product? What benefits have you realized?

We mostly deploy sales force automation solutions.

SQLite review by marc c.
marc c.
Validated Reviewer
Review Source

"SQLite for Android"

What do you like best?

I love SQLite! It's so easy to use and there are tons of information online you can search if you get stuck since it's a pretty common database for mobile phone app development.

What do you dislike?

I actually cannot think of anything, but i guess i wish there's a GUI to view the data and dont have to code everything just to query something.

Recommendations to others considering the product

If you want to have a very lightweight, free database when doing mobile phone applications, this is my go to database. You wont go wrong on this one, you have so much information from the internet which can get you going whenever you get stuck.

What business problems are you solving with the product? What benefits have you realized?

It's a free way to store information in a mobile application. Specially if your'e just starting off and dont have much funds to go big, SQLite is a perfect database and it's so lightweight.

SQLite review by Chris S.
Chris S.
Validated Reviewer
Review Source

"Easy to use and easy on resources server side "

What do you like best?

It allows a lot of reads and writes simultaneously and when you have an entire office accessing your database at once, caching and parallel access is essential.

What do you dislike?

Loading UI elements on the screen takes a long time on older computers.

Recommendations to others considering the product

One thing to consider when using SQLite, is when you draw tables on a GUI, it will take a considerable amount of time for on screen elements to load unless you choose to have all items load in parallel. This requires a more robust workstation video card, but items will load more efficiently

What business problems are you solving with the product? What benefits have you realized?

Running SQLite has allowed the doctors office I set up to move from traditional filing to e-filing on computers. This saves a tremendous amount of time. The benefit of SQL compared to CSV tables is obvious. The only factor in efficiency is the server bottleneck. When you use CSV tables or other types of database access, many times only one person at a time can access the data. However SQL is scalable and multiple sessions are supported with incremental changes allowed.

SQLite review by Himanshu K.
Himanshu K.
Validated Reviewer
Review Source

"Database architecture"

What do you like best?

This software is used for database management. It is the light version of SQL. It is self- contained, serverless and require no setup. It is suitable for small embedded devices like cell phone, mp3 player, etc. It is based on command line interface.

What do you dislike?

Sometimes it poses a risk on security. It is gets slow when data being handled increases.

Recommendations to others considering the product

I would recommend this software to those who needs to handle small database for small embedded device or small websites. It is very simple, compact and easy to learn.

What business problems are you solving with the product? What benefits have you realized?

I use this software to manage database for my embedded projects. It is very simple and easy to use. It requires no setup and is full featured like SQL. It has no extra dependency. It is best for small sized websites.

SQLite review by Fedor P.
Fedor P.
Validated Reviewer
Review Source

"Very well-developed and researched."

What do you like best?

There is a lot of obvious research that was put into making the language, which makes it a very good choice to use in small scale projects that don't require the corporate/advanced features that regular SQL has to offer. This software is also available for many different platforms, which is great for small-time developers that want to use professional database software like this for free. It is also extremely fast, as I've never personally had issues with the speed of retrieving data regardless of the platform I am using.

What do you dislike?

A lot of people dislike the SQL language in general, and often specifically the difficulty to create one-to-many relationships in SQLite, or just the difficulty of the SQL language in general. There also isn't any default encryption, which is a huge flaw for any product that is going to be used publicly and commercially. SQLite is also a single-user system. So, if it is a requirement that your company using a collection of accounts to manage the database, this could become an issue very quickly.

Recommendations to others considering the product

SQLite is a great option for those that are looking for an entry-level database management system that doesn't require any commercial licensing. However, be aware that some issues might arise in the later stages of product development, especially if you are looking to release a product like this publicly.

What business problems are you solving with the product? What benefits have you realized?

IT is really nice to be able to use a platform like this free-of-charge. I suppose this solves the problem of having to finance database software or possibly receive licensing for commercial use of some type of database software.

SQLite review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"If you a Android developer then SQLite would be the route to take. "

What do you like best?

For starting on Android Platform, SQLite would be the best for any kind of storage whether it is images, urls, data entry etc. As the name suggests, it is a lite version of the actual SQL which we have learnt right from our engineering days. However it is pretty vast for any kind of storage you looking for in your application.

What do you dislike?

SQLite was the traditional method for storing data using relational database. Now that we have many different database formats like NOSQL, PostGress, even for Android we now make use of Realm database as it has similar operations like SQLite but much more robust and easier to implement.

Recommendations to others considering the product

If you starting fresh on Android then go the SQLite route...once you become pretty efficient, you can them move to further simplified databases like Realm

What business problems are you solving with the product? What benefits have you realized?

We had to build a banking application for use by one of the Fortune 500 companies who have billions of accounts under their hood and since we had to store huge lot of data, SQLite was the one which we happened to implement and we were easily able to scale that to millions of customers.

SQLite review by Daniela C.
Daniela C.
Validated Reviewer
Review Source

"The best tool for your mobile apps"

What do you like best?

SQLite is anything but difficult to introduce and utilize. There is likely no better database for tenderfoots to begin finding out about running and utilizing a database. This likewise settles on it a brilliant decision for persevering information in an improvement domain. The speedy setup and convenience shield it from being a blocker for setting up an advancement situation. SQLite has a phenomenal documentation.

What do you dislike?

It isn't appropriate to expansive scale applications. It is intended for lightweight frameworks, not for big business applications, or applications that need to scale essentially. It additionally does not have a few highlights of the bigger scale databases like MySQL including security, consents, and sort highlights.

Recommendations to others considering the product

Realize what you require from a diligent information source. On the off chance that you are searching for something lightweight and simple to utilize, this is an incredible choice.

What business problems are you solving with the product? What benefits have you realized?

I have utilized SQLite to endure information being developed conditions where I am not as worried about execution or highlight issues. It works awesome for this reason since you can get steup up rapidly, and get into the real advancement work.

SQLite review by Andrew F.
Andrew F.
Validated Reviewer
Review Source

"Becoming the de facto built-in RDBMS solution for in-app storage needs. "

What do you like best?

SQLLite is a robust, one file solution.

What do you dislike?

Based on its usecase nothing to dislike.

Recommendations to others considering the product

If you’re looking at using SQLite then you know why you want to use it. It’s robust enough to be relied upon for what it is. It does not support multiple connections but this is basically a infinitely better solution over using the Jet driver.

Good for mock testing, localized microservice storage and local app storage.

What business problems are you solving with the product? What benefits have you realized?

In-App Structures Storage.

Comes preinstalled on almost all modern Operating Systems. Windows 10 and OS X now ship with it. And it’s easy enough to embed if needed. The only down side is the likelihood and needing to compile it yourself is sometimes high. But it’s a single source file if SSL isn’t used. It’s easily embedable and makes for a robust Loca User/Session storage mechanism. Would not use for mission critical data storage.

SQLite review by Juan M.
Juan M.
Validated Reviewer
Review Source

"Quick and reliable database without a server"

What do you like best?

SQLite is a relational database system that allows you to have a database without the boilerplate of a complete database server. It has a lot of database features and well defining your database the performance can be good enough for your requirements.

What do you dislike?

If you are looking for a real relational database system with multiple access for different sources, better do not use SQLite. This affirmation is even stronger if you are using your database in a Windows filesystem.

Recommendations to others considering the product

Always define well your tables, create indexes and primary keys. It will speed the performance of the access to the database.

What business problems are you solving with the product? What benefits have you realized?

We are using SQLite for a lot of applications that need to save relational data for itself: a communications driver, a system services and many other projects.

SQLite review by Diana P.
Diana P.
Validated Reviewer
Review Source

"I like SQLite"

What do you like best?

I like SQLite because it is easy to install it and easy to use it. The updates are also easy to install without losing my old progress. It is compatible with my python. With the base information that I had about SQL, I could make many decent tasks with SQLite.

What do you dislike?

I don't have a profound learning of the database programming and is hard for me to tell you about bad things. At the moment I don’t have bad experiences with SQLite.

Recommendations to others considering the product

You don’t need a technical background in SQL language for this tool.

What business problems are you solving with the product? What benefits have you realized?

I utilized SQLite for some big projects in my company. I sorted out many separate information like tables and columns I made the relations to each other utilizing python and SQLite. The result was a great database. My company got a fluid database and it’s working without gaps.

SQLite review by Misagh N.
Misagh N.
Validated Reviewer
Review Source

"Easy to use and powerful"

What do you like best?

What I like about SQLite is the simplicity of installation process and usage. It integrates easily with my python. With the minimum knowledge that I had about SQL systems, I could easily complete two nice projects with SQLite.

What do you dislike?

I don't have a deep knowledge of the database software packages and therefore am not qualified to tell what could be better. But from what I experienced, I didn't have any specific difficulty with anything in SQLite software.

What business problems are you solving with the product? What benefits have you realized?

I used SQLite for two smaller projects in my PhD. I organized many separate data tables of that had relations to one another using python and SQLite. The outcome was super nice, because I could quickly filter through large sets of data and specify a certain relationship and make a subset fulfilling that requirement. Some of these tasks could take a day on my desktop, while using SQLite It could be as fast as minutes.

SQLite review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source

"Would like to learn more on SQLite as a part of my project work"

What do you like best?

SQLite is a DB engine and the most excited piece of this tool is like this tool is built on C language. This tool has a very good feature to work in mobile applications like us in Pega Platform. The coolest part of this tool is like it is an Open source to public and is free to everyone to use for any purpose.

What do you dislike?

I don't see any such dislikes for me in this tool. Probably I may have to work in deep on this tool to know more about the limitations of this tool. For now, I am a beginner on this tool and still I need more expertise on this to make a comment on it.

What business problems are you solving with the product? What benefits have you realized?

In our mobile application, Pega is using this SQLite DB calls to make a connection and fetch the data from the DB tables in our Javascript code. To meet our biz requirement without any performance issues in mobile, we need to follow Pega directions and moreover Pega is using this tool internally in their product. With this DB call settings from Pega, we are fetching and populating the data on UI quickly and biz is happy with this approach.

SQLite review by Alex M.
Alex M.
Validated Reviewer
Verified Current User
Review Source

"Great for Spatial data exploration"

What do you like best?

SQLite is as simple as a database gets - it's not a network accessible server like PostgreSQL or MS SQL, but a very fast, standards compliant* step above using a flat file directly. It's fantastic for geospatial processing using the Spatialite extensions, which makes exploring geo data as nice a using SQL can be. It is probably the world's most widely used database, you've probably got several applications installed which rely on it, no matter what operating system.

What do you dislike?

Concurrency can be an issue, but concurrent access isn't really the goal of SQLite, and despite that, if you enable the write ahead log, performance can be quite good. Their interpretation of the SQL standard means some unexpected features - types on columns aren't enforced, but this is because close examination of the SQL spec means this must be the case.

Recommendations to others considering the product

Spatialite could be considered a superclass of SQLite, and is the obvious choice if you need fast access to geospatial data on the desktop. There are several other options if you need a single machine/desktop database, including very fast key-value stores such as LMBD and Tokyo and Kyoto Cabinet. It is possible that your app already is taking advantage of SQLite through API's like Apple's Core Data API, or via the Web SQL Database, which is implemented in most modest browsers by using SQLite underneath.

What business problems are you solving with the product? What benefits have you realized?

Geospatial data processing, indexing of text based documents, faster access to data than a CSV would give me.

SQLite review by Tyler W.
Tyler W.
Validated Reviewer
Verified Current User
Review Source

"Great For Development and Mobile"

What do you like best?

SQLite is very easy to install and use. There is probably no better database for beginners to start learning about running and using a database. This also makes it an excellent choice for persistent data in a development environment. The quick setup and ease of use keep it from being a blocker for setting up a development environment.

It is lightweight—under 500kb for the full featured version and under 300kb for a stripped down version—and well suited to applications that need to run with limited resources, like mobile applications and embedded systems.

It is in the public domain, so it is freely available for any use.

SQLite has excellent documentation.

What do you dislike?

It is not well suited to large scale applications. It is designed for lightweight systems, not for enterprise applications, or applications that need to scale significantly. It also lacks some features of the larger scale databases like MySQL including security, permissions, and type features.

If you are using SQLite for its intended purpose—persistent data in lightweight systems—these downsides don't really come into play.

Recommendations to others considering the product

Know what you need from a persistent data source. If you are looking for something lightweight and easy to use, this is a great option. If you need something that will scale with a large application, you might want to consider something else.

What business problems are you solving with the product? What benefits have you realized?

Personally, I have used SQLite to persist data in development environments where I am not as concerned with performance or feature issues. It works great for this purpose because you can get steup up quickly, and get into the actual development work.

SQLite review by Nico C.
Nico C.
Validated Reviewer
Verified Current User
Review Source

"SQLite for Cordova mobile apps"

What do you like best?

It is very reliable, doesn't require a server and is wide supported across major platform.

If well setted can have very good performances.

What do you dislike?

It has few types. Although you can do everything with types provided, having bigger control over numbers (specifying the byte length) can lead to some performance boosts.

Plus I really missed the lack of a boolean/bit type which is often very useful.

Another annoying thing is that you can't save your PRAGMAs directly to database but you have to query them every time, so on every connection you have to specify that the DBMS has to check foreign keys constraint (which are disabled by default), the journaling engine, and so on.

Recommendations to others considering the product

Before writing your DDL check the documentation as SQLite slightly differs from SQL standars.

For instance if you have a table with a primary key, you may want to specify the "WITHOUT ROWID" clausole onto that table in order to gain more performances.

Furthermore take a look to PRAGMAs, they are connection based and not saved on disk, but they can be very useful in you application.

What business problems are you solving with the product? What benefits have you realized?

I was developing a Cordova based app. It provides a good WebSQL and IndexedDB abstraction layer via JavaScript, but support is too much fragmented as some enviroments supports WebSQL, some IndexedDB and some both.

As SQLite is a standard de facto for mobile app persistence, I moved to it, grating cross platform full support.

SQLite review by User
User
Validated Reviewer
Review Source

"SQLite as old MSSQL DBA"

What do you like best?

Easy to use, manage and keep updated, simple to attach on your Projects, simple VS integration and develompent is good recived.

Easy to package with your application, and fast compresion with you are packaging with a new App.

Large compatibility with so mane OS and platforms, like Android, or IOS, well in my case I used with C# and embeded my DB with the application was easy, the idea to be just a simple file make my work easy in some many ways, you don't need a full RDBMS or install a portable server to use it, just a DLL and that's all.

With a couple of payed tools you can sync data or even make a big data repository.

What do you dislike?

No relative ubication path, the files are needed to use full path, thats sometimes hard to determinate and use.

Reduced features like Unions and Joins by side for example, Right Join or even Triggers arn't well implemented.

Reduced Data types are a Disadvantage too, Text works well but sometimes you need somenting more complete

Numeric is usefull but you need more

Recommendations to others considering the product

Absolutly YES!!!!!!!!!!!! so easy to use, well as DBA for Oracle and MSSQL any SQL variation are easy to use, but combined to C# development are great to use

What business problems are you solving with the product? What benefits have you realized?

Use combined to create Electronic Invoices, quick and lightweight transaccion, low resourses consumptions, and easy to install on client PCs

SQLite review by Diogo R.
Diogo R.
Validated Reviewer
Review Source

"SQL for tiny projects"

What do you like best?

It's a serverless database system. You just need an API library to access the database, which is stored in a single file. Most common SQL operations are available. For small projects it works better than other file formats like JSON or INI. You can relate data and make SQL queries, with some little differences.

Because it's in a single file, this means that it should work in memory, giving it speed. You can also create databases in memory, without storing them on the filesystem. It's quite useful when you have matrices and complex operations that you prefer to do using SQL.

What do you dislike?

Although it's ideal for small projects, as soon as you grow you need to move to a proper RDBMS. Since SQLite uses a file, only one process should be accessing the database at any given time or you'll loose data. Also, having the database on a file means that your systems need access to the filesystem, which creates many security problems. Using another database system like MYSQL you can expose only the databases and tables you want by granting specific permissions.

Recommendations to others considering the product

Don't use it if you know your data is going to grow or be used my multiple services. Use it for bootstrapping and testing projects.

What business problems are you solving with the product? What benefits have you realized?

- Storing information in a structured form, with tables and relations between them;

- Being able to bootstrap and test small projects on a laptop without having a database server;

SQLite review by Stefania S.
Stefania S.
Validated Reviewer
Review Source

"Great database tool for applications"

What do you like best?

I made numerous portable applications, and I frequently workd with SQLite, and it is nice to work with SQLite to spare my in-application information. It is easy to use, quick and smooth.

With this tool I can simple find information, seek and sort.

What do you dislike?

For the moment I like all, no dislikes, and exceptionally content with SQLite for applications. I don't utilize SQLite for site for work area application since I think it is too little for those sorts of application.

Recommendations to others considering the product

SQLite is a must-have in your versatile application to spare data, stacking information and finding - arranging information, incorporating data spared with information in it.

What business problems are you solving with the product? What benefits have you realized?

Versatile applications.Simple to spare information, connecting information, and discovering, arranging information. All that I have to work with information can be simple do with SQLite

SQLite review by Scott K.
Scott K.
Validated Reviewer
Verified Current User
Review Source

"excellent uses for sqlite where you don't need full sql daemon, such as vpopmail with postfix"

What do you like best?

It's a very lightweight sql database program where the database is more or less a binary file where you're able to create/drop tables, insert/update/delete data, view full schemas to understand the table structure.

It's extremely easy to use and probably the best SQL application for a beginner to learn with - then moving up towards more complex databases will be a lot easier for them to grasp and work on.

What do you dislike?

When I had implemented it on my postfix installation for virtual mailboxes, doing changes to the sqlite database wouldn't pick up via postfix until postfix was reloaded. That was a little weird to see and can be a bit tedious unless you were to automate such a process.

For the applications that I'm using sqlite for primarily, they are all lightweight and/or used due to keep other databases such as MySQL open with more connections and be able to process more advanced queries. Just for the reason that SQLite does exactly what I'm wanting to use it for, dislikes are far and few.

Recommendations to others considering the product

There's other databases one could use that are also very fast, however in terms of resources and efficiency, sqlite is probably one of the easier and better solutions to implement wherever you may end up having a bit of a traffic surge that could overwhelm a traditional [not properly tuned] database to be problematic, whereas sqlite should just continue to function smoothly.

What business problems are you solving with the product? What benefits have you realized?

It's a great lightweight, small database that can be implemented for so many applications. Virtual user accounts are an extremely easy way to be managed via sqlite and it also helps even the beginner learn the SQL language a bit easier as it isn't very complicated. Then such users can graduate to better databases that are much faster.

The business problems we've solved with it would be virtual accounts for security purposes. One could alternatively jail things, however sqlite virtual accounts seem to be popular and easy to do.

SQLite review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Review Source

"Opensource small and easy to deploy databsae"

What do you like best?

It is super easy to get up and running. All you need is a library for whatever language you are using to get up and moving using it. Doesn't require specific server installations or user accounts. You just need to have a library that supports it in whatever programming language you are using. It's very simple and easy to deploy. I can rotate databases very simply just by moving a file, which is great depending on your problem set.

What do you dislike?

The biggest con is that you can't scale it or use it for anything complex. It stores everything in a single file, which can lead to slower write speeds, especially compared to more complex systems like MySQL, when you are using it for bigger things. That single file could get very large too, and be a problem if you are on a limited file system like say FAT32 (unlikely, but anything is possible).

Recommendations to others considering the product

If you need something that you can get up and running fast. Use between systems, and runs light, then it's the solution for you. Doesn't have much for security and the like, but for small applications it can work really well.

What business problems are you solving with the product? What benefits have you realized?

I'm using it for storing data gathered from the cryptocurrency market. It allows me to rotate the database super easy, and to have different data sets for testing against. Writing can be sluggish compared to storage in RAM or other database systems so you should only write when you need to.

SQLite review by Giuseppe D.
Giuseppe D.
Validated Reviewer
Review Source

"SQLite the small and fast database engine for web and mobile applications"

What do you like best?

SQLite is the fast ad small database, ideal for small or big application (web, mobile, server or desktop).

Don't require a server software and the DB file is portable to other platforms (Windows, UNIX, etc).

Most popular software use SQLite (eg. yum repositories, Firefox, Tenable, Android, etc.)

Cover most of SQL syntax and it's possible to create table, view, index, virtual table (eg. from a csv file or from a directory) and custom functions (via programming language).

SQLite is supported by PHP5, Perl, C, Tcl, C++, C#, Python, Rust, and more programming language.

What do you dislike?

SQLite not offer built-in security facility (eg. login, ACL and encryption)

Recommendations to others considering the product

SQlite is the best choice for application prototyping and for redistributable application

What business problems are you solving with the product? What benefits have you realized?

SQLite is ideal with environment with less space or memory

SQLite review by David A.
David A.
Validated Reviewer
Verified Current User
Review Source

"Best embedded database. I use it everyday!"

What do you like best?

It is embedded. It is fast. It is customizable. It is fully featured. I use it everyday, not only supports standard SQL but also: ridiculously fast, interoperable between systems (same binary format), supports plugins, supports advanced operations (Full-text search, custom functions, JSON, etc.) and support for multi-type columns (each value, a type not tied to the schema).

What do you dislike?

Nothing, really. If you use it correctly, you won't find any issue. Of course, if you want to use a client/server model you have to ship your own, but being embeddable is the big plus for me.

Recommendations to others considering the product

Please, review features thoroughly against current versions. Most websites (stackoverflow included) state information that is no longer valid or false, because these opinions/information was deprecated. It is important to check current version and do proper testing.

What business problems are you solving with the product? What benefits have you realized?

Lots! I use it for:

- Storing configuration parameters.

- Crunching data that does not fit in RAM.

- Store big amounts of data, in a queryable format.

- Mimic production environments for testing, without the use of a full database server.

- (and the list goes on and on...)

SQLite review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"Simple-to-use, flexible database for lightweight loads"

What do you like best?

Very simple to manage - no need to spend lots of time configuring a client-server connection, as everything is stored in files on the local file system. Moreover, SQLite is very faithful to the classic SQL language, allowing one to easily learn how to operate the database.

What do you dislike?

Because everything is stored on a file, it is difficult to maintain a distributed, scalable replica of the database. If the server hosting the database goes down, it is impossible to recover the data.

Recommendations to others considering the product

This product is useful in allowing quick iterations of a work in progress. It would be inadvisable to use this product in a fully-functional production system. However, for hobby projects, or small use cases, SQLite is much simpler to use than the typical relational database.

What business problems are you solving with the product? What benefits have you realized?

We have used SQLite for light workloads where fault-tolerance and scalability were not key goals. It was useful for rapid prototyping, allowing fast iterations before moving to a more stable database.

SQLite review by Ankit J.
Ankit J.
Validated Reviewer
Review Source

"Fast and Reliable"

What do you like best?

A very powerful, embedded relational database management system. Best thing about SQLite is that when an application uses SQLite, the integration works with functional and direct calls made to a file holding the data rather than communicating through an interface of sorts

What do you dislike?

Lack of possibility to tinker with for additional performance and No No user management for SQLite because of their use case.

Recommendations to others considering the product

Just make sure you use it just to learn SQL and not to deploy some application with this as it is light weighted with no user management.

What business problems are you solving with the product? What benefits have you realized?

I practice SQL queries on SQLite as it is light weighted and does not require you to do necessary stuff and makes your life easy while learning.

SQLite review by Sarneet C.
Sarneet C.
Validated Reviewer
Review Source

"Best native database solution for beginners"

What do you like best?

SQLite has the following features I like the most

- Ease of Use

- Open Source

- Native and Portable

- Good performance for small applications

- easy to learn and apply

- supported by almost all frameworks

- great documentation

What do you dislike?

There are some caveats to using SQLite

- Stores data on raw files. Not safe from security point of view

- For large applications, it fails due to high storage space and poor speed as compared to NoSQL

- SQLite databases don't support encryption

Recommendations to others considering the product

SQLite is best suited for small scale applications. It is supported by almost all frameworks and very easy to use. Great place to start for a beginner in database.

What business problems are you solving with the product? What benefits have you realized?

SQLite is really easy to use and good for storing data natively. I have used it for storing data in small scale apps.

SQLite review by Suraj D.
Suraj D.
Validated Reviewer
Review Source

"Database for small storage purposes"

What do you like best?

The best thing is light weight, Not too much big footprint. This can easily utilized in small memory projects. Like embedded system applications are good fit for it.

I like the best all SQL queries are valid in it. You will feel like working in SQL.

What do you dislike?

I had interface with C++ so i don't like the long connection strings. If hard to debug , keep track of the open and to close the all open connections,, otherwise can be different behavior.

What business problems are you solving with the product? What benefits have you realized?

I used inside the Vehicle Infotainment system. In the Infotainment system there is a concept of different user logged in. So keep track of every user in the system, so you can see all the valid apps and other Vehicle Infotainment related settings.

SQLite review by Victor M.
Victor M.
Validated Reviewer
Review Source

"SQlite for mobile dev"

What do you like best?

It is a good alternative to store data locally and then be able to perform some synchronization with another online database. It is very fast to integrate and very easy to use

What do you dislike?

Sometimes errors occur and the messages are not very descriptive. It is necessary to investigate to find the error and a lot of time is lost in it. For some operations it is not the best option since the reading is slow

Recommendations to others considering the product

If you are going to read large volumes of data it is better to look for another alternative such as Realm for example

What business problems are you solving with the product? What benefits have you realized?

We synchronize mobile devices to perform offline work in mining operations

SQLite review by Michael T.
Michael T.
Validated Reviewer
Verified Current User
Review Source

"Lightweight, fast and reliable"

What do you like best?

SQLite is an amazing solution if you're looking for speed, reliability, common and well known syntax, ease of setup for your application. It is one of the best file based relational data bases out there. It helps creating a portable application a breeze especially if you are working on a port of a desktop application. You most likely have to do zero to none code refactoring. Our team has made a mistake of trying out alternative file-based databases (non-relational) and it was a horrible experience, we've grown so accustom to the SQL syntax and way of storing data that I can not imagine using anything else.

What do you dislike?

I don't think I came around any bugs or issues with SQLite, I'm more than happy using it on web, desktop and mobile applications. Performance gains are always welcome though.

Recommendations to others considering the product

Most of the applications and devices you use on a daily basis are powered by SQLite in one way or another. I can not recommend it enough for your own projects, be it small or large. Even enterprise level applications can benefit from storing some sort of data away from the main database. If you are doing everything right and are good at doing query caching you will be greatly amazed by SQLite's performance.

What business problems are you solving with the product? What benefits have you realized?

Smaller web or portable applications are all running on SQLite, as well as our mobile apps. If you need local or offline storage look no further, especially if you are willing to go an extra mile with back-end optimizations such as query caching, etc. you will be amazed by how fast even the heaviest or worst written queries are.

SQLite review by Miguel Angel A.
Miguel Angel A.
Validated Reviewer
Review Source

"The simplest yet most useful database I have used."

What do you like best?

The fact that it doesn't need a server process and yet is still a complete full-featured ACID database is it's best feature. That it's also public domain and supported pretty much anywhere with a C compiler is just icing on the cake.

Other great things? It can be statically linked and it's databases can be bundled with applications like any other file, and it's also bundled with CPython so it's part of the Python standard library!

What do you dislike?

Nothing really. Sqlite meets all my requirements beautifully. I'm aware that SQLite doens't have any form of secutiry functionality on it's own but I don't use SQLite on high security environments so it hasn't been a concern to me.

Only thing I can think of that I actually dislike is the lack of official Java wrappers, though the SQLjet project covers that (SQLjet is an independently produced 100% interoperable Java implementation of SQLite).

Recommendations to others considering the product

Do not use it for full scale backend deployments, SQLite is not designed for that. As a data store for applications and games, or as a quick prototyping tool for backend development it's great.

Also Sqlite itself doens't have any form of access control or security features, so be mindful about that.

What business problems are you solving with the product? What benefits have you realized?

I use SQLite as data storage when developing application prototypes with Python's Web.py framework, the Android SDK or the C/C++ API directly depending on the requirements. I have also used SQLite as a data store proper when developing final applications for Android outside the prototyping phase.

In my research center we are using SQLite for an internal web application used to register students for the practice schedules of the subjects we teach.

SQLite review by Marc S.
Marc S.
Validated Reviewer
Review Source

"SQLite, when simple matters"

What do you like best?

The best thing about SQLite - and main reason i'm using it - is the lightweight footprint. It's also dead simple to setup, & even simpler to use. It's great for small projects that require the use of a datastore.

What do you dislike?

It's not exactly what i DISLIKE about the software, it's more about when NOT to use SQLite.

I think you want to avoid using it for large scale applications, or if you're looking for a full-featured relational database. SQLite is not your solution in cases like this.

Recommendations to others considering the product

Download/install the software, and play around on the command line to get used to the syntax.

Great for development environments, and even lightweight production apps (SQLite embedded).

What business problems are you solving with the product? What benefits have you realized?

I'm using SQLite in a phone application i'm working on (right now an iOS app, but no reason it wouldn't work just as well for an android application).

SQLite meets my requirement for an embedded, lightweight datastore.

SQLite review by Scott S.
Scott S.
Validated Reviewer
Review Source

"Excellent dev database environment "

What do you like best?

This database has everything you need to get a web application up and running without the hassle of setting up a full database environment, it’s all in one easy file

What do you dislike?

If your coming from a MySQL background you will quickly realize the simplified data types and if your deepening on your database to enforce those requirements you will be out of luck. SQLite doesn’t support dates, times, or timestamps

Recommendations to others considering the product

If you need the power of MySQL on a mobile device use SQLite, it is the best solution around!

What business problems are you solving with the product? What benefits have you realized?

SQLite is my go to solution for both local development and for mobile offline development. As long as you understand it’s limitations it is an excellent database

SQLite review by Arthur G.
Arthur G.
Validated Reviewer
Verified Current User
Review Source

"Super easy"

What do you like best?

Easy to install, configure, and administer on Linux, Mac, or Windows.

What do you dislike?

We don't dislike anything. Even the performance is good enough for many purposes. We can easily switch to MySQL, MariaDB, or PostgreSQL, and rarely do so.

Recommendations to others considering the product

Some cloud vendors make SQLite deployment difficult. Not SQLite's fault.

What business problems are you solving with the product? What benefits have you realized?

Rapid application development, with less DB related effort.

SQLite review by Jorge G.
Jorge G.
Validated Reviewer
Verified Current User
Review Source

"The best solution for mobile apps"

What do you like best?

SQLite is the easy way to develop mobile apps, you can use in Android, iOS and even Windows UWP, is lightweight, and bring almost all the need for local storage.

What do you dislike?

Some function could be better specially the rules for update data, but is enough for resolve almost any kind of apps

What business problems are you solving with the product? What benefits have you realized?

We develop mobile apps like smart community, an app for control the visit in building, neighborhood, work in android, iOS and Windows UWP.

SQLite review by User
User
Validated Reviewer
Review Source

"The perfect solution for reliable unit tests"

What do you like best?

SQLite is hands down, the simplest databse engine in the market. It is definitely not scalable but an essential tool in the software development process.

What do you dislike?

The lack of visual development tools may make it hard for newcomers but it is still simple enough compared to the alternatives.

Recommendations to others considering the product

There are for sure many use cases for SQLite, but make no mistake, as a tool for unit testing is where it shines. Give it a chance and replace all you database and sql query mocks for real database interaction in your unit tests and you will be able to measure the increase in your software quality.

What business problems are you solving with the product? What benefits have you realized?

We use SQLite exhaustively for unit testing the data layer of a very large codebase and it has proven to be the best choice. The overhead is minimum and the benefits are enormous compared to other techniques, such as mocking or using stubs. Not having to rely on an external DB component, gives us faster deploy times and streamline our continuous integration efforts.

SQLite review by Kielse N.
Kielse N.
Validated Reviewer
Verified Current User
Review Source

"Excellent for tiny databases"

What do you like best?

It is really easy to start using SQLite. You can follow several tutorials and probably you will find a tutorial explaining how to use it with the program language that your are creating your software/solution.

What do you dislike?

Is not that I dislike, but people sometimes should think if the best solution is to use SQLite. For example, in a client/server solution, maybe, will be better to use a client/server database.

Recommendations to others considering the product

If you need to save a small database in the client application is really good. Receive the data using network and just save and read using SQL commands. Is excellent for off-line applications as well. You will love it.

What business problems are you solving with the product? What benefits have you realized?

Receiving useful data to run clients on mobile apps. Creating local SQLite and sending some changes to server using our own protocol.

SQLite review by Consultant in Chemicals
Consultant in Chemicals
Validated Reviewer
Review Source

"Can't Beat Free But Tread Lightly"

What do you like best?

That it's free and small to implement. Great for mobile development and has a large user case and community.

What do you dislike?

That it can't support Stored Procedures and can be very difficult if you are going to have multiple processes accessing your data at once you are going to have a bad time.

Recommendations to others considering the product

If you are considering SQLite for mobile development then I would stop considering and pull the trigger. It's similar to SQL and the feature is pretty great for a free alternative.

What business problems are you solving with the product? What benefits have you realized?

The business problems I solved with SQLite are that I have a database I can use, for free when developing brand new mobile apps. It's very similar to SQL, which I use commercially, and supports enough features that it is a no brainer to use. There really any benefits other then I have a go to when starting a new mobile app that requires a database backend.

SQLite review by Internal Consultant in Retail
Internal Consultant in Retail
Validated Reviewer
Verified Current User
Review Source

"SQLite is really light and efficient"

What do you like best?

First of all it is freeware.one of the widely accepted software and used by big giant companies.

It has all the features of sql database but very much compact.

Moreover it is good when you are or the device is on low memory capacity. It still performs well but as you give it more memory it performs better.

ACID transaction is one of the key feature. It is capable of server less function and supports cross platform file format.

What do you dislike?

There are few bugs and issues that we face sometimes. We log in defects with the product support team and get it resolved.

I like SQLite for it's feature and easy to use programming methods.

Queries are pretty simple and easy to connect to the database connection.

Recommendations to others considering the product

It is a robust software which is freely available with lots of functionality and all big companies like facebook, google already use it. So there is no need for any further recommendation and the product is highly compatible and efficient.

What business problems are you solving with the product? What benefits have you realized?

My company used SQLite as their SQL database engine.

It takes very less amount of space. No platform constraints and easy to use software.

Freeware software hence does not have to pay a lot for the initial test.

Easy training materials are available. Helpful vendor support system.

SQLite review by Thejdeep G.
Thejdeep G.
Validated Reviewer
Verified Current User
Review Source

"Great for beginners"

What do you like best?

- Small

The DB engine can run on any smartphone or any PC for that matter. All this because of its size and memory consumption.

- Portable

It is easy to share databases between multiple OS's. All that needs to be done is to copy the file and share it with the target system and that is it.

- Open Source and in the public domain

SQLite is freely accessible and available for download. No one is the owner or co-owner of the product, the public holds all rights to the product.

What do you dislike?

- Scalability

SQLite is unable to support large databases and also is unable to handle requests from a large number of users. This means to say that a large number of transactions is unable to be handled by SQLite

- SQL support

Not all features of SQL are present or implemented in SQLite. Some of the required concepts such as Outer Joins and Inner Joins are yet to be implemented. Although, support for this is in the works, it might take a small amount of time before a fully functional SQL language support is added into SQLite.

- Does not support data types such as Timestamps and date amongst the others. This is a major setback for people beginning to learn SQL through SQLite.

Recommendations to others considering the product

It's one of the best DB's to consider when building mobile applications and also when programming for embedded systems since its very light in size. The only drawback is scalability. If you have a small application, you can consider SQLite without any other considerations. However, if you have a large database and/or a large number of users, you might want to stay away from SQLite because of its scalability issues.

What business problems are you solving with the product? What benefits have you realized?

SQLite does what it is meant for. Hence, using it as a primary database when building android applications or any other mobile applications seems to be the right choice because of its light-weightedness and ability to run on most of the PC's and smartphones. Since there is nothing to configure, it also runs right out of the box.

SQLite review by M. Serhat D.
M. Serhat D.
Validated Reviewer
Verified Current User
Review Source

"Native Database of Ruby on Rails Projects"

What do you like best?

SQLite supports almost all the SQL commands. It is a well documented database management system and also easy to use and easy to integrate with applications. I use SQLite in Ruby on Rails projects during the development because it is quite faster to test applications with SQLite than MySQL. Also SQLite is a native database management system for Ruby on Rails projects.

What do you dislike?

It stores data on raw files which is not the best practice for security reasons. Also SQLite databases don't support data encryption and stores all the data as plain-text. Because of these reasons most of the people prefer SQLite only in development rather than production.

Recommendations to others considering the product

If you are a developer who is looking for easy to use, fast and reliable database management system during your development process, SQLite is the best option so far. Most of the programming languages and web frameworks are supporting SQLite natively.

What business problems are you solving with the product? What benefits have you realized?

SQLite is quite handy when it comes to development. It is easy to setup and manage a SQLite databases. SQLite truly makes development process faster.

SQLite review by Alexander F.
Alexander F.
Validated Reviewer
Verified Current User
Review Source

"Used in Android app"

What do you like best?

+ comes pre-installed with Android

+ supports many SQL commands

+ it is a library/API - in the sense that you don't have to install/configure the database backend

+ SQLite is free of cost and the source code is free available

+ SQLite is well supported - there is a lot of documentation and experienced users out there

+ For desktop there are several utilities allowing browsing SQLite databases

What do you dislike?

- On Android: you can not browse SQLite content easily

- On Android: you can not preload database content (unless you use a hack like: SQLiteAssetHelper library) and are often forced to download the content from a website first

- SQLite is not a full-fledged database and for example does not support checks, triggers and stored procedures.

Recommendations to others considering the product

Check out the vast documentation available for SQLite.

You can ask sqlite-tagged questions at the Stackoverflow website

What business problems are you solving with the product? What benefits have you realized?

Developing a multiplayer word game with 700,000 words in the dictionary (stored in SQLite)

SQLite review by Ricardo M.
Ricardo M.
Validated Reviewer
Verified Current User
Review Source

"My preferred database management system"

What do you like best?

SQLite is one the best database management systems out there. It is lightweight and really, really easy to use and install. Just create a database and, voi lá, you're ready to use what you want to communicate with it. No need to use something phpMyAdmin or something like it. Absolutely the best option to be embedded inside applications or websites. Works with every SQL code there is, as far as I know.

What do you dislike?

There's nothing I really dislike about SQLite, but the lack of access privileges management may not be suitable for every situation.

Recommendations to others considering the product

Absolutely use SQLite as your main database management system, specially if it is an embedded solution (e.g., Android app).

What business problems are you solving with the product? What benefits have you realized?

I used SQLite in my univerysity projects, like desktop software and web platforms. It was really useful.

SQLite review by User in Higher Education
User in Higher Education
Validated Reviewer
Review Source

"Small, fast, and easy to use database"

What do you like best?

SQLite's most attractive feature is that the database is contained within a single file, so it's very easy to set up and test against, as well as migrating to other machines or platforms. It's also a surprisingly fast database, especially for queries. Finally, it has an excellent Python interface for integration into programs.

What do you dislike?

SQLite lacks many fancy features of bigger database engines, such as stored procedures. It also doesn't handle concurrent writes very well (although reads are OK), so it wouldn't be a good choice on a heavily used website, for example.

Recommendations to others considering the product

SQLite.org has a great page about the features and limitations of the product to see if it's right for you. However, it's quite easy to migrate data between SQLite and other engines (PostgreSQL or MySQL) so it's worth trying even if you're not sure about it.

What business problems are you solving with the product? What benefits have you realized?

Some problems are solved quite naturally using SQL, so we store data in a local SQLite database and perform queries against it. The data are generally static for long periods so we're more concerned about handling concurrent reads rather than concurrent writes. Moreover, the query speeds in our experience are as good as PostgreSQL or MySQL without the management overhead of a full RDMS.

SQLite review by P R.
P R.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Indispensable tool for mobile development"

What do you like best?

Lite - there's a reason it's called that. So tiny and lightweight a footprint that it always comes first when wanting a database solution for an offline database.

What do you dislike?

Very little - possibly Entity Framework's implementation is restrictive, but that's a Microsoft issue TBH.

What business problems are you solving with the product? What benefits have you realized?

Offline, mobile database storage that scales and scales.

Kate from G2 Crowd

Learning about SQLite?

I can help.
* We monitor all SQLite reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.