Item: SQLite
Rating: 8
Author: Manidipa Kundu

Overall Satisfaction with SQLite

Use Cases and Deployment Scope

We use SQLite to store local data as it has zero maintenance deployment. Since it is lightweight, embedded database , has high performance without a dedicated server. we are running relational database server (like PostgreSQL or MySQL) so SQLite add no unnecessary complexity.The business problems we are solving with SQLite as it can use as offline tool. It is really fast to setup as a software. High performance for single-user or embedded workloads since it easily compatible with windows or mac os.
scope of our use case includes storing intermediate data during ETL process. we use it for light analytics for operation dashboards.

Pros and Cons

Pros

It basically work well on offline mode , easily syncs to backend file when connectivity restored.
SQLite provides transactional safety, even on unreliable devices like mobile phones and Raspberry Pis.
It provides fast reads & reliable writes.
easy to setup on various operating system.

Cons

it misses advanced SQL features.
its not suitable for big-data or high-throughput workflows.
Schema integrations can be more hectic than in PostgreSQL or MySQL.

Return on Investment

we had major cost savings while using it.
faster deployment helps with our productivity.
it increase our reliability for offline work.
Reduced ROI due to scalability and concurrency limitations

Usability

I have given this rating cause its irreplaceable in some of the areas like no more installation need except from a single library. I find dialect is simple in use cases. its suitable for any professionals with various skill levels. its easily connect with various os and devices. very less maintenance or administration required.

Alternatives Considered

DuckDB and PostgreSQL

PostgreSQL is more advanced features then SQLite, however it needs a server and complexity is high for low level development work. for offline work SQLite is best. DuckDB is great for analytics , it is the data base for analytics and better then SQLite for analytical purpose. however other areas like rapid transaction its not quite suitable.

Key Insights

Do you think SQLite delivers good value for the price?

Yes

Are you happy with SQLite's feature set?

Yes

Did SQLite live up to sales and marketing promises?

Yes

Did implementation of SQLite go as expected?

Yes

Would you buy SQLite again?

Yes

Other Software Used

PostgreSQL, Doodle, Asana

Likelihood to Recommend

I would rate SQLite an 8 out of 10, since its really good in some of the areas like Local/offline data base storage, low-concurrency workflows like Prototyping, scripting, automation etc. It has Zero-maintenance deployments which is suitable for general sql related functions. however its not suitable for project work where complex sql functions are needed. its not suitable for multiuse or Large-scale production databases.

Comments

Please log in to join the conversation

Review On SQLite