Skip to content
View pchemguy's full-sized avatar

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.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only 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 with a passion for exploring coding topics in my spare time. Recently, I have started learning ChatGPT as a coding and technical writing assistant, with a focus on prompting techniques and memory context management, as documented in ChatGPTExploratoryPrompting. My interests also include the technical aspects of SQLite, with my latest project, SQLiteMP, dedicated to developing a pure SQL implementation of a hierarchical category (class/tag) management system embeddable in an SQLite database. Some of my earlier projects include the advanced SQLite SQL Tutorial, the SQLite ICU project, which focuses on building custom versions of SQLite on Windows using MSYS2/MinGW and MSBuild toolchains, and the object-oriented VBA6 SQLite C/ADO VBA Library, which wraps the standard SQLite C API and the ADODB library.

Outside of my professional and technical pursuits, I enjoy playing online blitz chess variants, including Crazyhouse, Antichess, Atomic, and Three-check.

Pinned Loading

  1. ChatGPTExploratoryPrompting ChatGPTExploratoryPrompting Public

    Notes and materials related to efficient use of ChatGPT as a writing and coding assistant.

    1

  2. SQLite-SQL-Tutorial SQLite-SQL-Tutorial Public

    Advanced SQL/SQLite tutorials.

    HTML 4

  3. SQLiteMP SQLiteMP Public

    A proof-of-concept implementation of hierarchical category management system in SQLite with abstract interface.

  4. SQLite-ICU-MinGW SQLite-ICU-MinGW Public

    Building SQLite and SQLiteODBC on Windows with ICU and other extensions using MSVC Build Tools and MSYS2/MinGW

    C 11 3

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

    Forked from govert/SQLiteForExcel

    SQLite library for VBA wrapping ADODB and SQLite C-language API.

    VBA 5

  6. DllTools DllTools Public

    DllManager facilitates VBA function calls to non-system DLL libraries.

    VBA 4 1