SQLite Archived Reviews (More than two years old)

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Real User
Co-founder at a tech services company with 51-200 employees
Feb 02 2015

What is most valuable?

Whenever I need a single file database that works server-less, cross-platform and has acid properties, I use SQLite. It also supports triggers which can be used for many things like handling data… more »

How has it helped my organization?

I mostly used it at university in a Database Systems class where students are first introduced to SQL. They need something easy to use in their projects, so SQLite is the perfect candidate. As SQLite… more »

What needs improvement?

SQLite does not have user defined functions like other database management systems do, and you have to write C code, which is a complication that you may not get into for a user defined function.

Which solution did I use previously and why did I switch?

I previously used the H2 database and I changed because I had problems while connecting with the PHP server.

What other advice do I have?

In my experience, I have never used SQLite in a large project, but I used it teach and create proof of concept applications, and it has served me well. For one case, I needed spatial extensions which… more »

Which other solutions did I evaluate?

I also looked at using an embedded MySQL DB but it was not single file and there are problems using it on a PHP server as it needs some effort to run on a Windows machine.
Vendor
Developer at a transportation company with 1,001-5,000 employees
Feb 18 2013

What is most valuable?

- For me it was a really fast setup, I only needed to include a library into my application - This DMS is embedded, there is no need for the user to think about connections - It is used for testing because many frameworks, for example Rails use SQLite as testing database - For me was very easy to move a database - I observed that it has not external dependencies

What needs improvement?

- I used both SQLite and MySQL and I observed that SQLite’s capabilities are inferior to MySQL. - I noticed that SQLite does not have users and permissions, so everyone who can access the file can access all data - Also SQLite does not have performance improvement, it does not cache queries or optimizes selects. - I wanted to use SQLite with PHP, but I did not find many articles on the web about… more »

What other advice do I have?

When I first heard about SQLite, I read that it is a single-file based database which is useful for testing and for embedding in many applications. This means that all the information is stored in a single file on a file system and I use a SQLite library to open this file to read and write my data. Then I compared it with MySQL and I noticed that MySQL is a database server which got different… more »

What is SQLite?

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine
SQLite customers
Oracle, Bloomberg, Bentley, Mozilla
BUYER'S GUIDE
Download our free Open Source Databases Report and find out what your peers are saying about SQLite, Firebird, Oracle, and more!