examples_insert.sql

-- ============================================================
-- Plan9Basic Examples — INSERT script (97 rows)
-- Run in phpMyAdmin or via MySQL CLI
-- ============================================================

INSERT INTO `plan9basic_examples`
    (`name`, `filename`, `description`, `download_path`, `category`, `level`, `tags`, `featured`, `sort_order`)
VALUES
-- ── 01–25: Core libraries & utilities ────────────────────────
('StdLib Test', 'stdlib_test.bas', 'Demonstrates core standard library functions including pause, sign, and format settings retrieval.', 'https://plan9basic.com/assets/examples/stdlib_test.bas', 'Basics', 1, 'stdlib,pause,sign,format', 0, 10),
('StrLib Test', 'strlib_test.bas', 'Exercises the string library covering case conversion, trimming, substrings, character codes, number bases, and search functions.', 'https://plan9basic.com/assets/examples/strlib_test.bas', 'Strings', 1, 'strings,strlib,trim,substring,search', 0, 20),
('NumLib Test', 'numlib_test.bas', 'Covers the numeric library including rounding, trigonometry, hyperbolic functions, logarithms, random numbers, and angle conversion.', 'https://plan9basic.com/assets/examples/numlib_test.bas', 'Numbers', 1, 'math,numlib,trig,logarithm,random', 0, 30),
('DateTimeLib Test', 'datetimelib_test.bas', 'Tests all date and time functions including component extraction, date arithmetic, differences, leap year checks, and formatting.', 'https://plan9basic.com/assets/examples/datetimelib_test.bas', 'DateTime', 1, 'datetime,date,time,arithmetic,format', 0, 40),
('PlatformInfo Test', 'platforminfolib_test.bas', 'Queries operating system information such as platform name, architecture, version numbers, and version compatibility checks.', 'https://plan9basic.com/assets/examples/platforminfolib_test.bas', 'Utilities', 1, 'platform,os,system,version', 0, 50),
('SysLib Test', 'syslib_test.bas', 'Demonstrates system library functions for retrieving standard paths, path separators, file path manipulation, environment variables, and command-line parameters.', 'https://plan9basic.com/assets/examples/syslib_test.bas', 'Utilities', 1, 'syslib,paths,filesystem,environment', 0, 60),
('Digital Clock', 'digital_clock.bas', 'Displays a live digital clock that ticks every second for ten iterations, showing the current date, time, day of week, and day-of-year information.', 'https://plan9basic.com/assets/examples/digital_clock.bas', 'DateTime', 1, 'clock,datetime,loop,pause', 0, 70),
('Calculator Demo', 'calculator.bas', 'Performs basic arithmetic, advanced math (square root, logarithm, exponent), trigonometry, and rounding operations on two sample values.', 'https://plan9basic.com/assets/examples/calculator.bas', 'Numbers', 1, 'math,calculator,arithmetic,trig,rounding', 1, 80),
('Text Statistics', 'text_statistics.bas', 'Analyzes a sample string by computing length, case conversions, substrings, search results, reversal, and in-place replacement.', 'https://plan9basic.com/assets/examples/text_statistics.bas', 'Strings', 1, 'strings,analysis,search,replace,statistics', 0, 90),
('System Info Report', 'system_info.bas', 'Generates a comprehensive report combining OS details, current date and time, leap-year status, system paths, and command-line parameters.', 'https://plan9basic.com/assets/examples/system_info.bas', 'Utilities', 1, 'system,os,datetime,paths,report', 1, 100),
('String Formatter Demo', 'string_formatter.bas', 'Demonstrates text-alignment functions (ltab$, rtab$, lfill$, rfill$), multi-base number formatting, and string multiplication to produce formatted tables.', 'https://plan9basic.com/assets/examples/string_formatter.bas', 'Strings', 2, 'strings,formatting,alignment,padding,hex,binary', 0, 110),
('Guess the Number Game', 'number_game.bas', 'Simulates a classic number-guessing game using DATA/READ statements for pre-set guesses, then displays random number statistics including dice rolls.', 'https://plan9basic.com/assets/examples/number_game.bas', 'Basics', 1, 'game,random,loop,data,if', 1, 120),
('Age Calculator', 'age_calculator.bas', 'Calculates ages in years, months, weeks, and days for sample birth dates, and lists the number of days in each month of the current year.', 'https://plan9basic.com/assets/examples/age_calculator.bas', 'DateTime', 1, 'datetime,age,date arithmetic,leap year', 0, 130),
('Comprehensive Library Test', 'comprehensive_test.bas', 'Exercises all six built-in libraries (StdLib, StrLib, NumLib, DateTimeLib, PlatformInfoLib, SysLib) in a single applet to verify their core functions.', 'https://plan9basic.com/assets/examples/comprehensive_test.bas', 'Basics', 2, 'stdlib,strlib,numlib,datetime,platform,syslib', 0, 140),
('Math Functions Demo', 'math_demo.bas', 'Showcases the full numeric library with trig tables, inverse and hyperbolic functions, power and root operations, logarithms, rounding comparison, and value comparison.', 'https://plan9basic.com/assets/examples/math_demo.bas', 'Numbers', 2, 'math,trig,logarithm,rounding,hyperbolic', 1, 150),
('DO...LOOP Test', 'do_loop_test.bas', 'Tests all DO...LOOP variants including DO WHILE, DO UNTIL, post-condition forms, nested loops, BREAK, CONTINUE, and practical examples such as factorial and series summation.', 'https://plan9basic.com/assets/examples/do_loop_test.bas', 'Basics', 1, 'loop,do while,do until,break,continue,nested', 0, 160),
('StrLib Improved Test', 'test_strlib_improved.bas', 'Validates newer string library additions such as trim$, instr with start position, single-char left$/right$, hex$ with digit count, stri$, space$, string$, and bounds checking.', 'https://plan9basic.com/assets/examples/test_strlib_improved.bas', 'Strings', 2, 'strings,strlib,instr,trim,hex,padding,test suite', 0, 170),
('JSON Library Test', 'json_test.bas', 'Comprehensive test of the JSON library covering object and array literals, variable embedding, nested structures, path navigation, type checking, modification, cloning, merging, and JSON parsing.', 'https://plan9basic.com/assets/examples/json_test.bas', 'JSON', 2, 'json,parse,stringify,objects,arrays,path', 1, 180),
('RegexLib Tests', 'RegexLib_Tests.bas', 'Full test suite for the regular-expression library covering validation, basic matching, find/search, find-all, replace, split, capture groups, and pattern escaping across 28 functions.', 'https://plan9basic.com/assets/examples/RegexLib_Tests.bas', 'Regex', 3, 'regex,match,replace,split,groups,validation', 0, 190),
('Base64 Quick Test', 'Base64_quick_test.bas', 'Performs a rapid sanity check of Base64 encoding and decoding, including standard round-trip, RFC 4648 known value, URL-safe encoding, validation, and error handling.', 'https://plan9basic.com/assets/examples/Base64_quick_test.bas', 'Utilities', 1, 'base64,encode,decode,url-safe,validation', 0, 200),
('Base64Lib Tests', 'Base64Lib_tests.bas', 'Exhaustive Base64 test suite covering encoding edge cases, padding variants, round-trip tests, URL-safe encode/decode, error codes, file operations, and RFC 4648 test vectors.', 'https://plan9basic.com/assets/examples/Base64Lib_tests.bas', 'Utilities', 2, 'base64,encode,decode,rfc4648,file,url-safe', 0, 210),
('ZipLib Test Suite', 'test_ziplib.bas', 'Tests the ZIP library with archive creation and opening, adding files and string content, reading archive metadata, extracting individual and all files, and edge-case handling.', 'https://plan9basic.com/assets/examples/test_ziplib.bas', 'Compression', 3, 'zip,compress,archive,extract,file', 0, 220),
('GzipLib Test Suite', 'test_gziplib.bas', 'Validates GZIP string and file compression functions including round-trip integrity, compression levels, Unicode handling, ratio measurement, and file-based compress/decompress operations.', 'https://plan9basic.com/assets/examples/test_gziplib.bas', 'Compression', 3, 'gzip,compress,decompress,file,unicode', 0, 230),
('DictLib Tests', 'DictLib_Tests.bas', 'Tests all three dictionary types (numeric, string, pointer) covering creation, get/set with defaults, key existence, enumeration, removal, clearing, overwriting, method chaining, and nested dictionaries.', 'https://plan9basic.com/assets/examples/DictLib_Tests.bas', 'Data Structures', 2, 'dictionary,dict,key-value,pointer,string,numeric', 0, 240),
('ArrayLib Tests', 'ArrayLib_Tests.bas', 'Validates the dynamic array library for numeric, string, and pointer arrays across 1D through 4D dimensions, testing creation, get/set, 1-based indexing, type safety, large arrays, and edge cases.', 'https://plan9basic.com/assets/examples/ArrayLib_Tests.bas', 'Data Structures', 2, 'arrays,dim,multi-dimensional,pointer,string,numeric', 0, 250),

