{"id":12891,"date":"2021-01-20T20:55:53","date_gmt":"2021-01-21T01:55:53","guid":{"rendered":"https:\/\/panamahitek.com\/aprende-a-crear-bases-de-datos-sqlite\/"},"modified":"2021-03-27T18:48:11","modified_gmt":"2021-03-27T23:48:11","slug":"how-to-create-sqlite-databases","status":"publish","type":"post","link":"https:\/\/panamahitek.com\/en\/how-to-create-sqlite-databases\/","title":{"rendered":"How to create SQLite databases?"},"content":{"rendered":"

SQLite databases are a type of lightweight database that allows you to store, manage, and retrieve information using a command language with a syntax very similar to MySQL.\u00a0The main advantage of SQLite is that few resources are required to use it. The database consists of a file with a .db extension, in which all the information that we wish to store is stored.<\/p>\n

To create a database in SQLite, I recommend using a program called DB Browser for SQLite<\/strong>, which is available for free on Windows. This software can be downloaded at the following link: https:\/\/sqlitebrowser.org\/dl\/<\/a>.\u00a0Once downloaded and installed, we open it and we will have a simple and easy-to-use interface.<\/p>\n

\"\"<\/a>
Ventana principal del software DB Browser for SQLite<\/figcaption><\/figure>\n

To create a database, just click on “New Database”. A window will open in which we are asked to select a location and a name. This will be the location and name of the database, which is ultimately a single file. In my case I called my database “test.db”.<\/p>\n

After that a window appears in which we must specify the name of a table. Here I am assuming that I am going to create a table to store temperature data.<\/p>\n

\"\"<\/a><\/p>\n

SQL-based databases have tables, which are internal structures for storing data. It is like having an Excel file, where there can be multiple worksheets in one file. The file is equivalent to the database and the spreadsheets are equivalent to the tables.<\/p>\n

Each table has a name and several data fields. Data fields are like columns in a spreadsheet. These tables are where the records are stored, which is the equivalent of the rows on a spreadsheet.<\/p>\n

In my case I have created a table called “Temperatura<\/strong>” (see image). This table will have the following data fields: id<\/strong>, temp<\/strong>, and time<\/strong>. In id<\/strong> the identification of each record is stored, something that is customary in databases. This field will have the following characteristics: PK (primary key), AI (auto increment), U (unique).<\/p>\n

Below I proceed to describe these characteristics:<\/p>\n