15 años ayudando a las empresas españolas
a elegir el mejor software

Sobre SQLite

Solución de gestión de bases de datos en una biblioteca de programación C.

Descubre más sobre SQLite

Puntos a favor:

If the application is not an ERP sort of then Sqlite is the best choice, it's easy to integrate and fast if the data is small. Best choice for beginners as well.

Puntos en contra:

Sometimes loading files takes too long, making the working of the data bases difficult. It also can get laggy if using other applications.

Valoraciones de SQLite

Evaluación media

Facilidad de uso
4,5
Atención al cliente
3,6
Funcionalidades
4,1
Relación calidad-precio
4,5

Probabilidad de recomendación

8,5/10

SQLite tiene una valoración global de 4,5 estrellas sobre 5 según las 116 opiniones de usuarios de Capterra.

¿Has utilizado SQLite?

Comparte tu experiencia con otros compradores de software.

Filtrar opiniones (116)

Gustavo
Gustavo
Desarrollador Ruby on Rails en España
Usuario de Linkedin verificado
Desarrollo de programas, 2-10 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Excelente base de datos de desarrollo

4,0 hace 4 años

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.

Puntos en contra:

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.

Stephen
Stephen
Lead Android Developer en Nigeria
Usuario de Linkedin verificado
Software informático, 11-50 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Perfect database tool for embedded software

5,0 hace 5 años

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

Puntos en contra:

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

Jacek
DevOps Engineer en España
Tecnología y servicios de la información, 11-50 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Alternativas consideradas previamente:

Power in the simplicity

5,0 el año pasado

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.

Puntos en contra:

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.

Usuario verificado
Usuario de Linkedin verificado
Software informático, 501-1.000 empleados
Ha utilizado el software durante: Más de un año
Fuente de la opinión

The best database management

5,0 hace 2 meses Nuevo

Comentarios: I've been using SQLite to store databases and manage them easily. It's a fast and light tool, which helped me in several different cases.

Puntos a favor:

It's light (doesn't require much resources), fast, it's stable, cross-platform. It's a free and open-source software which helps a lot with saving money and making sure it's secure.

Puntos en contra:

It's not recommended for big databases, only for small ones.

Chaya
Chaya
Trainee Software Engineer en Sri Lanka
Usuario de Linkedin verificado
Software informático, 51-200 empleados
Ha utilizado el software durante: Más de un año
Fuente de la opinión

SQLite - compatability at it's best level

3,0 hace 5 años

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.

Puntos en contra:

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.

Jonathan Alexander
Jonathan Alexander
IT infrastructure analyst en República Dominicana
Usuario de Linkedin verificado
Hospital y atención sanitaria, 1.001-5.000 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Alternativas consideradas previamente:

An excellent database for mobile projects

4,0 hace 2 años

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

Puntos a favor:

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

Puntos en contra:

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

Esther
Esther
Self-Employed en EE. UU.
Usuario de Linkedin verificado
Servicios de información, Trabajador autónomo
Ha utilizado el software durante: 1-5 meses
Fuente de la opinión

Alternativas consideradas previamente:

Readily-Available Database Solution, But With Significant Limitations

3,0 hace 4 años

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

Puntos a favor:

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

Puntos en contra:

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

Carlos Hugo Martin
Carlos Hugo Martin
Consultor en Perú
Usuario de Linkedin verificado
Software informático, 11-50 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Experience with SQLite

5,0 hace 3 años

Comentarios: Describe your general experience with SQLite
It is very useful for me to be able to store information and consume it from different sources without having to implement specific software to do so. Its portability capacity has allowed us to distribute work effectively.

Puntos a favor:

The few resources you need and its portability. This allows us to use the stored data from any medium.

Puntos en contra:

That there is no native way to make it multi-user. That there is no native way to merge files from the same database, when they have been modified by different users and platforms.

Shola
Shola
Internship en Nigeria
Usuario de Linkedin verificado
Servicios financieros, 10.000+ empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

SQLite: The best Database ever

5,0 hace 5 meses

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.

Puntos en contra:

It is very complex for beginners, but easy to understand.

Ramindu
Ramindu
Software Technical Lead en EE. UU.
Usuario de Linkedin verificado
Software informático, 10.000+ empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

The best solution for small, pre-packaged databases

5,0 hace 4 años

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

Puntos a favor:

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.

Puntos en contra:

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.

Kshitij
N/A en India
Software informático, Trabajador autónomo
Ha utilizado el software durante: Prueba gratis
Fuente de la opinión

SQl lites is very helpful company

5,0 hace 7 meses

Puntos a favor:

Sql lite is eaay to use and the built are function is alo very good it helps me to save my time. The best i like is the supporting multiple languages like drupal and python

Puntos en contra:

I like the least is supporting the multiple languages because i an a data analyst student and for that i need data which is store in database and i can arange the data in order

Gareth
Web Developer en Sudáfrica
Software informático, 11-50 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

