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

Achievements

Achievement: StarstruckAchievement: Pull Sharkx2Achievement: Pair Extraordinaire

Achievements

Achievement: StarstruckAchievement: Pull Sharkx2Achievement: Pair Extraordinaire

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, technical writing, and generative AI topics in my spare time.

Recently, I began using ChatGPT as a coding and technical writing assistant, focusing on prompting techniques and memory context management, as documented in ChatGPTExploratoryPrompting. My current interests include the guided analysis of non-standard semistructured data, emphasizing the inference of structure and format with limited context. This process involves generating structured blueprint specifications and leveraging ChatGPT for assisted code development to handle the analyzed data. Additionally, I take advantage of ChatGPT's capabilities to interpret, annotate, and document Python code, as well as to generate extended test suites, including edge cases.

I am also interested in the technical aspects of SQLite. My latest project, SQLiteMP, is dedicated to developing a pure SQL implementation of a hierarchical category (class/tag) management system embeddable in an SQLite database. While SQL can be more challenging for generative AI compared to expressive general-purpose languages like Python, I have discovered that ChatGPT is capable of semantic SQL code interpretation. In some cases, I have replaced my SQL snippets with those predictively generated by ChatGPT based solely on plain text subject descriptions, without providing detailed logic descriptions. My previous projects include the advanced SQLite SQL Tutorial, the SQLite ICU project, focused on building custom SQLite versions 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.

Another area of interest is ChatGPT-assisted structure extraction from technical texts, particularly those well-suited to structured formats such as workflow descriptions and guides. ChatGPT has also proven helpful in guided topic exploration and transforming brainstorming results or technical "bunch-of-thoughts" texts into coherent, structured outputs.

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.

    16

  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