15 años ayudando a las empresas mexicanas
a elegir el mejor software
SQLite
¿Qué es SQLite?
Solución de gestión de bases de datos en una biblioteca de programación C.
¿Quién usa SQLite?
Grandes negocios.
¿Tienes dudas sobre SQLite?
Compara con una alternativa popular
SQLite
Opinones de SQLite
Excelente base de datos de desarrollo
Comentarios: Es muy fácil de configurar y empezar nuevas aplicaciones sin tener que instalar nada más o montar un docker con postgres o mysql es muy cómodo, sobre todo para principiantes. Las funcionalidades que provee son las básicas pero en general suficientes cuando tienes que desarrollar prototipos o "aplicaciones de laboratorio" destinadas a aprender. Al guardar los datos en un fichero es muy fácil llevarlo junto con el código para tener guardada una configuración inicial para el proyecto.
Puntos a favor:
Cuando comienzas un proyecto en Ruby on Rails, sqlite viene por defecto como motor de base de datos, por lo tanto su configuración para guardar los datos en un fichero es muy sencilla y de este modo es fácil comenzar a desarrollar un nuevo proyecto. Es fácil de configurar y muy efectivo como base de datos de desarrollo.
Contras:
Al ser una base de datos basada en un fichero, su performance no es muy buena, y si debes realizar pruebas de performance te recomiendo utilizar el motor de base de datos que tengas en producción. Por otro lado, hay algunas funcionalidades como columnas array o hstore no están disponibles por lo que en ese caso no podrás utilizarla.
Perfect database tool for embedded software
Comentarios: 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.
Puntos a favor:
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).
Contras:
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).
Alternativas consideradas:
Power in the simplicity
Comentarios: Works very well in simple scenarios! It might be a great choice for small applications that require low maintenance and easy setup
Puntos a favor:
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.
Contras:
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
Comentarios: 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
Puntos a favor:
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.
Contras:
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.
SQLite: The best Database ever
Comentarios: It is an excellent database as compared to others. I do not see any database competing with SQLite
Puntos a favor:
SQLite operates with lightning speed. It is the compressed version the MYSQL. It is extremely efficient in website management and many other managerial tasks in any organization.
Contras:
It is very complex for beginners, but easy to understand.