SQLite Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Showingreviews based on the current filters.
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.
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 customersOracle, Bloomberg, Bentley, Mozilla