SQLite Erfahrungen

- Very lightweight database products that you can quickly set up to without needing to install complicated tooling so can be used in mobile forms or embedded devices.

- Does not support the full features of SQL
- SQLite does not have support for multi-client concurrency access and can't be used in applications that need this.
- Validation of data to input fields is limited

I love how SQLite is so portable, and can be used in different platforms. I doesn't need any bulky installation for me to use. It is so lightweight and there is no learning curve when you came from MS SQL.

Maybe when opening a large sqlite file around 1GB above, it hangs up and sometimes fails to load. But maybe that's my fault because SQLite is not intended for storing large data. Good product anyway.

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

I don't dislike this software its perfect.

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.

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.

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

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

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

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.

I like how easy it is to use SQLite. It allows us to have a database backend without the usual set up and configuration steps needed for more complex RDBMS.

I don't really have anything I dislike about SQLite. It does its job well on its intended use cases.

The fact that it requires no installation makes it suitable for a quick application setup. It's a very lightweight tool that makes it useable across many systems. SQLite does not require a separate location that can be on the same server location which makes the I/O processing really fast and reliable.

Due to the lightweight, there ought to be some restrictions one of them is that a large number of concurrent access might let to a system crash. One more issue is that is works with whole DB lock while performing a write operation so all the write operations are sequential.

I like how SQLite offer T-SQL despite of being a portable database. I can create moderately complex queries and still runs fine.

There's nothing I really don't like with SQLite. It's free and does the job.

Compact
Fast
Easy to use
Preinstalled in most platform

Do not support nosql features
Do not support multi client

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.

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

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.

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

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.

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.

It is quite easy to use with its well versed documentations. The database administration for SQLite is also particularly excellent. The installation and setup is very very easy quick.

SQLite cannot be used for large data requirements so one cannot use it for businness purposeswith high data availability

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

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

it's easy to use and doesn't get too much space on your system!

Maybe not a proper choice for very big projects! but great for practicing or small projects