Wir helfen Unternehmen in Deutschland
seit 15 Jahren bei der Softwareauswahl

Über SQLite

Datenbank-Management-Lösung in einer C-Programmierbibliothek.

Erfahre mehr über SQLite

Vorteile:

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.

Nachteile:

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

Bewertungen zu SQLite

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4,5
Kundenservice
3,6
Funktionen
4,1
Preis-Leistungs-Verhältnis
4,5

Weiterempfehlungsquote

8,5/10

SQLite hat eine Gesamtbewertung von 4,5 von 5 Sternen basierend auf 115 Nutzerbewertungen auf Capterra.

Hast du SQLite bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (115)

Stephen
Stephen
Lead Android Developer in Nigeria
Verifizierter Nutzer auf LinkedIn
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Perfect database tool for embedded software

5,0 vor 5 Jahren

Kommentare: I work a lot with SQLite as it is the primary medium of local storage in Android devices (and by extension, Android applications) which I work with on a daily basis, and SQLite is just perfect for the purpose it serves on these devices. It's lightweight so you don't have to worry most times about how much of the user's storage space your database is going to take up. There's not much difference between the standard SQL commands and those used in SQLite, and many have reported that SQLite is a good starting and training resource for SQL in general.

Vorteile:

Doesn't need a separate server. Lightweight and portable. Integrates most of the commands, functions and syntax of other SQL software. Optimized for use on devices that need to store data locally. Large user base and community (support).

Nachteile:

All operations are locked to a single process, so it's not suitable for large scale database operations (which is not what you should be doing locally on a device anyway).

Jacek
DevOps Engineer in Spanien
Informationstechnologie & -dienste, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Power in the simplicity

5,0 vor 10 Monaten

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

Vorteile:

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.

Nachteile:

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.

Chaya
Chaya
Trainee Software Engineer in Sri Lanka
Verifizierter Nutzer auf LinkedIn
Computer-Software, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

SQLite - compatability at it's best level

3,0 vor 5 Jahren

Kommentare: SQLite has become more and more popular among the users because of its easy installation and easy accessing . As it is compatible with most of the programming languages and its light weight it is more popular among mobile application developers

Vorteile:

SQLite is a light weighted data base which could be embedded with any software. Due to the light weightage of the product the data base is more popular In mobile application development. With it’s light weight it is also fast. SQLite is almost 35% faster than any other file system. SQLite is easy to use and there is not special installation or configurations needed to be done in order to use the product. All user have to do is download the libraries and run them in the computer. It is compatible which is why the product can be used with many programming languages with out any issues. Users are given a chance to extend their data base in future by adding new tables or new columns to the existing tables which is a great help for the ongoing projects.

Nachteile:

SQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.

Shola
Shola
Internship in Nigeria
Verifizierter Nutzer auf LinkedIn
Finanzdienstleistungen, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

SQLite: The best Database ever

5,0 vor 2 Monaten

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

Vorteile:

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.

Nachteile:

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

Jonathan Alexander
Jonathan Alexander
IT infrastructure analyst in Dominikanische Republik
Verifizierter Nutzer auf LinkedIn
Krankenhausversorgung & Gesundheitswesen, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

An excellent database for mobile projects

4,0 vor 2 Jahren

Kommentare: 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

Vorteile:

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

Nachteile:

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

Esther
Esther
Self-Employed in USA
Verifizierter Nutzer auf LinkedIn
Informationsdienst, Selbstständig
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Readily-Available Database Solution, But With Significant Limitations

3,0 vor 4 Jahren

Kommentare: 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.

Vorteile:

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

Nachteile:

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

Semih
Database design for companies in Türkei
Programmentwicklung, Selbstständig
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

My SQLite Experience

5,0 vor 10 Monaten

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

Vorteile:

The using of tools, tables and manage datas

Nachteile:

The less functions compare other programs(etc. SSMS)

Carlos Hugo Martin
Carlos Hugo Martin
Consultor in Peru
Verifizierter Nutzer auf LinkedIn
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Experience with SQLite

5,0 vor 3 Jahren

Kommentare: Describe your general experience with SQLite
It is very useful for me to be able to store information and consume it from different sources without having to implement specific software to do so. Its portability capacity has allowed us to distribute work effectively.

Vorteile:

The few resources you need and its portability. This allows us to use the stored data from any medium.

Nachteile:

That there is no native way to make it multi-user. That there is no native way to merge files from the same database, when they have been modified by different users and platforms.

valerian
Support in Georgien
Buchhaltung, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Small business helper

4,0 vor 3 Monaten

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

Vorteile:

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.

Nachteile:

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

Kshitij
N/A in Indien
Computer-Software, Selbstständig
Verwendete die Software für: Kostenlose Testversion
Herkunft der Bewertung

SQl lites is very helpful company

5,0 vor 4 Monaten

Vorteile:

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

Nachteile:

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

Gareth
Web Developer in Südafrika
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

A standard for testing

5,0 vor 4 Jahren

Kommentare: 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.

Vorteile:

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.

Nachteile:

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.

Tigran
Quantitative Analyst in USA
Finanzdienstleistungen, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Nice for small solutions

4,0 vor 3 Jahren

Kommentare: Pretty good for quick tests and development experiments, especially when you like SQL, not great for large production-grade datasets.

Vorteile:

It is serverless, needs no configuration, easy to start working with and use in development, especially when fixing/improving some legacy software. When used correctly, especially with limited amount of data, allows for fast queries.

Nachteile:

