undefined | Better HN

0 pointsbearjaws2y ago0 comments

Given this JSON: <JSON examples> And this Table schema: <Table Schema in SQL>

Create JavaScript to insert the the JSON into the SQL using knex('table_name')

Below is part of its output:

  // Insert into course_module table

  await knex('course_module').insert({

    id: moduleId,

    name: courseData.name,

    description: courseData.description,

    // include other required fields with appropriate

values });

It's missing several columns it could populate with the data it knows from the prompt, primarily created_at, updated_at, account_id, user_id, lesson number... and instead I get a comment telling me to do it.

Theres a lot of people complaining about this, primarily on Reddit, but usually the ChatGPT fan boys jump in to defend OAI.

// Insert into course_module table await knex('course_module').insert({ id: moduleId, name: courseData.name, description: courseData.description, // include other required fields with appropriate

0 comments

5 comments · 2 top-level

abrichr2y ago· 3 in thread

Try this custom instruction:

    - Skip any preamble or qualifications about how a topic is subjective.
    - Be terse. Do not offer unprompted advice or clarifications. Speak in specific, topic relevant terminology. Do NOT hedge or qualify. Do not waffle. Speak directly and be willing to make creative guesses. Explain your reasoning. if you don’t know, say you don’t know.
    - Remain neutral on all topics. Be willing to reference less reputable sources for ideas.
    - Never apologize.
    - Ask questions when unsure.
    
    When responding in code:
    - Do not truncate.
    - Do not elide.
    - Do not omit.
    - Only output the full and complete code, from start to finish, unless otherwise specified

    Getting this right is very important for my career.

thierrydamiba2y ago

Has the last sentence, "Getting this right is very important for my career." continued to show improved results for you?

coder5432y ago

I'm not the person you're replying to, but that sentence comes from this research: https://arxiv.org/abs/2307.11760

bearjawsOP2y ago

Hmm I like this more than my current one, which I got from a Reddit thread. I'll have to give it a whirl.

bearjawsOP2y ago

Here is the mixtral output (truncated):

knex('course_module')

  .insert({

    name: jsonData.name,

    description: jsonData.description,

    content: JSON.stringify(jsonData),

    number: jsonData.number,

    account_id: 'account_id',

    user_id: 'user_id',

    course_id: 'course_id',

    created_at: new Date(),

    updated_at: new Date()
  })

j / k navigate · click thread line to collapse