Flyweight: An ORM for SQLite

Re:Flyweight: An ORM for SQLite by asalahli on Thursday September 29, 2022 @04:31PM (#33026719)

> you're creating a hard coupling to a specific flavor of SQL.

I fail to see why this is a problem. Switching databases is a costly move, and is pretty rare as far as I know. When it does happen, it is usually from one type of db to another type, not between two RDBMSs.

IMO it doesn't, by itself, justify sticking to an ORM rather than raw SQL.

[ Parent | on HN ]

Re:Flyweight: An ORM for SQLite by lenkite on Friday September 30, 2022 @02:42AM (#33031730)

Switching databases can be an easy move depending on how you design schemas, versioning and migration. We have a multi-cloud, multi-db offering - customers choose their DB. Without ORM, this would not be feasible.

[ Parent | on HN ]

Re:Flyweight: An ORM for SQLite by JustLurking2022 on Saturday October 01, 2022 @06:19PM (#33050664)

I do it all the time - I use SQLite for testing and something else in production.

[ Parent | on HN ]