Durchschnittliche Bewertung64 Bewertungen
- Gesamt 4.5 / 5
- Benutzerfreundlichkeit 4.5 / 5
- Kundenservice 3.5 / 5
- Funktionen 4 / 5
- Preis-Leistungs-Verhältnis 4.5 / 5
- Startpreis 0,00 $
- Kostenlose Testversion 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 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.
Bewertet am 8.11.2018
Easy to become a problem
Kommentare: 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).
Vorteile: 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).
Nachteile: 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.