In SQLite, creating a new database is simple because the database is just a single file. SQLite creates the database file automatically when you connect to a non-existent database. Here’s how you can ...

You should now have a file HOME\public_html\phpliteadmin.php Open phpliteadmin.php with a text editor, change the following: //password to gain access (change this to ...

When they need a relational database, software developers and system administrators often choose MySQL or PostgreSQL. For a lighter and simpler solution, however, developers should consider SQLite. It ...

PHP_Laravel12_With_SQLite is a beginner-friendly Laravel 12 CRUD project using SQLite as the database. This project demonstrates how to perform Create, Read, Update, and Delete (CRUD) operations on a ...

I recently published a tutorial describing the different available methods to store data locally in an Android app. However, due to article length constraints, I could not adequately cover creating ...

In my last article I wrote about accessing a PostgreSQL database in C/C++. In this article, I'm going to discuss performing the same functions in C against an SQLite database. Unlike Postgresql and ...

SQLite is suitable for apps that require reliable storage and small but frequent updates. DuckDB can handle large datasets and analytical SQL workloads efficiently. Matching database design to ...