On Fri, Jun 2, 2023, 09:36 Oliver Kohll <oli...@agilebase.co.uk> wrote:
> Hi, > > Just wondering, does anyone else create apps which might not have 'big' > data, but quite complex arrangements of views joining to each other? > > If so, do you have scripts to aid refactoring them e.g. drop/recreate/test > them in the right order etc.? > In Ledgersmb, we did this and also same with functions. We used versioned scripts, database schema change management tools, and reload utilities as well as Pgtap for testing. > > I'm really impressed with the way Postgres handles these multi-layered > views. Some of our explain analyze outputs could fill a book each! Tools > like Depesz' can be very useful. Sometimes a little tweaking or a judicious > index is necessary, but the performance is very reliable and scalable. > > Blog post about it here: > https://blog.agilebase.co.uk/2023/05/21/refactoring-sql-views/ > Yeah, I have always been impressed by Postgres here too. > > Oliver > > -- > See us at the Bath Digital Festival <https://techspark.co/bdf/>, 12th July >