It is not built for large-scale applications. Another thing is that it is not easy to predict performance for queries on large amounts of data, even if the user knows how that database is built. It is sometimes easier to design your own (customized) data structure rather than using the standard product.

Mehak
Software Engineer in Indien
Computer-Software, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Free and quick to setup and use.

5,0 vor 4 Jahren

Kommentare: 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.

Vorteile:

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.

Nachteile:

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.

Carl
Carl
Software Developer in UK
Computer-Software, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Great for simple persistent storage

5,0 vor 5 Jahren

Vorteile:

SQLite is great because it is really easy to interface with a number of languages, my preference being C#. This allows me to create persistent storage for my applications or Unity games. SQLite is also great because it does not require an installation, either on the developers side nor the players side, it is a simple DLL which can be embedded into the application with ease. It also has great support with database management GUIs allowing me to debug the database very quickly.

Nachteile:

Off the top of my head, there are no glaring issues with SQLite. However it is important to know when a system like this is needed as opposed to another simple storage option such as XML/JSON etc.

Luis Miguel
Software Developer in USA
Computer-Software, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Great tool to have lightweight data bases.

5,0 vor 4 Jahren

Kommentare: I was a part of team developing micro-services in python, and we used SQL Lite to store persistent information on each microservice. It is a great option because the setup it's really simple.

Vorteile:

* Really easy to install. * It has compatibility with different operating systems. * It can be used in many programming languages. * The command line is easy to use.

Nachteile:

* It's a light weight database if you are trying to save too much data you will face some problems.

Drew
Drew
IT Administrator in USA
Verifizierter Nutzer auf LinkedIn
Transport/Güterfrachtverkehr/Schienenverkehr, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Very Basic SQL engine for iPad

2,0 vor 6 Jahren

Kommentare: This is a budget choice for SQL on iOS if you're building some sort of mobile app that requires databasing. If you're looking for extensible support and lots of features, this ain't it. If you need basic databasing and are working to keep costs down, this may be a good choice, but I wouldn't recommend it outright.

Vorteile:

Compatible on multiple versions of iOS across my environment. Works well with app it was designed to work for. Pretty stable and predictable performance. Management GUI is excellet.

Nachteile:

It lacks some very basic features most mobile SQL engines would have. Stuff like importing DB's from external apps is just non-existent.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

You need a small database without problems? the answer is: SQLite

5,0 vor 6 Jahren

Vorteile:

small, easy, no complicated stored procedure. You choose how to use and STOP. SQLite is ok if need a database for your application . No problem with a lot of datas: I've managed SQLite database with Millions of records.

Nachteile:

Use only for storage information. No other features are available: No native stored procedure. So internal procedure are impossible.

Danoosh
Metadata Specialist in Kanada
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

A suitable light weight for small applications (and learning)

4,0 vor 6 Jahren

Vorteile:

I use this for teaching SQL and databases to beginners. It is very easy to setup and navigate (command line and DB browser). It has reasonable power to deal with mid-range databases for developing and supporting small applications

Nachteile:

If you are working with enterprise scale data (even small in enterprise realm), it will crash on you quite easily. You can not have multiple connections and it does not have many features of free MySQL

Jimcarl
Jimcarl
Data Analyst in Philippinen
Informationstechnologie & -dienste, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Good choice for portable database

4,0 vor 5 Jahren

Vorteile:

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

Nachteile:

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

Dhruvil
Dhruvil
Web developer in Indien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 11–50 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

SQLite review

5,0 letztes Jahr

Vorteile:

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

Nachteile:

I don't dislike this software its perfect.

Elcenir
Elcenir
Asistente Administrativo III in Venezuela
Verifizierter Nutzer auf LinkedIn
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Lightweight, easy and powerful at the same time

4,0 vor 6 Jahren

Kommentare: learn to consult views and functions in the tool

Vorteile:

is a lightweight and powerful database manager to store data from a web and mobile project, it is within relational databases, its installation is very simple, I use it to make simple querys of a project that I am currently carrying

Nachteile:

one more difficulty of software is of knowledge of the SQL language, since there are very complicated queries that I must do and sometimes the tool remains frozen and I have had to restart my machine

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

A great software for development

4,0 vor 3 Jahren

Vorteile:

It is very easy to set up while development phase. It does not require any complex setup and comes builtin with Python.

Nachteile:

It cannot handle multiple tasks at the same time so is not a good choice for production.

Sahil
Sahil
dot net developer in Indien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 11–50 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Sqllite

4,0 vor 5 Jahren

Kommentare: I solve my problem in window application to sync the server data and local storage data by adding local storage entries SqlLite.

Vorteile:

Excellent creation to store relational data in local storage, that is helpful for mobile and desktop application so they do not need server to store the data.

Nachteile:

Product look and feel needs to be change and it should be great if it has intelligence.

Alafia
Analista de programas in Venezuela
Verifizierter Nutzer auf LinkedIn
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

I used it while I was in a Java programming course in the practical exercises and final project

4,0 vor 6 Jahren

Kommentare: Practices and test projects

Vorteile:

It is a portable and lightweight database to handle small data quantities or parameters of an application without complicated configurations

Nachteile:

If there is no continuous debugging process and the database scale may present synchronization problems, you do not have the option to have stored procedures

Chris
Software Support Consultant in USA
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Functions as an easy, obtainable SQL server.

4,0 vor 6 Jahren

Vorteile:

Installation of this program was rather easy, and initial set up was just as easy. Free, and allowed for easy database configuration.

Nachteile:

Had a few issues installing an updated version on the database and had to downgrade, but believe that was due to the computer being utilized.