SQLite Reviews & Product Details


What is SQLite?

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

Write a Review

SQLite Profile Details

SQLite Profile Details

Vendor
SQLite
Company Website
Year Founded
2000
HQ Location
N/A
Employees on LinkedIn®
1
Twitter
@planetsqlite
Twitter Followers
351
Show moreShow fewer

Companies Using SQLite

Cisco
Microsoft
IBM
Salesforce
General Electric
VMware
Intuit
Accenture
Hewlett-Packard
Target
Citrix Systems
Bank of America

SQLite Reviews

Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Review Type
Write a Review
1-50 of 194 total SQLite reviews

SQLite Reviews

Write a Review
Filter By
Review Type

Connections
Show reviews that mention
1-50 of 194 total SQLite reviews
Copy Review URL
Data Scientist
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"SQLite is really light!"

What do you like best?

I like to use SQLite for being able to use a relational database management system without requiring too much resources. The first time I got in contact with SQLlite was when I was developing an Android mobile application and wanted to know if it was possible to include a database there. I found out that you can use a SQLite database on an Android mobile app. It's pretty simple to use if you already know SQL, it's a very light database for the App (which is something desired for an app), and the setup is simple.

What do you dislike?

I don't like that the purpose is too narrow for this application to work only with small databases. However, this is understood and balanced, as being "lite" specifies the purpose of SQLlite.

Recommendations to others considering the product:

SQLite is a gread and solid choice for Android mobile developers if they want to use a "lite" SQL database with their application.

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

Being able to access the power of SQL with a lite approach is great for mobile apps, apps which require low use of space, or low memory.

Copy Review URL
Software Engineer
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Lite Database with awesome feature"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

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

Copy Review URL
GIS/Web GIS Developer & Database Administrator
Information Technology and Services
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
Informaticien études et développement
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL

"Lightweight and powerfull embed database"

What do you like best?

- Easy to setup and configure

- Really fast to setup and to maintain

- Very lightweight and usable for embedded applications

- Open source and free to use

- Very efficient and suitable for speed programming

- Universal relationnal database language (SQL)

What do you dislike?

- The database is store on file system which increase hacking risk

- Need more optimisation to work with application which use multithreaded tasks.

- Not suitabe for big data and datawarehousing (Business intelligence module)

Recommendations to others considering the product:

- Best for data storage within mobile applications

- Really easy to use and no need to be an expert

- Really fast for mobile application data transactions

- I really recommend SQLite for anyone who want to build mobile application as fast as possible.

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

- Data storage for embedded application such as Android apps or IoS apps.

- Local data storage for mobile application (offline data manipulation after remote data synchronization)

- Remote data synchronisation of web apps and mobile apps

Copy Review URL
ICT Specialist
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"sqlite is the best software storage why?"

What do you like best?

sqlite has helped me to store large quantity of data regardless the format they written in .

it also helped me to access my information at any place at an every-time regardless where the person is located.

it gives me a easy way to automatic update of my data at every place .

What do you dislike?

it is costly in terms of price hence in terms of use is good however if the vendor reduces the price everyone can be able to acquire one and benefit from it.i can also say its popularity is low in terms of advertisement hence if the software is being advertised regularly to the internet most people must be aware of it.

Recommendations to others considering the product:

i would recommend people to purchase the sqlite to access the information at one place due to its emendation and other integrated software hence its fast and reliable .

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

due to it small in nature i have managed to utilize other space in the devices for keeping other records.

as it is embedded with other software it made me to access full features of the software under one gadget

it fast in terms of use hence it has made my job increase the productivity.

Copy Review URL
abogado
Validated Reviewer
Review Source
Copy Review URL

"Very bad performance"

What do you like best?

is lite and do not consume much rosources of the device.

What do you dislike?

1.- Is only compatible with android devices

2.- It does not have consistency with other type of data elements

3.- It does not display tables as a database manager , is more like a excel

4.- It does not have a query executor

5.- Only works on windows

6.- Is almost not infomation at all for this

Recommendations to others considering the product:

if you must use the tool , beware that is going to be a big problem to read and write data outside the android aplication. For the people of SQLite , try to focus on the user , no matter is a It people tool , but does not have to be this problematic , you should reconsiderer the UI , the query language and finally the integration with diferents Operating Systems

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

i'm developing an android aplication and was runing on a emulator but i want to see de data that was store in the device emulator but it was pretty dificult to read and obtain the data . I used because of hos low consuming requeistes and for trying a new tool

Copy Review URL
Gerente de Consultoria ABAP
Program Development
Small-Business
(Myself Only)
Validated Reviewer
Review Source
Copy Review URL

"I try to use it but is almost imposible"

What do you like best?

More than a like is the need to use it , was a database from another software i was trying and has a type of file than only aceppt this IDE , to install is pretty simple and super lite , has a free version and that would be the best of this. Does not consume much disk space so can be install in almost any server o machine.

