Avis clients sur 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).

Power in the simplicity

Commentaires : Works very well in simple scenarios! It might be a great choice for small applications that require low maintenance and easy setup

Avantages :

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.

Inconvénients :

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.

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.

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

Excellent option for quick and light needs.

Commentaires : What I appreciate best about SQLIte is how lightweight it is and how easily it can be used in Android applications. It appears to be designed to function on tiny devices with a minimal footprint. It is also open source. Because no server configuration is necessary, installation and setup take very little time.

Avantages :

SQLite was an excellent choice for us when we wanted to store a database for a basic utility that we were developing. The performance appeared to be excellent, and it was really steady.

Inconvénients :

It is not completely functional with all capabilities unless you purchase a professional version, which comes at a cost.

Good for simple and fast database solutions

Commentaires : When I used it to store data for my online project, it exceeded my expectations, and it's been working great ever since. Now, we can use a server to retrieve data from apps that use SQL and save it on the embedded application.

Avantages :

This is an excellent tool because it's easy to use with several languages, my favorite of which being C#. We may create persistent storage for our applications using SQLite, which does not need any installation on the developers' end. I also want to emphasize the superior database management.

Inconvénients :

This is a lightweight database, so if you try to store too much data, you can run into some problems. The most prevalent issue is that it will significantly affect performance. Another issue is that this functionality isn't always simple, which is related to integration.

My SQLite Experience

Commentaires : Its average in my opinion. The data management are good but complicated

Avantages :

The using of tools, tables and manage datas

Inconvénients :

The less functions compare other programs(etc. SSMS)

The best solution for small, pre-packaged databases

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

Avantages :

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.

Inconvénients :

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.

A lightweight relational database management system especially for offline mobile applications and d

Commentaires : We have used SQLite in developing many mobile apps, mostly Android App and as a database at back end we integrated this light weight DB system. The processing speed of queries is exceptionally fast. All the databases are working well.

Avantages :

SQLite is object based relational query language which keeps and maintained the whole databases in a very light weight, usually within 500kb to 1mb size, depending on size of databases. This database system has everything which a standard databases must have like relationships, events, all operations, etc. SQLite is very helpful in building application for Mobiles which stores databases in locally.

Inconvénients :

1. No dedicated server required. 2. Very light weight and easy to follow commands with knowledge. 3. Large community support makes learning this language even more fast and easy 4. Easy to keep backups as the whole database stored in single file. 5. Easy to implement and integrate.

SQLite is a comprehensive open source platform

Avantages :

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

Inconvénients :

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

A standard for testing

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

Avantages :

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.

Inconvénients :

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.

Great Database For Smaller Loads

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

Avantages :

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.

Inconvénients :

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.

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.

Database easily with SQLite

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

Avantages :

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

Inconvénients :

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

Smooth and Reliable DBMS

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

Avantages :

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.

Inconvénients :

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

Was easy to install and to install on customer machine

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

Avantages :

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

Inconvénients :

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.

A suitable light weight for small applications (and learning)

Avantages :

I use this for teaching SQL and databases to beginners. It is very easy to setup and navigate (command line and DB browser). It has reasonable power to deal with mid-range databases for developing and supporting small applications

Inconvénients :

If you are working with enterprise scale data (even small in enterprise realm), it will crash on you quite easily. You can not have multiple connections and it does not have many features of free MySQL

Good choice for portable database

Avantages :

I like how SQLite offer T-SQL despite of being a portable database. I can create moderately complex queries and still runs fine.

Inconvénients :

There's nothing I really don't like with SQLite. It's free and does the job.

SQLite review

Avantages :

It is easy to use . We can easily manage and exicute data in it.

Inconvénients :

I don't dislike this software its perfect.

Best relational database system for embedded applications.

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

Avantages :

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.

Inconvénients :

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.

A great software for development

Avantages :

It is very easy to set up while development phase. It does not require any complex setup and comes builtin with Python.

Inconvénients :

It cannot handle multiple tasks at the same time so is not a good choice for production.

Sqllite

Commentaires : I solve my problem in window application to sync the server data and local storage data by adding local storage entries SqlLite.

Avantages :

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.

Inconvénients :

Product look and feel needs to be change and it should be great if it has intelligence.

I used it while I was in a Java programming course in the practical exercises and final project

Commentaires : Practices and test projects

Avantages :

It is a portable and lightweight database to handle small data quantities or parameters of an application without complicated configurations

Inconvénients :

If there is no continuous debugging process and the database scale may present synchronization problems, you do not have the option to have stored procedures

Functions as an easy, obtainable SQL server.

Avantages :

Installation of this program was rather easy, and initial set up was just as easy. Free, and allowed for easy database configuration.

Inconvénients :

Had a few issues installing an updated version on the database and had to downgrade, but believe that was due to the computer being utilized.

Good software, needs a bit of knowledge

Avantages :

Free, powerful and comprehensive bit of software which manages and helps to look after our SQL databases

Inconvénients :

It does take a little while to get used to the software and to get to know the features, there are more features than meets the eye.