--- description: Review of SQLite Software: system overview, features, price and cost information. Get free demos and compare to similar programs on Software Advice New Zealand. image: https://gdm-localsites-assets-gfprod.imgix.net/images/software_advice/og_logo-55146305bbe7b450bea05c18e9be9c9a.png title: SQLite | Reviews, Pricing & Demos - SoftwareAdvice NZ --- Breadcrumb: [Home](/) > [Database Software](/directory/4512/database-management-systems/software) > [SQLite](/software/107973/sqlite) # SQLite Canonical: https://www.softwareadvice.co.nz/software/107973/sqlite Page: 1 / 6\ Next: [Next page](https://www.softwareadvice.co.nz/software/107973/sqlite?page=2) > SQLite is a license-based software library that provides businesses with a serverless and self-contained SQL database management system. The embedded database engine allows developers to manage multiple tables, triggers, indices and views of data within a single disk file and store additional files in a rollback journal for future purposes. Key features of SQLite include foreign key support, error and warning log, database analyzer, full-text search and JSON integration. The library comes with built-in scalar SQL functions, which lets administrators manage date and time strings, language expressions such as syntax, constants, if-then-else cases and between or like comparisons in databases. Additionally, users can also attach multiple databases into a single database connection to quickly write programs. SQLite provides a C-language Interface and backup API, which lets businesses import or export content from disk files and store it in the database. It is available on a one-time license fee. > > Verdict: Rated **4.4/5** by 118 users. Top-rated for **Likelihood to recommend**. ----- ## Quick Stats & Ratings | Metric | Rating | Detail | | **Overall** | **4.4/5** | 118 Reviews | | Ease of Use | 4.4/5 | Based on overall reviews | | Customer Support | 3.6/5 | Based on overall reviews | | Value for Money | 4.5/5 | Based on overall reviews | | Features | 4.1/5 | Based on overall reviews | | Recommendation percentage | 80% | (8/10 Likelihood to recommend) | ## About the vendor - **Company**: SQLite ## Commercial Context - **Starting Price**: US$6,000.00 - **Pricing model**: Flat Rate - **Pricing Details**: SQLite is available as an open-source application along with one-time fees, details of which are outlined below: SQLite License - $6000 one time fee SQLite Encryption Extension (SEE) - $2000 one time fee Compressed And Encrypted Read-Only Database (CEROD) - $2000 one time fee The ZIPVFS Read/Write Compressed Database Extension - $4000 one time fee - **Target Audience**: Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000, 5,001–10,000, 10,000+ - **Deployment & Platforms**: Cloud, SaaS, Web-based, Mac (Desktop), Windows (Desktop), Linux (Desktop), Windows (On-Premise), Linux (On-Premise) - **Supported Languages**: English - **Available Countries**: United States ## Features - API - Automatic Backup - Backup and Recovery - Data Capture and Transfer - Data Connectors - Data Extraction - Data Replication - Data Storage Management - Data Synchronisation - Database Conversion - Multiple Programming Languages Supported - Real-Time Data - Relational Database Management - Search/Filter - Secure Data Storage ## Support Options - Email/Help Desk - FAQs/Forum - Knowledge Base - Chat ## Category - [Database Software](https://www.softwareadvice.co.nz/directory/4512/database-management-systems/software) ## Alternatives 1. [Microsoft SQL Server](https://www.softwareadvice.co.nz/software/399511/microsoft-sql-server) — 4.6/5 (1977 reviews) 2. [MySQL](https://www.softwareadvice.co.nz/software/395969/mysql) — 4.6/5 (2095 reviews) 3. [Google Cloud](https://www.softwareadvice.co.nz/software/172144/google-cloud-platform) — 4.7/5 (2302 reviews) 4. [Airtable](https://www.softwareadvice.co.nz/software/205546/airtable) — 4.6/5 (2238 reviews) 5. [MongoDB](https://www.softwareadvice.co.nz/software/107967/mongodb) — 4.7/5 (470 reviews) ## Reviews ### "Easy to become a problem" — 4.0/5 > **Anderson** | *8 November 2018* | Information Technology & Services | Recommendation rating: 7.0/10 > > **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. > > 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). ----- ### "The best solution for small, pre-packaged databases" — 5.0/5 > **Ramindu** | *26 November 2019* | Computer Software | Recommendation rating: 8.0/10 > > **Pros**: SQLite is a great database solution when you have a small database that you need to package alongside an application, for example a database that stores user preferences. As it is local to the application, it bypasses issues you would have with other, larger database servers in terms of network latency. Its conformity (in the large part) to MySQL syntax and features make it easy to use as well. > > **Cons**: While SQLite's lack of scaling features is forgivable (that wasn't what it was built for after all) some SQL features that are not implemented make it a hassle to write queries to SQLite databases in some instances. > > We included SQLite alongside web and mobile applications where a small database was needed with minimum latency. Most commonly, this use case involved storing dynamic configuration values and user preferences. ----- ### "A useful, yet untidy tool" — 2.0/5 > **Verified Reviewer** | *9 July 2024* | Marketing & Advertising | Recommendation rating: 6.0/10 > > **Pros**: Very simple to use and undoubtedly reduces the amount of physical memory used > > **Cons**: Some security issues and occasionally non-loading user interface parts make me doubt its reliability > > quick to deploy and simple to implement, although certain users may want to be aware of some UI and security concerns. ----- ### "A good choice for storing small and local data" — 4.0/5 > **Nera Joy** | *19 June 2018* > > **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. ----- ### "A lightweight relational database management system especially for offline mobile applications and d" — 5.0/5 > **Rahul** | *18 January 2019* | Information Services | Recommendation rating: 10.0/10 > > **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. > > **Cons**: 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. > > 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. ----- Page: 1 / 6\ Next: [Next page](https://www.softwareadvice.co.nz/software/107973/sqlite?page=2) ## Links - [View on SoftwareAdvice](https://www.softwareadvice.co.nz/software/107973/sqlite) ## This page is available in the following languages | Locale | URL | | de | | | en | | | en-AU | | | en-GB | | | en-IE | | | en-NZ | | | fr | | ----- ## Structured Data