What do you dislike?

This is the first time a dislike a lot a software , sorry for the users of this but my opinion is base on my expirence because as i said , the database file a try to open was only manage by this, but i was terrible to work , to see just a table has to go over 3 screens and does not show al the data , make a query was really weird to do , was almos like working with excel . Is not compatible with more complex data types

Recommendations to others considering the product:

If you have to use it like me , use it just as last resort , was a pretty bad expirence , i think the developer team should get more practical with this software

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

Just to open a mobile aplication database , no more no less, the benefits are that is really lite , and fast instalation , and was the provider choise to use this tool instead of other more efficient but is not the best for the job.

Copy Review URL
Full Stack Web Developer
Information Services
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"SQLite is a great relational database management system for electronic devices like cell phones, etc"

What do you like best?

SQLite creates complex databases in the form of a single file with a size of hardly 500-700kb even though the database is too large. As compare to SQL server or any other RD system SQLite is lightweight and easy to implement and connect, as per my consideration.

SQLite file manages all data in the form of object data-type. All the tables, relationships, events, data, and everything is stored and managed in one single file.

As per my recommendation, SQLite is best option for portable devices for storing and accessing offline database. Devices like cell phones, video recorders, wifi routers, etc those need some database.

What do you dislike?

I have no dislikes as of now for this product

Recommendations to others considering the product:

SQLite gets integrated to any development environment with ease if having proper knowledge. From a large community support online it is very easy to learn. Use this light weight database system for offline devices and applications.

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

It helps in database solutions for many applications especially for mobile applications. We have developed many Android apps which uses SQLite as a database system. The great ability of relationships between entities is also helping in managing the database dynamically, a very important part of any Relational database out there, so SQLite has everything in a small bundle.

Secondly, we won't require any online server or dedicated server to keep and manage databases, yes in case of backups are use cloud storage but that is totally optional.

Copy Review URL
Database Administrator
Mid-Market
(501-1000 employees)
Validated Reviewer
Review Source
Copy Review URL

"Lightweight, Low Cost, and Easy to Use"

What do you like best?

One of my favorite things about SQLite is the community behind it. The fantastic SQLite team provides incredibly solid docs and examples. The SQL syntax support is excellent and more importantly, well documented.

What do you dislike?

Honestly, there's not much to dislike about SQLite. Older versions had some quirks that required strange workarounds (like not being able to alter a table, so you had to clone it, drop it, and create a new one - it was weird). But in recent years, things are in great shape.

Recommendations to others considering the product:

SQLite is an excellent choice for a fast and stable database, especially in a local, single-user environment. There are projects out there to enable network use as well, but it really shines as a local database.

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

