SQLite

(124)
4.3 out of 5 stars

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

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 124 SQLite reviews
LinkedIn Connections
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.

Sign in to G2 Crowd to see what your connections have to say about SQLite
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.

What Relational Databases solution do you use?

Thanks for letting us know!
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 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 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 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 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 Patrick R.
Patrick R.
Validated Reviewer
Verified Current User
Review Source

"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.

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

"Good database for mobile app"

What do you like best?

I develop many mobile apps, and often work with SQLite.

It is convenience to work with SQLite to save my in-app data.

It is lightweight, fast, smooth.

It is powerful. I can easy filter data, search & sort.

What do you dislike?

No I like it, and very happy with SQLite for apps.

i don't use SQLite for website for desktop app because I think it is too small for those types of app.

Recommendations to others considering the product

SQLite is a mut-have in your mobile app to save data, loading data and finding -sorting data, including filter saved data in it.

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

Mobile app development.

Easy to save data, linking data, and finding, sorting data.

Everything I need to work with data can be easy do with SQLite

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

"SQLite from a beginner's perspective"

What do you like best?

SQLite is fairly intuitive to use. It has all the functionality that I require but without overwhelming me.

What do you dislike?

Not much - overall I am very happy with SQLite.

Recommendations to others considering the product

I am fairly new to databases, but this software meets all my needs currently. It interfaces well with Python, which is extremely helpful. As I learn to use the software more, I hope to leverage it better.

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

I am trying to manage large datasets better. I am also trying add machine learning to our team and this software is very useful. We are hoping to better understand patterns among our customers that predict future outcomes. Ideally, we will be able to anticipate and head off future problems. This software will/should help us manage these large datasets.

SQLite review by User in Nanotechnology
User in Nanotechnology
Validated Reviewer
Verified Current User
Review Source

"Easy to use powerful client side Database"

What do you like best?

Stores data in a optimum way. Its a relational database so it is much easier to manage large amount of data easily. Data insertion and retrieval is very quick with no time lag. Large amount of data is also retrieved very fast.

What do you dislike?

There is no proper data type for storing date. We had to workaround in which we store the dates as string. Indexes are not present in this database. It could have been much better if indexes would have been there.

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

We were trying to develop a client side application in which we were using this database to store data locally and then synchronize this data to the back office server. It worked really good and solved the purpose. Client was happy with the solution which we provided.

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

"Simple, Portable, Open Source, Deploy Anywhere"

What do you like best?

See title! One disk image, run on any system or smartphone, bindings for any language I've ever looked for (base is ANSI-C), stability

What do you dislike?

There really isn't anything about SQLite to dislike.

Recommendations to others considering the product

I'd recommend it even if you're put off by the "Lite" terminology...fully configured, it's a powerhouse, plain and simple.

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

Single file can be combined quite quickly and easily into current project. There's help available for any questions you run into - someone's already solved your problem, so there's no down time, isolated transactions saved our bacon after destructive Hurricane.

SQLite review by Ryan G.
Ryan G.
Validated Reviewer
Review Source

"SQL Lite is perfect for mobile devices, quick/easy DB jobs"

What do you like best?

SQL Lite essentially gives you the full functionality of standard SQL--with very little configuration. It's nice and compact, quick to install and will have you database exploring in no time.

What do you dislike?

It does lack some of the depth of standard SQL however rich it is for a small compact version. I've had some issues with load times as well occasionally.

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

For quick exploration of missing data or GIS information on mobile devices--this is the product. Find your IOS backup, start exploring.

SQLite review by Tanim I.
Tanim I.
Validated Reviewer
Verified Current User
Review Source

"SQLite can do easy database stuff easily"

What do you like best?

It just works, it's a simple file-based database. The python plugins to SQLite are very high quality.

What do you dislike?

I can think of nothing I dislike. Sometimes even sqlite is overkill. A JSON file would be sufficient for many of my use cases.

Recommendations to others considering the product

Great for simple use cases and applications.

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

Configuration data.

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

"Essential for software that you will use everyday"

What do you like best?

I like SQLite's availability and that it is serverless. This makes it extremely portable and lightweight (considering alternatives). This bridges a gap between the always connected tech landscape and the increases needs for efficient and portable devices.

