Da 18 anni aiutiamo le aziende
a scegliere i migliori software

Cos'è SQLite?

Motore per database open source utilizzato dalle applicazioni per le sue dimensioni compatte, la stabilità multipiattaforma e le funzionalità senza server.

Chi utilizza SQLite?

Imprese di grandi dimensioni.

SQLite Software - 1
SQLite Software - 2
SQLite Software - 3

Hai dubbi su SQLite? Confrontalo con un'alternativa popolare

SQLite

SQLite

4,4 (118)
6.000,00 USD
una tantum
Versione gratuita
Prova gratuita
18
Nessuna integrazione trovata
4,4 (118)
4,5 (118)
3,6 (118)
VS.
Prezzo di partenza
Prezzi
Caratteristiche
Integrazioni
Facilità d'uso
Rapporto qualità-prezzo
Servizio clienti
Nessun prezzo trovato
Versione gratuita
Prova gratuita
30
3
4,5 (72)
4,8 (72)
4,2 (72)
Le barre di valutazione verdi mostrano il prodotto con il risultato migliore in base alla valutazione media e al numero di recensioni.

Altre alternative interessanti a SQLite

MariaDB
Funzionalità più votate
Backup e ripristino
Gestione dei servizi di storage
Supporto di più linguaggi di programmazione
MySQL
Funzionalità più votate
Archiviazione sicura dei dati
Backup e ripristino
Relational Database Management
Firebase
Funzionalità più votate
API
Creazione di report/analisi
Notifiche web
PostgreSQL
Funzionalità più votate
Backup e ripristino
Controllo accessi/Autorizzazioni
Gestione dei servizi di storage
Oracle Database
Funzionalità più votate
Backup e ripristino
Controllo accessi/Autorizzazioni
Gestione dei servizi di storage
Microsoft SQL Server
Funzionalità più votate
Analisi della performance
Backup e ripristino
Gestione dei servizi di storage
Microsoft Power BI
Funzionalità più votate
Creazione di report/analisi
Importazione/Esportazione di dati
Visualizzazione di dati
Google Cloud
Funzionalità più votate
Archiviazione sicura dei dati
Backup e ripristino
Gestione dei servizi di storage
Scaleway
Funzionalità più votate
Archiviazione sicura dei dati
Recupero dati
Supporto di più linguaggi di programmazione

Recensioni su SQLite

Punteggio medio

Nel complesso
4,4
Facilità d'uso
4,4
Servizio clienti
3,6
Caratteristiche
4,1
Rapporto qualità-prezzo
4,5

Recensioni per dimensioni dell'azienda (numero di dipendenti)

  • <50
  • 51-200
  • 201-1.000
  • >1.001

Trova recensioni per valutazione

5
55%
4
36%
3
7%
2
2%
Luigi
R and D Engineer (Italia)
Automazione industriale, 11-50 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Uno dei SW più efficienti per lo storage di dati

5,0 anno scorso

Aspetti positivi:

La sintassi SQL è abbastanza semplice da comprendere, quindi sarà facile creare codici per le proprie query. In più offre la possibilità di "scrivere" il codice mediante combinazioni di tasti.

Aspetti negativi:

Forse non è adatto a dataset estremamente complessi.

Utente Verificato
Utente LinkedIn Verificato
Servizi e tecnologie dell'informazione, 2-10 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

estremamente leggero e funzionale

5,0 2 anni fa

Aspetti positivi:

Utilissimo per applicazioni mobile, facile da utilizzare con comandi sql oppure con l'interfaccia DB Browser per Sql lite

Aspetti negativi:

non ci sono tutti i i tipi di dati che offrirebbe un DBMS come sql server, ma è una mancanza che per il 90% dei casi si può coprire utilizzando altri tipi.

Utente Verificato
Utente LinkedIn Verificato
Servizi e tecnologie dell'informazione, 11-50 dipendenti
Ha utilizzato il software per: 1-5 mesi
Fonte della recensione

Per DB leggeri

4,0 2 anni fa

Commenti: Buona per piccoli db, non per grandi aziende

Aspetti positivi:

Indicato per chi ha poche quantità di dati nel db, quindi uso domestico o piccole aziende.

Aspetti negativi:

Funzioni avanzate non disponibili, tipo PL/SQL

Shola
Shola
Internship (Nigeria)
Utente LinkedIn Verificato
Servizi finanziari, 10.000+ dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

SQLite: The best Database ever

5,0 anno scorso

Commenti: It is an excellent database as compared to others. I do not see any database competing with SQLite

Aspetti positivi:

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.

Aspetti negativi:

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

Utente Verificato
Utente LinkedIn Verificato
Software informatici, 501-1.000 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

The best database management

5,0 10 mesi fa

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

Aspetti positivi:

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.

Aspetti negativi:

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

Utente Verificato
Utente LinkedIn Verificato
Marketing e pubblicità, 11-50 dipendenti
Ha utilizzato il software per: 1-5 mesi
Fonte della recensione

A useful, yet untidy tool

2,0 7 mesi fa

Commenti: quick to deploy and simple to implement, although certain users may want to be aware of some UI and security concerns.

Aspetti positivi:

Very simple to use and undoubtedly reduces the amount of physical memory used

Aspetti negativi:

Some security issues and occasionally non-loading user interface parts make me doubt its reliability

Jacek
DevOps Engineer (Spagna)
Servizi e tecnologie dell'informazione, 11-50 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Alternative considerate:

Power in the simplicity

5,0 2 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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.

