SQLite

Perfect database tool for embedded software

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

Avantages :

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

Inconvénients :

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

An excellent database for mobile projects

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

Avantages :

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

Inconvénients :

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

An efficent and lightweight Database Management System!

Avantages :

I've been using this DBMS for a while and it is so far the best to use in this field. It is open-source and has a wide variety of platform and programming language support. It is pretty efficient in data retrieval and what I really love in using this is unlike other DBMS, it is serverless so I don't need to do any other configuration to use it other than integrating it in my system!

Inconvénients :

There's not much to complain however given that it is designed to be a lite database, the size of the database is limited thus it can't be used on large scale data.

SQLite - compatability at it's best level

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

Avantages :

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.

Inconvénients :

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.

Very good local database.

Avantages :

We use it in our software when we need little local database. The API with c# is very easy to learn. I recommand this if you need local database.

Inconvénients :

There is no data viewer include. You need to find an alternative.