What do you dislike?

Security is lacking by design which significantly increases the risk of implementing sqlite

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

By synchronizing files automatically based on network availability, I can be sure that I can work on the same information on multiples devices without having to transport the information myself (like emailing a document as an attachment)

SQLite review by Andreas O.
Andreas O.
Validated Reviewer
Verified Current User
Review Source

"SQLite lives up to its name"

What do you like best?

I love how simple and easy to use SQLite is. It doesn’t require administration and is very reliable. You don’t have to think or worry about it. Did I mention it’s free?

What do you dislike?

Nothing! The product serves its purpose very well.

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

Robust, reliable, and lightweight database for restaurant applications on embedded devices.

SQLite review by Administrator
Administrator
Validated Reviewer
Review Source

"Lite SQL"

What do you like best?

It is so easy to work with the SQLite. It is great for testing, personal or single user purpose as it is lightweight and can be used stand alone, with some IDE like DB Browser, Beaver DB, or through the Python as well... Light and powerful.

What do you dislike?

Well, there are not too many things to dislike in SQLite. Only if I compare it to the other (but bigger ) db systems like Oracle, SQL Server... But that is not properly comparable.

Recommendations to others considering the product

If you want something lighter than LibreOffice Base and MS Access, yet powerful and more like "big databases" or just for education or prototyping purpose, you don't need to look further. SQLite is the tool.

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

Private data storage and testing purpose - for prototyping...

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

"Just as strong as SQL"

What do you like best?

I like that this lets you get files direct. no database server required. This is a very great program made for smaller devices, like moblie phones and tablets. I like that its an embedded relational batabase management system, and that it uses sql syntax.

I know that most will disagree but i like to think that its like a third party open sourced software.

I love that this is avalible for many platforms. OSX, Windows and Linux.

If you need more versions, on their website, there is many precompiled versions like Binaries for .NET, Windows Runtime, Windows Phone 8 & Universal App Platform.

There is so much information and help that its so easy to jump into and get help when stuck.

What do you dislike?

I tend to have issues when i dont map all my request through my database.

Other than its a great program, i tend to have issues when i need to have my oracle db to connect to it so it can have more functionality, since sqlite its a little limited.

Recommendations to others considering the product

SQLite is just like SQL just made for tablets and mobile devices. Its suitable for storing small amounts of data locally and this mobile based application is where there is little to no need for web.

Easy to use.

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

Coding applications and migrating to other languages. Runs great but have to rewrite and debug some issues. not sure if its just on conversion or bad programming.

SQLite review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Fantastic Implementation of SQL"

What do you like best?

SQLite is a great implementation of SQL for multiple platforms. It's a great choice for both web applications and mobile (Android and iOS in particular). I'm a big proponent of open-source software, and SQLite doesn't disappoint in this department. It can be used freely both for personal and commercial uses.

What do you dislike?

Configuration of SQLite can be a little bit daunting and confusing to new users without any experience. Luckily, there's a lot of community support and documentation on the web to help with this concern.

Recommendations to others considering the product

If you are having trouble setting up a database using SQLite, I would recommend browsing the internet for documentation and help. I've found a lot of good resources on Stackover and other helpful web forums.

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

I'm using SQLite as a backend with a local database stored on an iOS application. The iOS SDK supports both SQLite and another Apple-specific technology called Core Data. Core Data's backing end happens to be an SQLite database.

While I can manipulate and configure the data objects using a front end GUI in Xcode, I have used the sqlite3 tool from the command line in the past.

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

"SQL db is good software"

What do you like best?

The SQLite is a good database for a small application. It is very easy to use and very light and fast.

What do you dislike?

SQLite cannot be used for a very big database to store a lot of information. It is better for internal applications.

Recommendations to others considering the product

SQLite is a great SQL db for small uses

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

I use SQLite for small internal application that we have to write, it is very easy to use and light to install into the application when deploying to clients.

SQLite review by Aung Thu Rha H.
Aung Thu Rha H.
Validated Reviewer
Review Source

"High Performance File Based DB"

What do you like best?

