Sometimes, you need to store more complex data in your app than just simple key/value pairs saved with a text file or Shared Preferences. Databases are ideal for storing complex data structures and ...

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

Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI. The article How to know if the Auto Date ...

SQLite can run using a single storage file, which is a normal file on the local disk. You can use this local version for simple storage when you don’t require the ...

Microsoft now provides five different methods for creating tables: the Graphic Grid, Insert Table, Draw Table, insert a new or existing Excel Spreadsheet table, and Quick Tables, plus an option for ...

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

In this third and final installment on using SQLite from C++, I want to begin exploring some of the internals of this amazing little database engine. SQLite does things quite differently than most ...

The SQLite database is a wildly successful and ubiquitous software package that is mostly unknown to the larger IT community. Designed and coded by Dr. Richard Hipp, the third major revision of SQLite ...