Reviewed on 22/03/2019
Perfect database tool for embedded software
Comments: I work a lot with SQLite as it is the primary medium of local storage in Android devices (and by extension, Android applications) which I work with on a daily basis, and SQLite is just perfect for the purpose it serves on these devices. It's lightweight so you don't have to worry most times about how much of the user's storage space your database is going to take up. There's not much difference between the standard SQL commands and those used in SQLite, and many have reported that SQLite is a good starting and training resource for SQL in general.
Doesn't need a separate server.
Lightweight and portable.
Integrates most of the commands, functions and syntax of other SQL software.
Optimized for use on devices that need to store data locally.
Large user base and community (support).
Cons: All operations are locked to a single process, so it's not suitable for large scale database operations (which is not what you should be doing locally on a device anyway).
Reviewed on 25/04/2019
No server required, used for standalone application and less configuration
Comments: We are using SQLite for java and android application. SQLite is use for small and mid level organization as well because its cost affordable for any one. There is no required to back up every time because SQLite make a file for backup .
Pros: SQLite is very faster then other database as performance wise. we are using SQLite for mobile application and desktop application. Mose imp feature i like in SQLite is at the time of deployment on production it not required any space. SQLite is lightweight. select query is very faster in standalone application.
Cons: There is no reporting functionality in SQLite. At the time of multiple insert query perform in queue that its goes slow for some time. There is administration in SQLite,so its very difficult to manage for multiple user.
Reviewed on 08/11/2018
Easy to become a problem
Comments: On a Windows Forms app we used to query services thousand times for data that does not change so frequently. We also had to store some business information (imagine as storing a wizard progress) and that used to be handled using TXT files (and it was a mess). We changed to SQLite and it worked almost like a charm but as the app grew and we decided to create an architecture similar to Google Chrome (multiple processes) it became a major problem for all of them to both read and write at it (we had to create a proxy app to write).
Pros: Integrates nicely with .NET (specially Windows Forms) applications, it's really easy to use (specially if you're already familiar with SQL Server) and deployment is really easy (copy/paste required files).
Cons: It's locking architecture enables only a single process to write at a time so building a more complex application may cause hard-to-solve problems.
Reviewed on 03/04/2019
SQLite - compatability at it's best level
Comments: SQLite has become more and more popular among the users because of its easy installation and easy accessing . As it is compatible with most of the programming languages and its light weight it is more popular among mobile application developers
Pros: SQLite is a light weighted data base which could be embedded with any software. Due to the light weightage of the product the data base is more popular In mobile application development. With it’s light weight it is also fast. SQLite is almost 35% faster than any other file system. SQLite is easy to use and there is not special installation or configurations needed to be done in order to use the product. All user have to do is download the libraries and run them in the computer. It is compatible which is why the product can be used with many programming languages with out any issues. Users are given a chance to extend their data base in future by adding new tables or new columns to the existing tables which is a great help for the ongoing projects.
Cons: SQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.
Reviewed on 19/06/2018
A good choice for storing small and local data
Nera joy C.
Pros: I love how SQLite is so portable, and can be used in different platforms. I doesn't need any bulky installation for me to use. It is so lightweight and there is no learning curve when you came from MS SQL.
Cons: Maybe when opening a large sqlite file around 1GB above, it hangs up and sometimes fails to load. But maybe that's my fault because SQLite is not intended for storing large data. Good product anyway.
Reviewed on 06/03/2019
The perfect landscape to train and test SQL
Comments: Integrates well with SQL learning tool. Followed many guides in my quest to learn SQL and almost all suggested SQLite. This is mostly for training and testing.
Pros: About as simple as it gets -- as the name suggests. Made learning SQL easy knowing I wouldn't be affecting my own database.
Cons: I truly enjoyed using the product although I never use it anymore. It sits dormant on my computer now that I have a grasp of SQL.
Reviewed on 18/01/2019
A lightweight relational database management system especially for offline mobile applications and d
Comments: We have used SQLite in developing many mobile apps, mostly Android App and as a database at back end we integrated this light weight DB system. The processing speed of queries is exceptionally fast. All the databases are working well.
Pros: SQLite is object based relational query language which keeps and maintained the whole databases in a very light weight, usually within 500kb to 1mb size, depending on size of databases. This database system has everything which a standard databases must have like relationships, events, all operations, etc. SQLite is very helpful in building application for Mobiles which stores databases in locally.
1. No dedicated server required.
2. Very light weight and easy to follow commands with knowledge.
3. Large community support makes learning this language even more fast and easy
4. Easy to keep backups as the whole database stored in single file.
5. Easy to implement and integrate.
Reviewed on 03/08/2019
best software to manage android database
Comments: My overall experience is quite good and outstanding. i love to use it.
Pros: i am using SQlite for my mobile android database management i am using it since 1 year. I created multiple project projecting SQlite as the most important role. it can handle any type of data. weather you store blob of you store text number data, it also helps in removing redundancies in the tables . it is the best solution and i like it the most
Cons: The feature i do not like is there is not lot of tutorials present into the market or on the youtube . i need to search for the best and need to get a teacher to learn it. it is bit complex for the beginners to mad there database with the android application.
Reviewed on 15/08/2019
Great choice if you use it correctly
Pros: SQLite is a fantastic database for resource-constraint systems or for those cases where full-blown SQL client-server system is not required. SQLite has been probably implemented for any platform. It even exists for microcontrollers. When used properly, SQLite makes programmers life easy.
Cons: There is nothing that I dislike about SQLite.
Reviewed on 28/02/2019
Great for simple persistent storage
Pros: SQLite is great because it is really easy to interface with a number of languages, my preference being C#. This allows me to create persistent storage for my applications or Unity games. SQLite is also great because it does not require an installation, either on the developers side nor the players side, it is a simple DLL which can be embedded into the application with ease. It also has great support with database management GUIs allowing me to debug the database very quickly.
Cons: Off the top of my head, there are no glaring issues with SQLite. However it is important to know when a system like this is needed as opposed to another simple storage option such as XML/JSON etc.
Reviewed on 12/06/2019
Exactly what the name says SQL lite
Comments: Whenever I need a database, SQLite is always a top option. Local storage is needed in most projects and the ability to use SQLite on almost any platform in almost any language means I always have the ability to execute the project with ease.
Pros: SQLite is a go to for when I need a quick lite weight database. It provides the ability to create local storage with the ability to integrate into most programming languages. It uses the familiar SQL structure and doesn't require any administration.
Cons: There are some areas where it deviates from using SQL language, but it is usually easily fixed by a quick Google search.
Reviewed on 08/07/2018
Database manager very functional, fast and easy to use for different programming languages
Comments: It is a public domain tool that when created with the C ++ language gives those who have experience in programming the facility to adapt it to their requirements, SQLite is independent of the platform. The operations are carried out very efficiently with a single library and a small memory
Pros: This Database Manager is really very functional, transactions are fast and its simple interface makes it easy to use, you can work with different programming languages such as PHP and phyton. It is much less complex than other handlers such as Postgres or MySQL
Cons: It is not recommended for systems that use a large amount of data, rather for medium-sized applications or for websites whose number of transactions is very high. It also does not support systems under the client-server platform
Reviewed on 17/04/2018
To store small data perfect solution
1. It is free
2. Easy to set up and connect
3. Multiple person can use simultaneously which we cann't do in CSV
1. Integration with some other tools is not so much easy
2. Loading time for existing tables is little high
3. No stored procedure can be written
Reviewed on 02/04/2019
A very efficient way to store certain kinds of data.
Comments: We use it for storing certain data.
Pros: You get all the benefits of using sql statements without having to set up a sql server online.
Cons: SQL syntax varies between the different versions of sql so the syntax you are familiar with may or may not be available in sqlite.
Reviewed on 20/04/2019
Open Source solution for local persistence
Pros: It’s lightweight, it complies most simple SQL language, it does not need a server process working and it’s free. These make SQLite a good option to store information locally in your application without running any extra application. For example, you can use it in a wide set of scenarios: mobile apps, embedded apps, or even desktop apps where you do not need intensive data change. It is Open Source and widely used, what makes it a plus for the community support.
Cons: It is not a good option for heavy load work. The lock mechanism that SQLite uses means that multiprocess applications will have to look for potential concurrency issues. Also it does not have the high end benefits of RDBMS, you can find problems working with big files or intensive use of data.
Reviewed on 30/07/2018
Was easy to install and to install on customer machine
Comments: Is free, but same time is good enough for programming very fast.
Pros: Easy to learn, no complicated database definitions. Can use only Varchar variable for everything.
Cons: Hard programming for multi-user. I have to create my own system to avoid database crash when more than one computer is assessing the database.
Reviewed on 18/07/2019
Used it for a small python project, and It was great
Pros: It's in the name, it's very light and easy to run, but what I like most is the interface, it's simple and doesn't need a learning curve.
Cons: Some features aren't available, like some sql commands and also when a lot of people are updating the db, this may cause a data crash.
Reviewed on 13/04/2018
You need a small database without problems? the answer is: SQLite
Pros: small, easy, no complicated stored procedure. You choose how to use and STOP. SQLite is ok if need a database for your application . No problem with a lot of datas: I've managed SQLite database with Millions of records.
Cons: Use only for storage information. No other features are available: No native stored procedure. So internal procedure are impossible.
Reviewed on 08/05/2019
Small, Fast And Efficient RDBMS
Pros: SQLite is a great RDBM solution if you need a database for embedded devices, IoT, websites or cache management. It is small, fast and efficient. It doesn't require any setup or administration. It provides easy to use APIs.
Cons: if what you need is a client-server database, it's not for you.
Reviewed on 25/07/2018
SQLite made pulling, manipulating and evaluating data from multi-relational databases a breeze!
John d. K.
Comments: Ease of accessing data for Ad-Hoc reports.
Pros: Linking SQLite to the internal database was quite simple; setting up authorized users was as well.
Cons: SQLite could be finicky on my company's database, I would sometimes switch over to Sandbox to run quicker queries.
Reviewed on 17/05/2018
A suitable light weight for small applications (and learning)
Pros: I use this for teaching SQL and databases to beginners. It is very easy to setup and navigate (command line and DB browser). It has reasonable power to deal with mid-range databases for developing and supporting small applications
Cons: If you are working with enterprise scale data (even small in enterprise realm), it will crash on you quite easily. You can not have multiple connections and it does not have many features of free MySQL
Reviewed on 19/04/2019
Depends on how you store your data
Pros: If you are storing variable data that resemble objects, use this instead of MySQL! There are also a lot of libraries built for accessing and manipulating SQLite databases now.
Cons: It takes up much more space and memory compared to conventional databases like MySQL
Reviewed on 18/04/2019
Lightweight and easy to use.
Comments: Perfect for small project and easy to setup.
Pros: It's really well design and easy to connect to database, and best of all it is free.
Cons: It's not really good for large databases it can be quite slow, but perfect for small projects.
Reviewed on 09/09/2018
Good choice for portable database
Pros: I like how SQLite offer T-SQL despite of being a portable database. I can create moderately complex queries and still runs fine.
Cons: There's nothing I really don't like with SQLite. It's free and does the job.
Reviewed on 26/04/2019
Database on the go!
Pros: SQLite is a great solution when your application needs a small footprint database with all the powers from relational SQL. It integrates with any language you need and is available in any platform!
Cons: Being a smaller library, it misses some features from bigger database systems.