1. Home
  2. Release Notes Agent V1.48
  3. 1. New Feature
  4. 1.5 Use SQLite for the Agent database and Move all file base configuration to SQLite

1.5 Use SQLite for the Agent database and Move all file base configuration to SQLite

[add-search-inside]

SQLite is a relational database management system based on the SQL language but optimized for use in small environments such as mobile phones or small applications. SQLite it is self-contained, serverless, zero-configuration and transactional. It is very fast and lightweight, and the entire database is stored in a single file. SQLite is built for simplicity and speed compared to a hosted client-server relational database such as MySQL. It sacrifices sophistication for utility and complexity for size. Queries in SQLite are almost identical to other SQL calls.

Before starting we would highly recommend all user to install DB Browser for SQLite. The browser can be downloaded from their official page easily. DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It will help us to see the databases being created and edited in real time.

Contents 

  • CONNECTING to a Database
  • CREATING a Table
  • INSERTING records in a TABLE
  • SELECTING records from the TABLE
  • UPDATING Records in the TABLE
  • DELETE Operation
  • Example walk trough
Fandest du diesen Artikel hilfreich? Ja Nein

Wie können wir helfen?