Durchschnittliche Bewertung66 Bewertungen
- Gesamt 4.5 / 5
- Benutzerfreundlichkeit 4.4 / 5
- Kundenservice 3.7 / 5
- Funktionen 4.1 / 5
- Preis-Leistungs-Verhältnis 4.4 / 5
- Startpreis 0,00 $
- Gratis Testen Nein
Installiert - Mac
Installiert - Windows
Angaben zum Hersteller
Datenbank-Management-Lösung in einer C-Programmierbibliothek.
- Backup und Recovery
- Mobiler Zugriff
- Unterstützt zahlreiche Programmiersprachen
Die hilfreichsten Reviews für SQLite
Bewertet am 14.9.2019
A standard for testing
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.
Bewertet am 9.12.2019
Reliable and battle tested database engine
Kommentare: I had been using it for Windows, iOS, backend and Android for many purposes. The support for sqlite always straight forward. I would recommend sqlite for tasks which not use joins nor store procedures. Native security is quite weak without supporting encrypt particular table or column.
Vorteile: Lightweight relational database, works on many platforms and has gain support from popularity in community. The toolkit for developing is great and easy to understand the concept. Integration to mobile is a nicer experience compare to other db engine. The speed and datasize is good for mobile as well.
Nachteile: We need to define data structure first before actually implement features, any mismatch in database scheme must be resolved using migration. The locking architecture only allow a single process to write at a time - no high volume transaction - and it isn’t able to scale to hundreds of users nor store large amount of data.
Bewertet am 22.3.2019
Perfect database tool for embedded software
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.
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).
Bewertet am 25.4.2019
No server required, used for standalone application and less configuration
Kommentare: 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 .
Vorteile: 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.
Nachteile: 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.
Bewertet am 3.10.2019
Great Database For Smaller Loads
Kommentare: This is definitely a great option when we are working on smaller projects that require and embedded database rather than the whole database setup. You quickly get up and running but security is definitely a concern when working on more sensitive work
It doesn't required installing an extra software.
Provides the essentials in terms of structured query language which is often better than having to use a text file, especially when relations are involved.
It is very cross-platform from mobile, desktop etc which makes life easier.
When it comes to systems that may have a lot of concurrent actions it, in my experience, often tends to lock up.
It doesn't give much in terms of allowing to tune performance for more complex scenarios.
There is no user management in place thus there are not permissions, it may not be the best option for more sensitive data
Last I checked there was no date data type which means enforcing that date formats conformity is often on the developer's side.