Send Error Reports to the Google Error Reporting Service API
Send error reports to the Google Error Reporting service and view errors and assign error status in the Google Error Reporting user interface.
No Clocks
R - APIs
Powerful Classes for HTTP Requests and Responses
In order to facilitate parsing of http requests and creating appropriate responses this package provides two classes to handle a lot of the housekeeping involved in working with http exchanges. The infrastructure builds upon the rook specification and is thus well suited to be combined with httpuv based web servers.
Load data from a REST API | dlt Docs
How to extract data from a REST API using dlt's REST API source
Data Engineering
DatabasesDeclarative vs Versioned Workflows | Atlas | Manage your database schema as code
This section introduces two types of workflows that are supported by Atlas
Schema Change Management Tools
Here's a brief history of database schema migration and how modern, opensource solutions can be used so both Devs and Ops can work less and accomplish more.
A Look at PostgreSQL User-defined Data Types
This tutorial shows you how to create PostgreSQL user-defined data type using CREATE DOMAIN and CREATE TYPE statements.
PostgreSQL Generated Columns
In this tutorial, you will learn about PostgreSQL generated columns whose values are automatically calculated from other columns.
In PostgreSQL, a generated column is a special type of column whose values are automatically calculated based on expressions or values from other columns.
A generated column is referred to as a computed column in the SQL Server
or a virtual column in Oracle
.
There are two kinds of generated columns:
Stored: A stored generated column is calculated when it is inserted or updated and occupies storage space.
Virtual: A virtual generated column is computed when it is read and does not occupy storage space.
A virtual generated column is like a view, whereas a stored generated column is similar to a materialized view. Unlike a material view, PostgreSQL automatically updates data for stored generated columns.
PostgreSQL currently implements only stored generated columns.
PostgreSQL Sequences
In this tutorial, you will learn about the PostgreSQL sequences and how to use a sequence object to generate a sequence of numbers.
In PostgreSQL, a sequence is a database object that allows you to generate a sequence of unique integers.
Typically, you use a sequence to generate a unique identifier for a primary key in a table. Additionally, you can use a sequence to generate unique numbers across tables.
To create a new sequence, you use the CREATE SEQUENCE statement.
Listing all sequences in a database
To list all sequences in the current database, you use the following query:
SELECT
relname sequence_name
FROM
pg_class
WHERE
relkind = 'S';
PostgreSQL Identity Column
This tutorial shows you how to use the GENERATED AS IDENTITY constraint to create the PostgreSQL identity column for a table.
PostgreSQL version 10 introduced a new constraint GENERATED AS IDENTITY that allows you to automatically assign a unique number to a column.
The GENERATED AS IDENTITY constraint is the SQL standard-conforming variant of the good old SERIAL column.
The following illustrates the syntax of the GENERATED AS IDENTITY constraint:
column_name type
GENERATED { ALWAYS | BY DEFAULT }
AS IDENTITY[ ( sequence_option ) ]
In this syntax:
The type can be SMALLINT, INT, or BIGINT.
The GENERATED ALWAYS instructs PostgreSQL to always generate a value for the identity column. If you attempt to insert (or update) values into the GENERATED ALWAYS AS IDENTITY column, PostgreSQL will issue an error.
The GENERATED BY DEFAULT instructs PostgreSQL to generate a value for the identity column. However, if you supply a value for insert or update, PostgreSQL will use that value to insert into the identity column instead of using the system-generated value.
PostgreSQL allows a table to have more than one identity column. Like the SERIAL, the GENERATED AS IDENTITY constraint also uses the SEQUENCE object internally.
To fix the error, you can use the OVERRIDING SYSTEM VALUE clause as follows:
INSERT INTO color (color_id, color_name)
OVERRIDING SYSTEM VALUE
VALUES(2, 'Green');
Alternatively, you can use GENERATED BY DEFAULT AS IDENTITY instead.
Because the GENERATED AS IDENTITY constraint uses the SEQUENCE object, you can specify the sequence options for the system-generated values.
For example, you can specify the starting value and the increment as follows:
DROP TABLE color;
CREATE TABLE color (
color_id INT GENERATED BY DEFAULT AS IDENTITY
(START WITH 10 INCREMENT BY 10),
color_name VARCHAR NOT NULL
);
In this example, the system-generated value for the color_id column starts with 10 and the increment value is also 10.
Retrieval-Augmented Generation (RAG) Workflows
Provides tools for implementing Retrieval-Augmented Generation (RAG) workflows with Large Language Models (LLMs). Includes functions for document processing, text chunking, embedding generation, storage management, and content retrieval. Supports various document types and embedding providers (Ollama, OpenAI), with DuckDB as the default storage backend. Integrates with the ellmer package to equip chat objects with retrieval capabilities. Designed to offer both sensible defaults and customization options with transparent access to intermediate outputs.
R - Shiny
Claude MCP for Obsidian using Rest API
Hi Obsidian Community! https://github.com/PublikPrinciple/obsidian-mcp-rest I’m working on implementing an MCP (Model Context Protocol) server that integrates with Obsidian’s Local REST API plugin. The goal is to allow AI assistants like Claude to interact directly with Obsidian vaults in a secure, local manner. Project Overview GitHub Repository: GitHub - PublikPrinciple/obsidian-mcp-rest: An MCP server implementation for accessing Obsidian via local REST API Purpose: Enable AI assistants ...
Obsidian
Get Plugged In: How to Use Generative AI Tools in Obsidian
Two community-developed plug-ins highlight how the next generation of app developers can embrace large language models on RTX AI PCs.
How I Use Obsidian Right Now — Complete System, Plugins and Projects Insight • Fundamentalised by Theo Stowell
It was well over two years ago that I first found out about Obsidian now, and I can’t remember how it came to my attention either. All I remember was that I thought that this app would be a great solution for all clicking about between Notion, OneNote and more that I was doing. I
Generative AI beginner's guide | Google Cloud
Learn about generative AI workflows in Vertex AI, available models (including Gemini), and how to start building your generative AI app.
GCP
R Development Guide
A guide to R development.
R#r-development#r#r-package#github#r-package-devt#development#r-project#r-devguide#contributor-guide
Package-Wide Variables/Cache in R Packages | R-bloggers
It’s often beneficial to have a variable shared between all the functions in an R package. One obvious example would be the maintenance of a package-wide cache for all of your functions. I’ve encountered this situation multiple times and always forget at least one important step in the process, so I thought I’d document it [...]
Simple Arrays
Provides a toolkit for manipulating arrays in a consistent, powerful, and intuitive manner through the use of broadcasting and a new array class, the rray.
R Coding Style Best Practices - Datanovia
1 1Share This article describes the essentials of R coding style best practices. It’s based on the tidyverse style guide. Google’s current guide is also derived from the tidyverse style guide. […]
CodeConvert AI - Convert code with a click of a button
Convert code from one programming language to another in just a click of a button.
Chatgpt R-programming Prompts • PromptDen
Explore a curated collection of thought-provoking chatbot prompts designed for R-programming enthusiasts. Ignite your coding creativity!
Ambiorix
Web framework for the R programming language, inspired by express.js, allows building applications as well as APIs.
Capturing Screenshots Programmatically With R
As part of our work documenting R-Universe, we’re adding screenshots of the interface to the documentation website. Taking screenshots manually could quickly become very cumbersome, especially as we expect they’ll need updating in future: we might want to change the universes we feature, the interface might improve yet again and therefore look slightly different. Therefore, we decided to opt for a programmatic approach. In this post we shall present our learnings from using the R packages chromote and magick to produce screenshots.
How to webscrape in R?
Learn how to webscrape in R and use it to gather real data on the Internet.
Smoother Change Tracking and Versioning for R Packages
Streamlines the process of updating changelogs (NEWS.md) and versioning R packages developed in git repositories.
Display Idiomatic Code to Construct Most R Objects
Prints code that can be used to recreate R objects. In a sense it is similar to base::dput() or base::deparse() but constructive strives to use idiomatic constructors.