-- ── 26–50: Networking & UI controls ──────────────────────────
('HttpLib Quick Test', 'HttpLib_QuickTest.bas', 'A minimal validation suite that quickly tests all core HttpLib operations including GET, POST, PUT, DELETE, Basic Auth, query parameters, custom headers, form data, and URL encoding.', 'https://plan9basic.com/assets/examples/HttpLib_QuickTest.bas', 'HTTP/Networking', 2, 'http,get,post,auth,testing', 0, 260),
('HttpLib Full Test Suite', 'HttpLib_Tests.bas', 'A comprehensive 22-test suite covering all HttpLib features including all HTTP methods, authentication schemes, cookies, response headers, timeouts, URL/HTML encoding, and error handling.', 'https://plan9basic.com/assets/examples/HttpLib_Tests.bas', 'HTTP/Networking', 3, 'http,get,post,put,delete,patch,auth,cookies,headers', 1, 270),
('HttpLib Methods Test', 'HttpLib_MethodsTest.bas', 'Tests all HTTP methods (GET, POST, PUT, DELETE, PATCH, HEAD) with sequential requests, response header inspection, delayed requests, and error handling using the synchronous API.', 'https://plan9basic.com/assets/examples/HttpLib_MethodsTest.bas', 'HTTP/Networking', 2, 'http,get,post,put,delete,patch,head', 0, 280),
('HttpLib Simple Test', 'HttpLib_SimpleTest.bas', 'A straightforward walkthrough of creating an HTTP client, making GET and POST requests, inspecting response details, and testing URL encoding with step-by-step console output.', 'https://plan9basic.com/assets/examples/HttpLib_SimpleTest.bas', 'HTTP/Networking', 1, 'http,get,post,beginner', 0, 290),
('HttpLib Debug Test', 'HttpLib_DebugTest.bas', 'A minimal HTTP debug snippet that creates a client, makes a single GET request, and prints the response length to verify the engine is working correctly.', 'https://plan9basic.com/assets/examples/HttpLib_DebugTest.bas', 'HTTP/Networking', 1, 'http,debug,get', 0, 300),
('FormLib Test Suite', 'FormLib_Tests.bas', 'A thorough test suite validating all FormLib functions including form creation, position, size, border styles, window states, transparency, visibility, modal results, screen info, and event callbacks.', 'https://plan9basic.com/assets/examples/FormLib_Tests.bas', 'UI Controls', 2, 'form,window,testing,events', 0, 310),
('LayoutLib Test Suite', 'LayoutLib_Test.bas', 'Validates all LayoutLib functions covering layout creation, parent-child management, position and size, alignment, margins, padding, visibility, opacity, and event callbacks.', 'https://plan9basic.com/assets/examples/LayoutLib_Test.bas', 'Layout', 2, 'layout,alignment,margins,padding,testing', 0, 320),
('RectangleLib Test Suite', 'RectangleLib_Test.bas', 'Comprehensive test suite for RectangleLib covering rectangle creation, fill and stroke styling, corner radius, selective sides and corners flags, rotation, opacity, and event callbacks.', 'https://plan9basic.com/assets/examples/RectangleLib_Test.bas', 'Drawing', 2, 'rectangle,fill,stroke,testing,events', 0, 330),
('RectangleLib Visual Demo', 'RectangleLib_Demo.bas', 'An interactive visual showcase of rectangle capabilities including fill colors, corner rounding, stroke styles, opacity levels, rotation, selective sides, card shadows, an animated progress bar, and hover effects.', 'https://plan9basic.com/assets/examples/RectangleLib_Demo.bas', 'Drawing', 2, 'rectangle,animation,interactive,colors,opacity,rotation', 1, 340),
('LabelLib Visual Demo', 'LabelLib_Demo.bas', 'A rich visual demo of label capabilities including font sizes, styles (bold, italic, underline), text colors, alignment, word wrap, rotated labels, opacity, interactive clickable links, and an animated counter.', 'https://plan9basic.com/assets/examples/LabelLib_Demo.bas', 'UI Controls', 2, 'label,font,animation,interactive,colors,alignment', 1, 350),
('LabelLib Test Suite', 'LabelLib_Test.bas', 'Validates all LabelLib functions including label creation, text content, font properties (size, family, color, bold, italic, underline, strikeout), alignment, word wrap, auto-size, visibility, rotation, and events.', 'https://plan9basic.com/assets/examples/LabelLib_Test.bas', 'UI Controls', 2, 'label,font,testing,events', 0, 360),
('Label Text Color Change', 'LabelLib_Text_Color_Change.bas', 'A minimal interactive demo showing a clickable label that cycles through six text colors on each click, demonstrating dynamic font color changes and click event handling.', 'https://plan9basic.com/assets/examples/LabelLib_Text_Color_Change.bas', 'UI Controls', 1, 'label,color,interactive,events,beginner', 0, 370),
('EditLib Examples', 'editlib_examples.bas', 'Five practical edit field examples demonstrating a live search box, a simple calculator, a password field with strength feedback, font style variations, and character-restricted input fields.', 'https://plan9basic.com/assets/examples/editlib_examples.bas', 'UI Controls', 2, 'edit,input,password,validation,events', 0, 380),
('EditLib Test Suite', 'test_editlib.bas', 'A comprehensive EditLib test applet covering edit creation, text content, placeholder, password mode, read-only mode, font properties, text alignment, character filtering, selection, caret, events, and mobile keyboard types.', 'https://plan9basic.com/assets/examples/test_editlib.bas', 'UI Controls', 2, 'edit,input,testing,events,mobile', 0, 390),
('MemoLib Examples', 'memolib_examples.bas', 'Five practical multi-line text editor examples including a simple text editor with status bar, a read-only log viewer, a code editor, styled notes with font variations, and a text alignment demo.', 'https://plan9basic.com/assets/examples/memolib_examples.bas', 'UI Controls', 2, 'memo,multiline,editor,font,alignment', 0, 400),
('MemoLib Test Suite', 'test_memolib.bas', 'A comprehensive MemoLib test applet validating memo creation, text content, line operations (add, insert, modify, delete), word wrap, scroll bars, font properties, read-only mode, selection, caret, and events.', 'https://plan9basic.com/assets/examples/test_memolib.bas', 'UI Controls', 2, 'memo,multiline,testing,events,lines', 0, 410),
('ButtonLib Basic Tests', 'test_buttonlib_basic.bas', 'Validates ButtonLib covering button creation with various constructors, text content, position, size, visibility, enabled state, opacity, tag, tab order, focus, hit test, alignment, margins, parent, z-order, and error handling.', 'https://plan9basic.com/assets/examples/test_buttonlib_basic.bas', 'UI Controls', 2, 'button,testing,events,margins,alignment', 0, 420),
('SpeedButton Toolbar Demo', 'demo_speedbutton_toolbar.bas', 'A practical text editor toolbar demo using SpeedButtons for independent bold/italic/underline toggles, mutually exclusive alignment and font-size groups, and action buttons that control a memo control.', 'https://plan9basic.com/assets/examples/demo_speedbutton_toolbar.bas', 'UI Controls', 2, 'speedbutton,toolbar,toggle,interactive,memo', 1, 430),
('SpeedButtonLib Test Suite', 'test_speedbuttonlib.bas', 'Validates all SpeedButtonLib functions including creation, text, font properties, group index, stays-pressed, down state, position, size, visibility, tag, alignment, margins, hit test, drag mode, parent, and event callbacks.', 'https://plan9basic.com/assets/examples/test_speedbuttonlib.bas', 'UI Controls', 2, 'speedbutton,testing,events,groupindex', 0, 440),
('ComboBox & ListBox Demo', 'demo_combobox_listbox.bas', 'An interactive demo with two combo boxes for color and size selection and a dual-listbox transfer UI where items can be moved between available and selected lists, with add and remove buttons.', 'https://plan9basic.com/assets/examples/demo_combobox_listbox.bas', 'UI Controls', 2, 'combobox,listbox,interactive,selection,events', 0, 450),
('ComboBox & ListBox Test Suite', 'test_combobox_listbox.bas', 'Validates ComboBoxLib and ListBoxLib covering creation, item management (add, insert, delete, modify, clear), selection, multi-select, properties, event callbacks, ListBoxItem helpers, and error handling.', 'https://plan9basic.com/assets/examples/test_combobox_listbox.bas', 'UI Controls', 2, 'combobox,listbox,testing,multiselect,events', 0, 460),
('CheckBox Demo', 'demo_checkbox.bas', 'An interactive demo showing text formatting checkboxes (bold, italic, underline) that update a live sample label, a master "Enable All" checkbox that controls feature sub-checkboxes, and reset/state-display buttons.', 'https://plan9basic.com/assets/examples/demo_checkbox.bas', 'UI Controls', 1, 'checkbox,interactive,formatting,events', 0, 470),
('CheckBox Test Suite', 'test_checkbox.bas', 'Validates all CheckBoxLib functions including creation, checked state, text, properties, font styling, position, alignment, margins, visibility, focus, tab order, all event callbacks, and drag-and-drop events.', 'https://plan9basic.com/assets/examples/test_checkbox.bas', 'UI Controls', 2, 'checkbox,testing,events,dragdrop', 0, 480),
('RadioButtonLib Test Suite', 'RadioButtonLib_Test.bas', 'An interactive RadioButtonLib test applet featuring grouped radio buttons for color and size selection, independent buttons, automated tests for creation, group names, mutual exclusion, font properties, and error handling.', 'https://plan9basic.com/assets/examples/RadioButtonLib_Test.bas', 'UI Controls', 2, 'radiobutton,groupname,mutualexclusion,testing,events', 0, 490),
('PanelLib Test Suite', 'PanelLib_test.bas', 'Validates all PanelLib functions including panel creation, position, size, alignment, margins, padding, visibility, opacity, clip children, hit test, locking, tag, parent-child management, z-order, event callbacks, and error handling.', 'https://plan9basic.com/assets/examples/PanelLib_test.bas', 'Layout', 2, 'panel,layout,testing,events,childmanagement', 0, 500),

