Technology Tales

JavaScript HTML DOM

The HTML Document Object Model represents web pages as structured trees of nodes, enabling dynamic interaction through programming. When a browser loads an HTML document, it constructs a hierarchical tree where elements, attributes and text are represented as nodes, allowing scripts to access and modify content, style, or structure. JavaScript methods such as getElementById are commonly used to locate and alter elements, demonstrating how the DOM facilitates changes to web page components. This model, developed by standards bodies like the W3C, provides a language-independent framework for manipulating documents, forming the basis for modern web development practices.

Hugo's '.plain' Function Ignores Page Resources

When generating a JSON index for a Hugo site that incorporates Page Resources, the .plain function fails to include content from these resources, resulting in incomplete or empty entries in the index. This issue arises because .plain and similar methods like plainify only capture Markdown content directly on the page, ignoring additional text from associated Page Resources.

To address this, a workaround involves manually iterating through the Page Resources, extracting their titles and content and combining them with the main page's description and introductory text before including them in the index. This approach ensures that all relevant content is indexed for search functionality, though it requires custom template adjustments and may not be the most elegant solution. The process highlights the need for careful handling of content sources when using Page Resources in Hugo sites.

DM

The dm package in R provides a framework for managing and organising multiple data frames or database tables, enabling users to construct, manipulate and deploy relational data models efficiently. It offers a consistent set of tools for working with datasets, supporting dplyr-style operations alongside features such as visualisation of table relationships, automated join simplification and checks for data consistency and constraints.

Designed for both individual analysis and organisational use, dm facilitates the transition from in-memory datasets to large-scale relational databases, with deployment options to RDBMS systems. It can be installed from CRAN or GitHub and integrates seamlessly into existing workflows, allowing users to explore and refine complex data structures while ensuring accuracy through rigorous validation processes.

Connections

The connections package enhances database interaction in R by integrating DBI-compliant packages with the RStudio IDE’s Connection Pane, enabling users to manage database connections through a dedicated interface. It introduces functions such as connection_open and connection_close to establish and terminate connections, while also supporting dplyr operations like tbl and copy_to for working with database tables. Additionally, it extends compatibility with the pins package, allowing users to pin database connections and dplyr queries for reuse, with functions like connection_pin_write and connection_pin_read to save and retrieve these objects. Examples demonstrate its use with databases such as BigQuery and PostgreSQL, and it provides tools to refresh or view existing DBI connections outside its own opening functions.

DBI

The DBI package in R provides a standardised interface for connecting to database management systems, separating the connection process into front-end and back-end components. It supports operations such as establishing connections, executing queries, retrieving results, handling errors, managing transactions and accessing metadata, with implementations available through various backends like RPostgres, RSQLite and odbc.

Installation is typically automatic when using specific database packages, though it can be manually installed from CRAN or GitHub. An example demonstrates creating an in-memory SQLite database, writing and reading data and fetching query results in chunks. The package defines core classes including DBIDriver, DBIConnection and DBIResult, which are extended by individual backends to facilitate interaction with different databases.

Tidyverts

The tidyverts project offers a suite of R packages designed to bring tidy data principles to time series analysis. The core package, tsibble, provides temporal data frames and associated tools, while fable handles tidy forecasting and feasts focuses on feature extraction and statistics. Supporting these are tsibbledata, which supplies diverse datasets formatted for use with tsibble, along with additional packages including fable.prophet, which interfaces with the prophet forecaster, fable.binary for forecasting binary time series and tsibbletalk for producing interactive crosstalk graphics.

Pillow is a Python Imaging Library fork designed to extend image processing capabilities within Python, offering support for multiple file formats, efficient data handling and tools for image manipulation.

Plumber

The plumber package in R enables the creation of web APIs by adding roxygen2-like comments to existing R code, allowing functions to be exposed as endpoints through HTTP methods such as GET and POST. Parameters from query strings or JSON payloads are passed to functions as character strings, with examples demonstrating echo, histogram generation and arithmetic operations.

Documentation for Visual Studio Code

Visual Studio Code is a versatile code editor offering extensive documentation, tutorials and AI-assisted coding through GitHub Copilot, supporting multiple programming languages such as Python, JavaScript and Java. It integrates features like debugging, testing, version control and remote development environments, while a vast marketplace of extensions enhances functionality. The editor automatically updates and collects usage data by default, with options to disable these features and provides community support, forums and resources for troubleshooting and feature requests.

Working with GitHub in VS Code

Visual Studio Code offers extensive integration with GitHub, enabling users to manage repositories, create and review pull requests and work on issues directly within the editor. Key features include setting up authentication through the GitHub Pull Requests and Issues extension, cloning repositories and using the GitHub Repositories extension to browse and edit remote files without local cloning.

Editor enhancements such as hover previews and context-based suggestions streamline workflows, while the ability to switch branches and manage changes across development environments ensures flexibility. Users can also create pull requests, collaborate on issues and leverage tools like the Remote Explorer for accessing previously opened repositories. Additional support includes options to transition to local development or cloud-based environments, ensuring seamless continuation of work across different setups.