It's versatile and can use in various platforms and mobile/desktop applications. In-memory database option is one of my favourite feature that can create database on-the-fly.

What do you dislike?

I can't really think of major drawbacks of SQLite DB but one thing that lacks is the incapability to run as the main thread process.

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

It's open source database and this is one of the main benefit of using it. The website has full documentation for the developer to integrate with apps.

SQLite review by Robin S.
Robin S.
Validated Reviewer
Verified Current User
Review Source

"SQLite with Windows 8 Apps"

What do you like best?

I have used SQLite in two fairly complicated Windows 8 store apps without any major issues at all. I would use it again in a heartbeat. It is extremely useful for Windows 8 Apps because it is serverless, lightweight and operates within the 'sandboxed' environment as required by the Windows 8 store. Needless to say, SQLite is also free. :-)

What do you dislike?

I started out using SQLite Manager, which is a Firefox Add-in for SQLite. I found it really unpredictable and it would sometimes block the app from running correctly if I had the db open in SQLite Manager and the app solution debugging in Visual Studio at the same time.

SQLite Expert, a free, stand-alone tool that does not run as a browser plugin, seems to be a lot easier to work with and has more features. I would recommend it over SQLite Manager.

One thing that I have recently found was that if you plan to export data from SQLite to SQL Server, you need to be careful about the string lengths. For example, if you collect a string in a multi-line text box control in Win 8 XAML with a maxlength value set to match the corresponding field in your SQLite table, everything will work as expected. However, if you then export this string via some sort of service-based process and try to insert it to a varchar field in SQL Server with the same field length, you can run into overflow problems. This is because SQL Server counts the new line characters "\r\n" as four characters and XAML/SQLite count them as two. I am sure there must be other issues related to this difference, but this is the only one that has caused me problems thus far.

I can't think of anything I really strongly dislike about SQLite itself. I vaguely remember experiencing some stumbling blocks early on when trying to configure foreign keys, but it was probably because I wasn't familiar with the syntax.

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

Both of the Windows 8 Apps that I personally used SQLite for used Guids as primary keys and that worked very well. Both apps required a fair number of tables (25-35). In some cases, the tables needed to be relatively dynamic. Some were loaded on the fly with text files, etc. I can't remember any problems with SQLiite. Overall, it worked very well.

SQLite review by Sulabh B.
Sulabh B.
Validated Reviewer
Verified Current User
Review Source

"Perfect for mobile application"

What do you like best?

While developing a Xamarin based application, we used SQLite as our backend for local data. SQLite is very light and easy to integrate with Xamarin (and with any other language or framework). You can write the uber-popular SQL language to read/write data as opposed to a home-baked flat file based data storage.

What do you dislike?

Because it is a local database, remote access is not possible. But SQLite was not designed to be accessed remotely anyway. I also had to struggle to find a right database management tool.

Recommendations to others considering the product

Find a good management tool. 0xDBE or SQLiteStudio (both cross-platform) are my suggestions.

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

I was developing a mobile app to manage events in a festival in our local town. I initially planned for a REST based backend service to store data for the app. But for the initial release I used SQLite which decreased the development time significantly as I would not have to worry about backend at all. It also allowed the app to function even without internet connection. The app now uses a REST based backend that is used to synchronize the SQLite database. So SQLite is still the main data source for the app and it has worked out very well.

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

"Relatively easy to use even for first-timers"

What do you like best?

I like the options SQLite gives to allow for command line interface as well as the different platforms supported (ie., Windows, Mac and Linux). Also because of its “lite”ness I can analyze rather large datasets and files efficiently.

What do you dislike?

Like all programming, there is a learning curve requirement for using SQL, however it is not a huge drawback. I do wish there was more documentation to help with commands

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

As a bioinformatics Researcher, I’ve used SQLite for parsing of large files (CSV) corresponding to genomic datasets, which I then performed statistical analyses on R. In this sense, SQLite has made my life much easier.

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

"A great quick soluton, but not a long term solution"

What do you like best?

It is good for something quick and simple. Easy to deploy, easy to use and link to object.

What do you dislike?

Everything else.

It gets you up an running, and looks like an SQL database, but it is not really. ACID principles are missing.

