DB Browser for SQLite for Microsoft Windows systems

DB Browser for SQLite provides a data base management system (DBMS) for SQLite databases on a variety of operating systems. It is available for Microsoft Windows operating systems—there is even a portable application version that does not have to be installed, but instead can be run from a USB flash drive. The software is also available for macOS—see DB Browser for SQLite on OS X— and Linux systems. SQLIte itself is a relational database management system (RDBMS) available for a variety of operating systems. SQLite is freely available under a public domain license and DB Browser for SQLite is also freely available under a GNU General Public License (GPL). DB Browser for SQLite provides the underlying SQLite software, so you don't need to install SQLite on a system prior to installng DB Browser for SQLite.

[More Info]

[/software/database/sqlite/db_browser] permanent link

Creating a list that is expandable and collapsible in HTML5

If you wish to make a list that can be collapsed and expanded on a webpage or a section on the page that can be expanded to reveal more details, you can use the details and summary tags with version 5 of HTML. E.g., the following code allows information to be displayed or hidden by clicking on an arrowhead that will appear to the left of whatever appears within the summary tags. The information within the details tag will be hidden or displayed by clicking on the arrowhead to toggle between the two options.

<details>
<summary>Overview</summary>
The American Civil War began on April 12, 1865 when South Carolina
militia forces attacked Fort Sumter at Charleston, South Carolina. 
The war effectively ended on April 9, 1865 with the surrender by
Confederate General Robert E. Lee to Union General Ulysses S. Grant, but
the president of the Confederacy, Jefferson Davis, did not declare an
end to the insurrection until May 9, 1865. Each side in the
conflict suffered over 800,000 casualties. The principal cause of the
conflict was the issue of slavery within the United States with abolitionists
in the North viewing the practice as a crime against humanity while Southern
slave owners viewed it as a necessary evil or, for some defenders of slavery,
even as a positive good, which they feared would be eliminated under the
recently elected President Abraham Lincoln.
</details>

[More Info]

[/network/web/html] permanent link

Iterating over a PHP associative array by key

The PHP scripting language provides associative arrays that allow one to associate a key in the array to a value; each key in the array must be unique. E.g., I can create an array of United States presidents that uses the presidents' names as the keys and their political party affiliation as the value for each key. I could then iterate through the array by key and show the corresponding value for each key as in the example PHP code.

[/languages/php] permanent link