Plurrrr

Wed 26 Jan 2022

Micro C, Part 0: Introduction

In this series, we will explore how to write a compiler for a small subset of C to LLVM in Haskell. Our language, Micro C, is basically a small subset of real C. We'll have basic numeric types, a real bool type, pointers, and structs. At the end of the series, we'll have a beautiful executable, mcc (Micro C Compiler), that takes one .mc source file and produces an executable.

Source: Micro C, Part 0: Introduction, an article by Joseph Morag.

The fastest way to read a CSV in Pandas

You have a large CSV, you’re going to be reading it in to Pandas—but every time you load it, you have to wait for the CSV to load. And that slows down your development feedback loop, and might meaningfully slows down your production processing.

But it’s faster to read the data in faster. Let’s see how.

Source: The fastest way to read a CSV in Pandas, an article by Itamar Turner-Trauring.

Static Typing Python Decorators

Accurately static typing decorators in Python is an icky business. The wrapper function obfuscates type information required to statically determine the types of the parameters and the return values of the wrapped function.

Let's write a decorator that registers the decorated functions in a global dictionary during function definition time.

Source: Static Typing Python Decorators, an article by Redowan Delowar.

Creating a Postgres Foreign Data Wrapper

Here at DoltHub some of us have been working with PostgreSQL extensions recently. This is an introductory tutorial on how to get started building a PostgreSQL foreign data wrapper. We introduce the basics around setting up a project for building and installing the extension and how to implement a very basic read only scan.

Source: Creating a Postgres Foreign Data Wrapper, an article by Aaron Son.