#dbixclass — Public Fediverse posts

Why we've changed our database schema 26 times until now:
- make Coocook easier to use by simplifying required input
- add new features like organizations (groups of users)
- add missing metadata like creation timestamps

Longer gaps are difficult changes that took long to prepare:
1. add database versioning in the first place
2. drop infamous table "quantities" that connected units that can be converted, like "masses" with lb and kg, etc.🙈
#perl #sql #SchemaVersioning #graph #dbixclass #dbi

@Perl I have a hard time getting this database query to work with DBIx::Class. I gave my best to describe it in a useful way. I’d very much appreciate any hints or questions:

https://stackoverflow.com/questions/77558505/use-function-value-from-subquery-in-where-clause-fetch-it-with-results-using-d

#perl #dbixclass #dbi