-- ── 51–75: Drawing, images & animation ───────────────────────
('CircleLib Test Suite', 'CircleLib_Tests.bas', 'Comprehensive test suite covering all 72 CircleLib functions including creation, fill, stroke, position, visibility, events, and error handling, with an interactive hover color-change demo.', 'https://plan9basic.com/assets/examples/CircleLib_Tests.bas', 'Drawing', 2, 'circle,drawing,testing,events', 0, 510),
('RoundRectLib Test Suite', 'RoundRectLib_Tests.bas', 'Comprehensive test suite for all 73 RoundRectLib functions covering rounded rectangles with selectable corners, fill, stroke, position, visibility, and interactive mouse events.', 'https://plan9basic.com/assets/examples/RoundRectLib_Tests.bas', 'Drawing', 2, 'roundrect,drawing,testing,events', 0, 520),
('EllipseLib Test Suite', 'EllipseLib_Tests.bas', 'Comprehensive test suite for all 72 EllipseLib functions covering ellipse creation, fill, stroke, position, rotation, visibility, and interactive click and hover events.', 'https://plan9basic.com/assets/examples/EllipseLib_Tests.bas', 'Drawing', 2, 'ellipse,drawing,testing,events', 0, 530),
('ArcLib Test Suite', 'ArcLib_Tests.bas', 'Comprehensive test suite for all 77 ArcLib functions including start/end angle control, fill, stroke, position, and an interactive Pac-Man style arc that toggles its mouth on click.', 'https://plan9basic.com/assets/examples/ArcLib_Tests.bas', 'Drawing', 2, 'arc,drawing,testing,angles,events', 0, 540),
('PieLib Test Suite', 'PieLib_Tests.bas', 'Comprehensive test suite for all 78 PieLib functions covering pie slice creation with configurable start/end angles, stroke styles, and an interactive Pac-Man pie that animates its mouth on click.', 'https://plan9basic.com/assets/examples/PieLib_Tests.bas', 'Drawing', 2, 'pie,drawing,testing,angles,events', 0, 550),
('LineLib Test Suite', 'LineLib_Tests.bas', 'Comprehensive test suite for all 72 LineLib functions covering diagonal, horizontal, and vertical line types with stroke styles, dash patterns, round caps, rotation, and interactive click events.', 'https://plan9basic.com/assets/examples/LineLib_Tests.bas', 'Drawing', 2, 'line,drawing,testing,stroke,events', 0, 560),
('CalloutRectangleLib Test Suite', 'CalloutRectangleLib_Tests.bas', 'Comprehensive test suite for all 90 CalloutRectangleLib functions covering speech bubble shapes with configurable callout position, length, width, offset, corner radius, and interactive events.', 'https://plan9basic.com/assets/examples/CalloutRectangleLib_Tests.bas', 'Drawing', 2, 'callout,speech-bubble,drawing,testing,events', 0, 570),
('PathLib Test Suite', 'PathLib_Tests.bas', 'Comprehensive test suite for all 105 PathLib functions covering SVG path data strings, programmatic path construction (MoveTo, LineTo, Bezier curves), helper shapes, transformations, wrap modes, and an interactive clickable star.', 'https://plan9basic.com/assets/examples/PathLib_Tests.bas', 'Drawing', 3, 'path,svg,bezier,drawing,testing,events', 0, 580),
('ImageLib Test Suite', 'ImageLib_Tests.bas', 'Comprehensive test suite for all 85 ImageLib functions covering image creation, wrap modes, position, visibility, events, and live web image loading from Lorem Picsum with an interactive rotating image demo.', 'https://plan9basic.com/assets/examples/ImageLib_Tests.bas', 'Images', 2, 'image,bitmap,web,testing,events', 0, 590),
('Web Image Gallery', 'ImageLib_WebGallery_Demo.bas', 'Demonstrates loading images from the web using ImageLib by building an 8-thumbnail gallery powered by Lorem Picsum. Click any thumbnail to display it full-size with opacity hover effects.', 'https://plan9basic.com/assets/examples/ImageLib_WebGallery_Demo.bas', 'Images', 2, 'image,gallery,web,http,picsum', 1, 600),
('Chuck Norris Facts', 'ChuckNorrisFacts_Demo.bas', 'A full-featured dark-themed app that fetches Chuck Norris jokes from a live REST API, demonstrating HTTP requests, JSON parsing, ComboBox category selection, and multi-library UI composition.', 'https://plan9basic.com/assets/examples/ChuckNorrisFacts_Demo.bas', 'HTTP/Networking', 2, 'http,json,api,combobox,ui,demo', 1, 610),
('SwitchLib Diagnostic', 'SwitchLib_Diagnostic.bas', 'Minimal diagnostic test verifying switch controls toggle correctly both with and without an event callback attached. Useful for understanding basic SwitchLib behaviour.', 'https://plan9basic.com/assets/examples/SwitchLib_Diagnostic.bas', 'UI Controls', 1, 'switch,toggle,diagnostic,testing', 0, 620),
('SwitchLib Settings Panel', 'SwitchLib_Example.bas', 'Builds a realistic settings panel with five labelled toggle switches supporting Enable All, Disable All, and Toggle All bulk operations with live status tracking.', 'https://plan9basic.com/assets/examples/SwitchLib_Example.bas', 'UI Controls', 1, 'switch,toggle,settings,panel,ui', 0, 630),
('SwitchLib Simple Example', 'SwitchLib_Simple_Example.bas', 'Minimal example showing how to create a single switch control and respond to its toggle event to update a status label.', 'https://plan9basic.com/assets/examples/SwitchLib_Simple_Example.bas', 'UI Controls', 1, 'switch,toggle,beginner,events', 0, 640),
('StringGrid Demo', 'StringGrid_Demo.bas', 'Product inventory demo showcasing StringGrid with String, Checkbox, Currency, Progress, Popup, and Date column types, plus editing, alternating row colors, and add/delete row operations.', 'https://plan9basic.com/assets/examples/StringGrid_Demo.bas', 'UI Controls', 2, 'stringgrid,grid,table,columns,inventory', 1, 650),
('StringGrid New Features Demo', 'StringGrid_NewFeatures_Demo.bas', 'Demonstrates StringGrid 1.1.0 features including row insert/delete/swap, alpha and numeric column sorting, clipboard copy/paste, column alignment, and CSV import/export.', 'https://plan9basic.com/assets/examples/StringGrid_NewFeatures_Demo.bas', 'UI Controls', 2, 'stringgrid,sort,csv,clipboard,grid', 0, 660),
('Basic Float Animation', 'Animations_Test01_BasicFloatAnimation.bas', 'Demonstrates float property animations on a rectangle including fade in/out (Opacity), horizontal movement (Position.X), and grow/shrink (Width, Height) with Quadratic, Cubic, and Elastic interpolation.', 'https://plan9basic.com/assets/examples/Animations_Test01_BasicFloatAnimation.bas', 'Animation', 1, 'animation,float,opacity,movement,interpolation', 0, 670),
('Interpolation Types Demo', 'Animations_Test03_InterpolationTypes.bas', 'Visually compares all eight float animation interpolation types (Linear, Quadratic, Cubic, Sinusoidal, Elastic, Back, Bounce, Exponential) by racing eight coloured balls across the screen simultaneously.', 'https://plan9basic.com/assets/examples/Animations_Test03_InterpolationTypes.bas', 'Animation', 1, 'animation,interpolation,easing,comparison', 1, 680),
('Color Animation Demo', 'Animations_Test02_ColorAnimation.bas', 'Demonstrates color property animations including single-shot color transitions on Fill and Stroke, looping pulse effects with AutoReverse, and simultaneous multi-rectangle color animations.', 'https://plan9basic.com/assets/examples/Animations_Test02_ColorAnimation.bas', 'Animation', 1, 'animation,color,fill,stroke,pulse', 0, 690),
('Sequential Animations Demo', 'Animations_Test04_SequentialAnimations.bas', 'Demonstrates chaining animations using OnFinish callbacks to build complex sequences: a four-step square path traverse, a bounce-squash-stretch-flash sequence, and a simultaneous fade-and-move transition.', 'https://plan9basic.com/assets/examples/Animations_Test04_SequentialAnimations.bas', 'Animation', 2, 'animation,sequence,chaining,callbacks,float', 0, 700),
('Animation Progress Tracking', 'Animations_Test05_OnProcessProgress.bas', 'Shows how to use the OnProcess callback to track animation progress in real time, updating a custom progress bar and percentage label as a circle traverses the screen over five seconds.', 'https://plan9basic.com/assets/examples/Animations_Test05_OnProcessProgress.bas', 'Animation', 2, 'animation,progress,onprocess,callback,float', 0, 710),
('Comprehensive Animation Demo', 'Animations_Test06_ComprehensiveDemo.bas', 'A practical gallery of six real-world animation effects: button press scale, pulsing loading indicator, fade-in toast notification with auto-dismiss, sliding panel, looping color cycle, and bouncing ball.', 'https://plan9basic.com/assets/examples/Animations_Test06_ComprehensiveDemo.bas', 'Animation', 2, 'animation,ui,effects,toast,bounce,color,loading', 0, 720),
('Bitmap List (Sprite Sheet) Animation', 'Animations_test_bitmaplistanimation.bas', 'Demonstrates sprite sheet animation with three modes: looping playback, ping-pong AutoReverse, and single play-once. Requires external sprite sheet PNG files loaded at runtime.', 'https://plan9basic.com/assets/examples/Animations_test_bitmaplistanimation.bas', 'Animation', 2, 'animation,sprite,spritesheet,bitmap,loop', 0, 730),
('Path Animation Demo', 'Animations_test_pathanimation.bas', 'Animates objects along SVG path curves using pathani: an S-curve looping red ball, a figure-eight ping-pong blue ball, a square-path bouncing ellipse, and a rotating arrow that follows a curved path.', 'https://plan9basic.com/assets/examples/Animations_test_pathanimation.bas', 'Animation', 2, 'animation,path,svg,bezier,rotation,loop', 0, 740),
('Rectangle Bounds Animation', 'Animations_test_rectanimation.bas', 'Demonstrates rectani bounds animations: auto-reversing move-and-resize, bounce-interpolated expand/collapse triggered by button, elastic pulsing ellipse, and a Back-interpolated window open/close effect.', 'https://plan9basic.com/assets/examples/Animations_test_rectanimation.bas', 'Animation', 2, 'animation,rect,bounds,elastic,bounce,back', 0, 750),

