Re: storing zipped SQLite inside PG ?

I'll have to read more about sqlite_fdw. Thanks for that Steve !

Each SQLite isn't that big (billions of records), more like 30K records or
so. But there are lots and lots of these SQLite DBs which add up over time
to perhaps billions of records.

This is for a big corp with an IT dept. Maybe I can get them to upgrade
the DB itself.
Thank You too David !

On Tue, Dec 21, 2021 at 10:14 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tuesday, December 21, 2021, David Gauthier <davegauthierpg(at)gmail(dot)com>
> wrote:
>
>>
>> OK, you get the picture. I'm all ears :-) And thanks in advance for any
>> suggestions !
>>
>
> This is basically a variant of “should I store images in the database” but
> the content sizes involved are insanely high compared to most images.
> External storage, with a pointer in the DB, would seem like a much better
> choice.
>
> Either way, though, not applying a minor release in over two years is just
> wrong; you should get on top of that before building new functionality on
> top of said database.
>
> David J.
>
>