Was ist SQLite?
Datenbank-Management-Lösung in einer C-Programmierbibliothek.
SQLite – Details
SQLite – Preisübersicht
SQLite ist verfügbar ab 0,00 $. SQLite bietet keine kostenlose Testversion. Weitere Preisinformationen für SQLite finden Sie unten.
SQLite – Nutzerbewertungen
5 von 72 Nutzerbewertungen angezeigt
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 26.11.2019
The best solution for small, pre-packaged databases
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.
Bewertet am 28.12.2019
Free and quick to setup and use.
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.
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 3.4.2019
SQLite - compatability at it's best level
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.