Wij helpen bedrijven al 18 jaar
betere software te kiezen

Over SQLite

Open source database-engine die wordt gebruikt door applicaties vanwege de compacte afmetingen, platformonafhankelijke stabiliteit en serverloze functionaliteit.

Meer informatie over SQLite

Pluspunten:

If the application is not an ERP sort of then Sqlite is the best choice, it's easy to integrate and fast if the data is small. Best choice for beginners as well.

Minpunten:

Sometimes loading files takes too long, making the working of the data bases difficult. It also can get laggy if using other applications.

Beoordelingen van SQLite

Gemiddelde score

Gebruiksgemak
4,4
Klantenservice
3,6
Functies
4,1
Prijs-kwaliteitverhouding
4,5

Waarschijnlijkheid van aanbeveling

8,5/ 10

SQLite heeft een totaalscore van 4,4 van 5 sterren op basis van 118 gebruikersreviews op Capterra.

Heb je SQLite eerder gebruikt?

Deel je ervaringen met andere softwarekopers.

Reviews filteren (118)

Shola
Shola
Internship in Nigeria
Geverifieerde LinkedIn-gebruiker
Financiële dienstverlening, 10.000+ werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

SQLite: The best Database ever

5,0 vorig jaar

Opmerkingen: It is an excellent database as compared to others. I do not see any database competing with SQLite

Pluspunten:

SQLite operates with lightning speed. It is the compressed version the MYSQL. It is extremely efficient in website management and many other managerial tasks in any organization.

Minpunten:

It is very complex for beginners, but easy to understand.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Computersoftware, 501-1.000 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

The best database management

5,0 10 maanden geleden

Opmerkingen: I've been using SQLite to store databases and manage them easily. It's a fast and light tool, which helped me in several different cases.

Pluspunten:

It's light (doesn't require much resources), fast, it's stable, cross-platform. It's a free and open-source software which helps a lot with saving money and making sure it's secure.

Minpunten:

It's not recommended for big databases, only for small ones.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Marketing en reclame, 11-50 werknemers
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

A useful, yet untidy tool

2,0 7 maanden geleden

Opmerkingen: quick to deploy and simple to implement, although certain users may want to be aware of some UI and security concerns.

Pluspunten:

Very simple to use and undoubtedly reduces the amount of physical memory used

Minpunten:

Some security issues and occasionally non-loading user interface parts make me doubt its reliability

Jacek
DevOps Engineer in Spanje
Informatietechnologie en -diensten, 11-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

Power in the simplicity

5,0 2 jaar geleden

Opmerkingen: Works very well in simple scenarios! It might be a great choice for small applications that require low maintenance and easy setup

Pluspunten:

It's very simple to use and lightweight. Typically does not require a separate server (it could run on the same server as a web application). It's quite handy that the database is contained in one file, which then can be backed up easily or transferred across machines. It's quite fast for certain uses.

Minpunten:

Compared to other RDBMSes, it's very simple - which means that it's lacking certain features when it comes to scalability - it performs well in simple scenarios, and in complex ones - it just won't (unless you are very lucky and it's e.g. a case when there is only a single connection).Moreover, it lacks certain security features like user management and access control.

Jonathan Alexander
Jonathan Alexander
IT infrastructure analyst in Dominicaanse Republiek
Geverifieerde LinkedIn-gebruiker
Ziekenhuis- en gezondheidszorgbranche, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Eerder overwogen alternatieven:

An excellent database for mobile projects

4,0 3 jaar geleden

Opmerkingen: I have used this database for the development of mobile application projects and for the prototyping of web pages, which makes it a very good database, easy and agile when manipulating data

Pluspunten:

What I like most about this product or database is how easy it is to integrate with mobile projects in the creation of applications and its easy portability, as well as performance, agility and little space in its implementation that makes it unique when it comes to of mobile application projects

Minpunten:

That for very large projects it is not so robust handling so many transaction threads

Pablo
RPA Developer in Spanje
Informatietechnologie en -diensten, 5.001-10.000 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

My Own Experience working with SQLite

3,0 5 jaar geleden

Opmerkingen: My overall experience using SQLite is good, but it is based on small projects, always working locally and with little information. If you are thinking of working on large-volume information projects, I recommend other applications related to somewhat better, more visual databases, and with more functions to generate code and store queries or procedures.

Pluspunten:

The best thing about SQLite is undoubtedly that you can work with it for free. In addition with SQLite we can perform any type of query that we would perform with another program.

Minpunten:

What I like least about SQLite is undoubtedly nothing visual. The way to work with SQLite is through the console, and this may seem silly, and when you are accustomed it may not matter, but for people who begin to familiarize themselves with database environments, it is really useful for tables, and which is done with them, be fully visible. When displaying results by console, unless you print them in an external table, such as an Excel workbook, it will be quite complicated to see and analyze large results (Tables over 10k rows for example)

