home.social
Sign in Create account

#dt260208 — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #dt260208, aggregated by home.social.

  1. MTBeeSQL @[email protected] ·

    # #dt260208
    # #sql
    # #primarykey
    # #foreignkey
    # #SQLite

    I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

    chatgpt.com/share/69894b9c-b94

    ...

    Highlights:

    1. SQLite-Idiomatic Schema (Clean Rewrite)
    Global settings (critical in SQLite)
    PRAGMA foreign_keys = ON;
    PRAGMA journal_mode = WAL;
    PRAGMA synchronous = NORMAL;

    #dt260208 #sql #primarykey #foreignkey #sqlite
  2. MTBeeSQL @[email protected] ·

    # #dt260208
    # #sql
    # #primarykey
    # #foreignkey
    # #SQLite

    I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

    chatgpt.com/share/69894b9c-b94

    ...

    Highlights:

    1. SQLite-Idiomatic Schema (Clean Rewrite)
    Global settings (critical in SQLite)
    PRAGMA foreign_keys = ON;
    PRAGMA journal_mode = WAL;
    PRAGMA synchronous = NORMAL;

    #dt260208 #sql #primarykey #foreignkey #sqlite
  3. MTBeeSQL @[email protected] ·

    # #dt260208
    # #sql
    # #primarykey
    # #foreignkey
    # #SQLite

    I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

    chatgpt.com/share/69894b9c-b94

    ...

    Highlights:

    1. SQLite-Idiomatic Schema (Clean Rewrite)
    Global settings (critical in SQLite)
    PRAGMA foreign_keys = ON;
    PRAGMA journal_mode = WAL;
    PRAGMA synchronous = NORMAL;

    #dt260208 #sql #primarykey #foreignkey #sqlite
  4. MTBeeSQL @[email protected] ·

    # #dt260208
    # #sql
    # #primarykey
    # #foreignkey
    # #SQLite

    I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

    chatgpt.com/share/69894b9c-b94

    ...

    Highlights:

    1. SQLite-Idiomatic Schema (Clean Rewrite)
    Global settings (critical in SQLite)
    PRAGMA foreign_keys = ON;
    PRAGMA journal_mode = WAL;
    PRAGMA synchronous = NORMAL;

    #sqlite #foreignkey #primarykey #sql #dt260208
  5. MTBeeSQL @[email protected] ·

    # #dt260208
    # #sql
    # #primarykey
    # #foreignkey
    # #SQLite

    I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

    chatgpt.com/share/69894b9c-b94

    ...

    Highlights:

    1. SQLite-Idiomatic Schema (Clean Rewrite)
    Global settings (critical in SQLite)
    PRAGMA foreign_keys = ON;
    PRAGMA journal_mode = WAL;
    PRAGMA synchronous = NORMAL;

    #dt260208 #sql #primarykey #foreignkey #sqlite