Query optimisation is joke. Performance tends to scale with DB size (in the bad way).

For real production work you need something better. For a receipe app, it's probably okay.

Recommendations to others considering the product

Carefully check your scaling and persistence requirements and test them.

There are lots of people who rave about it, but there a number of big traps in the background.

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

We use for a large database or nutrition information. Previously we used it for photo tags and other meta data.

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

"Best database for mobile apps"

What do you like best?

One of the easy and cool database to setup for mobile data store, we were exploring couple of options and found SQLite is the best one which you can use for mobile database.

What do you dislike?

Scaling of database is not that great. Security also needs to improve

Recommendations to others considering the product

If you want good database for mobile, this is best you can get.

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

Small database footprint where needed, and it fits right there.

SQLite review by Administrator in Research
Administrator in Research
Validated Reviewer
Verified Current User
Review Source

"SQLite for quickly prototyping"

What do you like best?

It is very easy to setup databases using SQLite. Creating a new database is very quick and does not require lots of additional packages and software. As all data is stored in files, databases can easily be migrated or shared.

What do you dislike?

The performance of SQLite degrades significantly when storing a large amount of data. Therefore SQLite is mostly suitable or small project or prototypes.

Recommendations to others considering the product

SQLite is a great choice for a very light weight database that stores data in the file system.

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

SQLite is extremely helpful when prototyping or developing any applications that rely on a database in the backend. While the production servers are likely to run a full-featured DBMS, locally it is possible to stay very light-weight using SQLite.

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

"Sqlite a lighter alternative to MySQL and PostgreSQL"

What do you like best?

The Size of the Sqlite database is so small, and so easy to integrate. This makes it portable, and adequate for devices with relatively small memory size (phones).

What do you dislike?

Sqlite is obviously not made for a high-traffic application (parallel transactions executed in parallel).

Recommendations to others considering the product

Sqlite is particularly for a small application (especially if you're planning to deploy it on a device that's not too much powerful, i.e. phones, Raspberry Pi).

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

Small Flask webapps I've developed in the past, where the database used was Sqlite.

SQLite review by André M.
André M.
Validated Reviewer
Review Source

"Simple and useful"

What do you like best?

