Alexander Bezverkhniy alex-bezverkhniy

🧠 BigQuery ML Cheat Sheet

📌 Basics

BigQuery ML allows you to create and execute machine learning models directly in BigQuery using SQL syntax.

📊 Create a Model

AI-Based Real-Time Anomaly Detection System: Study Plan

Question to ChatGPT: Can you recommend a study plan to build AI-based real-time detection of anomalies

Building an AI-based real-time anomaly detection system requires a solid foundation in machine learning (ML), data engineering, and real-time systems architecture. Below is a comprehensive study plan to guide you through the learning process.

1. Understand the Basics of Machine Learning (2-3 months)

CodeQL Learning Plan

Stage 1: Introduction to CodeQL Basics

Goal: Understand the core concepts of CodeQL, how it works, and its basic functionalities.

1.1. Understand CodeQL Overview

Task: Read through the GitHub CodeQL documentation and understand what CodeQL is and how it fits into the software development lifecycle.
Topics:
- What is CodeQL?
How does CodeQL work (turning code into a database)?

Terraform Basics

What is Terraform?

Terraform is a tool for creating, changing, and deleting infrastructure as code. It is a tool for creating and managing infrastructure resources on cloud providers.

Tutorial - Create a simple Terraform project

[Draft] How to evolve tutorial project into real world app

Photo by Eugene Zhyvchik - unsplash.com

Introduction

It is always hard to break the wall and move away from writing tutorial projects and create "real world application".
I went through this process every time in my career when I learned new programming language or framework and started using it using it for real world project.

Set array value via expression-driven dependency injection - `@Value`

import org.springframework.beans.factory.annotation.Value;
...
    @Value("${client.contextPaths:com.myapp.defaultmodel}")
    protected String[] contextPaths;

Comma separated values in .yml file application.yml

	import uvicorn as uvicorn
	from pydantic import BaseModel
	from fastapi import FastAPI
	from fastapi_crudrouter import MemoryCRUDRouter as CRUDRouter

	class Potato(BaseModel):
	id: int
	color: str
	mass: float

	package main

	import (
	"crypto/aes"
	"crypto/cipher"
	"crypto/rand"
	b64 "encoding/base64"
	"errors"
	"fmt"
	"os"

	struct Solution;

	impl Solution {
	// [2, 7, 11, 15] t = 9
	// [3, 4, 2] t = 6
	fn two_sum(nums: Vec<i32>, target: i32) -> Vec<i32> {
	let mut j = 0;

	for (i, &num) in nums.iter().enumerate() {
	if i > 0 {


	[
	{
	"number": 1,
	"title": "What is the supreme law of the land?",
	"answers": ["the Constitution"]
	},
	{
	"number": 2,
	"title": "What does the Constitution do?",