SQLite

As the logistics industry evolves, it requires advanced solutions to streamline operations and enhance efficiency. This case study explores the development of a truck tracker cum delivery services software built using React Native, RESTful APIs, and SQLite. The software caters to both drivers and management, providing features such as route mapping, delivery status updates, and real-time tracking. Objective The primary goal was to create a comprehensive logistics management tool that enables: Real-time truck tracking for management. Route optimization and navigation…

Introducing SQLite SQLite is a kind of open-source RDBMS that is distinguished from most other database management systems built on a client-server model since it is a server-less embedded database. This means that the SQLite database runs within the software that accesses the data, eliminating the need for a separate server. Due to such architecture, SQLite is a highly reliable, efficient system that works perfectly in low-memory environments. One of the major benefits of SQLite is its cross-platform compatibility, allowing…

Displaying tables in SQLite is important in database navigation and management. When working with databases, displaying the table helps you understand the database structure, especially when handling data with complex relationships. Unlike MySQL, which provides a straightforward SHOW TABLES command, SQLite does not have a direct table display method. However, SQLite offers several alternative methods to achieve the same result. In this tutorial, I will show you the different methods for showing tables in the SQLite database, including using the…

SQLite is one of the most popular relational database management systems (RDBMS). It’s lightweight, meaning that it doesn’t take up much space on your system. One of its best features is that it’s serverless, so you don’t need to install or manage a separate server to use it. Instead, it stores everything in a simple file on your computer. It also requires zero configuration, so there’s no complicated setup process, making it perfect for beginners and small projects. SQLite is…

In this guide, we explore a fascinating intersection between two popular technologies: JSON and SQLite. Knowing how to use JSON with SQLite is important in modern software development, especially when dealing with complex data structures that may not completely fit in a tabular structure. Whether you’re an experienced developer or an eager beginner to expand your knowledge, this tutorial will help you start learning how to use JSON in the SQLite database. Let’s get started! Empowering Modern Application Data Management…

In the prior article, Learning the Basics: How to Use JSON in SQLite, we dived into SQLite’s essential JSON functions and their capabilities. We explored the use of JSON as unstructured data within an SQLite database. Crucially, we detailed some of the necessary SQLite JSON functions, discussing their role in data storage and retrieval, followed by practical SQL query examples. This foundational understanding of how to work with JSON data in SQLite sets the stage for your advanced exploration of…

Python provides several modules for working with databases, including sqlite3, MySQLdb, and psycopg2. These modules allow easy database interaction to store, retrieve, and manipulate data efficiently. You can construct, change, and manage databases effectively and efficiently with a basic understanding of Python language and SQL syntax. Steps for Database Creation Using Python Step 1 Install a database adapter that matches the database management system you want to use. For example, if you are to use SQLite, you can install the…

The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Introduction In web applications, you usually need a database, which is an organized collection of data. You use a database to store and maintain persistent data that can be retrieved and manipulated efficiently. For example, in a social media application, you have a database where user data (personal information, posts, comments, followers) is stored in a way that can…

Introduction The relational data model, which organizes data in tables of rows and columns, predominates in database management tools. Today there are other data models, including NoSQL and NewSQL, but relational database management systems (RDBMSs) remain dominant for storing and managing data worldwide. This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it will explore the data types that each RDBMS uses, their advantages and disadvantages, and situations where they are…