Opiniones de SQLite

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,7
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 109 opiniones de usuarios de Capterra.

¿Has utilizado SQLite?

Comparte tu experiencia con otros compradores de software.

Filtrar opiniones (109)

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 reseña

Excelente base de datos de desarrollo

4,0 hace 3 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 reseña

Perfect database tool for embedded software

5,0 hace 4 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 reseña

Alternativas consideradas:

Power in the simplicity

5,0 el mes pasado Nuevo

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.

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 reseña

SQLite - compatability at it's best level

3,0 hace 4 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.

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 reseña

My SQLite Experience

5,0 hace 4 semanas Nuevo

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)

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 reseña

Alternativas consideradas:

An excellent database for mobile projects

4,0 el año pasado

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

Pablo
RPA Developer en España
Tecnología y servicios de la información, 5.001-10.000 empleados
Ha utilizado el software durante: Más de un año
Fuente de la reseña

My Own Experience working with SQLite

3,0 hace 4 años

Comentarios: My overall experience using SQLite is good, but it is based on small projects, always working locally and with little information. If you are thinking of working on large-volume information projects, I recommend other applications related to somewhat better, more visual databases, and with more functions to generate code and store queries or procedures.

Puntos a favor:

The best thing about SQLite is undoubtedly that you can work with it for free. In addition with SQLite we can perform any type of query that we would perform with another program.

Puntos en contra:

What I like least about SQLite is undoubtedly nothing visual. The way to work with SQLite is through the console, and this may seem silly, and when you are accustomed it may not matter, but for people who begin to familiarize themselves with database environments, it is really useful for tables, and which is done with them, be fully visible. When displaying results by console, unless you print them in an external table, such as an Excel workbook, it will be quite complicated to see and analyze large results (Tables over 10k rows for example)

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 reseña

Alternativas consideradas:

Readily-Available Database Solution, But With Significant Limitations

3,0 hace 3 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

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 reseña

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.

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 reseña

SQLite is a comprehensive open source platform

5,0 hace 7 meses

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.

Richard Aries
Software Programmer en Filipinas
Tecnología y servicios de la información, 2-10 empleados
Ha utilizado el software durante: Más de un año
Fuente de la reseña

An efficent and lightweight Database Management System!

5,0 hace 3 meses

Puntos a favor:

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!

Puntos en contra:

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.

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 reseña

A standard for testing

5,0 hace 4 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.

Usuario verificado
Usuario de Linkedin verificado
Tecnología y servicios de la información, 2-10 empleados
Ha utilizado el software durante: Más de un año
Fuente de la reseña

Great Database For Smaller Loads

5,0 hace 4 años

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

Puntos a favor:

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.

Puntos en contra:

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.

Steve
Programmer en Canadá
Fabricación de productos eléctricos/electrónicos, 11-50 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la reseña

Very good local database.

5,0 hace 11 meses

Puntos a favor:

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.

Puntos en contra:

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

Carl
Carl
Software Developer en RU
Software informático, Trabajador autónomo
Ha utilizado el software durante: Más de dos años
Fuente de la reseña

Great for simple persistent storage

5,0 hace 4 años

Puntos a favor:

SQLite is great because it is really easy to interface with a number of languages, my preference being C#. This allows me to create persistent storage for my applications or Unity games. SQLite is also great because it does not require an installation, either on the developers side nor the players side, it is a simple DLL which can be embedded into the application with ease. It also has great support with database management GUIs allowing me to debug the database very quickly.

Puntos en contra:

Off the top of my head, there are no glaring issues with SQLite. However it is important to know when a system like this is needed as opposed to another simple storage option such as XML/JSON etc.

Usuario verificado
Usuario de Linkedin verificado
Tecnología y servicios de la información, 11-50 empleados
Ha utilizado el software durante: Más de un año
Fuente de la reseña

A very efficient way to store certain kinds of data.

5,0 hace 4 años

Comentarios: We use it for storing certain data.

Puntos a favor:

You get all the benefits of using sql statements without having to set up a sql server online.

Puntos en contra:

SQL syntax varies between the different versions of sql so the syntax you are familiar with may or may not be available in sqlite.

ARIEL
President en Puerto Rico
, 2-10 empleados
Ha utilizado el software durante: 6-12 meses
Fuente de la reseña

Was easy to install and to install on customer machine

4,0 hace 5 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.

Filip
Big Data Developer II en Serbia
Tecnología y servicios de la información, 10.000+ empleados
Ha utilizado el software durante: Más de un año
Fuente de la reseña

Good way of storing your app data

4,0 hace 3 años

Comentarios: I'm extremely satisfied with the SQLite. I've used it to store my web app data, and it has been performing flawless ever since.

Puntos a favor:

It has great integrated features that are compatible with multiple languages. Ease of access and connection to the SQLite database are a big plus when working with data.

Puntos en contra:

It has some limitations when it comes to the size of the data your'e working with. It's not designed to store and manipulate large sets/chunks of data (big data).

Danoosh
Metadata Specialist en Canadá
Ha utilizado el software durante: Más de un año
Fuente de la reseña

A suitable light weight for small applications (and learning)

4,0 hace 5 años

Puntos a favor:

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

Puntos en contra:

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

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 reseña

Opnion

5,0 hace 5 meses

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.

Elcenir
Elcenir
Asistente Administrativo III en Venezuela
Usuario de Linkedin verificado
Ha utilizado el software durante: 1-5 meses
Fuente de la reseña

Lightweight, easy and powerful at the same time

4,0 hace 5 años

Comentarios: learn to consult views and functions in the tool

Puntos a favor:

is a lightweight and powerful database manager to store data from a web and mobile project, it is within relational databases, its installation is very simple, I use it to make simple querys of a project that I am currently carrying

Puntos en contra:

one more difficulty of software is of knowledge of the SQL language, since there are very complicated queries that I must do and sometimes the tool remains frozen and I have had to restart my machine

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 reseña

Very good for studying SQL, small projects and local storage

5,0 hace 3 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.

Barton
Data Analyst II en EE. UU.
Software informático, 51-200 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la reseña

My favorite file-based database

5,0 hace 3 años

Puntos a favor:

Reliable SQL relational database meets file-based database. Those cases where you need some modest relational data access, but don't need or can't accommodate a full RDBMS server instance. The small footprint and portability makes SQLite a great choice for small applications.

Puntos en contra:

Can't be as feature rich as a full blown server application. More of a trade-off than a con.

Nestor
Integration Engineer en El Salvador
Ha utilizado el software durante: 6-12 meses
Fuente de la reseña

When the small is really big.

5,0 hace 5 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.

Usuario verificado
Usuario de Linkedin verificado
Tecnología y servicios de la información, 51-200 empleados
Ha utilizado el software durante: 1-5 meses
Fuente de la reseña

SQLite is a good embedded database choice

4,0 hace 4 años

Puntos a favor:

I like how SQLite offer similar capabilities with full-pledged MSSQL. It runs traditional TSQL and it stays small in file size. It's very convenient to use and have so 3rd party management tools available.

Puntos en contra:

When the database gets large, say around 2 gigs, loading times can be a bit slow.