-- ── 76–97: Effects, transitions & database ───────────────────
('Blur Effect Library Test', 'BlurEffectLib_Test.bas', 'Comprehensive test suite for the Blur Effect Library, covering creation, softness, enabled, trigger, error handling, nil pointer safety, and multiple effect instances, with an interactive cycle and animated blur demo.', 'https://plan9basic.com/assets/examples/BlurEffectLib_Test.bas', 'Effects', 2, 'blur,effects,animation,testing', 0, 760),
('Effects Showcase Demo', 'Effects_Showcase_Demo.bas', 'Interactive showcase demonstrating blur, shadow, and glow effects applied to controls, with animated transitions, color pickers, and a neon button gallery.', 'https://plan9basic.com/assets/examples/Effects_Showcase_Demo.bas', 'Effects', 1, 'blur,shadow,glow,effects,animation', 1, 770),
('Reflection Effect Library Test', 'ReflectionEffectLib_Test.bas', 'Tests and demonstrates the Reflection Effect Library, allowing interactive adjustment of length, opacity, and offset, with hover-triggered and animated reflection examples.', 'https://plan9basic.com/assets/examples/ReflectionEffectLib_Test.bas', 'Effects', 2, 'reflection,effects,animation,testing', 0, 780),
('Monochrome Effect Library Test', 'MonochromeEffectLib_Test.bas', 'Tests and demonstrates the Monochrome Effect Library, showing grayscale conversion of controls with hover-triggered and gallery examples including a disabled-state simulation.', 'https://plan9basic.com/assets/examples/MonochromeEffectLib_Test.bas', 'Effects', 1, 'monochrome,grayscale,effects,testing', 0, 790),
('ColorKey Alpha Effect Test', 'ColorKeyAlphaEffectLib_Test.bas', 'Demonstrates the ColorKey Alpha Effect for green-screen-style transparency, with adjustable target color and tolerance and a multi-rectangle gallery showing selective color removal.', 'https://plan9basic.com/assets/examples/ColorKeyAlphaEffectLib_Test.bas', 'Effects', 2, 'colorkey,alpha,transparency,effects,testing', 0, 800),
('Inner Glow Effect Library Test', 'InnerGlowEffectLib_Test.bas', 'Tests and demonstrates the Inner Glow Effect Library with interactive color, softness, and opacity controls, a pulsing animation, and a focus-triggered glow example.', 'https://plan9basic.com/assets/examples/InnerGlowEffectLib_Test.bas', 'Effects', 2, 'innerglow,glow,effects,animation,testing', 0, 810),
('Bevel Effect Library Test', 'BevelEffectLib_Test.bas', 'Tests and demonstrates the Bevel Effect Library, showing 3D raised and sunken appearances with adjustable direction and size, including a rotating light animation.', 'https://plan9basic.com/assets/examples/BevelEffectLib_Test.bas', 'Effects', 2, 'bevel,3d,effects,animation,testing', 0, 820),
('Tier 2 Color Effects Test', 'Tier2_ColorEffects_Test.bas', 'Demonstrates four Tier-2 color adjustment effects — Contrast, HueAdjust, Sepia, and Invert — applied to colored rectangles with animated and gallery comparisons.', 'https://plan9basic.com/assets/examples/Tier2_ColorEffects_Test.bas', 'Effects', 2, 'contrast,hue,sepia,invert,color,effects', 0, 830),
('Tier 3 Artistic Effects Test', 'Tier3_ArtisticEffects_Test.bas', 'Demonstrates six artistic image effects — Emboss, Pixelate, Toon, Sharpen, PaperSketch, and PencilStroke — applied to web images with interactive controls and comparison galleries.', 'https://plan9basic.com/assets/examples/Tier3_ArtisticEffects_Test.bas', 'Effects', 2, 'emboss,pixelate,toon,sharpen,sketch,effects,images', 1, 840),
('Tier 4 Distortion Effects Test', 'Tier4_DistortionEffects_Test.bas', 'Demonstrates six distortion effects — Wave, Swirl, Ripple, Magnify, Bands, and Wrap — applied to web images with animated controls and comparison galleries.', 'https://plan9basic.com/assets/examples/Tier4_DistortionEffects_Test.bas', 'Effects', 3, 'wave,swirl,ripple,magnify,distortion,effects,images', 0, 850),
('Blind Transition Effect Test', 'BlindTransitionTest.bas', 'Tests the Blind Transition Effect, demonstrating a venetian-blind wipe between two web images with adjustable progress percentage and blind count.', 'https://plan9basic.com/assets/examples/BlindTransitionTest.bas', 'Transitions', 2, 'blind,transition,effects,images', 0, 860),
('Swipe Effect Interactive Test', 'SwipeEffectInteractiveTest.bas', 'Interactive page-turn swipe transition driven by live mouse position over an image, with adjustable fold depth and preset positions demonstrating pixel-coordinate mouse tracking.', 'https://plan9basic.com/assets/examples/SwipeEffectInteractiveTest.bas', 'Transitions', 2, 'swipe,pageturn,transition,effects,mouse,interactive', 1, 870),
('Tier 6 Transition Effects Gallery', 'Tier6TransitionEffectsTest.bas', 'Gallery of 17 transition effects — including BandedSwirl, Blood, Blur, Crumple, Ripple, Swirl, and Wiggle — with a trackbar-controlled progress slider and one-click animation.', 'https://plan9basic.com/assets/examples/Tier6TransitionEffectsTest.bas', 'Transitions', 3, 'transition,effects,gallery,animation,images', 1, 880),
('Tier 7 Blur Effects Gallery', 'Tier7BlurEffectsTest.bas', 'Gallery of four advanced blur effects — BoxBlur, GaussianBlur, DirectionalBlur, and RadialBlur — applied to a web image with a trackbar-controlled blur amount and animated sweep.', 'https://plan9basic.com/assets/examples/Tier7BlurEffectsTest.bas', 'Effects', 2, 'boxblur,gaussianblur,directionalblur,radialblur,effects,images', 0, 890),
('Light Effects Test', 'LightEffectsTest.bas', 'Demonstrates Bloom and Gloom light effects on a web image, with trackbar controls for effect intensity, base intensity, and saturation.', 'https://plan9basic.com/assets/examples/LightEffectsTest.bas', 'Effects', 2, 'bloom,gloom,light,effects,images', 0, 900),
('Transform Effects Gallery', 'TransformEffectsTest.bas', 'Gallery of four image transform effects — Affine, Perspective, Crop, and Tiler — with four property sliders that adapt to each effect for interactive exploration.', 'https://plan9basic.com/assets/examples/TransformEffectsTest.bas', 'Effects', 3, 'affine,perspective,crop,tiler,transform,effects,images', 0, 910),
('Fill and Special Effects Gallery', 'FillSpecialEffectsTest.bas', 'Gallery of seven special effects — Fill, FillRGB, MaskToAlpha, SmoothMagnify, Pinch, BandedSwirl, and Blend — with adaptive property sliders and a two-image blend demonstration.', 'https://plan9basic.com/assets/examples/FillSpecialEffectsTest.bas', 'Effects', 3, 'fill,magnify,pinch,swirl,blend,effects,images', 0, 920),
('Monochrome Effect Diagnostic', 'monochrome_test.bas', 'Diagnostic test comparing the monochrome grayscale effect across three control types — TImage, TRectangle, and TButton — to illustrate which controls support pixel-shader effects.', 'https://plan9basic.com/assets/examples/monochrome_test.bas', 'Effects', 2, 'monochrome,grayscale,effects,testing,diagnostic', 0, 930),
('SQLite Basic Operations', 'sqlite_example1_basic.bas', 'Introduces SQLite database usage with create, insert, query, update, and delete operations on a notes table, demonstrating prepared statements and JSON parameter binding.', 'https://plan9basic.com/assets/examples/sqlite_example1_basic.bas', 'Database', 1, 'sqlite,database,crud,sql,json', 0, 940),
('SQLite JSON Integration', 'sqlite_example2_json.bas', 'Demonstrates deep SQLite and JSON integration: inserting rows from JSON objects, fetching results as JSON arrays, grouping queries, and updating records with JSON parameters.', 'https://plan9basic.com/assets/examples/sqlite_example2_json.bas', 'Database', 2, 'sqlite,database,json,sql,query', 0, 950),
('SQLite Transactions and Introspection', 'sqlite_example3_transactions.bas', 'Shows SQLite transaction management with a banking transfer scenario — including begin, commit, and rollback — plus schema introspection to list tables and columns programmatically.', 'https://plan9basic.com/assets/examples/sqlite_example3_transactions.bas', 'Database', 2, 'sqlite,database,transactions,sql,schema', 0, 960),
('SQLite Address Book Application', 'sqlite_example4_addressbook.bas', 'A complete address book application built on SQLite with full CRUD, full-text search, JSON and CSV export/import, indexed queries, and per-city statistics.', 'https://plan9basic.com/assets/examples/sqlite_example4_addressbook.bas', 'Database', 3, 'sqlite,database,addressbook,crud,json,csv,search', 0, 970)
;