Definitely the ease of use. The library is already built in PHP, so you don`t need to setup a thing, everything is already done, just use it.

What do you dislike?

Being small and simple it is not so scalable, but I guess you wouldn't use it to store large DBs. Furthermore, don't expect it to have all the resources a powerful DBMS has, like stored procedures.

Recommendations to others considering the product

Since SQLite stores all data unencrypted and in plain-text in a regular file, be sure you are not storing this file in a public place, otherwise it can be access by people with malicious intents.

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

I have used SQLite for many projects from web sites to mobile apps and it always served me well.

SQLite review by Jodi R.
Jodi R.
Validated Reviewer
Verified Current User
Review Source

"Easy, simple, and free!"

What do you like best?

- Its free!

- Easy to install

- Easy to Maintain

- Fast!

- Has great querying capabilites

What do you dislike?

Doesn't quite have all the features of a full db but it isn't a full db so I rally can't complain too much.

Recommendations to others considering the product

If you need something that is face and not too cumbersome this is your product.

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

We use this for our internal website with a relatively small user base and have had no issues, also great for people with little db experience.

SQLite review by User
User
Validated Reviewer
Verified Current User
Review Source

"Great cross platform database"

What do you like best?

That the database the I use in my mobile app can be imported into my desktop app with no changes and it just works.

What do you dislike?

Lack of some more advanced features like store procedures limits ease of use. Lack of free full featured UI for design and development.

Recommendations to others considering the product

It’s great and free and available on almost every platform.

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

Free cross platform database

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

"Simple and useful for Mobile development"

What do you like best?

All the basic sql options are present, so it's very useful for small mobile projects.

What do you dislike?

Some commands are different, so I needed to check the documentation to change them.

Recommendations to others considering the product

Remember to check the documentation for diferent commands and be sure sqlite is enough for your project. It is very reliable.

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

I created a few apps with sqlite using titanium.

SQLite review by User
User
Validated Reviewer
Verified Current User
Review Source

"SQL Lite - Great Open tool "

What do you like best?

Open tool that I could used for development of my personal projects. Also could used it for analysing some of my the data. Database itself is embedded into end program

What do you dislike?

It's NOT a client server DB tool; nor is it meant as highly scalable tool like the conventional MS SQL or Oracle DB

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

Mainly internal small scale projects

SQLite review by Laura E.
Laura E.
Validated Reviewer
Review Source

"Review SQL lite"

What do you like best?

Lo mejor es que es un programa libre y portable, perfecto para cualquier programa pequeño.

What do you dislike?

Para hacer programas más grandes se queda algo justo a la hora de hacer las querys

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

Para proyectos pequeños nos ha servido este programa gracias a su gran rendimiento y fácil instalación

SQLite review by Nexus W.
Nexus W.
Validated Reviewer
Review Source

"Convenient portable functionality that works with a number of use cases"

What do you like best?

SqlLite is easy to use, portable and performant.

What do you dislike?

SQLite is not for every use case, and has limits. Although fast, it can not be used by more than one user at a time.

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

Great for mobile apps and as as simple file based backend for web apps.

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

"Automotive Industry - Toolds development - Java application with JDBC calls to SQLite"

What do you like best?

I wanted a database that is simple enough to configure and did not require whole lot of administration. This was used to store huge file information after parsing. Though it is a light weight database it had all the capability as any real time database. All the database calls were quick as the database is deployed with the application. It solved the purpose.

What do you dislike?

I have really nothing to dislike this product as this solved the purpose.

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

We wanted a lightweight database as the application performance was crucial as this application will be executed during the build process. This application was designed to parse the codes and display any inefficient access of memory. This mem application was called as part of Make process this cannot take whole lot of time executing while trying to build the core application. We had to keep the application lightweight in order to do so we needed database support to parse store and access as required. This SQLite database solved this problem and worked efficiently. This application is live from 2007 and it's still running efficiently.

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

"SQLite database with c# applications ans Asp.net websites"

What do you like best?

It is very lightweight database that is embedded with your application. Since all it is a single database file is very easy to package.

SQLite does not need to be installed before it is used.

Also, lots of help docs and big community.

What do you dislike?

There was a limited IDEs for it, although recently the SQLiteStudio is out and it's quite good.

Depends on your task, SQLite should be only used for for small databases.

Not great for multi-user applications.

Recommendations to others considering the product

Choosing the right tool depends on your task

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

Embedded applications that need to be portable.

Local applications, such as internal tools applications for single user.

Asp.Net websites to persist controls states per user.

Unit tests.

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

"SQLite used as database in my app developments"

What do you like best?

I use SQLite used as database in my app developments. Very easy to use. You can quickly learn to use this and create simple to complex queries.

What do you dislike?

Nothing really to dislike. If required it can be enriched in user experience. Although no complains!!

Recommendations to others considering the product

I use SQLite used as database in my app developments. Very easy to use. You can quickly learn to use this and create simple to complex queries.

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

I use this for a app development . It is very simple to use and can be effectively embedded.

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

"Simple and useful as embedded database"

What do you like best?

SQLite is a great database for web applications with low write concurrency. It is perfect as an embedded database since it does not require a commercial license.

It is is easy to install and back up, these advantages are derived from it storing the data as a single file.

What do you dislike?

Since it only stores data, not code, any data processing logic needs to be done on the code layer.

Regarding security, it is very easy to open the file and review its contents since there is no security layer attached to the file.

Recommendations to others considering the product

The database does not come with a GUI. I recommend you use Firefox's convenient SQLite Tool.

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

Before implementing SQLite, I evaluated other options, but found this to be the best choice for a commercial PHP application running on Apache/IIS and used by a small team reading and writing to the database.

SQLite review by D. Gregory P.
D. Gregory P.
Validated Reviewer
Review Source

"SQLite is a great tool for maintaining our Databases"

What do you like best?

Simple, and easy to use API and CLI

Once setup is complete, it is very easy to use

Can have mutiple databases worked on at one time

What do you dislike?

I found it very difficult to setup, I know the instructions stated to just copy sqlite3.exe to target and run it, but found there were other programs that interfreerd with it.

Recommendations to others considering the product

Great tool. Allow lots of time before implemtning, dont have a tight schedule

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

Using it for databases on our website. we have a smaller website that our employees use for communication and this was a great tool to replace the Fwrite we were using

SQLite review by Ethan O.
Ethan O.
Validated Reviewer
Review Source

"SQLite is a mini postgres, does everything in a feather-lite package."

What do you like best?

SQLite is very compact and light. As a rails developers SQLite is the default db for all environments because it is so compact you can ship a rails app and do everything you need to do with a db for any environment, although that isn't entirely recommended.

What do you dislike?

I'm not a fan of SQL databases in general. I much prefer NOsql dbs like mongo. The only other complaint I could imagine about sqlite is it isn't as fast as postgres, although for good reason. Postgres is a huge bulky application designed for production environments.

Recommendations to others considering the product

SQLite is great as a compact SQL DB, for production environments, if your going to use a sql db instead of nosql, (which is my real recommendation) Postgres is a little faster.

AND ITS FREE, hell ya!

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

Any kind of relational db issues can be solved with sqlite3.

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

"A great companion for web app prototypes"

What do you like best?

It's very very easy to setup and change with or without a gui tool.

What do you dislike?

It doesn't have the advanced options of other sql implementations.

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

Sqlite was used to accompany a web app prototype. It was very easy to setup, tear down and rebuild as the project evolved.

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

"best embedded database choice bar none"

What do you like best?

very light install and memory footprint - plus does not require a Microsoft Windows service running 24x7 in the background. SQLite also implement the SQL language syntax very well so that switching from another database is often quite easy. The database engine and SQL optimizer also seem to run very efficiently, handling even the most complex SQL use cases with ease.

What do you dislike?

as freeware, SQLite sometimes does not evolve as quickly as one might like - but given the cost it's hard to hold that against the product.

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

when writing software programs that require a repository or database, embedding a light weight database like SQLite handles the task with ease. given that it's free - it's easy to see why so many software packages that require a repository or database have standardized on SQLite.

SQLite review by User
User
Validated Reviewer
Review Source

"Godd"

What do you like best?

the best is the performance since the operations are more efficient and it is faster than MySQL and PostgreSQL and the portability is executed on many platforms and its databases can be easily carried out without any configuration or administration.

What do you dislike?

Lack of documentation in Spanish: although there is already a Spanish-speaking community of SQLite, it would be important to find much more. documentation, books, review, etc. as many other database engines count today.

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

Customer data management

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

"Simple SQL application"

What do you like best?

small footprint, easy to use. It provides most of what is needed for a simple SQL interface.

What do you dislike?

Doesn't implement enough SQL commands. so some SQL commands can't be used.

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

Portable application with embedded database for more robust functionality than a simple configuration file would provide

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

"Simple but enough to do a lot"

What do you like best?

Light weight and simple but beautiful piece of software

Simple to learn and use within 20 minutes

Have enough features to perform data analysis on small and medium data sets

Useful for quick testing, Hassle free setup and ready to use within minutes

What do you dislike?

Integrated GUI interface is lacking . SQL server management studio (SSMS) like interface would be great so that user can avoid writing the code and have the work done with few clicks. Advance analytic functions within SQLLite will be very helpful

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

I wanted to use a quick and simple to use database without having to install and administer the database. My purpose was to quickly load the data into database and use SQL to analyze the data within minutes in different operating systems. SQLLite is perfect for that.

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

"Easy to use for Mobile or Hybrid app development"

What do you like best?

It is very light weight database and easy to integrate with the angular based mobile apps.

What do you dislike?

There are some limitation compared with the traditional or full veraion databases.

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

Locally Stored all the mobile app and user information

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

"Simple, small and efficient"

What do you like best?

The simplicity of having a database of easy access and locomotion since all this is done through a single file.

What do you dislike?

Problems of performance, I use for big project e it's is slow for big projects.

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

A database local for the main project for tests and development.

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

"Greate simple db for portable apps"

What do you like best?

SQLITE is very portable! you can easily ship it along with your code without having to worry about configuring and maintaining servers.

What do you dislike?

Sometimes it might be unperformant but it is totally understandable

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

Android apps. GIS software using ogr2ogr and spatialite

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

"SQL Lite - Good Database for Mobile Apps or Lightweight Database Work"

What do you like best?

It is very easy to install and to deploy. Easy user interface

What do you dislike?

The database itself is stored as a file, which can be confusing

Recommendations to others considering the product

I would recommend SQLite, particularly for mobile application development. It is a very easy to install and to administer. The file system implementation can be confusing but works well with Android platforms

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

I have used this to store data on an Android phone for an app

I have also used it for teaching courses

SQLite review by Administrator
Administrator
Validated Reviewer
Review Source

"Perfect for smaller sites without need for comcurrency"

What do you like best?

Exactly what my title says. Very nice and simple DB. Great command line features as well to make it very easy to use.

What do you dislike?

It’s not concurrent, but it’s honestly not that big of an issue for most small to medium sized corps

Recommendations to others considering the product

Again, it is for smaller simple projects. Ditch Access and use this instead.

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

Simple, light, free, open source, and best of all: very easy to work with and maintain

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

"Powerful, simple, embedded database that packs a punch!"

What do you like best?

Powerful, simple, embedded database that packs a punch!

What do you dislike?

Its really hard to find something not to like!

Recommendations to others considering the product

If you are looking for a light database for embedded systems or to test local web based scripts while skipping the installation and configuration of bigger databases look no further!

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

SQLite is great for embedded devices, testing applications locally without having to install bigger database packages or spend time to properly configure said packaged (MySQL, postgres I'm looking at you!)

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

"Great software"

What do you like best?

Easy interface and good database for links

What do you dislike?

I do not have any dislikes for sql lite.

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

Stores required product information. Allowed building of parts database for copper parts that were carried in for service inventory.

SQLite review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Very useful for mobile development"

What do you like best?

Very powerful can create views and triggers

What do you dislike?

Nothing as such. More in terms of writting stored procedures and functions if possible

Recommendations to others considering the product

Very useful

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

We are developing mobile applications and storing data on devices using sqlite

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

"Used in conjunction with visual studio and works great. "

What do you like best?

It became part of the package when developing websites. Allowed for quick connectivity without needing to load up a separate server.

What do you dislike?

Set up for me repeatedly produced errors. Finding a solution took a fair amount of time.

Recommendations to others considering the product

Highly recommended for use with visual studio

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

I have used this when developing websites, it is a ideal solution when running on a single device. Doesn't require a server running in background draining resources.

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

"SQLite is pretty good"

What do you like best?

Easily accessible and same as like SQL server

What do you dislike?

The scheme pattern is bit hard to manage as compare to SQL

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

It’s a basic tool for capturing data on mobile devices

SQLite review by Administrator in Military
Administrator in Military
Validated Reviewer
Review Source

"Easy to learn with sql background"

What do you like best?

I like the NaviCat GUI. It is easy to learn and follow.

What do you dislike?

I do low level troubleshooting but I struggle with C. I would prefer they use a more widely used language like C++ in sql server.

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

The rdbms is easy to work in especially with NaviCat. The training for new employees is easy and it has been very reliable for us.

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

"Quick development database"

What do you like best?

1. No configuration requried

2. Can be kept in source control due to low size

3. ORMs can easily switch between SQLite and Postgres, so SQLite is mostly used in development and small to medium size applications.

What do you dislike?

1. Restricted database size.

2. No caching mechanism of it's own.

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

Used as temporary database. Ease of setup and low configuration helps quick setup of application.

SQLite review by User in Real Estate
User in Real Estate
Validated Reviewer
Verified Current User
Review Source

"Perfect for quick MVPs "

What do you like best?

The best part of sqlite is that I don't need to have databases created beforehand. Like tables , it can create a database automatically when you use it with Django/Rails.

What do you dislike?

No user management in the database and not the best option when you have to scale

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

Single page applications which require porting or building MVPs. It is very easy to setup. No headaches.

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

"sqlite is open source"

What do you like best?

SQLite has friendly licensing terms and is both lightweight and pervasively implemented.

What do you dislike?

Performance tuning indices is non-existent.

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

storing data from iot data sources and tons of origination points

SQLite review by Administrator
Administrator
Validated Reviewer
Review Source

"Best Database for small and light application"

What do you like best?

Light, easy, no complex rule to follow or understand. If you need a database only for store information, without no stored procedure or complex functions, SQLite is your database.

What do you dislike?

Sometimes, simple e lightful stored procedure could be useful and only small complexity may be good.

Recommendations to others considering the product

if you need simplicity, SQLite is your choose.

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

create a local database where an offiline application can work.

SQLite review by User in Wireless
User in Wireless
Validated Reviewer
Verified Current User
Review Source

"Excellent price for small business"

What do you like best?

Best price option in database choices for small business. Amazing third party support you can find on web.

What do you dislike?

It's hard to find a enterprise level support for SQLite.

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

We mainly use SQLite for application files because the database is almost platform-free.

SQLite review by Isaac Z.
Isaac Z.
Validated Reviewer
Review Source

"SQLite as Storage is Everywhere"

What do you like best?

1. very slightly

2. Ease to use. need not configure, use it directory.

3. Portable. SQLite is everywhere, Linux, Windows, Mobile...

What do you dislike?

Actually, my dislike is nothing.

It is not fair if said SQLite has some disadvantage that compared with other database. because SQLite is simply.

Recommendations to others considering the product

All programmer need learn it.

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

0. development.

1. Emacs index

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

"Good tiny database"

What do you like best?

You can use it as in memory database for your unit tests. You can add to your project very easily.

What do you dislike?

It doesn't support stored procedures. I understand that so tiny DB is not intended to use them, but it would be useful for tests

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

We use it for unit tests. Works very fast in memory mode.

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

"I had good experience whilst using the product "

What do you like best?

Easy to understand,

Ease of use once it learnt,

Is very fast,

Supports advanced features like taking snapshot of the database

What do you dislike?

They way the database is used by the user is different from the usual mysql ,oracle usage so can take up some time to start using it

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

Solving large amounts of data in organized manner.

Can store data locally and make a call to the cloud only when the new data is required

SQLite review by User in Medical Devices
User in Medical Devices
Validated Reviewer
Review Source

"The simplest and most robust standalone database you can use"

What do you like best?

It's simple, it's public domain, it's very well documented, it's very well tested, and it's a ton simpler than installing Postgres or MySql, or anything else.

What do you dislike?

It doesn't include encryption support by default, and you have to hunt around for another software package. Not all of them are good.

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

Client side simple database

SQLite review by User in Retail
User in Retail
Validated Reviewer
Review Source

"Lightweight and quick"

What do you like best?

I prefer lite so alternatives like mongodb and postgre.

What do you dislike?

I love using CLI but I'm not s huge fan of SQLite CLI.

Recommendations to others considering the product

The syntax can be difficult but is very usable once you have a little experience.

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

I'm building user dbs and it's query return speed is saving me time.

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

"Optimal DBMS "

What do you like best?

Easy to use, secure and fast. SQLite is the most popular database engine. ACID properties are critical for transactions.

What do you dislike?

Rigid structure, unlike MongoDB which is flexible and unstructured.

Recommendations to others considering the product

Document-based structure would be better than table-based format.

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

Organized data schema and RDBMS for data and operations.

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

"Does the work. Not for production systems"

What do you like best?

It is light, fast, and comes for free with django.

What do you dislike?

Well, it is not suitable for production systems. It should instead remain confined to development tasks only.

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

I am using it to test my local django app with integrated ORM. It is super fast to set up and get going.

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

"Good for a singleton application "

What do you like best?

SQLite is easy to use and powerful when embedded in applications

What do you dislike?

There are very limited options for scaling

Recommendations to others considering the product

Do not inadvertently use this where you may want to scale horizontally in the future.

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

We used it in a key management tool with a lot of encryption

SQLite review by Administrator in Media Production
Administrator in Media Production
Validated Reviewer
Review Source

"Simple but Powerful Database"

What do you like best?

SQLite is compact and all contained in a single file.

What do you dislike?

There is really little not to like about this simple database solution

Recommendations to others considering the product

This is a great database for simple to moderately complex software

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

I use SQLite for a variety of both desktop and mobile software solutions

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.