18 års erfaring med å hjelpe bedrifter
velge bedre programvare

Hva er SQLite?

Åpen kilde-databasemotor som brukes av applikasjoner på grunn av den kompakte størrelsen, tverrplattformstabiliteten og den serverløse funksjonaliteten.

Hvem benytter SQLite?

Store bedrifter.

SQLite-programvare – 1
SQLite-programvare – 2
SQLite-programvare – 3

Er du usikker på SQLite? Sammenlign med et populært alternativ

SQLite

SQLite

4,4 (118)
6 000,00 USD
engangs
Gratisversjon
Gratis prøveperiode
18
Fant ingen integreringer
4,4 (118)
4,5 (118)
3,6 (118)
kontra
Startpris
Prisvalg
Funksjoner
Integreringer
Lett å bruke
Verdi for pengene
Kundeservice
0,00 USD
måned
Gratisversjon
Gratis prøveperiode
129
3
4,5 (69)
4,7 (69)
4,6 (69)
Grønne søyler viser det best rangerte produktet basert på gjennomsnittlig vurdering og antall anmeldelser.

Andre gode alternativer til SQLite

Baserow
Funksjoner med best vurdering
Adgangskontroller/-tillatelser
Administrasjon av datalagring
Flere prosjekter
SQL Complete
Funksjoner med best vurdering
Adgangskontroller/-tillatelser
Søk/filter
Tilpassede maler
MarkLogic
Funksjoner med best vurdering
Ingen funksjoner i dette produktet er vurdert av anmeldere.

Anmeldelser av SQLite

Gjennomsnittlig score

Samlet
4,4
Lett å bruke
4,4
Kundeservice
3,6
Funksjoner
4,1
Verdi for pengene
4,5

Anmeldelser etter størrelsen på bedriften (antall ansatte)

  • <50
  • 51-200
  • 201-1 000
  • >1 001

Finn anmeldelser etter vurdering

5
55%
4
36%
3
7%
2
2%
Shola
Shola
Internship i Nigeria
Verifisert LinkedIn-bruker
Økonomiske tjenester, 10 000+ ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

SQLite: The best Database ever

5,0 i fjor

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

Fordeler:

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.

Ulemper:

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

Verifisert anmelder
Verifisert LinkedIn-bruker
Datamaskin, programvare, 501–1 000 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

The best database management

5,0 for 10 måneder siden

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

Fordeler:

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.

Ulemper:

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

Verifisert anmelder
Verifisert LinkedIn-bruker
Markedsføring og reklame, 11–50 ansatte
Har brukt programvaren i: 1–5 måneder
Anmelderkilde

A useful, yet untidy tool

2,0 for 7 måneder siden

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

Fordeler:

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

Ulemper:

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

Jacek
DevOps Engineer i Spania
Informasjonsteknologi og -tjenester, 11–50 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Power in the simplicity

5,0 for 2 år siden

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

Fordeler:

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.

Ulemper:

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 i Den dominikanske republikk
Verifisert LinkedIn-bruker
Sykehus- og helsetjenester, 1 001–5 000 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

An excellent database for mobile projects

4,0 for 3 år siden

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

Fordeler:

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

Ulemper:

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

Pablo
RPA Developer i Spania
Informasjonsteknologi og -tjenester, 5 001–10 000 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

My Own Experience working with SQLite

3,0 for 5 år siden

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

Fordeler:

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.

Ulemper:

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 i USA
Verifisert LinkedIn-bruker
Informasjonstjenester, Selvstendig næringsdrivende
Har brukt programvaren i: 1–5 måneder
Anmelderkilde

Readily-Available Database Solution, But With Significant Limitations

3,0 for 5 år siden

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

Fordeler:

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

Ulemper:

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 i India
Datamaskin, programvare, Selvstendig næringsdrivende
Har brukt programvaren i: Gratis prøveperiode
Anmelderkilde

SQl lites is very helpful company

5,0 i fjor

Fordeler:

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

Ulemper:

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 i India
Verifisert LinkedIn-bruker
Informasjonsteknologi og -tjenester, 11–50 ansatte
Har brukt programvaren i: 6–12 måneder
Anmelderkilde

SQLite review

5,0 for 2 år siden

Fordeler:

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

Ulemper:

I don't dislike this software its perfect.

Chaya
Chaya
Trainee Software Engineer i Sri Lanka
Verifisert LinkedIn-bruker
Datamaskin, programvare, 51–200 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