We have an ancient AS/400 that we still use for just a few functions (it's being phased out, but that takes time). Some people in our business office and human resources department need to run reports on that data, but those reports require dozens and dozens of queries, which can get very bogged down with a web front end to the AS/400. So we pull that data into a local SQLite database on each user's computer and run the reports locally - it's blazingly fast. Plus, I can build a custom desktop UI that's very easy for each person to use.

Copy Review URL
Jr. Mobile Application Developer
Mid-Market
(201-500 employees)
Validated Reviewer
Review Source
Copy Review URL

"SQLite: Light and Efficient Cross Platform Storage"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
Engineering Manager
Information Technology and Services
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

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

What do you like best?

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

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

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

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

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

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

What do you dislike?

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

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

3. Store procedures are not supported.

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
Mid-Market
(201-500 employees)
Validated Reviewer
Review Source
Copy Review URL

"sqlite, a light and easy to use software"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
Android Developer
Computer Software
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"Easy to use and researched."

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"SQL for mobile phones"

What do you like best?

There are many things I like so much about Sqlite.

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

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

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

It is very easy to install and to administrate.

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

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

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

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

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

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

What do you dislike?

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

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

Recommendations to others considering the product:

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

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

We mostly deploy sales force automation solutions.

Copy Review URL
Senior Deployment Engineer | Full Stack Engineer
Telecommunications
Mid-Market
(201-500 employees)
Validated Reviewer
Review Source
Copy Review URL

"SQLite for Android"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
Assistant Information Systems Specialist
Civil Engineering
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
U
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"SQLite is a Lightweight Databse"

What do you like best?

SQLite is easy to use if you are already familiar with SQL. It's deployment is fairly easy. Like the name suggests, it is very light weight, and works best for storing small particularly local data that mimics your large SQL databases. It is free.

What do you dislike?

It crashes if you go beyond its storage capacity. You can only use SQLite for small to mid-sized applications.

Recommendations to others considering the product:

The software is free, and that is the biggest benefit. However, ensure you a aware of the storage capacity. SQLite works only with limited amounts of data. It is a light weight software but provides you with the capability of popular SQL databases such as MySQL, and SQL Server.

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

SQLite works great as the backend for simple mobile application or websites.

Copy Review URL
Manager
Validated Reviewer
Review Source
Copy Review URL

"Database architecture"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
Co-Founder/CEO
Computer Software
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
UI
Mid-Market
(501-1000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
System Engineer
Information Technology and Services
Enterprise
(5001-10,000 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
U
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Database server"

What do you like best?

Sqlite database server with this application user can make any kind of application like website or mobile application. If user going to make mobile application and user can use this server and make database programmatic.

What do you dislike?

This application will not work for high amount of value of data. Because it is not easy to handle big data amount.

Recommendations to others considering the product:

It is good application to use for mobile and website application. you can develop any kind of application and make your automatic mobile application database.

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

I solved many problem with mobile application or website server. this had helped my site to make it done with fast. It good with process and make your application great.

Copy Review URL
Company Owner
Defense & Space
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
Project Manager
Information Technology and Services
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"Quick and reliable database without a server"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product:

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

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

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

Copy Review URL
UB
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL

"Best Portable Database"

What do you like best?

SQLite is known for being lightweight, robust and reliable at the same time. Since it is serverless, you don't need to install it or keep separate space for it. It's a standalone relational database which is ideal for mobile platforms whether IOS or Andriod. The syntax or query language of SQLite is quite easy to understand and you can go through their docs or online portals to find many examples and tutorials for the same.

What do you dislike?

I think most of the people face this problem that it is not a multi-user database application which restricts it to a single user writing at a time. It also lacks some of the basic functionality that other competitor software provides like different Joins and Stored Procedures call. It is primarily used in our development cycle but it's not well suited to handle Enterprise level databases.

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

We use it for all our development projects where the data is not that huge and a strict Timeout period is not applied to the database call. It gives us the data in a structured form in tables and that too in a size under 1 Mb. It doesn't require any space or server for installation. So, saves a lot of physical space and CPU resources.

Copy Review URL
System Engineer
Management Consulting
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
Software Developer
Information Technology and Services
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"SQLite Database for Better management of Datas in a structured way"

What do you like best?

SQLite can be used in Embedded software systems.

performance wise also SQLite beats other company database structure.

SQLite has no restriction of 32 or 64 bit systems. it will work in both the systems.

SQ Lite can be used to perform many operations like data storage and achieving.

What do you dislike?

Not Able to use for big and huge data management systems like HTTP request DB.

The size of database is restricted and not able to use for big data storage.

Recommendations to others considering the product:

Yes I will recommend this app to all developers and business users.

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

Data management problems like storing and query process.

Best benefits in using and best management techniques are present in SQLite.

Copy Review URL
Biochemistry PhD student and Research Assistant in Computational and Systems Biology
Higher Education
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
AI
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL

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

What do you like best?

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

What do you dislike?

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

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

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

Copy Review URL
Software Engineer (Technology R&D)
Research
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
Programmer
Internet
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
Operaio
Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
U
Small-Business
(Myself Only)
Validated Reviewer
Review Source
Copy Review URL

"SQLite as old MSSQL DBA"

What do you like best?

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

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

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

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

What do you dislike?

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

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

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

Numeric is usefull but you need more

Recommendations to others considering the product:

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

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

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

Copy Review URL
CEO
Computer & Network Security
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
IT Specialist
Automotive
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
AC
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
U
Validated Reviewer
Review Source
Copy Review URL

""SQLite Great Start to your business!""

What do you like best?

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

What do you dislike?

one more difficulty of software is of knowledge of the SQL language, since there are very complicated queries that I must do and sometimes the tool remains frozen and I have had to restart my machine

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

It's more suited for a start up on a budget since it presents a very good solution for data storage, maintenance and allows database engineers to structure the tables more efficiently and with scalability in mind.

I would say it's less appropriate for bigger companies and firms with a more lax budget. I currently use Microsoft SQL Server management studio and the main reason why we use it is because of its security.

Copy Review URL
Analista Programmatore e Sistemista BMC Remedy, BMC ITSM e BMC Discovery / ADDM
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"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 problems are you solving with the product? What benefits have you realized?

SQLite is ideal with environment with less space or memory

Copy Review URL
Founder
Small-Business
(Myself Only)
Validated Reviewer
Review Source
Copy Review URL

"SQLite "

What do you like best?

SQLite is a very important database library that many open source software uses. It also has a self contained database system as well. SQLite is very small and fast. It also can be run and embedded in specific applications.

What do you dislike?

I do not dislike much about SQLite except the fact that its difficult to use at times. Also sometimes its slow especially with big Databases

Recommendations to others considering the product:

Use only for embedded databases to make small scale applications work. (I.e. locally installed programs with no LAN or WAN connection)

What proble