Skip to content
View pchemguy's full-sized avatar
29 followers · 22 following

Achievements

Achievement: Pair Extraordinairex2Achievement: QuickdrawAchievement: StarstruckAchievement: Pull Sharkx2

Achievements

Achievement: Pair Extraordinairex2Achievement: QuickdrawAchievement: StarstruckAchievement: Pull Sharkx2

Block or report pchemguy

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
PChemGuy/README.md

I am a physical chemist and R&D engineer. Here I develop personal projects around SQLite, structured data, Python/C integration, technical writing, and AI-assisted software development. Most begin with a practical problem and evolve into reusable code, proof-of-concept models, or detailed implementation notes.

Areas of Interest

  • SQLite engineering: SQL data modelling, custom Windows builds, C extensions, and object-oriented access from VBA.
  • Structured technical data: extracting, interpreting, and relationally modelling implicit structure, including hierarchical classification systems.
  • Native-code development: reproducible Windows environments and direct testing of C APIs with Pytest and CFFI.
  • AI-assisted development and writing: using language models to explore designs, develop specifications and software, extend test suites, and refine technical documentation.

My broader collection of practical notes and related projects is available in Field-Notes.

Outside technical work, I enjoy online blitz chess variants, particularly Crazyhouse, Antichess, Atomic, and Three-check.

Pinned Loading

  1. Field-Notes Field-Notes Public

    Practical technical notes, scripts, and solutions to non-obvious real-world problems.

    Python

  2. SQLiteExtensionTemplate SQLiteExtensionTemplate Public template

    Reusable template for developing, integrating, and testing SQLite C extensions.

    Python

  3. SQLite-ICU-MinGW SQLite-ICU-MinGW Public

    Scripts for building SQLite and SQLiteODBC on Windows with ICU and additional extensions using MSVC or MinGW.

    C 15 4

  4. SQLiteMP SQLiteMP Public

    Proof-of-concept materialized-path hierarchy implementation using SQLite views, triggers, and a JSON-based interface.

    16

  5. SQLiteC-for-VBA SQLiteC-for-VBA Public

    Forked from govert/SQLiteForExcel

    Object-oriented VBA interfaces for SQLite access via ADODB and directly through the C API.

    VBA 7

  6. CFFI_Pytest_C_Testing CFFI_Pytest_C_Testing Public

    Direct testing of deterministic C APIs with Pytest and CFFI API mode.

    Python