What is SQLite?
What is SQLite?
SQLite is a transactional and relational SQL database engine developed in C and C++ that does not require any configuration.
SQLite is an open-source project and supports many programming languages.
It was first developed by D. Richard Hipp in August 2000, as the first version of SQLite to meet the database needs of a project in the US Navy.
Which Platforms Does it Support
It supports almost all platforms and their derivatives such as Linux, Mac, and Windows.
One reason for mentioning the derivatives is that it also works on mobile devices such as Android and iOS and can be used easily.
Therefore, you can easily use it in your projects.
Advantages and Disadvantages
Advantages
- No installation is required to use it.
- It does not require a central hub like a main server to store data.
- It is small in size. (512kb)
- As long as SQLite can read the disk file, it works. (It can even work from USB)
- Supports operating systems like Windows, Linux, Mac OS.
- Supports iPhone and Android devices.
- There are libraries for Python, C#, Node.js and many other languages.
- It is public domain software and there are no copyright or licensing fees.
- It is an open-source project.
- It is fast.
Disadvantages
- Concurrent write limitation.
- More limited than normal SQL engines.
- Security issues.
- No user-based usage restrictions.
Brands that Use It and Usage Areas
SQLite is used by many brands. Apple, Google, Microsoft...
If I need to give examples of SQLite usage areas, it is generally used to store personal data and user settings records in applications.
As an example, I can mention storing NPC information in games.
In addition, in small-scale projects, it can be used for quick prototyping according to needs.
Yorum Gönder