A standard for testing

5,0 hace 5 años

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

Puntos a favor:

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.

Puntos en contra:

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.

Semih
Database design for companies en Turquía
Desarrollo de programas, Trabajador autónomo
Ha utilizado el software durante: Más de un año
Fuente de la opinión

My SQLite Experience

5,0 el año pasado

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

Puntos a favor:

The using of tools, tables and manage datas

Puntos en contra:

The less functions compare other programs(etc. SSMS)

Prince
Software developer en Ghana
Software informático, 2-10 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Best Lightweight Relational Database for Small Applications and Websites.

5,0 hace 3 años

Comentarios: We always use SQLite as our database when building software and web application prototypes and when deploying basic websites and apps that are not data-intensive.

Puntos a favor:

SQLite does not run on a server like MySQL but is part of the end application thus making data storage and retrieval very fast.

Puntos en contra:

It is not reliable when deploying it with applications with multi-user access to database. With websites, SQLite can only handle sites with low to medium traffic.

Ali Emre
Software Engineer & Co-Founder en Sudáfrica
Software informático, 2-10 empleados
Ha utilizado el software durante: 6-12 meses
Fuente de la opinión

SQLite is a comprehensive open source platform

5,0 hace 2 años

Puntos a favor:

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

Puntos en contra:

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

Barış
Data Scientist en Turquía
Aprendizaje en línea, 11-50 empleados
Ha utilizado el software durante: 1-5 meses
Fuente de la opinión

Database easily with SQLite

5,0 hace 2 años

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

Puntos a favor:

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

Puntos en contra:

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

Drew
Drew
IT Administrator en EE. UU.
Usuario de Linkedin verificado
Transporte/transporte en camión/ferrocarril, 11-50 empleados
Ha utilizado el software durante: Más de un año
Fuente de la opinión

Very Basic SQL engine for iPad

2,0 hace 6 años

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

Puntos a favor:

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.

Puntos en contra:

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

ARIEL
President en Puerto Rico
, 2-10 empleados
Ha utilizado el software durante: 6-12 meses
Fuente de la opinión

Was easy to install and to install on customer machine

4,0 hace 6 años

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

Puntos a favor:

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

Puntos en contra:

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.

Ali
Analyst en España
Tecnología y servicios de la información, 11-50 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Small, Fast And Efficient RDBMS

4,0 hace 5 años

Puntos a favor:

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.

Puntos en contra:

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

Dennis
Software Engineer en Macedonia del Norte
Tecnología y servicios de la información, 51-200 empleados
Ha utilizado el software durante: 6-12 meses
Fuente de la opinión

Lightweight and easy to use.

5,0 hace 5 años

Comentarios: Perfect for small project and easy to setup.

Puntos a favor:

It's really well design and easy to connect to database, and best of all it is free.

Puntos en contra:

It's not really good for large databases it can be quite slow, but perfect for small projects.

barun
HR Specialist en Bangladés
Construcción, 501-1.000 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Opnion

5,0 el año pasado

Comentarios: overall good software.

Puntos a favor:

Small in size, ready to use and other user loved features such as create, edit, delete databese

Puntos en contra:

Sometimes interface of the software are difficult to understand.

Usuario verificado
Usuario de Linkedin verificado
Tecnología y servicios de la información, 5.001-10.000 empleados
Ha utilizado el software durante: 1-5 meses
Fuente de la opinión

Best relational database system for embedded applications.

5,0 hace 5 años

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

Puntos a favor:

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.

Puntos en contra:

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.

Denis
Denis
Ph.D. Student en Brasil
Investigación, Trabajador autónomo
Ha utilizado el software durante: Más de dos años
Fuente de la opinión

Very good for studying SQL, small projects and local storage

5,0 hace 4 años

Comentarios: Sometimes I use it as a stand alone application to make queries in the terminal or as a driver/library that is easily embedded into some of my software.

Puntos a favor:

Very small footprint and overhead, battle-tested in real-world applications (which indicates that it’s pretty reliable) and well supported by several major companies. It’s also very good for people learning SQL due to its simplicity.

Puntos en contra:

Cannot handle very large datasets well. It’s not ideal for concurrently running or distributed software.

Sahil
Sahil
dot net developer en India
Usuario de Linkedin verificado
Tecnología y servicios de la información, 11-50 empleados
Ha utilizado el software durante: 1-5 meses
Fuente de la opinión

Sqllite

4,0 hace 6 años

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

Puntos a favor:

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.

Puntos en contra:

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

Nestor
Integration Engineer en El Salvador
Ha utilizado el software durante: 6-12 meses
Fuente de la opinión

When the small is really big.

5,0 hace 6 años

Puntos a favor:

It's fast, simple and fun. The learning curve is very comfortable. Although it is a small database it is capable of storage up to 2 terabytes of information.

Puntos en contra:

The tables are not related. The relationships are logical (We have to program this logic). There are no DATE type columns. This hinders operations between DATES.