Jonathan Alexander
Jonathan Alexander
IT infrastructure analyst (Repubblica Dominicana)
Utente LinkedIn Verificato
Ospedali e sistemi sanitari, 1.001-5.000 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Alternative considerate:

An excellent database for mobile projects

4,0 3 anni fa

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

Aspetti positivi:

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

Aspetti negativi:

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

Pablo
RPA Developer (Spagna)
Servizi e tecnologie dell'informazione, 5.001-10.000 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

My Own Experience working with SQLite

3,0 5 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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 (USA)
Utente LinkedIn Verificato
Servizi di informazione, Lavoratore autonomo
Ha utilizzato il software per: 1-5 mesi
Fonte della recensione

Alternative considerate:

Readily-Available Database Solution, But With Significant Limitations

3,0 5 anni fa

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

Aspetti positivi:

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

Aspetti negativi:

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

Kshitij
N/A (India)
Software informatici, Lavoratore autonomo
Ha utilizzato il software per: Prova gratuita
Fonte della recensione

SQl lites is very helpful company

5,0 anno scorso

Aspetti positivi:

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

Aspetti negativi:

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

Dhruvil
Dhruvil
Web developer (India)
Utente LinkedIn Verificato
Servizi e tecnologie dell'informazione, 11-50 dipendenti
Ha utilizzato il software per: 6-12 mesi
Fonte della recensione

SQLite review

5,0 2 anni fa

Aspetti positivi:

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

Aspetti negativi:

I don't dislike this software its perfect.

Chaya
Chaya
Trainee Software Engineer (Sri Lanka)
Utente LinkedIn Verificato
Software informatici, 51-200 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

SQLite - compatability at it's best level

3,0 6 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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.

valerian
Support (Georgia)
Contabilità, 1.001-5.000 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

Small business helper

4,0 anno scorso

Commenti: Overall SQLite is good software in its field that can help greatly.

Aspetti positivi:

SQLite is suitable for small companies that doesn't have big databases. SQLite handles small data very easily. It doesn't load the computer. And is relatively easy to use.

Aspetti negativi:

As i mentioned SQLite is comfortable for small databases. But won't be affordable for large amount of data.

barun
HR Specialist (Bangladesh)
Industria edilizia, 501-1.000 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Opnion

5,0 2 anni fa

Commenti: overall good software.

Aspetti positivi:

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

Aspetti negativi:

Sometimes interface of the software are difficult to understand.

merve
BUSINESS ANALYST (Turchia)
Gestione formativa, 51-200 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Excellent option for quick and light needs.

4,0 2 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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

Utente Verificato
Utente LinkedIn Verificato
Software informatici, 11-50 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

The perfect landscape to train and test SQL

5,0 6 anni fa

Commenti: Integrates well with SQL learning tool. Followed many guides in my quest to learn SQL and almost all suggested SQLite. This is mostly for training and testing.

Aspetti positivi:

About as simple as it gets -- as the name suggests. Made learning SQL easy knowing I wouldn't be affecting my own database.

Aspetti negativi:

I truly enjoyed using the product although I never use it anymore. It sits dormant on my computer now that I have a grasp of SQL.

Carl
Carl
Software Developer (UK)
Software informatici, Lavoratore autonomo
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Great for simple persistent storage

5,0 6 anni fa

Aspetti positivi:

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.

Aspetti negativi:

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.

Utente Verificato
Utente LinkedIn Verificato
Servizi e tecnologie dell'informazione, 2-10 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

Great Database For Smaller Loads

5,0 5 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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.

Mahonri
Electrical Buyer (USA)
Costruzione di reti ferroviarie, 201-500 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

Self-contained

5,0 3 anni fa

Commenti: Reliable

Aspetti positivi:

This software is fast, reliable, and very useful for small and big projects. It's user-friendly and fast to learn. I like that it is an open-source SQL database engine. SQLite is very convenient because is an embedded and lightweight database engine and its tools are very easy to use.

Aspetti negativi:

SQLite is not a fit for large applications, it has its limitations. One of the reasons is that when you run a large amount of data, the speed of the queries could be slow

Utente Verificato
Utente LinkedIn Verificato
Servizi finanziari, 10.000+ dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Depends on how you store your data

5,0 6 anni fa

Aspetti positivi:

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.

Aspetti negativi:

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

Umut
Game Developer (Turchia)
Utente LinkedIn Verificato
Intrattenimento, 11-50 dipendenti
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Fast Embedded database

5,0 4 anni fa

Aspetti positivi:

Compact Fast Easy to use Preinstalled in most platform

Aspetti negativi:

Do not support nosql features Do not support multi client

Varun
Manufacturing Specialist (Canada)
Industria edilizia, 51-200 dipendenti
Ha utilizzato il software per: Più di 1 anno
Fonte della recensione

Smooth and Reliable DBMS

4,0 3 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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

Denis
Denis
Ph.D. Student (Brasile)
Ricerca, Lavoratore autonomo
Ha utilizzato il software per: Più di 2 anni
Fonte della recensione

Very good for studying SQL, small projects and local storage

5,0 5 anni fa

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

Aspetti positivi:

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.

Aspetti negativi:

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

Utente Verificato
Utente LinkedIn Verificato
Servizi e tecnologie dell'informazione, 51-200 dipendenti
Ha utilizzato il software per: 1-5 mesi
Fonte della recensione

SQLite is a good embedded database choice

4,0 6 anni fa

Aspetti positivi:

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.

Aspetti negativi:

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