Flyweight: An ORM for SQLite

Re:Flyweight: An ORM for SQLite by matharmin on Thursday September 29, 2022 @03:50PM (#33026132)

With SQLite, I've started using json_each on a JSON parameter for bulk inserts or updates. Other SQL databases should have something similar.

It's much cleaner than generating SQL, and doesn't run into issues with exceeding the maximum number of parameters.

[ Parent | on HN ]

Re:Flyweight: An ORM for SQLite by plugin-baby on Thursday September 29, 2022 @04:19PM (#33026560)

This sounds very neat. Do you have an example handy?

[ Parent | on HN ]

Re:Flyweight: An ORM for SQLite by fragile_frogs on Friday September 30, 2022 @03:58AM (#33032222)

This is what I do in postgres:

  insert into your_table(id, created_at, uri, project_id)
  select id
       , created_at
       , endpoint as uri
       , project_id 
    from jsonb_to_recordset($1)
      as x(
          id uuid
        , created_at timestamptz
        , endpoint text
        , project_id uuid
      )

[ Parent | on HN ]