Computer Hacking - SQLite 2017 Features
SQLite
- SQLite is a software library that gives a relational database management system.
- The SQLite means light weight in relations of the setup in database management and essential source.
SQLite characteristics:
- SQLite does dynamic methods for the tables.
- It means that the user can store any value in any column, unrelatedly of the data type.
- SQLite permits a single database linking to access many database files concurrently.
- It fetches numerous features like joining tables in different databases or repetition data between databases in a single command.
- SQLite is skilled of generating in-memory databases which are very fast to work.
sqlite characteristics
SQLite Features:
- Self-contained
- Serverless
- Zero-configuration
- Transactional
Self-contained:
- The SQLite "self-contained" it means sqlite is very erratic dependencies.
- SQLite is a platform independent.
- SQLite do not hold any external libraries or interfaces additional than a rare standard C-library calls may use.
- The whole SQLite library is encapsulated in a single source code file that needs no special facilities or tools to build.
Serverless:
- SQLite is an serverless It means it does not require separate server process to operate.
- SQLite database is combined with the application that contacts the database.
- The applications relate with the SQLite database read and write straight from the database records to store on disk.
Zero-configuration:
- SQLite does not need to be "installed" before it is used.
- There is no "setup" procedure. There is no server process that needs to be started, stopped, or configured.
- There is no need for an administrator to create a new database instance or assign access permissions to users.
- SQLite uses no configuration files.
- Nothing needs to be done to tell the system that SQLite is running.
- No actions are required to recover after a system crash or power failure. There is nothing to troubleshoot.
Transactional:
- SQLite implements serializable transactions. They are
- Atomic
- Consistent
- Isolated
- Durable
- Even if the transaction is broken up by a program crash, an operating system crash, or a power failure to the computer.
SQLite requires:
- A negligible build of SQLite needs just these follows from the standard C library they are
- memcmp()
- memcpy()
- memmove()
- memset()
- strcmp()
- strlen()
- strncmp()
sqlite requires
- Record builds also use the system memory distribution practices:
- malloc()
- realloc()
- free()
- But those follows are optional can be omitted using a compile time operation.
- Default builds of SQLite hold suitable VFS objects for talking to fundamental operating system and those VFS objects.
- It contains operating system calls such as
- open()
- read()
- write()
- fsync()
- These interfaces are eagerly offered on most platforms and practice VFS can be planned to run SQLite on the fixed devices.
SQLite database objects:
Insert():
- To insert data is to execute a single SQL statement by execSQL()
Create():
- This will call automatically when the database not exist. It does not call any more if the database exists.
Update():
- If present version of the database is advanced than the old this method will be called to perform updating operations.
Delete():
- Delete() method is similar as update().
- Delete method is used to remove the records from the database.
sqlite database object