SQLite

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

Find the Right Product

SQLite Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 98 SQLite reviews
LinkedIn Connections
SQLite review by <span>Chris S.</span>
Chris S.
Validated Review
Review Source
Validated Review
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.

0 of 0 found this helpful.
Helpful?
Sign in to G2 Crowd to see what your connections have to say about SQLite
Headshots
SQLite review by User in Information Technology and Services
User in Information Technology and Services
Review Source
Validated Review
Verified Current User
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.

0 of 0 found this helpful.
Helpful?

What Relational Databases solution do you use?

Thanks for letting us know!
SQLite review by <span>Daniela C.</span>
Daniela C.
Validated Review
Review Source

The best tool for your mobile apps

Reviewed On
Validated Review
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.

0 of 0 found this helpful.
Helpful?
SQLite review by <span>Fedor P.</span>
Fedor P.
Validated Review
Review Source

Very well-developed and researched.

Updated On
Validated Review
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.

0 of 0 found this helpful.
Helpful?
SQLite review by <span>Andrew F.</span>
Andrew F.
Validated Reviewer
Review Source
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.

0 of 0 found this helpful.
Helpful?
SQLite review by <span>Diana P.</span>
Diana P.
Validated Reviewer
Review Source

I like SQLite

Updated On
Validated Reviewer
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.

0 of 0 found this helpful.
Helpful?
Kate avatar
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.