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

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.

Readily-Available Database Solution, But With Significant Limitations

Commentaires : SQLite is best-known for its near-universal availability in many operating systems and programming languages, but this comes at a certain cost. It is possible to implement it in a variety of use cases, and it is simple to set up and get running quickly. On the other hand, it does tend to have some significant differences from other solutions in this area, and this can make it difficult to transition away from SQLite when expansion options are needed. If a simple database and engine is needed, SQLite is perfect, but once anything more advanced is required it can be frustrating to adapt existing tools and software to the existing database. Keeping these limitations in mind are key, and it may be worth considering if the ease of setup is a fair trade-off for the lack of transition pathways.

Avantages :

Widely available for a variety of use cases, easy to implement in various software packages, extensive documentation available

Inconvénients :

Rather limited feature set, functions do not always transfer particularly well to other use cases, a universal solution that often sacrifices features

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.

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.

A complete and productive database manager

Commentaires : As a student, I have used SQLite in several projects, in which my experience has been good. Thanks to its interface, understanding all its specific functions was not so difficult for me and at the same time working with its tools is an effective and fast process.

Avantages :

Access to databases created in SQLite is fast and easy, because it works as its own independent server. Its connection and management with computer and mobile applications is one of the best, its interface is quite simple and easy to use for the user.

Inconvénients :

It seems to me the most complete program in its field of work, so I don't see any cons about this program.

Good database to choose if you have small database requirements.

Avantages :

It is quite easy to use with its well versed documentations. The database administration for SQLite is also particularly excellent. The installation and setup is very very easy quick.

Inconvénients :

SQLite cannot be used for large data requirements so one cannot use it for businness purposeswith high data availability

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.

Great choice if you use it correctly

Avantages :

SQLite is a fantastic database for resource-constraint systems or for those cases where full-blown SQL client-server system is not required. SQLite has been probably implemented for any platform. It even exists for microcontrollers. When used properly, SQLite makes programmers life easy.

Inconvénients :

There is nothing that I dislike about SQLite.

Great tool to have lightweight data bases.

Commentaires : I was a part of team developing micro-services in python, and we used SQL Lite to store persistent information on each microservice. It is a great option because the setup it's really simple.

Avantages :

* Really easy to install. * It has compatibility with different operating systems. * It can be used in many programming languages. * The command line is easy to use.

Inconvénients :

* It's a light weight database if you are trying to save too much data you will face some problems.

Very Basic SQL engine for iPad

Commentaires : This is a budget choice for SQL on iOS if you're building some sort of mobile app that requires databasing. If you're looking for extensible support and lots of features, this ain't it. If you need basic databasing and are working to keep costs down, this may be a good choice, but I wouldn't recommend it outright.

Avantages :

Compatible on multiple versions of iOS across my environment. Works well with app it was designed to work for. Pretty stable and predictable performance. Management GUI is excellet.

Inconvénients :

It lacks some very basic features most mobile SQL engines would have. Stuff like importing DB's from external apps is just non-existent.

Small, Fast And Efficient RDBMS

Avantages :

SQLite is a great RDBM solution if you need a database for embedded devices, IoT, websites or cache management. It is small, fast and efficient. It doesn't require any setup or administration. It provides easy to use APIs.

Inconvénients :

if what you need is a client-server database, it's not for you.

Depends on how you store your data

Avantages :

If you are storing variable data that resemble objects, use this instead of MySQL! There are also a lot of libraries built for accessing and manipulating SQLite databases now.

Inconvénients :

It takes up much more space and memory compared to conventional databases like MySQL

Database on the go!

Avantages :

SQLite is a great solution when your application needs a small footprint database with all the powers from relational SQL. It integrates with any language you need and is available in any platform!

Inconvénients :

Being a smaller library, it misses some features from bigger database systems.

Invaluable offline database

Avantages :

SQLite is great for rapid applications development and testing out how your application works without having to connect to a server. It serves as a decent local cache of data.

Inconvénients :

Understandably not suitable for large data content

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.