Esther
Esther
Self-Employed in VS
Geverifieerde LinkedIn-gebruiker
Informatiediensten, Zelfstandig ondernemer
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

Eerder overwogen alternatieven:

Readily-Available Database Solution, But With Significant Limitations

3,0 5 jaar geleden

Opmerkingen: SQLite is best-known for its near-universal availability in many operating systems and programming languages, but this comes at a certain cost. It is possible to implement it in a variety of use cases, and it is simple to set up and get running quickly. On the other hand, it does tend to have some significant differences from other solutions in this area, and this can make it difficult to transition away from SQLite when expansion options are needed. If a simple database and engine is needed, SQLite is perfect, but once anything more advanced is required it can be frustrating to adapt existing tools and software to the existing database. Keeping these limitations in mind are key, and it may be worth considering if the ease of setup is a fair trade-off for the lack of transition pathways.

Pluspunten:

Widely available for a variety of use cases, easy to implement in various software packages, extensive documentation available

Minpunten:

Rather limited feature set, functions do not always transfer particularly well to other use cases, a universal solution that often sacrifices features

Kshitij
N/A in India
Computersoftware, Zelfstandig ondernemer
Heeft de software gebruikt voor: Gratis proef
Bron van de reviewer

SQl lites is very helpful company

5,0 vorig jaar

Pluspunten:

Sql lite is eaay to use and the built are function is alo very good it helps me to save my time. The best i like is the supporting multiple languages like drupal and python

Minpunten:

I like the least is supporting the multiple languages because i an a data analyst student and for that i need data which is store in database and i can arange the data in order

valerian
Support in Georgië
Administratie, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Small business helper

4,0 vorig jaar

Opmerkingen: Overall SQLite is good software in its field that can help greatly.

Pluspunten:

SQLite is suitable for small companies that doesn't have big databases. SQLite handles small data very easily. It doesn't load the computer. And is relatively easy to use.

Minpunten:

As i mentioned SQLite is comfortable for small databases. But won't be affordable for large amount of data.

Dhruvil
Dhruvil
Web developer in India
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 11-50 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

SQLite review

5,0 2 jaar geleden

Pluspunten:

It is easy to use . We can easily manage and exicute data in it.

Minpunten:

I don't dislike this software its perfect.

Semih
Database design for companies in Turkije
Programmaontwikkeling, Zelfstandig ondernemer
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

My SQLite Experience

5,0 2 jaar geleden

Opmerkingen: Its average in my opinion. The data management are good but complicated

Pluspunten:

The using of tools, tables and manage datas

Minpunten:

The less functions compare other programs(etc. SSMS)

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Telecommunicatie, 11-50 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

No server required, used for standalone application and less configuration

5,0 6 jaar geleden

Opmerkingen: We are using SQLite for java and android application. SQLite is use for small and mid level organization as well because its cost affordable for any one. There is no required to back up every time because SQLite make a file for backup .

Pluspunten:

SQLite is very faster then other database as performance wise. we are using SQLite for mobile application and desktop application. Mose imp feature i like in SQLite is at the time of deployment on production it not required any space. SQLite is lightweight. select query is very faster in standalone application.

Minpunten:

There is no reporting functionality in SQLite. At the time of multiple insert query perform in queue that its goes slow for some time. There is administration in SQLite,so its very difficult to manage for multiple user.

Gareth
Web Developer in Zuid-Afrika
Computersoftware, 11-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

A standard for testing

5,0 5 jaar geleden

Opmerkingen: SQLite allows us to setup and test all our database structures, it's quick and easy to get going and it stays out of your way. Most of the time you'll forget that it's even part of your tech stack.

Pluspunten:

I like that SQLite for the most part stays out of your way. As soon as you have your desired config set up, you can transfer it with ease to most other projects and it just works. We use SQLite for testing purposes as it speeds up the entire process. You can either spin a local instance up or have it run in-memory to speed up your tests. The fact that it's usage is so ubiquitous, finding help or answers online isn't an issue at all.

Minpunten:

If I had to fault it at something, there is an edge case with how it builds your database structure, especially with how it handles foreign keys. It's easily handled by adjusting your test setup structure. That's the only hiccup we ever had and resolved with ease.

Barış
Data Scientist in Turkije
E-learning, 11-50 werknemers
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

Database easily with SQLite

5,0 3 jaar geleden

Opmerkingen: I used this application to learn database systems. I transferred the excel data I had, created tables, and transferred this data to the external environment with an external connection.

Pluspunten:

The application is very easy to use. The interface is simple and user friendly. The convenience of the download process is amazing. Very little space on the computer

Minpunten:

There is nothing wrong with the application, it is suitable for learning purposes.

Prince
Software developer in Ghana
Computersoftware, 2-10 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Best Lightweight Relational Database for Small Applications and Websites.

