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 116 Nutzerbewertungen auf Capterra.

Hast du SQLite bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (116)

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 letztes Jahr

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.

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

The best database management

5,0 letzten Monat Neu

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

Vorteile:

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.

Nachteile:

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

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.

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

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.

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 5 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.

Ramindu
Ramindu
Software Technical Lead in USA
Verifizierter Nutzer auf LinkedIn
Computer-Software, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

The best solution for small, pre-packaged databases

5,0 vor 4 Jahren

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

Vorteile:

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.

Nachteile:

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.

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 7 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 5 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.

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 letztes Jahr

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)

Prince
Software developer in Ghana
Computer-Software, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Best Lightweight Relational Database for Small Applications and Websites.

5,0 vor 3 Jahren

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

Vorteile:

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

Nachteile:

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.

Ali Emre
Software Engineer & Co-Founder in Südafrika
Computer-Software, 2–10 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

SQLite is a comprehensive open source platform

5,0 vor 2 Jahren

Vorteile:

SQLite offers a highly advance database management solution with its open source structure.

Nachteile:

There needs to be a better customer support behind SQLite platform.

Barış
Data Scientist in Türkei
E-Learning, 11–50 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Database easily with SQLite

5,0 vor 2 Jahren

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

Vorteile:

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

Nachteile:

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

Varun
Manufacturing Specialist in Kanada
Bau, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Smooth and Reliable DBMS

4,0 vor 2 Jahren

Kommentare: My overall experience has been smooth and SQLite has satisfied most of my needs. It's a lite, easy to use and robust for everyday needs. The support community is fantastic and you can find solution to most problems there.

Vorteile:

SQLite is quite easy to install and get started. This makes it one of the best DBM tools for beginners. It's open source and free to install and runs on a server-less environment. The syntax is quite similar to any other SQL database management system.

Nachteile:

The competition wins when it comes to scalability and is not suited for projects that will expand.

ARIEL
President in Puerto Rico
, 2–10 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Was easy to install and to install on customer machine

4,0 vor 6 Jahren

Kommentare: Is free, but same time is good enough for programming very fast.

Vorteile:

Easy to learn, no complicated database definitions. Can use only Varchar variable for everything.

Nachteile:

Hard programming for multi-user. I have to create my own system to avoid database crash when more than one computer is assessing the database.

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

Small, Fast And Efficient RDBMS

4,0 vor 5 Jahren

Vorteile:

SQLite is a great RDBM solution if you need a database for embedded devices, IoT, websites or cache management. It is small, fast and efficient. It doesn't require any setup or administration. It provides easy to use APIs.

Nachteile:

if what you need is a client-server database, it's not for you.

Dennis
Software Engineer in Nordmazedonien
Informationstechnologie & -dienste, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Lightweight and easy to use.

5,0 vor 5 Jahren

Kommentare: Perfect for small project and easy to setup.

Vorteile:

It's really well design and easy to connect to database, and best of all it is free.

Nachteile:

It's not really good for large databases it can be quite slow, but perfect for small projects.

barun
HR Specialist in Bangladesch
Bau, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Opnion

5,0 letztes Jahr

Kommentare: overall good software.

Vorteile:

Small in size, ready to use and other user loved features such as create, edit, delete databese

Nachteile:

Sometimes interface of the software are difficult to understand.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 5.001–10.000 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Best relational database system for embedded applications.

5,0 vor 5 Jahren

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

Vorteile:

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.

Nachteile:

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.

Denis
Denis
Ph.D. Student in Brasilien
Forschung, Selbstständig
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Very good for studying SQL, small projects and local storage

5,0 vor 4 Jahren

Kommentare: Sometimes I use it as a stand alone application to make queries in the terminal or as a driver/library that is easily embedded into some of my software.

Vorteile:

Very small footprint and overhead, battle-tested in real-world applications (which indicates that it’s pretty reliable) and well supported by several major companies. It’s also very good for people learning SQL due to its simplicity.

Nachteile:

Cannot handle very large datasets well. It’s not ideal for concurrently running or distributed software.

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 6 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.

Nestor
Integration Engineer in El Salvador
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

When the small is really big.

5,0 vor 6 Jahren

Vorteile:

It's fast, simple and fun. The learning curve is very comfortable. Although it is a small database it is capable of storage up to 2 terabytes of information.

Nachteile:

The tables are not related. The relationships are logical (We have to program this logic). There are no DATE type columns. This hinders operations between DATES.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 51–200 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

SQLite is a good embedded database choice

4,0 vor 5 Jahren

Vorteile:

I like how SQLite offer similar capabilities with full-pledged MSSQL. It runs traditional TSQL and it stays small in file size. It's very convenient to use and have so 3rd party management tools available.

Nachteile:

When the database gets large, say around 2 gigs, loading times can be a bit slow.