GavinRay97

Making Apache Calcite work in SQuirreL SQL Client

Recently I wanted to test some Calcite functionality, and thought it might be nice to use a GUI instead of sqlline. It turns out, it is:

I figured you could just use something like SquirreL, which lets you import arbitrary JDBC drivers. This was less straightforward than I thought.

GavinRay97

https://mail.openjdk.org/pipermail/valhalla-spec-observers/2023-May/002243.html

Design document on nullability and value types
Brian Goetz brian.goetz at oracle.com
Wed May 31 18:37:34 UTC 2023

As we've hinted at, we've made some progress refining the essential differences between primitive and reference types, which has enabled us

GavinRay97

# Makefile to compile and run Java sources manually
# because JDK 20 Valhalla support is not yet available in IntelliJ IDEA
JAVA_VERSION = 20
JAVAC = /home/user/downloads/jdk-20-vahalla-20-75/bin/javac
JAVA = /home/user/downloads/jdk-20-vahalla-20-75/bin/java

JAVA_COMPILE_OPTIONS = --enable-preview --release $(JAVA_VERSION)
JAVA_OPTIONS = --enable-preview

JAVA_MAIN_CLASS = org.example.Database

GavinRay97

The 4 things I wish Kotlin had (as a Kotlin + Java + Scala developer)

• Union types
• Collection literals, like Groovy:
• Native Tuples
• Destructuring-assignment and guards in pattern-matches for when:

Union types

GavinRay97

--[[
  @author Ilias-Timon Poulakis (FeedTheCat)
  @license MIT
  @version 1.8.0
  @provides [main=main,mediaexplorer] .
  @about Simple tuner utility for the reaper media explorer
  @changelog
    - Alt-click on a key now adds 'key' metadata (not automatic on MacOS)
    - Alt-click on the metadata icon now removes 'key' metadata
    - Improved FFT pitch detection algorithm (better harmonics detection)

GavinRay97

WASI_VERSION_FULL = 20.0
WASMTIME_DIR = ../third-party/wasmtime-dev-x86_64-linux-c-api
WASI_SDK_PATH = ./wasi-sdk-$(WASI_VERSION_FULL)

CC = clang++
WASM_CC = $(WASI_SDK_PATH)/bin/clang++ --sysroot=$(WASI_SDK_PATH)/share/wasi-sysroot

CFLAGS = -std=c++20 -I$(WASMTIME_DIR)/include -L$(WASMTIME_DIR)/lib
LIBS = -lwasmtime

GavinRay97

#include <cassert>
#include <cstddef>
#include <cstdint>
#include <cstring>
#include <optional>
#include <span>
#include <string>

// A write-ahead log is a log of all the operations that have been performed on the database.
struct LogEntryHeader

GavinRay97

Build a PostgreSQL Wire Protocol Server in Vanilla JDK 21

• Build a PostgreSQL Wire Protocol Server in Vanilla JDK 21
  • Outline
  • Introduction to the PostgreSQL Wire Protocol
  • Step 1: Doing The Simplest Thing That Could Possibly Work (TM)
    • Step 1.1 - Initial Server Skeleton
      • Connecting to the Server with psql
    • Step 1.2 - Responding to the SSL Negotiation message and the Startup Message
• Step 1.3 - Differentiating between the SSL/Authentication request, and Command messages

GavinRay97

val JDK_21_PATH = "/home/user/.sdkman/candidates/java/21.ea.6-open"

tasks.withType<org.jetbrains.kotlin.gradle.tasks.UsesKotlinJavaToolchain>().configureEach {
    kotlinJavaToolchain.jdk.use(JDK_21_PATH, JavaVersion.VERSION_21)
}

GavinRay97

// Compile with:
// $ /opt/gcc-latest/bin/g++ --std=c++2b -fmodules-ts  other-module.cxx example-module.cxx -o example

// Global module fragment where #includes can happen
module;
#include <iostream>

// first thing after the Global module fragment must be a module command
export module example;
import other_module;