5,0 4 jaar geleden

Opmerkingen: We always use SQLite as our database when building software and web application prototypes and when deploying basic websites and apps that are not data-intensive.

Pluspunten:

SQLite does not run on a server like MySQL but is part of the end application thus making data storage and retrieval very fast.

Minpunten:

It is not reliable when deploying it with applications with multi-user access to database. With websites, SQLite can only handle sites with low to medium traffic.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Logistiek en toeleveringsketen, 201-500 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Great lightweight database for simple use cases

4,0 3 jaar geleden

Opmerkingen: Overall, SQLite allows us to build tools more rapidly. We've had a productive overall experience with SQLite.

Pluspunten:

I like how easy it is to use SQLite. It allows us to have a database backend without the usual set up and configuration steps needed for more complex RDBMS.

Minpunten:

I don't really have anything I dislike about SQLite. It does its job well on its intended use cases.

Mehak
Software Engineer in India
Computersoftware, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Free and quick to setup and use.

5,0 5 jaar geleden

Opmerkingen: The use-case I used SQLite was fairly simple I had to set up some small application quickly so this was the best possible solution for me.

Pluspunten:

The fact that it requires no installation makes it suitable for a quick application setup. It's a very lightweight tool that makes it useable across many systems. SQLite does not require a separate location that can be on the same server location which makes the I/O processing really fast and reliable.

Minpunten:

Due to the lightweight, there ought to be some restrictions one of them is that a large number of concurrent access might let to a system crash. One more issue is that is works with whole DB lock while performing a write operation so all the write operations are sequential.

Jimcarl
Jimcarl
Data Analyst in Filipijnen
Informatietechnologie en -diensten, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Good choice for portable database

4,0 6 jaar geleden

Pluspunten:

I like how SQLite offer T-SQL despite of being a portable database. I can create moderately complex queries and still runs fine.

Minpunten:

There's nothing I really don't like with SQLite. It's free and does the job.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 5.001-10.000 werknemers
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

Best relational database system for embedded applications.

5,0 5 jaar geleden

Opmerkingen: Bets choice to choose SQL for store data on embedded application instead of connecting Server and get data.

Pluspunten:

SQLite support almost ANSI standard SQL, If you know PostgreSQL it is very much easy to adapt SQLite, Best thing it supports ACID properties.Its embedded database software so its faster than client-Server databases.

Minpunten:

As it's a lightweight database software , it works perfect when your database size is smaller , but your Database size is more you can see performance issues.

Steve
Programmer in Canada
Fabricage van elektrische/elektronische producten, 11-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Very good local database.

5,0 3 jaar geleden

Pluspunten:

We use it in our software when we need little local database. The API with c# is very easy to learn. I recommand this if you need local database.

Minpunten:

There is no data viewer include. You need to find an alternative.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 11-50 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

A very efficient way to store certain kinds of data.

5,0 6 jaar geleden

Opmerkingen: We use it for storing certain data.

Pluspunten:

You get all the benefits of using sql statements without having to set up a sql server online.

Minpunten:

SQL syntax varies between the different versions of sql so the syntax you are familiar with may or may not be available in sqlite.

Sadia
Oracle Consultant in Pakistan
Geverifieerde LinkedIn-gebruiker
Computersoftware, 201-500 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Lightweight, Easy to integrate

5,0 4 jaar geleden

Pluspunten:

If the application is not an ERP sort of then Sqlite is the best choice, it's easy to integrate and fast if the data is small. Best choice for beginners as well.

Minpunten:

Its performance is really impacted if the data gets large overtime. Not a good choice for applications with many users.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Computernetwerken, Zelfstandig ondernemer
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Database for as storage

4,0 6 jaar geleden

Opmerkingen: SQLite is perfect for a certain kind of usage. Not for massive access but amazing for compact traditional database.

Pluspunten:

SQLite is fast and durable due to it's file-as-database approach. SQL Dump is very much compliant with most other databases.

Minpunten:

The bottle-neck on concurrency makes SQLite unsable for server/client use.

John D.
Founder in VS
Geverifieerde LinkedIn-gebruiker
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

SQLite made pulling, manipulating and evaluating data from multi-relational databases a breeze!

5,0 7 jaar geleden

Opmerkingen: Ease of accessing data for Ad-Hoc reports.

Pluspunten:

Linking SQLite to the internal database was quite simple; setting up authorized users was as well.

Minpunten:

SQLite could be finicky on my company's database, I would sometimes switch over to Sandbox to run quicker queries.

Julio
Developer in Brazilië
Computergames, 11-50 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Database on the go!

5,0 6 jaar geleden

Pluspunten:

SQLite is a great solution when your application needs a small footprint database with all the powers from relational SQL. It integrates with any language you need and is available in any platform!

Minpunten:

Being a smaller library, it misses some features from bigger database systems.