SQLite Case Statements

This discussed the basic syntax of case statements and SQLite case statement. SQLite case expressions execute a list of conditions and return an expression.

SQLite SELECT DISTINCT Statement

A guide on using the SQLite “SELECT DISTINCT” statement to delete duplicate entries from the data set by inserting data and using the “SELECT” query.

How to Install and Use SQLite on Ubuntu 20.04

This guide shows you how to install SQLite and how to get started using this lightweight database by using the SQLite Browser database GUI application.
The post How to Install and Use SQLite on Ubuntu 20.04 appeared first on Linux Today.

digiKam 7.4 Professional Photo Management App Release

Coming five months after digiKam 7.3, the digiKam 7.4 release is here with a new tool that lets users share items on the network with a Motion JPEG stream server, as well as an improved Showfoto component that received a new left sidebar. This can host a folder-view to help users quickly explore images from […]

The post digiKam 7.4 Professional Photo Management App Release appeared first on Linux Today.

SQLite 3.37 Lightweight Database Comes Packed with New Features

SQLite 3.37 just got better with new features such as CLI enhancements and additional interfaces. The biggest new feature in this release is support for STRICT tables.
The post SQLite 3.37 Lightweight Database Comes Packed with New Features appeared fi…

How to Install SQLite and SQLite Browser in Ubuntu

The post How to Install SQLite and SQLite Browser in Ubuntu first appeared on Tecmint: Linux Howtos, Tutorials & Guides .SQLite is a lightweight, small and self-contained RDBMS in a C library. Popular databases like MySql, PostgreSQL, etc. works in the…