SQLite - compatability at it's best level

3,0 for 6 år siden

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

Fordeler:

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.

Ulemper:

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 i Georgia
Regnskap, 1 001–5 000 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

Small business helper

4,0 i fjor

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

Fordeler:

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.

Ulemper:

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

barun
HR Specialist i Bangladesh
Byggebransjen, 501–1 000 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Opnion

5,0 for 2 år siden

Kommentarer: overall good software.

Fordeler:

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

Ulemper:

Sometimes interface of the software are difficult to understand.

merve
BUSINESS ANALYST i Tyrkia
Utdanningsadministrasjon, 51–200 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Excellent option for quick and light needs.

4,0 for 2 år siden

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

Fordeler:

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.

Ulemper:

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

Verifisert anmelder
Verifisert LinkedIn-bruker
Datamaskin, programvare, 11–50 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

The perfect landscape to train and test SQL

5,0 for 6 år siden

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

Fordeler:

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

Ulemper:

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 i Storbritannia
Datamaskin, programvare, Selvstendig næringsdrivende
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Great for simple persistent storage

5,0 for 6 år siden

Fordeler:

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.

Ulemper:

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.

Verifisert anmelder
Verifisert LinkedIn-bruker
Informasjonsteknologi og -tjenester, 2–10 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

Great Database For Smaller Loads

5,0 for 5 år siden

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

Fordeler:

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.

Ulemper:

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 i USA
Jernbaneproduksjon, 201–500 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

Self-contained

5,0 for 3 år siden

Kommentarer: Reliable

Fordeler:

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.

Ulemper:

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

Verifisert anmelder
Verifisert LinkedIn-bruker
Økonomiske tjenester, 10 000+ ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Depends on how you store your data

5,0 for 6 år siden

Fordeler:

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.

Ulemper:

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

Umut
Game Developer i Tyrkia
Verifisert LinkedIn-bruker
Underholdning, 11–50 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Fast Embedded database

5,0 for 4 år siden

Fordeler:

Compact Fast Easy to use Preinstalled in most platform

Ulemper:

Do not support nosql features Do not support multi client

Varun
Manufacturing Specialist i Canada
Byggebransjen, 51–200 ansatte
Har brukt programvaren i: Men enn 1 år
Anmelderkilde

Smooth and Reliable DBMS

4,0 for 3 år siden

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

Fordeler:

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.

Ulemper:

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

Denis
Denis
Ph.D. Student i Brasil
Forskning, Selvstendig næringsdrivende
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Very good for studying SQL, small projects and local storage

5,0 for 5 år siden

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

Fordeler:

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.

Ulemper:

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

Verifisert anmelder
Verifisert LinkedIn-bruker
Informasjonsteknologi og -tjenester, 51–200 ansatte
Har brukt programvaren i: 1–5 måneder
Anmelderkilde

SQLite is a good embedded database choice

4,0 for 6 år siden

Fordeler:

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.

Ulemper:

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

Zach
Director i USA
Datamaskin, nettverk, 10 000+ ansatte
Har brukt programvaren i: 6–12 måneder
Anmelderkilde

fast flexible database with robust features

4,0 for 5 år siden

Kommentarer: SQLite works great for our specific use case as we prefer performance over HA / concurrency.

Fordeler:

Extremely portable and fast ACID store. SQLite is very battle tested and highly performant. There are many bindings for various programming languages which makes it easy to get started with. If you couple SQLite with fast SSD, the performance is incredible (since it's just a file). Backup and restore is super easy and fast.

Ulemper:

SQLite is for a very specific use case and there are no distribution properties or guarantees. Designed to be very simple so not a lot of tuning for SQLite. If you want high availability and concurrency, you may want to look at a different solution.

Ali
Analyst i Spania
Informasjonsteknologi og -tjenester, 11–50 ansatte
Har brukt programvaren i: Mer enn 2 år
Anmelderkilde

Small, Fast And Efficient RDBMS

4,0 for 6 år siden

Fordeler:

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.

Ulemper:

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

Dennis
Software Engineer i Nord-Makedonia
Informasjonsteknologi og -tjenester, 51–200 ansatte
Har brukt programvaren i: 6–12 måneder
Anmelderkilde

Lightweight and easy to use.

5,0 for 6 år siden

Kommentarer: Perfect for small project and easy to setup.

Fordeler:

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

Ulemper:

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