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 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 characteristics

          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 characteristics

                    sqlite database object


                    Related Searches to Computer Hacking - SQLite 2017 Features