We’re launching Lyria 3.5 in Google Flow Music, with advances across musicality, lyrics, vocals, and creative control
deepmind.google·6d ago
AI Engineering
Hacker News·Jul 3·5 min read
Hacker News·Jul 3·5 min readCommodore 64 Basic for PostgreSQL
TL;DR
Many programmers have nostalgic memories of using Commodore 64 BASIC, but its limitations hinder modern applications. PL/CBMBASIC is a procedural language extension that allows PostgreSQL to execute actual Commodore 64 BASIC V2 code.
✦ Why It Matters
Engineers can leverage PL/CBMBASIC to integrate nostalgic BASIC code into modern PostgreSQL applications efficiently.
Key Takeaways
- Explore using PL/CBMBASIC for legacy BASIC code in PostgreSQL.
- Understand the performance benefits of executing BASIC functions in-memory.
- Utilize the unique line number requirement for function arguments.
- Consider the implications of variable naming conventions from BASIC.
Full Summary
Commodore 64 BASIC was a beloved programming language, but its constraints limited its use in contemporary software development. PL/CBMBASIC is a procedural language extension for PostgreSQL that runs the original BASIC V2 interpreter, recompiled from the 6502 ROM into C.
Each function call resets the environment, mimicking a power cycle of the original hardware, but executes in about 15 to 20 microseconds. This speed allows for efficient processing of BASIC functions over large datasets.
The extension requires user code to start at line 10, with function arguments injected into reserved lines, maintaining the original BASIC syntax. This innovative approach preserves the nostalgic experience while significantly enhancing performance, making it feasible to use BASIC in modern database applications.